If you are using SQLAlchemy declarative you can set the engine per table in
the query args,
and if not using declarative you can set in the Table
Ex:
class MyTable(DeclarativeBase):
__tablename__ = 'table1'
__table_args__ = {'mysql_engine':'InnoDB'}
Vince
On Thu, Jan 20, 2011 at 8:07 AM, rajasekhar911 <[email protected]>wrote:
> Hi guys,
>
> I am trying to use innodb as storage engine. But i dont want to set
> the engine to innodb for all
> databases (in my.cnf).
>
> i can set the storage engine at the time of setup-app by executing the
> command
> set storage_engine='innodb' through the sa_engine. tables were created
> with innodb as engine.
>
> how do i set the engine at the run time?
> i tried to set it in init_model in __init__.py in model
> but it does not seem to work.
> also will this effect when TG is initializing connection pool?
> or is there any other way i can specify the engine in
> development.ini ? or in URL ?
>
> ---
> thanks
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "TurboGears" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<turbogears%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/turbogears?hl=en.
>
>
--
Vince Spicer
Developer
--
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en.
