Tweekers : Plateforme de conception et d'architecture logicielle collaborative

Connexion | Inscription

Edition :MySQL en Python en 5 Minutes

Modifier l'intitulé' :

Importer le module : <pre>import MySQLdb </pre>Connexion : <pre>conn = MySQLdb.connect (host = "localhost", user = "testuser", passwd = "testpass", db = "test")</pre><pre> conn.close () </pre>Executer une requete : <pre>cursor = conn.cursor () cursor.execute ("SELECT VERSION()") row = cursor.fetchone () print "server version:", row[0] cursor.close () </pre>Gestion des erreurs :  <pre> try: conn = MySQLdb.connect (host = "localhost", user = "testuser", passwd = "testpass", db = "test") except MySQLdb.Error, e: print "Error %d: %s" % (e.args[0], e.args[1]) sys.exit (1) </pre> Nombre de rangées affectées :   <pre> cursor.execute (""" INSERT INTO animal (name, category) VALUES ('snake', 'reptile'), ('frog', 'amphibian'), ('tuna', 'fish'), ('racoon', 'mammal') """) print "Number of rows inserted: %d" % cursor.rowcount</pre> Requètes SELECT :  <pre> cursor.execute ("SELECT name, category FROM animal") while (1): row = cursor.fetchone () if row == None: break print "%s, %s" % (row[0], row[1]) print "Number of rows returned: %d" % cursor.rowcount </pre> ou<pre> cursor.execute ("SELECT name, category FROM animal") rows = cursor.fetchall () for row in rows: print "%s, %s" % (row[0], row[1]) print "Number of rows returned: %d" % cursor.rowcount </pre> ou (pour avoir le nom des colonnes)  <pre> cursor = conn.cursor (MySQLdb.cursors.DictCursor) cursor.execute ("SELECT name, category FROM animal") result_set = cursor.fetchall () for row in result_set: print "%s, %s" % (row["name"], row["category"]) print "Number of rows returned: %d" % cursor.rowcount</pre> Paramètres :<pre> cursor.execute (""" UPDATE animal SET name = %s WHERE name = %s """, ("snake", "turtle")) print "Number of rows updated: %d" % cursor.rowcount </pre>Effectuer les changements : <pre> conn.commit () </pre>

Type :