longbox

commit 3b2d8eb488d64ad8e0eaf4218c5e447ca8cf7306
parent 00b71cb7749f65d95979be9a241b7b23f5dea403
Author: pyratebeard <root@pyratebeard.net>
Date:   Wed, 27 Jul 2022 16:50:43 +0100

test mysql connection. add dev steps to readme

Diffstat:
M
README.md
 | 
7
+++++++
A
longbox
 | 
29
+++++++++++++++++++++++++++++

2 files changed, 36 insertions(+), 0 deletions(-)
diff --git a/README.md b/README.md
@@ -1 +1,8 @@
 # longbox
+
+## developing
+```
+python3 -m virtualenv env
+source env/bin/activate
+pip install mysql-connector-python
+```
diff --git a/longbox b/longbox
@@ -0,0 +1,29 @@
+#!/usr/bin/env python3
+#
+# ░█░░░█▀█░█▀█░█▀▀░█▀▄░█▀█░█░█░░
+# ░█░░░█░█░█░█░█░█░█▀▄░█░█░▄▀▄░░
+# ░▀▀▀░▀▀▀░▀░▀░▀▀▀░▀▀░░▀▀▀░▀░▀░░
+#
+# what ░ comic book stash
+#  who ░ pyratebeard <root@pyratebeard.net>
+# repo ░ https://git.pyratebeard.net/longbox
+#
+# TODO
+# * read from gcd database
+#   * search?
+# * create personal stash database
+#   * add issues from gcd to stash
+#   * easy view stash, web browser?
+
+from getpass import getpass
+from mysql.connector import connect, Error
+
+try:
+    with connect(
+        host="localhost",
+        user=input("username: "),
+        password=getpass("password: "),
+    ) as connection:
+        print(connection)
+except Error as e:
+    print(e)