Aşağıda basitce mysql bağlantısı ve tablo oluşturma üzerine kodları ekliyoruz.
Aklınıza takılan noktaları sorarsanız cevaplayabiliriz.
[code] #!/usr/bin/python
# hayvanlar.py - hayvanlar tablosunu oluşturacağız
# ve siniflarin azacagiz
import sys
import MySQLdb[/code]
[code] try:
conn = MySQLdb.connect (host = "localhost",
user = "uye",
passwd = "parola",
db = "veritabani")
except MySQLdb.Error, e:
print "Hata %d: %s" % (e.args[0], e.args[1])
sys.exit (1)
[/code]
[code] cursor = conn.cursor ()
cursor.execute ("DROP TABLE IF EXISTS hayvanlar")
cursor.execute ("""
CREATE TABLE hayvanlar
(
hayvan CHAR(40),
sinifi CHAR(40)
)
""")
cursor.execute ("""
INSERT INTO animal (hayvan,sinifi)
VALUES
('yilan', 'sürüngen'),
('hamsi', 'balik'),
('inek', 'sigir')
""")
print "toplam yeni ekleme: %d" % cursor.rowcount
[/code]
daha geniş bilgi için
http://www.kitebird.com/articles/pydbapi.html
[code]
#!/usr/bin/python
# animal.py - create animal table and
# retrieve information from it
import sys
import MySQLdb
# connect to the MySQL server
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)
# create the animal table and populate it
try:
cursor = conn.cursor ()
cursor.execute ("DROP TABLE IF EXISTS animal")
cursor.execute ("""
CREATE TABLE animal
(
name CHAR(40),
category CHAR(40)
)
""")
cursor.execute ("""
INSERT INTO animal (name, category)
VALUES
('snake', 'reptile'),
('frog', 'amphibian'),
('tuna', 'fish'),
('racoon', 'mammal')
""")
print "Number of rows inserted: %d" % cursor.rowcount
# perform a fetch loop using fetchone()
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
# perform a fetch loop using fetchall()
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
# issue a statement that changes the name by including data values
# literally in the statement string, then change the name back
# by using placeholders
cursor.execute ("""
UPDATE animal SET name = 'turtle'
WHERE name = 'snake'
""")
print "Number of rows updated: %d" % cursor.rowcount
cursor.execute ("""
UPDATE animal SET name = %s
WHERE name = %s
""", ("snake", "turtle"))
print "Number of rows updated: %d" % cursor.rowcount
# create a dictionary cursor so that column values
# can be accessed by name rather than by position
cursor.close ()
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
cursor.close ()
except MySQLdb.Error, e:
print "Error %d: %s" % (e.args[0], e.args[1])
sys.exit (1)
conn.commit ()
conn.close ()
[/code]