Re: [sqlalchemy] Weird error with update

On Fri, Nov 20, 2009 at 5:14 PM, Mariano Mara wrote: > ... or, at least, is weird for me :) > Hi everyone. I'm running a pylons controller > with the following instruction: > >meta.Session.query(ESMagicNumber).filter( >ESMagicNumber.uuid==request.params['uuid_']).\ >

[sqlalchemy] Weird error with update

... or, at least, is weird for me :) Hi everyone. I'm running a pylons controller with the following instruction: meta.Session.query(ESMagicNumber).filter( ESMagicNumber.uuid==request.params['uuid_']).\ update({'last_access':datetime.datetime.now()}) but I'm ge

Re: [sqlalchemy] Automatically Creating Table Definitions

Conor, Conor wrote: > Rodney Haynie wrote: > >> In SQLAlchemy, is there some process available that will create the >> following code from an existing database/table? i.e. the database has >> one table, the name of the table is users. >> After running the process, the following code would be

Re: [sqlalchemy] Automatically Creating Table Definitions

Rodney Haynie wrote: > In SQLAlchemy, is there some process available that will create the > following code from an existing database/table? i.e. the database has > one table, the name of the table is users. > After running the process, the following code would be created in a file: > > users = Ta

[sqlalchemy] Automatically Creating Table Definitions

In SQLAlchemy, is there some process available that will create the following code from an existing database/table? i.e. the database has one table, the name of the table is users. After running the process, the following code would be created in a file: users = Table('users', metadata, Colum

Re: [sqlalchemy] get_or_create(**kwargs) ?

Michael Bayer wrote: > chaouche yacine wrote: > >> But how can I be sure that the city of New Jersey will be inserted before >> the user in the database so that the new user row will get the proper city >> id ? >> > > SQLAlchemy takes care of that automatically once you configure the > rela

Re: [sqlalchemy] get_or_create(**kwargs) ?

chaouche yacine wrote: > But how can I be sure that the city of New Jersey will be inserted before > the user in the database so that the new user row will get the proper city > id ? SQLAlchemy takes care of that automatically once you configure the relationship between user and city using relatio

Re: [sqlalchemy] Adding ManyToMany relationships when creating an object

Lea H wrote: > Hi all, > I wanted to ask if there is a way to add many to many relationships to > the database every time a new object is inserted. > I have a Question that has a many to many relationship to AnswerCode. > Every time I create and insert a new Question I'd like to add the > correspon

[sqlalchemy] stored procedures and bind params on mssql

Hello, Does anyone have much experience using sqlalchemy with stored procedures on mssql? I'm trying to use bind params with text() in a query and it doesn't seem to like them ie, i try running: s = sql.text("""DECLARE @res INT; exec @res = LOGINS_ID :x ; select @res;""") and then: Session.execut

[sqlalchemy] get_or_create(**kwargs) ?

Hello, This is the first time I try an ORM, and I chose SQLAlchemy, which is popular amongst pythonistas. Since I am a complete beginner, here's my beginner's two cents question : Suppose you have a very basic model like this (pseudo code) : User(firstname,lastname,nick,ManyToOne(city)) City(

[sqlalchemy] Adding ManyToMany relationships when creating an object

Hi all, I wanted to ask if there is a way to add many to many relationships to the database every time a new object is inserted. I have a Question that has a many to many relationship to AnswerCode. Every time I create and insert a new Question I'd like to add the corresponding answer codes to that