init

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