Guest User

Untitled

a guest
Feb 9th, 2019
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. import sys
  2. import datetime
  3. import mysql.connector
  4.  
  5. class Install(object):
  6.  
  7. def _init__(self,dbname='blah'):
  8. self.dbname = dbname
  9. self.createDB = "CREATE DATABASE IF NOT EXISTS {0};".format(self.dbname)
  10.  
  11.  
  12. # after the class
  13.  
  14. dbinfo = {}
  15. dbinfo['dbhost'] = "localhost"
  16. dbinfo['dbname'] = "testing2"
  17. dbinfo['dbusername'] = "iamsparticus"
  18. dbinfo['dbpwd'] = "bryb2yrbqt4y"
  19.  
  20. m = Install(dbname=dbinfo['dbname'])
  21.  
  22. connection = mysql.connector.Connect(host=dbinfo['dbhost'],
  23. user=dbinfo['dbusername'],
  24. password=dbinfo['dbpwd'],
  25. database=dbinfo['dbname'])
  26.  
  27. # get var's for connecting to DB
  28. c = connection.cursor()
  29. c.execute(m.createDB)
  30. warnings = c.fetchwarnings()
  31. #if warnings:
  32. # print(warnings)
  33. connection.commit()
  34.  
  35. mysql.connector.errors.ProgrammingError: 1049: Unknown database 'testing2'
Add Comment
Please, Sign In to add comment