Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.48 KB | None | 0 0
  1. import MySQLdb
  2.  
  3. DB_HOST = ""
  4. DB_USER = ""
  5. DB_PASS = ""
  6. DB_NAME = ""
  7.  
  8. db = MySQLdb.connect(DB_HOST, DB_USER, DB_PASS, DB_NAME)
  9.  
  10.  
  11. def connect():
  12.     cursor = db.cursor()
  13.     cursor.execute("SELECT VERSION()")
  14.     data = cursor.fetchone()
  15.    
  16.     if not data:
  17.         return 0
  18.     elif data:
  19.         return 1
  20.     else:
  21.         return "database null"
  22.    
  23.  
  24. def read():
  25.     if connect() == 1:
  26.         print "OK"
  27.     else:
  28.         print "NO"
  29.    
  30.  
  31.  
  32.  
  33. read()
  34. db.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement