[cspay-dev] Problema inserare date DB

[Lupescu Grigore]

De aproape 2 zile tot incerc sa fac modulul de scriere in baza de date sa mearga. Tot restrangand problema nu am reusit sa identific exact problema. Am creat astfel o baza de date pe propiul pc si am incercat sa vad daca merge macar sa introduc ceva simplu in baza de date... Stupoare !!! ... Pot sa execut aproape orice comanda SQL (creare tabel,stergerea  tabel,selectie date ...) dar pana acum nici o comanda de inserare cat de simpla nu mi-a functionat fara sa emita vreo eroare... Efectiv parca nu se intampla nimic...
Exemplu de cod concret utilizat :

import xlrd
import line_parser
import line_reader
import db_writer
import sys
import MySQLdb


try:
    conn = MySQLdb.connect (host = "127.0.0.1", user = "root",
                                        passwd = "mysql", db = "rsoc_cspay")
except MySQLdb.Error, e:
    print "Error %d: %s" % (e.args[0], e.args[1])
    sys.exit (1)
#cursor = conn.cursor (MySQLdb.cursors.DictCursor)
cursor = conn.cursor ()
cursor.execute("""CREATE TABLE example9 (id INT,id2 INT);""")
cursor.execute("""INSERT INTO example9 (id,id2) VALUES (234,2142)""")


#cursor.executemany ("""INSERT INTO test (Name,CNP) VALUES (%s,%s)""",[tuple1,tuple2])

cursor.close ()
conn.close()




_________________________________________________________________
Drag n’ drop—Get easy photo sharing with Windows Live™ Photos.

http://www.microsoft.com/windows/windowslive/products/photos.aspx
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.rosedu.org/pipermail/cspay-dev/attachments/20090719/da3f439a/attachment.htm>