Hi guys, thanks for the quick reply.
actually all tables have their engine set to innodb. that part is done. i want the connections to have the innodb engine at the run time. (during paster serve) or are you guys suggesting that , once the table engine is set to innodb, that should take care of the rest of the operations done on the table.? On Jan 20, 7:36 pm, Vince Spicer <[email protected]> wrote: > 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.
