Python/pymysql: Difference between revisions

From Wiki
No edit summary
 
(5 intermediate revisions by the same user not shown)
Line 6: Line 6:
* [[Mysql]]
* [[Mysql]]
|}
|}
== Commit() ==
Changes to the database require a commit(), unless a "with" statement is used!


== Examples ==
== Examples ==
Line 17: Line 19:
* show version
* show version
<pre>
<pre>
try:
with db:
    with db:
    cursor = db.cursor()
        cursor = db.cursor()
    cursor.execute("SELECT VERSION()")
        cursor.execute("SELECT VERSION()")
    version = cursor.fetchone()
        version = cursor.fetchone()
    print("Database version: {}".format(version[0]))
        print("Database version: {}".format(version[0]))
except Exception as e:
    print(e)
</pre>
</pre>


Line 33: Line 32:
         cursor = db.cursor()
         cursor = db.cursor()
         cursor.execute("CREATE DATABASE carsearch")
         cursor.execute("CREATE DATABASE carsearch")
        #db.commit() -> not needed as we use "with"
except Exception as e:
except Exception as e:
     print(e)
     print(e)
Line 38: Line 38:


== Connection ==
== Connection ==
<pre>
db = pymysql.connect(host=localhost, port=3306, user="root", password="1234")
</pre>
* parameters:
** host
** port (default: 3306)
** user
** password
** autocommit (default: false)
* db.commit()
* db.close()
* db.rollback() #rollback current transaction


== Cursor ==
== Cursor ==
* cursor.execute("CREATE DATABASE carsearch")
* cursor.close()
* cursor.fetchone()
* cursor.fetchmany()
* cursor.fetchall()





Latest revision as of 13:45, 19 June 2020

Quick links

Commit()

Changes to the database require a commit(), unless a "with" statement is used!

Examples

  • connect
import pymysql

db = pymysql.connect(host=localhost, port=3306, user="root", password="1234")
  • show version
with db:
    cursor = db.cursor()
    cursor.execute("SELECT VERSION()")
    version = cursor.fetchone()
    print("Database version: {}".format(version[0]))
  • create database
try:
    with db:
        cursor = db.cursor()
        cursor.execute("CREATE DATABASE carsearch")
        #db.commit() -> not needed as we use "with"
except Exception as e:
    print(e)

Connection

db = pymysql.connect(host=localhost, port=3306, user="root", password="1234")
  • parameters:
    • host
    • port (default: 3306)
    • user
    • password
    • autocommit (default: false)
  • db.commit()
  • db.close()
  • db.rollback() #rollback current transaction

Cursor

  • cursor.execute("CREATE DATABASE carsearch")
  • cursor.close()
  • cursor.fetchone()
  • cursor.fetchmany()
  • cursor.fetchall()


Documentation