Re: UsersFromDatabase() mysql tables

[Arnoldas Grigutis]

And because I could not access the table object users_table =
Table(...) in the authkit directly, I had to emulate it in the
execute_at call using the same name.

Hope all this makes sense.

On Thu, Mar 4, 2010 at 10:34 PM, Arnoldas Grigutis
<arnoldas...@gmail.com> wrote:
> I found away around this. I converted the authkit table to InnoDB
> after creation.
>
>    # Convert authkit tables to InnoDB
>    alt = DDL('ALTER TABLE users ENGINE = INNODB')
>    alt = alt.execute_at('after-create', Table("users", meta.metadata))
>

[Arnoldas Grigutis]

I found away around this. I converted the authkit table to InnoDB
after creation.

# Convert authkit tables to InnoDB
alt = DDL('ALTER TABLE users ENGINE = INNODB')
alt = alt.execute_at('after-create', Table("users", meta.metadata))

On Thu, Mar 4, 2010 at 8:44 PM, Fazz <arnoldas...@gmail.com> wrote:
> Hi,
>
> I'm using a ForeignKey on AuthKit's `users` table. The table
> referencing to `users` is of InnoDB type while the users table which
> is created by authkit.users.UsersFromDatabase, is MyISAM.
>
> The problem is that I need to tell AuthKit to create tables of InnoDB
> type. I either need to pass the default-storage-engine to the database
> connection URL, which I failed to do, or AuthKit should let me pass
> mysql_engine='InnoDB' to SQLAlchemy when creating tables.
>
> I think passing default-table-engine to the connection is better than
> breaking into authkit's code. Anyone knows how to do this?
>
> Arnoldas

[Fazz]