usually additional params that are specific to a certain database
implementation are passed through as keyword arguments to create_engine():
x = create_engine('driver://user:[EMAIL PROTECTED]/db', do_this=True,
do_that=False)
the **kwargs of create_engine are passed to the constructor of the Dialect
corresponding to the database being used.
examples of this include oracle's "use_ansi" and postgres' "use_oids" and
"module".
this keeps the URLs completely consistent and provides a nice separation
of "db-specific" vs. "db-agnostic".
Brad Clements wrote:
> I am trying to figure out how to get extra engine specific params from the
> db url.
>
> What I'd like is a url object that populates the standard attributes:
>
> self.drivername = drivername
> self.username = username
> self.password = password
> self.host = host
> self.port = port
> self.database= database
>
>
> Then has another dictionary of "any other connect params" that were
> passed..
>
> So
>
> firebird://user:[EMAIL PROTECTED]:port/e:/temp/mydb.gdb?init=200
>
> would have url with
>
> self.extra_params = {'init':'200'}
>
>
> URL.translate_connect_args just seems totally odd to me.. Like I give it a
> list of
> attributes that I want extracted into a dict.. but, I guess I have to know
> the order of
> elements in attribute_names in this method. strange..
>
>
> I digress.
>
> The engine.url._parse_keyvalue_args method seems to be half of what I
> want..
>
> but make_url doesn't use it.. In fact, nothing does.
>
> looks like I need to submit a patch for url.py to allow extra args to get
> parsed out
> of a url.
>
>
>
>
>
> --
> Brad Clements, [EMAIL PROTECTED] (315)268-1000
> http://www.murkworks.com
> AOL-IM or SKYPE: BKClements
>
>
>
>
> -------------------------------------------------------
> All the advantages of Linux Managed Hosting--Without the Cost and Risk!
> Fully trained technicians. The highest number of Red Hat certifications in
> the hosting industry. Fanatical Support. Click to learn more
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
> _______________________________________________
> Sqlalchemy-users mailing list
> Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
>
-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
