From faa13839f898c60ff5618be6e916ad2e60958468 Mon Sep 17 00:00:00 2001 From: nil0j Date: Sat, 21 Sep 2024 10:17:23 +0200 Subject: init --- python/database.py | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 python/database.py (limited to 'python/database.py') 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 -- cgit v1.2.3