[sqlalchemy] Re: creating tables dynamically

2010-07-23 Thread Aref
Thank you for taking the time to reply. The application I am writing takes input from the user to define the table name, number of columns, types etc... I tried formatting the inputs in a list and then passing the list elements to Table(). I kept getting error messages. I abandoned this approach an

[sqlalchemy] creating tables dynamically

2010-07-22 Thread Aref
Hello, I am working on an application where I would need to create a table in a database but I do not have a priori knowledge of how many columns does this table has. Is it possible to do this in SA? If so can someone point me to an example or reference documentation explaining how to accomplish t

[sqlalchemy] Re: modifying a field

2010-06-22 Thread Aref
In this example I used: DB.password = 'hello' where passwod is the column name. Can I pass the column name in a variable? It does not seem that I could. I have tried different ways but none seems to work. Thanks. On Jun 20, 5:18 pm, Michael Bayer wrote: > On Jun 20, 2010, at 5:53 P

[sqlalchemy] Re: modifying a field

2010-06-21 Thread Aref
Thank you so much. That worked. I was staring at the SQLsoup doc you linked to for hours trying to understand but could not figure what the "_" meant. In any case your explanation is clear and very useful. Thanks again. On Jun 20, 5:18 pm, Michael Bayer wrote: > On Jun 20, 2010, at

[sqlalchemy] Re: modifying a field

2010-06-20 Thread Aref
tf_user.id, tf_user.user_name, tf_user.password, tf_user.display_name, tf_user.created FROM tf_user 2010-06-20 16:00:02,546 INFO sqlalchemy.engine.base.Engine.0x...6c50 () [['1', u'Joey', u'top-Secret', u'plummer', '2010-06-19 20:35:27.093000']]

[sqlalchemy] Re: modifying a field

2010-06-20 Thread Aref
ggection and see. Thanks. On Jun 20, 3:40 pm, Michael Bayer wrote: > On Jun 20, 2010, at 5:33 PM, Aref wrote: > > > I tried that and still cannot seem to change the field. > > is "password" an actual column in the database table ?   create a SQLSoup > using an e

[sqlalchemy] Re: modifying a field

2010-06-20 Thread Aref
I tried that and still cannot seem to change the field. On Jun 20, 3:25 pm, Michael Bayer wrote: > On Jun 20, 2010, at 5:18 PM, Aref Nammari wrote: > > > > > > > I have the following code: > > > db = SqlSoup('sqlite:///c:\\tutorial.db3') > > db_

[sqlalchemy] modifying a field

2010-06-20 Thread Aref Nammari
value is still there. What am I doing wrong? What is the best way to update or modify fields? I can't seem to find anything substantial regarding SQLSoup. Thanks Aref -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this

[sqlalchemy] Re: session save

2010-06-16 Thread Aref
Is there a book that is more current that you recommend? Thanks On Jun 16, 7:35 am, Michael Bayer wrote: > unfortunately Essential SQLA is sorely out of date, save() was moved to add() > around the time of late 0.4 and in 0.6 we've removed the old save(). > > On Jun 16, 2010,

[sqlalchemy] Re: session save

2010-06-16 Thread Aref
Thank you so much. I'll make a note of that. On Jun 16, 7:35 am, Michael Bayer wrote: > unfortunately Essential SQLA is sorely out of date, save() was moved to add() > around the time of late 0.4 and in 0.6 we've removed the old save(). > > On Jun 16, 2010,

[sqlalchemy] session save

2010-06-16 Thread Aref
Hello, I am learning sqlalchemy and been reading and working through the examples/tutorials in Copeland's "Essential SQLAlchemy". I am running sqlalchemy 0.6.1 and python2.5 I am running into a problem when trying to save a session using save. session.save(newuser) for example. I get an error say

[sqlalchemy] Re: help please

2010-06-10 Thread Aref
Thank you very much. I'll try it. Is there a better way of doing this-- I mean there must be since this is necessary for any application needing to modify a database where generally tables are accessed dynamically. On Jun 10, 9:37 am, Lance Edgar wrote: > On 6/10/2010 10:29 AM, Aref wro

[sqlalchemy] Re: help please

2010-06-10 Thread Aref
a prior knowledge of what tables and what are the table columns that may exist. How can I do that if at all? On Jun 10, 7:21 am, GHZ wrote: > you should access column names via lower case > > i.e. > > columns = 'projectid', 'program', 'progmanger'] > &

[sqlalchemy] help please

2010-06-10 Thread Aref
Hello All, I just began learning sqlalchemy and am not quite used to it yet so please excuse my ignorance and which might be a trivial question to some of you. I am writing a database module and need to load a table and possibly modify a record in the table. I can get the connection established an