MySQLdb

[pavloutefkros]

hello,
i have problem manipulating mySQL data. When i add values in a Table,
i can recieve them instantly but when i check the table from another
script, the new values dont exist.

i'm not experienced in sql dbses so the problem might be something
outside python.

example (i do this to add values, and then i check and values have
been added):

####################################################################
import MySQLdb
conn = MySQLdb.connect (host = 'localhost',
user = 'root',
passwd = 'MYPASHERE',
db = 'test')
cursor = conn.cursor ()

cursor.execute ("""
INSERT INTO testsignin (user, pass, secretcode)
VALUES
('dkiauser', 'dkiapass', 'dkiacode'),
('gmtuser', 'gmtpass', 'gmtcode')
""")

print "Number of rows inserted: %d" % cursor.rowcount

cursor.execute ('SELECT * FROM testsignin WHERE user="gmtuser"')
row = cursor.fetchone()
print row
####################################################################

but then when i try to get them from another script with this:

####################################################################
import MySQLdb
conn = MySQLdb.connect (host = 'localhost',
user = 'root',
passwd = 'MYPASHERE',
db = 'test')
cursor = conn.cursor ()

cursor.execute ('SELECT * FROM testsignin WHERE user="gmtuser"')
row = cursor.fetchone()
print row
####################################################################

i get a None

 

[Diez B. Roggisch]

hello,
i have problem manipulating mySQL data. When i add values in a Table,
i can recieve them instantly but when i check the table from another
script, the new values dont exist.

i'm not experienced in sql dbses so the problem might be something
outside python.

example (i do this to add values, and then i check and values have
been added):

####################################################################
import MySQLdb
conn = MySQLdb.connect (host = 'localhost',
user = 'root',
passwd = 'MYPASHERE',
db = 'test')
cursor = conn.cursor ()

cursor.execute ("""
INSERT INTO testsignin (user, pass, secretcode)
VALUES
('dkiauser', 'dkiapass', 'dkiacode'),
('gmtuser', 'gmtpass', 'gmtcode')
""")

print "Number of rows inserted: %d" % cursor.rowcount

cursor.execute ('SELECT * FROM testsignin WHERE user="gmtuser"')
row = cursor.fetchone()
print row
####################################################################

but then when i try to get them from another script with this:

####################################################################
import MySQLdb
conn = MySQLdb.connect (host = 'localhost',
user = 'root',
passwd = 'MYPASHERE',
db = 'test')
cursor = conn.cursor ()

cursor.execute ('SELECT * FROM testsignin WHERE user="gmtuser"')
row = cursor.fetchone()
print row
####################################################################

i get a None

You need to commit your changes, using

conn.commit()

after doing them.

Diez

 

[Tim Chase]

i have problem manipulating mySQL data. When i add values in a Table,

i can recieve them instantly but when i check the table from another
script, the new values dont exist.

Depending on your transaction settings (both on your mysql
connection object in code, and the engine used for the table(s)
in mysql's DB), you may have to commit your transaction to make
it visible in other connections. This helps prevent partial
transactions from being visible when they're in inconsistent states.

-tkc