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()
#!/usr/bin/env python import mysql mysql.create_database() data = mysql.MySQL() mysql.Base.metadata.create_all(data.engine)