Article Outline
Python mysql example 'Database Functions'
Modules used in program:
import time
import mysql.connector as mysql
python Database Functions
Python mysql example: Database Functions
import mysql.connector as mysql
import time
class Database_Functions:
def ConnectToDatabase(self):
try:
data = Database()
if data.is_connected():
print("Connection Established!!!")
print("------------------------------------------------------")
return data
except Exception as e:
print(e)
print("...")
time.sleep(30)
print("Trying again")
print("------------------------------------------------------")
ConnectToDatabase()
# connects to the Database
def Database(self):
File = open("Setup.config").readlines()
host = File.pop(0)
port = File.pop(0)
user = File.pop(0)
passwd = File.pop(0)
database = File.pop(0)
print("------------------------------------------------------")
print("Connecting to Database: " + host + " as " + user + " on port " + port)
print("Password: " + passwd)
print("------------------------------------------------------")
Database = mysql.connect(
host=host,
port=port,
user=user,
database=database
)
return Database
Python links
- Learn Python: https://pythonbasics.org/
- Python Tutorial: https://pythonprogramminglanguage.com