[sqlalchemy] metadata.drop_all() error

2009-05-20 Thread mhearne808[insert-at-sign-here]gmail[insert-dot-here]com
Hello - I am using SQLAlchemy as a part of the Enthought Python Distribution. I'm getting an error while using metadata.drop_all() with mysql, but not with sqlite. I was hoping someone could explain what it is that I'm doing wrong. Version info: Mac OS 10.5.7 MySQL Ver 14.14 Distrib 5.1.34

[sqlalchemy] MYSQL cascade constraint on column

2009-05-04 Thread mhearne808[insert-at-sign-here]gmail[insert-dot-here]com
Hello - I am developing the back-end of an application using Python and SQLAlchemy. The web-based (PHP, etc.) administrative front-end to the application is the responsibility of another developer. The point of commonality between the two is the database. I have already figured out how to have

[sqlalchemy] SQL Syntax Error

2009-03-17 Thread mhearne808[insert-at-sign-here]gmail[insert-dot-here]com
I have a reasonably complex schema that I attempting to manage with SQLAlchemy. I just added some tables in code and tried re-creating the database, and got an error that looks like this: ## sqlalchemy.exc.ProgrammingError: (ProgrammingError) (1064, You have an error in your SQL

[sqlalchemy] altering tables

2009-02-10 Thread mhearne808[insert-at-sign-here]gmail[insert-dot-here]com
Let's say I create a table with metadata using something like the following: metadata = MetaData() self.address_table = Table('address', metadata, Column('id', Integer, primary_key=True), Column('email', String

[sqlalchemy] Complex objects using sqlalchemy

2007-10-19 Thread mhearne808[insert-at-sign-here]gmail[insert-dot-here]com
Does anyone have any examples of using more complex classes with sqlalchemy? I'd like to have a user interface for my objects that hides as much of the complexity of sqlalchemy as possible. Using the users/addresses example from the sqlalchemy website (http://