Re: [SQLObject] SQLObject MS SQL Server

2007-08-10 Thread luis cota
Is it possible to override this mapping without delving into styles.py? On 8/10/07, Oleg Broytmann [EMAIL PROTECTED] wrote: On Fri, Aug 10, 2007 at 04:16:43PM -0400, luis cota wrote: Why is SQLObject mapping the CMBSHistory class to cmbs_history as a name? The mapping is performed

[SQLObject] SQLObject MS SQL Server

2007-08-10 Thread luis cota
I am able to use SQL Object to connect to SQL Server database, but I am having trouble using the Dynamic Class generation. I have an existing table structure that has tables such as: dbo.Currencies dbo.CMBSHistory I define the following classes: class CMBSHistory(SQLObject): class sqlmeta:

[SQLObject] Setting Conditions in a Table

2007-08-28 Thread luis cota
Is it possible to set conditions on a table entry? For example, if you have a data set with these cols: ts = DateTimeCol () // time stamp id_str = StringCol // string identifier Can I create a condition that forces the ts/id_str combination within each row to be unique? Thanks! - Luis

Re: [SQLObject] checking version

2007-11-23 Thread luis cota
in next version, remove later. 3) Planned to deprecate sometime, remove sometime much later ;) How do I know if I am installing the correct version? On Nov 23, 2007 12:39 PM, Oleg Broytmann [EMAIL PROTECTED] wrote: On Fri, Nov 23, 2007 at 12:00:31PM -0500, luis cota wrote: How can I check

[SQLObject] Unable to set StringCol to be UNIQUE

2010-08-10 Thread luis cota
Keeps throwing an error in MS SQL Server that this column type is not capable of being made a key ... is it possible to make this a unique field in SQL Server? My code is simple: class myClass(SQLObject): fld_name = StringCol(alternateID=True, unique=True) Please help. - Luis

[SQLObject] Constraint for Time Series DB

2010-08-10 Thread luis cota
How can I ensure that there exists only one value for a given Date, ID pair? - Luis -- This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge

Re: [SQLObject] Constraint for Time Series DB

2010-08-10 Thread luis cota
this, or if there was already a way to impose such a constraint. - Luis On Tue, Aug 10, 2010 at 2:37 PM, Oleg Broytman p...@phd.pp.ru wrote: On Tue, Aug 10, 2010 at 02:16:26PM -0400, luis cota wrote: How can I ensure that there exists only one value for a given Date, ID pair? In general, by creating

[SQLObject] Creating new objects in pre-existing table

2010-08-20 Thread luis cota
I have a pre-defined table in a SQL Server database that contains 4 columns + the primary key (integer). My class in Python is defined as: class HistoricalMatrix(SQLObject): class sqlmeta: fromDatabase = True table=HistoricalMatrix ccy = StringCol(length = 4) dataDate

[SQLObject] SQL Server Login Fails

2011-04-06 Thread luis cota
What is the appropriate way to connect to a SQL Server database using Windows Authentication? I've attempted using a connection string like this: conn_string = mssql://HOSTNAME/Test This results in: adodbapi.adodbapi.DatabaseError: (-2147352567, 'Exception occurred.', (0, u'Micr osoft OLE DB