Re: [Sqlalchemy-users] SQLAlchemy and Firebird SQL
Hello, Michael Bayer said the following on 29.07.2006 6:47: firebird support is not regularly maintained. though its not very hard, assuming one has firebird installed (i dont, doesnt seem to have an OSX version that is up to date). There are OSX versions of most recent 1.5.3 release, for both super- and classic-server architectures: http://tinyurl.com/qhfb8 But release candidate builds for upcoming 2.0 version are provided for linux and windows platforms only. we're sort of looking for someone who can regularly keep it running, if youre so inclined to take a look at firebird.py. I have two boxes running firebird 1.5.3 and 2.0rc3 and I could try to run tests on these firebird versions... -- Oleg - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
Re: [Sqlalchemy-users] SQLAlchemy and Firebird SQL
On 7/26/06, Oleg Deribas [EMAIL PROTECTED] wrote: users_table.create()i = users_table.insert()print i-And it gives me this:AttributeError: 'NoneType' object has no attribute 'has_key' Well, you should be able to print out an insert object... you could try giving us the full stacktrace, but I suspect that the Firebird code needs updating is what it comes down to. Do the tests pass when you follow the instructions in README.unittests, with --dburi=some_firebird_test_db ?-- Jonathan Ellishttp://spyced.blogspot.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV___ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
Re: [Sqlalchemy-users] SQLAlchemy and Firebird SQL
Oleg Deribas wrote:
Hello,
I'm trying to investigate possibility to use SQLAlchemy with Firebird
SQL. And I've wrote this simple script following tutorial:
-
from sqlalchemy import *
db = create_engine('firebird://SYSDBA:[EMAIL PROTECTED]/employee')
metadata = BoundMetaData(db)
metadata.engine.echo = True
try:
# Drop users table if it exists
users_table = Table('users', metadata, autoload=True)
users_table.drop()
del(users_table)
except:
pass
users_table = Table('users', metadata,
Column('user_id', Integer, primary_key=True),
Column('user_name', String(40)),
Column('passwd', String(10)),
redefine=True
)
users_table.create()
i = users_table.insert()
print i
-
And it gives me this:
AttributeError: 'NoneType' object has no attribute 'has_key'
My config:
win2k, python 2.4, SQLAlchemy 0.2.6, kinterbasdb 3.2rc1, firebird 2.0rc3
Firebird needs exclusive access for DDL.
Normally you don't do DDL and DML in the same script.
Try creating the needed table, commit it and drop the connection.
Than create a new connection and do your data inserts.
At least, that's how i am doing it.
It works!
Uwe
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV
___
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
[Sqlalchemy-users] SQLAlchemy and Firebird SQL
Hello,
I'm trying to investigate possibility to use SQLAlchemy with Firebird
SQL. And I've wrote this simple script following tutorial:
-
from sqlalchemy import *
db = create_engine('firebird://SYSDBA:[EMAIL PROTECTED]/employee')
metadata = BoundMetaData(db)
metadata.engine.echo = True
try:
# Drop users table if it exists
users_table = Table('users', metadata, autoload=True)
users_table.drop()
del(users_table)
except:
pass
users_table = Table('users', metadata,
Column('user_id', Integer, primary_key=True),
Column('user_name', String(40)),
Column('passwd', String(10)),
redefine=True
)
users_table.create()
i = users_table.insert()
print i
-
And it gives me this:
AttributeError: 'NoneType' object has no attribute 'has_key'
My config:
win2k, python 2.4, SQLAlchemy 0.2.6, kinterbasdb 3.2rc1, firebird 2.0rc3
--
Oleg
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV
___
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
[Sqlalchemy-users] SQLAlchemy and Firebird SQL
Hello,
I'm trying to investigate possibility to use SQLAlchemy with Firebird
SQL. And I've wrote this simple script following tutorial:
-
from sqlalchemy import *
db = create_engine('firebird://SYSDBA:[EMAIL PROTECTED]/employee')
metadata = BoundMetaData(db)
metadata.engine.echo = True
try:
# Drop users table if it exists
users_table = Table('users', metadata, autoload=True)
users_table.drop()
del(users_table)
except:
pass
users_table = Table('users', metadata,
Column('user_id', Integer, primary_key=True),
Column('user_name', String(40)),
Column('passwd', String(10)),
redefine=True
)
users_table.create()
i = users_table.insert()
print i
-
And it gives me this:
AttributeError: 'NoneType' object has no attribute 'has_key'
My config:
win2k, python 2.4, SQLAlchemy 0.2.6, kinterbasdb 3.2rc1, firebird 2.0rc3
--
Oleg
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV
___
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
