def create_database(self):
from LibScan.mysql_ampache import database_tables, database_constraints, database_creator, catalog_creator, catalog_local_creator
self.db.autocommit(True)
cursor = self.db.cursor()
print "Creating the database"
cursor.execute(database_creator % self.database)
cursor.execute("USE `{}`".format(self.database))
print "Creating the tables"
for table, creator in database_tables.iteritems():
print "Creating table {}".format(table)
cursor.execute(creator)
print "Tables created"
print "Creating constraints"
for table, creator in database_constraints.iteritems():
print "Creating constraint {}".format(table)
cursor.execute(creator)
print "Constraints created"
print "Creating catalog entry"
now = int(time())
cursor.execute(catalog_creator, (self.catalog_name, now, now, now))
new_cat_id = cursor.lastrowid
print "Created catalog entry, creating local entry"
cursor.execute(catalog_local_creator, (self.catalog_dir, new_cat_id))
print "Created local entry"
print "Reconnecting to the new database"
self.db_connect()
def on_upgrade_dialog_yes_button_clicked(self, *args):
from LibScan.mysql_ampache import database_tables, database_constraints, database_creator, catalog_creator, catalog_local_creator
self.db.autocommit(True)
cursor = self.db.cursor()
print "Updating the database"
#cursor.execute("USE `{}`".format(self.database))
print "Creating the tables"
for table, creator in database_tables.iteritems():
print "Creating table {}".format(table)
try:
cursor.execute(creator)
except:
print "Table {} already in database".format(table)
print "Tables created"
print "Creating constraints"
for table, creator in database_constraints.iteritems():
print "Creating constraint {}".format(table)
try:
cursor.execute(creator)
except:
print "Constraint {} already in database".format(table)
print "Constraints created"
self.db_connect()
self.gobject['upgrade_dialog'].hide()