Re: [sqlalchemy] utf8 error upon insert

2016-06-10 Thread Ven Karri
= create_engine("mysql+pymysql://scott:tiger@localhost/test", echo=True) > Base.metadata.drop_all(e) > Base.metadata.create_all(e) > > gcm_key = > '\xfeE\x87\xe7\xc9\xe5\xec\xe0\x9c\xd6\x85\x11\xc7\xebd\xe3\x7f\xd9\xfel\xe6\x86"j\xbe=\xf4\xd7\x95\x99F\x8f' > > > > s =

Re: [sqlalchemy] utf8 error upon insert

2016-06-09 Thread Ven Karri
t = self._query(query) > /home/classic/.venv/lib/python2.7/site-packages/pymysql/cursors.py:146: > Warning: Incorrect string value: '\xFEE\x87\xE7\xC9\xE5...' for column > 'data' at row 1 > result = self._query(query) > > > please run this script and modify it to show you

Re: [sqlalchemy] utf8 error upon insert

2016-06-09 Thread Ven Karri
Any ideas? On Thursday, June 9, 2016 at 10:21:27 AM UTC-4, Ven Karri wrote: > > Using, python 2.7 using 'mysql+pymysql' driver > > Code is very simple: > > gcm_key = '\xfeE\x87\xe7\xc9\xe5\xec\xe0\x9c\xd6\x85\x11\xc7\xebd\ > xe3\x7f\xd9\xfel\xe6\x86"j\xbe=\xf4\xd7\x95\

Re: [sqlalchemy] utf8 error upon insert

2016-06-09 Thread Ven Karri
/09/2016 09:52 AM, Ven Karri wrote: > > I am getting a UTF-8 error upon insert using sql alchemy ORM. The same > > query runs fine when I run using raw sql. Here's the ORM query: > > > > rotating_keys_object = rotating_keys_model( > > gcm_ke

[sqlalchemy] Re: utf8 error upon insert

2016-06-09 Thread Ven Karri
Btw, It's a MySQL backend On Thursday, June 9, 2016 at 9:52:41 AM UTC-4, Ven Karri wrote: > > I am getting a UTF-8 error upon insert using sql alchemy ORM. The same > query runs fine when I run using raw sql. Here's the ORM query: > > rotating_keys_object = rota

[sqlalchemy] utf8 error upon insert

2016-06-09 Thread Ven Karri
I am getting a UTF-8 error upon insert using sql alchemy ORM. The same query runs fine when I run using raw sql. Here's the ORM query: rotating_keys_object = rotating_keys_model( gcm_key=rot_gcm_key, nonce=rot_nonce, tag=rot_tag,

[sqlalchemy] Postgres OID column in SQLA 0.8

2015-01-12 Thread Ven Karri
Hi Mike, Is there anyway, you can make the following changes to SQLA 0.8 ? https://bitbucket.org/zzzeek/sqlalchemy/commits/42bbb7163ada -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from

[sqlalchemy] How to define metaclass for a class that extends from sqlalchemy declarative base ?

2013-07-02 Thread Ven Karri
I use: Python 2.6 and sqlalchemy 0.6.1 This is what I am trying to do: from sqlalchemy.types import ( Integer, String, Boolean ) from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() class SampleMeta(type): def __new__(cls, name, bases,