コード例 #1
0
def main():
    """Main."""
    os.system('/etc/init.d/mysql start')
    username, password = _test_mysql_conn()
    db_connect_creds.write_creds(username, password)

    dbconn = MySQLdb.connect('localhost', user=username, passwd=password)
    dbcurr = dbconn.cursor()
    create_db(dbcurr, INFERNAL_DB, username, password)
    dbconn.close()
コード例 #2
0
def main():
    """Main."""
    os.system('/etc/init.d/mysql start')
    username, password = _test_mysql_conn()
    db_connect_creds.write_creds(username, password)

    dbconn = MySQLdb.connect('localhost', user=username, passwd=password)
    dbcurr = dbconn.cursor()
    create_db(dbcurr, INFERNAL_DB, username, password)
    dbconn.close()
コード例 #3
0
ファイル: db_setup.py プロジェクト: noikiy/infernal-twin
def main():
    """Main."""
    os.system("/etc/init.d/mysql start")
    username, password = _test_mysql_conn()
    db_connect_creds.write_creds(username, password)

    dbconn = MySQLdb.connect("localhost", user=username, passwd=password)
    dbcurr = dbconn.cursor()
    create_db = "CREATE DATABASE IF NOT EXISTS %s" % INFERNAL_DB
    logging.debug(create_db)
    dbcurr.execute(create_db)

    grant_all = "GRANT ALL ON %s.* TO '%s'@'localhost'" % (INFERNAL_DB, username)
    if password != "":
        grant_all = "%s IDENTIFIED BY '%s'" % (grant_all, password)

    logging.debug(grant_all)
    dbcurr.execute(grant_all)
    dbconn.close()
コード例 #4
0
def main():
    """Main."""
    os.system('/etc/init.d/mysql start')
    username, password = _test_mysql_conn()
    db_connect_creds.write_creds(username, password)

    dbconn = MySQLdb.connect('localhost', user=username, passwd=password)
    dbcurr = dbconn.cursor()
    create_db = 'CREATE DATABASE IF NOT EXISTS %s' % INFERNAL_DB
    logging.debug(create_db)
    dbcurr.execute(create_db)

    grant_all = "GRANT ALL ON %s.* TO '%s'@'localhost'" % (INFERNAL_DB,
                                                           username)
    if password != '':
        grant_all = "%s IDENTIFIED BY '%s'" % (grant_all, password)

    logging.debug(grant_all)
    dbcurr.execute(grant_all)
    dbconn.close()