def create_newdb(self, dbname, connect=False):
"create a new, empty database"
backup_versions(dbname)
make_newdb(dbname)
if connect:
time.sleep(0.5)
self.connect(dbname, backup=False)
PointerCol('position'),
PointerCol('pv'),
StrCol('value'))
info = Table('info', metadata,
Column('key', Text, primary_key=True, unique=True),
StrCol('value'))
metadata.create_all()
session = sessionmaker(bind=engine)()
for name, notes in InitialData.pvtype:
pvtype.insert().execute(name=name, notes=notes)
now = datetime.isoformat(datetime.now())
for key, value in InitialData.info:
if value == '<now>':
value = now
info.insert().execute(key=key, value=value)
session.commit()
if __name__ == '__main__':
dbname = 'Test.ein'
backup_versions(dbname)
make_newdb(dbname)
print '''%s created and initialized.''' % dbname
dumpsql(dbname)
Column('id', Integer, primary_key=True),
StrCol('notes'), PointerCol('position'),
PointerCol('pv'), StrCol('value'))
info = Table('info', metadata,
Column('key', Text, primary_key=True, unique=True),
StrCol('value'))
metadata.create_all()
session = sessionmaker(bind=engine)()
for name, notes in InitialData.pvtype:
pvtype.insert().execute(name=name, notes=notes)
now = datetime.isoformat(datetime.now())
for key, value in InitialData.info:
if value == '<now>':
value = now
info.insert().execute(key=key, value=value)
session.commit()
if __name__ == '__main__':
dbname = 'Test.ein'
backup_versions(dbname)
make_newdb(dbname)
print '''%s created and initialized.''' % dbname
dumpsql(dbname)
