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)