[sqlalchemy] Re: I can't delete SQLite db file

2009-05-15 Thread Виктор Иконников
Hi Mike, Thank you very much. It's work. 2009/5/16 Mike Conley > I found that you need to call > eng.dispose() > to disconnect from the database before deleting the file. > > Not sure about what is happening under the covers at that point, but it > seems to work. > > -- > Mike Conley > > > > >

[sqlalchemy] Re: I can't delete SQLite db file

2009-05-15 Thread Виктор Иконников
...*work[s] 2009/5/16 Виктор Иконников > Hi Mike, > > Thank you very much. It's work. > > 2009/5/16 Mike Conley > > I found that you need to call >> eng.dispose() >> to disconnect from the database before deleting the file. >> >> Not sure about what is happening under the covers at that point,

[sqlalchemy] Re: I can't delete SQLite db file

2009-05-15 Thread Mike Conley
I found that you need to call eng.dispose() to disconnect from the database before deleting the file. Not sure about what is happening under the covers at that point, but it seems to work. -- Mike Conley On Fri, May 15, 2009 at 1:35 PM, RusPython wrote: > > Hi guys, > > I have next code: > >

[sqlalchemy] I can't delete SQLite db file

2009-05-15 Thread RusPython
Hi guys, I have next code: import os from sqlalchemy import * from sqlalchemy.orm import * metadata = MetaData() engine = create_engine('sqlite:///temp.db', convert_unicode=True) metadata.bind = engine branches = Table('branches', metadata, Column('id', Integer, primary_key=True), Colu

[sqlalchemy] Re: Using column_property getting no results

2009-05-15 Thread Michael Bayer
put echo='debug' to see what the results are. On May 15, 2009, at 8:08 AM, Nathan Harmston wrote: > > Hi, > > I am trying to use a column property, I have a class Foo: > > class Foo(object): > pass > > which is mapped to a table foo_table and it has multiple names which > are stored in bar_tab

[sqlalchemy] Using column_property getting no results

2009-05-15 Thread Nathan Harmston
Hi, I am trying to use a column property, I have a class Foo: class Foo(object): pass which is mapped to a table foo_table and it has multiple names which are stored in bar_table with foo_id as the primary key in Foo and ForeignKey in bar_table. I am trying to use a column property to acces

[sqlalchemy] Re: SQLAlchemy GUI

2009-05-15 Thread Jarrod Chesney
Database and schema independent application - Yes. Whats CRUD? Google sais "Create, read, update and delete" The gui is wx. Believe it or not, Oracles SQL Developer is supposed to be able to manage MSSQL, Oracle and MYSQL (not sure about postgresql) They have built in SVN or CVS, I assume for us