On 2019-01-08 06:55, [email protected] wrote:
> '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 must run:
cursor.execute(*select)
The query object is iterable and return the query string follwed by the
params.
Or if you prefer you can also run:
cursor.execute(str(select), select.params)
--
Cédric Krier - B2CK SPRL
Email/Jabber: [email protected]
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
