def main(): conf = appconfig('config:/home/cspot/webapps/cspot/cspot/development.ini', name='main') engine = engine_from_config(conf, 'sqlalchemy.') DBSession.configure(bind=engine) Base.metadata.bind = engine Base.metadata.bind.echo = True Base.metadata.drop_all(engine) Base.metadata.create_all(engine)
def main(): conf = appconfig('config:/home/cspot/webapps/cspot/cspot/production.ini', name='main') engine = engine_from_config(conf, 'sqlalchemy.') DBSession.configure(bind=engine) session = DBSession() conn = session.connection() # conn.execute('alter table projects add reviewed') files = conn.execute("select id, filename from `values` where type = 'file'") for id, filename in files.fetchall(): if filename: files = [filename] else: files = [] conn.execute("update `values` set text_value = %s where id = %s", simplejson.dumps(files), id) print id, files mark_changed(session) transaction.commit()