> The MyISAM storage engine doesn't retain foreign key information- to
> autoload FKs you must create the table with a storage engine that
> supports FKs such as InnoDB. That looks like:
>
> Table('stats', metadata, ..columns.., mysql_engine='InnodB')
>
> You can also use ALTER TABLE via mysq
Noufal wrote:
> On Sep 20, 10:34 pm, Noufal <[EMAIL PROTECTED]> wrote:
> [..]
>> I create the tables using SQLAlchemy. I'll send you the output in a
>> day, I'm away from the machine where this code is right now.
>
> The output of the create table column looks like this
>
> CREATE TABLE `stats`
On Sep 20, 10:34 pm, Noufal <[EMAIL PROTECTED]> wrote:
[..]
> I create the tables using SQLAlchemy. I'll send you the output in a
> day, I'm away from the machine where this code is right now.
The output of the create table column looks like this
CREATE TABLE `stats` (
`sid` int(11) NOT NULL
> Did you originally create the tables through SQLAlchemy or are you
> reflecting an existing schema? In either case I'd need to see the
> output of SHOW CREATE TABLES for the problem table to make a diagnosis.
I create the tables using SQLAlchemy. I'll send you the output in a
day, I'm away
Noufal wrote:
> Hello everyone,
> I've recently picked up SQLAlchemy for a project that I'm working
> on. I couldn't get a version newer than 0.3.10 (admin bureaucracy) and
> have to use this.
>
> I create two tables like so
> run_table = sa.Table('runs',md,
>
Noufal wrote:
>
>
> I create two tables like so
> run_table = sa.Table('runs',md,
> sa.Column('rid', sa.Integer,
> primary_key=True),
> sa.Column('cmdline', sa.String(250)),
> sa.Column('hostname', s
