def export_db_dump(self):
"""
asksaveasfilename Dialog für dem Datenbank SQL Dump.
"""
filename = filedialog.asksaveasfilename(
defaultextension=".sql",
initialdir=os.path.expanduser('~'),
title="Export Datenbank als SQL Datei",
initialfile="pystunden_db",
filetypes=[("SQL Datei", ".sql"),
("Alle Dateien", ".*")])
if filename:
db.dump_db(filename)
def backup_db():
""" Backups database. """
dump_name = dump_db(env.config.DB.name, env.config.DB.user,
env.config.DB.password)
env.config.save()
return dump_name
def initialize_db():
db._reset_db()
db.add_bottle_type('Johnnie Walker', 'black label', 'blended scotch')
db.add_to_inventory('Johnnie Walker', 'black label', '500 ml')
db.add_bottle_type('Three Olives', 'Vodka', 'flavored vodka')
db.add_bottle_type('Uncle Herman\'s', 'moonshine', 'blended scotch')
db.add_to_inventory('Uncle Herman\'s', 'moonshine', '5 liter')
r = recipes.Recipe('scotch on the rocks', [('blended scotch','4 oz')])
db.add_recipe(r)
r = recipes.Recipe('vodka martini', [('unflavored vodka', '7 oz'),('vermouth', '1.5 oz')])
db.add_recipe(r)
r = recipes.Recipe('vomit inducing martini', [('orange juice',
'6 oz'),
('vermouth',
'1.5 oz')])
db.add_recipe(r)
db._c.execute('INSERT INTO users (firstname,lastname,username,pass) VALUES ("test1_first","test1_last","test1_username","guest")')
db.dump_db('db.txt')
def main(args):
try:
logging.basicConfig(level=args.log_level)
except ValueError as e:
print('Unable to initialise logging: %s' % e)
raise SystemExit
logging.info('Starting the server...')
logging.info('Version: %s.', server_version())
config.config = config.Config.load(args.config_file)
from db import load_db, dump_db
load_db()
from networking import factory
listener = reactor.listenTCP(config.config.port,
factory,
interface=config.config.interface)
logging.info('Listening on %s:%d.', listener.interface, listener.port)
from log_handler import LogHandler
logging.getLogger().addHandler(LogHandler())
reactor.run()
logging.info('Server shutting down.')
dump_db()
config.config.dump(args.config_file)
