Re: [Sqlalchemy-users] database literature

2006-09-12 Thread Kent Johnson
Alexandre CONRAD wrote: >> I don't think these are quite on the mark - one is too low-level, the >> other too high - but they are both good books and somewhat related. > > What do you mean by "too high" or "too low-level" ? Do you mean it's too > high or too low in terms of programming ? Or it's

Re: [Sqlalchemy-users] database literature

2006-09-11 Thread Kent Johnson
Alexandre CONRAD wrote: > Hello, > > I thought this might be a good place to ask for literature about > database design and concepts. I don't think these are quite on the mark - one is too low-level, the other too high - but they are both good books and somewhat related. Here is a very practi

Re: [Sqlalchemy-users] MSSQL - what am I doing wrong?

2006-09-10 Thread Kent Johnson
ecttable coltype = coltype(*args) TypeError: __init__() takes at most 2 arguments (3 given) Kent > > On Sep 10, 2006, at 6:30 PM, Kent Johnson wrote: > >> Kent Johnson wrote: >>> Michael Bayer wrote: >>>> SQLAlchemy should be working with a DBAPI that has

Re: [Sqlalchemy-users] MSSQL - what am I doing wrong?

2006-09-10 Thread Kent Johnson
Kent Johnson wrote: > Michael Bayer wrote: >> SQLAlchemy should be working with a DBAPI that has auto-commit turned >> off; this is because the Connection object supports its own "auto >> commit" feature. > > OK, I'll look into reworking mssql to ass

Re: [Sqlalchemy-users] MSSQL - what am I doing wrong?

2006-09-10 Thread Kent Johnson
Rick Morrison wrote: > Yikes! > > OK after an initial bit of panic on this subject and some subsequent > digging around, I'm happy to let the list know that the current CVS > version of pymssql is, and that an upcoming version 8 of pymssql will be > licensed LGPL: >http://sourceforge.net/fo

Re: [Sqlalchemy-users] MSSQL - what am I doing wrong?

2006-09-10 Thread Kent Johnson
an idea of how to fix this in mssql without having to change adodbapi. > > the idea of mssql.py is to adapt all the quirks of the adodbapi > library to a standard interface, so wahtever hacks are needed, thats > the place to put them. OK, thanks, Kent > > On Sep 10, 2006, a

Re: [Sqlalchemy-users] MSSQL - what am I doing wrong?

2006-09-10 Thread Kent Johnson
Rick Morrison wrote: > Just how viral is GPL in a circumstance like this? I was under the > impression that it is perfectly OK to use a GPL library in a commercial > product, as long as the source to the library itself was made available, > along with any patches/modifications to that library.

Re: [Sqlalchemy-users] MSSQL - what am I doing wrong?

2006-09-10 Thread Kent Johnson
The problem with mssql.py and adodbapi is that mssql.py assumes that adodbapi is using auto-commit and disables all the commit logic! In my case, the DB is not auto-committing so nothing ever gets committed. adodbapi has code in it to do the right thing depending on whether transactions are ena

Re: [Sqlalchemy-users] Problems with MS SQL Server

2006-09-10 Thread Kent Johnson
Kent Johnson wrote: > Kent Johnson wrote: >> Michael Bayer wrote: >>> i wonder if its something related to the ado module ? it might be >>> interesting if you could see if thats the case for your particular test >>> program (or if you could post a fu

Re: [Sqlalchemy-users] Problems with MS SQL Server

2006-09-10 Thread Kent Johnson
Kent Johnson wrote: > Michael Bayer wrote: >> i wonder if its something related to the ado module ? it might be >> interesting if you could see if thats the case for your particular test >> program (or if you could post a full test program to a new trac ticket). >> &g

Re: [Sqlalchemy-users] MSSQL - what am I doing wrong?

2006-09-09 Thread Kent Johnson
Michael Bayer wrote: > its really weird. i am able to get basic create/reflection stuff working > with the pymssql layer, maybe you want to play with that DBAPI for awhile > instead to get things working, then we can try seeing why adodbapi is > failing so much. from your echoing, it is calling "

[Sqlalchemy-users] MSSQL - what am I doing wrong?

2006-09-09 Thread Kent Johnson
I decided to start from the beginning and work through the tutorial using MSSQL as the database and adodbapi as the DB-API layer. I didn't get very far... I tried this program: from sqlalchemy import * db = create_engine('mssql://xx:[EMAIL PROTECTED]/SQLAlchemyTest') metadata = BoundMetaData(

Re: [Sqlalchemy-users] Problems with MS SQL Server

2006-09-09 Thread Kent Johnson
Michael Bayer wrote: > i wonder if its something related to the ado module ? it might be > interesting if you could see if thats the case for your particular test > program (or if you could post a full test program to a new trac ticket). > > we're generally in need of a little more help with tes

Re: [Sqlalchemy-users] Problems with MS SQL Server

2006-09-08 Thread Kent Johnson
Michael Bayer wrote: > Kent Johnson wrote: >> I added a simple MSUnicode type to mssql.py, basically copying what was >> done for MSString and changing String to Unicode, varchar to nvarchar. >> Is this a reasonable fix? Why is NVARCHAR not supported in the >> distri

[Sqlalchemy-users] adodbapi & mxDateTime failure

2006-09-08 Thread Kent Johnson
Reading a SMALLDATETIME field from SQL Server using adodbapi with mxDateTime installed fails with this traceback: Traceback (most recent call last): File "D:\Projects\CB\(misc)\Scripts\CbAlchemy\SqlAlchemyCbDaoTest.py", line 19, in test_saveAndUpdateCourse course2 = self.dao.findOneCour

[Sqlalchemy-users] Problems with MS SQL Server

2006-09-08 Thread Kent Johnson
Hi, I am a SQLAlchemy newbie trying to get started with an existing SQL Server database. I am running on WinXP and using adodbapi to access the DB. I am trying to use autoload to make a Table corresponding to one of my DB tables. The first problem I have is that my DB has NVARCHAR fields which