salipshitz · salipshitz · Oct 20, 2017 · Sep 29, 2017 · Sep 30, 2017 · Sep 30, 2017
diff --git a/__pycache__/mainloop.cpython-34.pyc b/__pycache__/mainloop.cpython-34.pyc
diff --git a/__pycache__/screens.cpython-34.pyc b/__pycache__/screens.cpython-34.pyc
diff --git a/__pycache__/screens.cpython-35.pyc b/__pycache__/screens.cpython-35.pyc
diff --git a/__pycache__/window.cpython-34.pyc b/__pycache__/window.cpython-34.pyc
diff --git a/__pycache__/window.cpython-35.pyc b/__pycache__/window.cpython-35.pyc
diff --git a/appinst/exe.md b/appinst/exe.md
diff --git a/appinst/setup.py b/appinst/setup.py
diff --git a/dist/LearnPythonWithPython.exe b/dist/LearnPythonWithPython.exe
diff --git a/handlers.py b/handlers.py
@@ -0,0 +1,60 @@
+import sqlite3
+import smtplib
+
+class UserError(Exception):
+    pass
+
+class SqlHandler:
+    def __init__(self):
+        self.connection = sqlite3.connect("comments.db")
+        self.cursor = self.connection
+
+        cmd = """
+        CREATE TABLE IF NOT EXISTS users (
+        id INTEGER PRIMARY KEY,
+        username TEXT
+        email TEXT
+        password TEXT);"""
+
+        self.cursor.execute(cmd)
+
+        cmd = """
+        CREATE TABLE IF NOT EXISTS comments (
+        id INTEGER PRIMARY KEY,
+        senderId INTEGER
+        comment TEXT);"""
+
+        self.cursor.execute(cmd)
+
+    def login(self, username, password):
+        cmd = "SELECT 1 FROM users WHERE ((username = {0} OR email = {0}) AND password = {1});".format(username, password)
+        self.cursor.execute(cmd)
+        user = self.cursor.fetchone()
+        try:
+           assert user != None
+        except AssertionError:
+            raise UserError("While logging in: Username or password not correct.")
+        return user
+
+    def signup(self, username, email, password):
+        cmd = "SELECT 1 FROM users WHERE (username = \"{0}\" OR email = \"{1}\");".format(username, email)
+        self.cursor.execute(cmd)
+        try:
+            assert user == None
+        except AssertionError:
+            raise UserError("While signing up: User with username or email already exists")
+            return False
+        cmd = "INSERT INTO users VALUES(NULL, {0}, {1}, {2});\n SELECT 1 FROM users WHERE (username = {0});".format(username, email, password)
+        self.cursor.execute(cmd)
+        return self.cursor.fetchone()
+
+    def sendComment(self, senderId, comment):
+        cmd = "INSERT INTO comments VALUES(NULL, {0}, {1});".format(senderId, comment)
+        self.cursor.execute(cmd)
+
+    def showComments(self):
+        cmd = "SELECT * FROM comments"
+        self.cursor.execute(cmd)
+        return self.fetchall
+
+
diff --git a/screens.py b/screens.py
diff --git a/setup_exe.py b/setup_exe.py
@@ -0,0 +1,11 @@
+from distutils.core import setup
+import py2exe
+import window, screens
+
+setup(
+    console = [{
+        "script": "mainloop.py",
+        "icon_resources": [(1, "pycon-icon.ico")],
+        "dest_base": "LearnPythonWithPython"
+    }]
+)
diff --git a/window.py b/window.py
@@ -3,7 +3,7 @@
 class Window(Frame):
         def __init__(self, master=None):
                super(Window, self).__init__()
-               self.s_init()
+               self.s_init(1)
 
         def close_app(self):
                 self.master.destroy()
@@ -21,8 +21,8 @@ def choBtn(self, txt, func, x, y):
         def btnQuit(self):
                 return self.choBtn("Quit", self.close_app, 0, 0)
 
-        def btnBack(self):
-                return self.choBtn("Back", self.s_init, 0, 0)
+        def btnBack(self, unit):
+                return self.choBtn("Back", lambda: self.s_init(unit), 0, 0)
 
         def btnNext(self, nextScreen):
                 return Button(self, text="Next", command=nextScreen).place(relx=1.0, rely=1.0, anchor=SE)
@@ -39,12 +39,12 @@ def cenLbl(self, txt):
                 return Label(self, text=txt).pack()
 
         def multiLbl(self, txt):
-                return Label(self, text=txt, anchor=W, wraplength=425).pack()
+                return Label(self, text=txt, wraplength=750).pack(anchor=W)
 
-        def new(self, home=False):
+        def new(self, unit):
                 for widget in self.winfo_children():
                         widget.destroy()
-                if home == True:
+                if unit == 0:
                         self.btnQuit()
                 else:
-                        self.btnBack()
+                        self.btnBack(unit)