Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sys
- import datetime
- import mysql.connector
- class Install(object):
- def _init__(self,dbname='blah'):
- self.dbname = dbname
- self.createDB = "CREATE DATABASE IF NOT EXISTS {0};".format(self.dbname)
- # after the class
- dbinfo = {}
- dbinfo['dbhost'] = "localhost"
- dbinfo['dbname'] = "testing2"
- dbinfo['dbusername'] = "iamsparticus"
- dbinfo['dbpwd'] = "bryb2yrbqt4y"
- m = Install(dbname=dbinfo['dbname'])
- connection = mysql.connector.Connect(host=dbinfo['dbhost'],
- user=dbinfo['dbusername'],
- password=dbinfo['dbpwd'],
- database=dbinfo['dbname'])
- # get var's for connecting to DB
- c = connection.cursor()
- c.execute(m.createDB)
- warnings = c.fetchwarnings()
- #if warnings:
- # print(warnings)
- connection.commit()
- mysql.connector.errors.ProgrammingError: 1049: Unknown database 'testing2'
Add Comment
Please, Sign In to add comment