On Jul 8, 5:47 pm, "Rick Morrison" <[EMAIL PROTECTED]> wrote:
> Also all this discussion leaves out the engine options. Right now a user has
> to make their own provisions for getting both Dialect and engine config
> options into a program using SA. either by hardcoding the options in the
> engine creation code, or by a roll-your-own method to read the config data
> and get those options to the engine constructor. The dburi does a lot to
> ease this path for DBAPI options, all I'm saying is that it would nice to
> open the door somehow to engine and dialect options too.
i was proposing having the dialect options be available from the query
string too.
if we are going whole hog with query strings (basically we're talking
about adding pool options mostly), a comprehensive solution needs to
be added in DefaultEngineStrategy. right now theres a system of
parsing the kwargs on each dialect, pulling them out of the
create_engine() kwargs, and applying them to the appropriate classes
(dialect, pool, engine). that system prevents invalid keyword
arguments from being passed no matter what combination of classes gets
instantiated. basically that system would have to be expanded to look
at the query string args on the URL as well. also, the system of
"typing" the string args would have to be more automatic than it is
now...id favor an auto-conversion that converts pure integer strings
to ints, "true"/"false" to True/False, and the rest stays as string.
this is so that writing a dialect doesnt require that you have to
interpret all the given kwargs among several types. basically i want
a really strong, DRY solution with lots of new tests in test/engine/
parseconnect.py.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
