hello - you need to use the SQLAlchemy API fully, the code example below is using the SQLite DBAPI directly.
Go through the tutorial at http://docs.sqlalchemy.org/en/rel_1_0/core/tutorial.html to see how to properly invoke SQL with SQLAlchemy. On 12/03/2015 12:19 AM, Jothybasu Selvaraj wrote: > Dear All > > I just started to use sqlalchemy and I am also quite new to databases. > > I have a sqlite database saved with a table with name "Table1" and now I > want to insert a colum with PickleType. The below code works for TEXT, > INTEGER, etc... but not for PickleType. > > > > > curResults13={'Output':2.01,'QualityIndex':0.66,'FlatnessX':1.5,'FlatnessY=':1.8} > > conn = sqlite3.connect("C:\\MLC QA\LA4.db") > c = conn.cursor() > c.execute("ALTER TABLE {tn} ADD COLUMN '{cn}' {ct} DEFAULT '{df}'"\ > .format(tn='Table1', cn='Results', ct='ARRAY', df=curResults13)) > conn.commit() > conn.close() > > > > > Can any of you guide me on this issue? > > > > Thanks > > > Jothy > > > > -- > You received this message because you are subscribed to the Google > Groups "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send > an email to [email protected] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
