def loadTables(myhost, myport, myuser, mypassword, databaseName):
wkdir = localsettings.determine_path()
f = open(os.path.join(wkdir,"resources","demodump.sql"),"r")
dumpString = f.read()
f.close()
print myhost, myport, myuser, databaseName, mypassword
db = MySQLdb.connect(host = myhost, port = myport,
user = myuser, db = databaseName, passwd = mypassword)
cursor = db.cursor()
cursor.execute(dumpString)
cursor.close()
db.commit()
db.close()
return True
def loadTables(myhost, myport, myuser, mypassword, databaseName):
wkdir = localsettings.determine_path()
f = open(os.path.join(wkdir, "resources", "demodump.sql"), "r")
dumpString = f.read()
f.close()
print myhost, myport, myuser, databaseName, mypassword
db = MySQLdb.connect(host=myhost,
port=myport,
user=myuser,
db=databaseName,
passwd=mypassword)
cursor = db.cursor()
cursor.execute(dumpString)
cursor.close()
db.commit()
db.close()
return True
def create_tables(host_, port_, user_, pass_wd, db_name):
try:
wkdir = localsettings.determine_path()
f = open(os.path.join(wkdir, "resources", "schema.sql"), "r")
sql_statements = f.read()
f.close()
db = MySQLdb.connect(host=host_,
port=port_,
user=user_,
db=db_name,
passwd=pass_wd)
cursor = db.cursor()
cursor.execute(sql_statements)
cursor.close()
db.commit()
db.close()
return True
except:
LOGGER.exception("error creating database tables")
def create_tables(host_, port_, user_, pass_wd, db_name):
try:
wkdir = localsettings.determine_path()
f = open(os.path.join(wkdir, "resources", "schema.sql"), "r")
sql_statements = f.read()
f.close()
db = MySQLdb.connect(host=host_,
port=port_,
user=user_,
db=db_name,
passwd=pass_wd)
cursor = db.cursor()
cursor.execute(sql_statements)
cursor.close()
db.commit()
db.close()
return True
except:
LOGGER.exception("error creating database tables")
