python db-api precision if real numeric value the precision supported by the attributescale indicates the scale of the attributenull_ok this indicates whether null values are acceptable for this attribute the first two items (name and type_codeare mandatorythe other five are optional and are set to none if no meaningful values can be provided transactions in pymysql transactions are managed in pymysql via the database connection object this object provides the following methodconnection commit(this causes the current transaction to commit all the changes made permanently to the database new transaction is then started connection rollback(this causes all changes that have been made so far (but not permanently stored into the database not committedto be removed new transaction is then started the standard does not specify how database interface should manage turning on and off transaction (not least because not all databases support transactionshowevermysql does support transactions and can work in two modesone supports the use of transactions as already describedthe other uses an auto commit mode in auto commit mode each command sent to the database (whether select statement or an insert/update statementis treated as an independent transaction and any changes are automatically committed at the end of the statement this auto commit mode can be turned on in pymysql usingconnection autocommit(trueturn on autocommit (false to turn off auto commit which is the defaultother associated methods include connection get_autocommit(which returns boolean indicating whether auto commit is turned on or not connection begin(to explicitly begin new transaction online resources see the following online resources for more information on the python database api