On 7 avr, 16:31, "Michael Bayer" <[email protected]> wrote:
> you're free to access the raw connection and use the pysqlite
> create_collation method. If you'd like to assemble this on all
> connections, look into the PoolListener API described
> inhttp://www.sqlalchemy.org/docs/05/reference/sqlalchemy/interfaces.htm...
> and implement the "connect" method.
Ok, I've appended my collation function with dbapi_con.create_collation
("my_collate", my_collate) but I don't know how can I use my collation
in query statement.
::
import locale
from sqlalchemy.interfaces import PoolListener
from sqlalchemy import Table, MetaData
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from sqlalchemy.orm import mapper
locale.setlocale(locale.LC_ALL,"fr_FR.UTF-8")
def my_collate(string1, string2):
return locale.strcoll(string1, string2)
class MyListener(PoolListener):
def connect(self, dbapi_con, con_record):
dbapi_con.create_collation("my_collate", my_collate)
engine = create_engine('sqlite:///development.db', echo=True,
listeners = [MyListener()])
metadata = MetaData()
metadata.bind = engine
clients = Table('client', metadata, autoload = True)
Session = sessionmaker(bind=engine)
session = Session()
class Client(object):
pass
mapper(Client, clients)
result = session.query(Client).order_by("brand_name")
How can I add collation this query ?
Regards,
Stephane
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
