summaryrefslogtreecommitdiff
path: root/python/database.py
diff options
context:
space:
mode:
Diffstat (limited to 'python/database.py')
-rw-r--r--python/database.py20
1 files changed, 20 insertions, 0 deletions
diff --git a/python/database.py b/python/database.py
new file mode 100644
index 0000000..5bc8b5f
--- /dev/null
+++ b/python/database.py
@@ -0,0 +1,20 @@
+import mysql.connector
+
+
+def getConnector():
+ return mysql.connector.connect(
+ host="localhost",
+ user="root",
+ )
+
+
+def getCursor(connector):
+ return connector.cursor()
+
+
+def runQuery(connector, query):
+ cursor = getCursor(connector)
+ cursor.execute(query)
+ result = cursor.fetchall()
+ cursor.close()
+ return result