Friday, November 25, 2011

Re: where can i get detail tutorial for using cloud sql in gae?

my examples:
from google.appengine.api import rdbms
conn = rdbms.connect(instance='projectname:instancename',
database='database_name', charset='utf8') # charset - for dev-server
cursor = conn.cursor()
cursor.execute('DELETE FROM `email` WHERE id=%s', [id])
cursor.close()
cursor = conn.cursor()
cursor.execute(u'REPLACE INTO `email` (`id`, `time`, `from`, `to`,
`subject`, `comment`, `text`) VALUES (%s, %s, %s, %s, %s, %s, %s)',
[email.id(), email.Time.strftime('%Y-%m-%d--%H-%M-%S'), email.From,
email.To, email.Subject, email.Comment, email.Text])
cursor.close()
cursor = conn.cursor()
cursor.execute("select from email WHERE `from`=%s", ['asd@mail.ru'])
result = cursor.fetchall()
for row in result:
...

No comments:

Post a Comment