Why does the ROLLBACK information appear in the print log when using sqlalchemy to make only query queries (no data changes)?

[printed information]

after testing the ROLLBACK, execute

before self.db.close () in the code

session configuration code uses the default: autoflush=True, autocommit=False, expire_on_commit=True

[Information queried by yourself]

1. When sqlalchemy performs the query operation, it will first execute flush () to submit the information to the database (but no commit)

2. Add self.db.commit () after the query and the ROLLBACK information will not be printed

No relevant explanation was found on the web page

so I would like to ask, during the query operation, there is no change in the data, what is the operating mechanism? Why the ROLLBACK information will appear, the query must also be commit ()?

Sqlalchemy python

May.10,2022

1. Every time a session is opened, a transaction
2.close a session will be opened. If the transaction has not been committed, the
3.commit () will be rolled back. After the transaction has been committed, the transaction will not be rolled back

when close.

Previous: ReactDOM.render output components that use dva will make an error

Next: The problem of mixed arrangement of P tags in Chinese and English?

How does the Python database orm framework SQLAlchemy exclude specified fields and not map / serialize specified fields when mapping fields?
as shown in the figure below, does SQLAlchemy have a simple way to directly declare that the specified field is not mapped serialized? for example, does java s Hibernate framework have such a function? (although there are other "indirect " solut...

Database python3.x orm sqlalchemy python

Feb.28,2021
Consult the simplified implementation of the same operation of multiple Model classes in Python
now there is a problem in the project. The project is completed in flask. Now there are several data tables with the same order field, and all need to query the data of these tables and adjust the value of the order field. the inefficient way is to im...

Sqlalchemy python flask

Mar.02,2021
Python flask sqlalchemy multi-field query, dynamically change the query statement
suddenly there is an idea that if the field changes are complicated when making a query, you can t write the query statement, just like A.query.filter (name== ds ) is written dead. If I need to dynamically switch query fields, especially when there ...

Flask-sqlalchemy python3.x

Mar.07,2021
How to implement thread-safe INSERT IF NOT EXIST? gracefully by sqlalchemy
Database table mytable structure id id_card INT VARCHAR (32) where id is the self-increasing primary key how to gracefully implement if id_card insertion when it does not exist, of course, thread-safe can not be repeated. my implementation is to a...

Sqlalchemy python

Mar.18,2021
How to initialize the database by directly executing the SQL script using Flask-SQLAlchemy?
problem description I want to execute the SQL script directly to initialize the database when initializing the flask application. the database is Postgresql. the environmental background of the problems and what methods you have tried flask tutor...

Flask-sqlalchemy python3.x

Mar.25,2021
When python operates mysql, how can it be sorted according to the size of the group summation after grouping and summing first?
The structure of the table is a top-up record table. Users generate a record for each top-up. I want to sum each user s top-up within a period of time, sort it according to the total amount of each user s top-up, and intercept the first few bits. The ...

Sqlalchemy python mysql

Aug.01,2021
Python sqlalchemy operation mysql error, Truncated incorrect DOUBLE value?
sqlalchemy operation data Times error: Warning: (1292, "Truncated incorrect DOUBLE value: weixincode ") result = self._query(query) but the data is inserted. Why? the source code is as follows: @staticmethod def create_account(area_c...

Mysql sqlalchemy python python3.x

Aug.27,2021
Python sqlalchemy, has two databases, in which the table name is duplicated. How to set it so as not to confuse the two tables?
1. In both databases, there is a table called table_A, that will be confused when performing ORM operations ...

Sqlalchemy python

Oct.29,2021
Sqlalchemy Why does order_by return different data and expectations when used with paging operations?
whether you use slice or limit offset to do paging, there will be problems as long as you sort and then paginate. Why? there is a problem when PS: only shows that the amount of data per page is less than the total amount of data. Why? result = session...

Sqlalchemy python mysql

Dec.29,2021
Relationship, with flask sqlalchemy cannot be called
problem description relationship, with flask sqlalehemy cannot be called. An error message appears TypeError: InstrumentedAttribute object is not callable the environmental background of the problems and what methods you have tried python 3.7...

Flask-sqlalchemy flask sqlalchemy python

Jan.25,2022
Flask error prompt: syntax error: position parameter follows keyword parameter
question I want to query the data of the user signin=0 within a time range in the CarJob_User table. Syntax error: the positional parameter follows the keyword argument. What is wrong with the following code? 2. Code today = datetime.date.tod...

Flask-sqlalchemy python

May.09,2022

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b225c6-4ccaa.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b225c6-4ccaa.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?