I have read the example in https://pypi.org/project/python-sql/#description.


'The flavor of python-sql allows you to use almost any database using any 
PEP 249 python library.'

But I still don't know how to use it in mysql.

conn = MySQLdb.Connect(unix_socket = config.mysql_sock,
                               user = config.mysql_user,
                               passwd = secret,
                               connect_timeout=10,
                               charset="utf8",
                               cursorclass = MySQLdb.cursors.DictCursor)
cursor = conn.cursor()

user = Table('user')                                                            
                                                                
select = user.select()
select.where = user.EnglishName=='testname'

How to excute it ?
cursor.execute(select) ?
cursor.execute(tuple(select) ?

-- 
You received this message because you are subscribed to the Google Groups 
"python-sql" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to python-sql+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to