def setup( dbh ):
""" populate the database with basic, essential data """
if get_datalogger():
get_clsreg().sync()
session.commit()
dbsession = dbh.session()
EK.bulk_update( ek_initlist, dbsession=dbsession )
Group.bulk_insert( essential_groups, dbsession=dbsession )
UserClass.bulk_insert( system_userclass, dbsession=dbsession )
group_id = Group._id('_SysAdm_', dbsession)
file = File( path='/', group_id = group_id, permanent = True )
dbsession.add( file )
file.type = 'file/folder'
file.mimetype = 'application/x-directory'
cerr('INFO: root password is %s\n' % root_password)
def setup_db( *ops ):
""" setup the database (create tables, etc) and populate with basic data """
base = get_base()
# WARN: use alembic to create initial tables
#base.metadata.create_all()
with transaction.manager:
if get_datalogger():
get_clsreg().sync()
with transaction.manager:
EK.bulk_insert( ek_initlist )
Group.bulk_insert( essential_groups )
file = File( path='/', type='file/folder', mimetype='application/x-directory',
group_id = Group._id('_SysAdm_'), permanent = True )
dbsession.add( file )
for op in ops:
op()