def setUp(self):
self.mysql = mysql.MySQL()
self.session = self.mysql.session()
mysql.drop_database()
mysql.create_database()
mysql.Base.metadata.create_all(self.mysql.engine)
def dispatch_request(self) -> str:
self.logger.info(f"form: {flask.request.form}")
# Get the fields necessary
username = flask.request.form.get("username", "")
password = flask.request.form.get("password", "")
dbname = flask.request.form.get("dbname", "")
# Check that all fields are valid
valid, msg = self.validate(username, password, dbname)
if not valid:
self.logger.error(f"invalid create DB request: {msg}")
return self.render(mysql_create_error=msg,
mysql_delete_error="",
mysql_active=True)
# Try to create the database
try:
mysql.create_database(username, dbname, False)
except mysql.DatabaseAccessError as e:
self.logger.error(f"database error: {e}")
return self.render(
mysql_create_error="There was an error creating your Database",
mysql_delete_error="",
mysql_active=True,
)
# Success (probably should do more than just redirect to / ...)
self.logger.info(
f"successfully created database for {username} named {dbname}")
return flask.redirect("/tools/mysql")
def create_database():
"""
Create the Mayan EDMS database
"""
setup_environment()
print(green('Creating Mayan EDMS database', bold=True))
if env.database_manager == DB_MYSQL:
mysql.create_database()
def create_database():
"""
Create the Mayan EDMS database
"""
setup_environment()
print(green('Creating Mayan EDMS database', bold=True))
if env.database_manager == DB_MYSQL:
mysql.create_database()
#!/usr/bin/env python import mysql mysql.create_database() data = mysql.MySQL() mysql.Base.metadata.create_all(data.engine)
