[sqlalchemy] searching money to one relationships

2007-10-13 Thread Jason
I have a tagging system where I tag articles that can be tagged with an unlimited number of tags from a tag table. This relationship is of course governed by a secondary table to store the relationship. so my question is how do I search for articles based on tags. I can get it to work by search f

[sqlalchemy] Re: FYI: AutoCode moved to a new repository

2007-10-13 Thread Michael Bayer
On Oct 12, 2007, at 12:46 PM, Gaetan de Menten wrote: > I don't say that everything should be integrated, just the reflection > part (if at all useful in SA0.4) and the repr methods of the > corresponding objects (*_repr in formatter.py) which should IMHO > replace the current repr methods. Or,

[sqlalchemy] Re: Connecting to a Microsoft Access Database

2007-10-13 Thread Paul Johnston
Hi, >Just curious but where would I look to find out that I needed to use >access instead of mssql? > > At the moment, just by reading the source! This is what I mean by _experimental_ support. If access support becomes more solid, the docs will be updated to mention it. >just want to make s

[sqlalchemy] Re: Connecting to a Microsoft Access Database

2007-10-13 Thread Werner F. Bruhin
Eddie, Eddie wrote: > Thank your Paul (and Expo!) > > Just curious but where would I look to find out that I needed to use > access instead of mssql? > You might want to check the documentation: http://www.sqlalchemy.org/docs/04 More specifically: http://www.sqlalchemy.org/docs/04/documentati

[sqlalchemy] Re: Connecting to a Microsoft Access Database

2007-10-13 Thread Eddie
Thank your Paul (and Expo!) Just curious but where would I look to find out that I needed to use access instead of mssql? I did indeed go to that web page as well as scour some other resources, but nothing ever specifically mentioned access:///... just want to make sure I can read as much as I ca

[sqlalchemy] Re: Connecting to a Microsoft Access Database

2007-10-13 Thread Expo
On Oct 13, 2:13 am, Eddie <[EMAIL PROTECTED]> wrote: > > engine = create_engine('mssql://VMCPDB', echo=True) I think thi line is the error. Like previous post you should use access:// URI : engine = create_engine('access://VMCPDB', echo=True) --~--~-~--~~~---~--~

[sqlalchemy] Re: FYI: AutoCode moved to a new repository

2007-10-13 Thread Simon Pamies
On 12.10.2007, at 18:56, Paul Johnston wrote: BTW, with SA 0.4, this script should be able to work with no database-specific hacks at all. If you're interesting in implementing this, I can explain more. Would be nice to hear more details about this. With 0.4, dialects have a table_names(

[sqlalchemy] Re: FYI: AutoCode moved to a new repository

2007-10-13 Thread Simon Pamies
On 12.10.2007, at 18:46, Gaetan de Menten wrote: On 10/12/07, Simon Pamies <[EMAIL PROTECTED]> wrote: On Oct 12, 10:09 am, "Gaetan de Menten" <[EMAIL PROTECTED]> wrote: I couldn't agree more. I mean: shouldn't the "autoload" part be integrated into SQLAlchemy reflection capability if it can