StudentDatabase/main.py at master · ngengesenior/StudentDatabase · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
import re

from kivy.uix.textinput import TextInput

import model
from kivy.app import App
from kivy.properties import ObjectProperty
from kivy.uix.label import Label
from kivy.uix.popup import Popup
from kivy.uix.screenmanager import Screen, ScreenManager
import sqlite3


class ErrorPopup(Popup):
    pass


class AddStudent(Screen):
    first_name = ObjectProperty(None)
    last_name = ObjectProperty(None)
    student_id = ObjectProperty(None)
    phone_number = ObjectProperty(None)
    parent_address = ObjectProperty(None)
    male_check = ObjectProperty(None)
    female_check = ObjectProperty(None)

    def insert_student(self):
        if self.validate_input():
            model.insert(self.first_name.text, self.last_name.text, self.student_id.text.upper(),
                         self.phone_number.text,
                         self.parent_address.text, self.validate_check())

            print "Student inserted"

            self.first_name.text, self.last_name.text, self.student_id.text, \
                self.phone_number.text, self.parent_address.text =\
                "", "", "", "", ""

        else:
            error_pop = ErrorPopup()
            error_pop.ids.error.text = "Failed to insert student in database.try again"
            error_pop.title = "Insert Error"
            error_pop.open()

    def validate_check(self):
        if self.male_check.state == "down":
            print "Male"
            return "M"
        if self.female_check.state == "down":
            print "Female"
            return "F"

    def validate_input(self):
        if self.first_name.text != "" and self.last_name.text != "" and self.student_id.text != "" and self.phone_number.text != "" and self.parent_address.text != "":
            print "True"
            return True
        else:
            print "False"
            return False


class RemoveStudent(Screen):
    pass


class Manager(ScreenManager):
    pass


class MainScreenManager(ScreenManager):
    pass


class Login(Screen):
    login_name = ObjectProperty(None)
    password = ObjectProperty(None)

    def __init__(self, **kwargs):
        super(Login, self).__init__(**kwargs)

    def login(self):
        try:
            conn = sqlite3.connect("student_db.db")
            curs = conn.cursor()
            curs.execute(
                "SELECT * FROM admin"
            )

            name, password = curs.fetchone()
            print name, password
            if name == self.login_name.text and password == self.password.text:
                self.manager.current = "main_screen"
                self.password.text, self.login_name.text = "", ""
                print "User logged in"
            else:
                print "Login failure"
                pop_error = ErrorPopup()
                pop_error.title = "Login failure"
                pop_error.ids.error.text = "Failed to login.Check credentials"
                pop_error.open()

        except sqlite3.OperationalError as err:
            pop_error = ErrorPopup()
            pop_error.title = "Login failure"
            pop_error.ids.error.text = err.message + " .Failed to login user"
            pop_error.open()


class MainScreen(Screen):
    pass

class FloatInput(TextInput):

    pat = re.compile('[^0-9]')

    def insert_text(self, substring, from_undo=False):
        pat = self.pat
        if '.' in self.text:
            s = re.sub(pat, '', substring)
        else:
            s = '.'.join([re.sub(pat, '', s) for s in \
                              substring.split('.', 1)])
        return super(FloatInput, self).insert_text(s, from_undo=from_undo)


class MainApp(App):
    def build(self):
        manager = Manager()
        return manager


if __name__ == '__main__':
    conn = sqlite3.connect('student_db.db')
    curs = conn.cursor()
    data = curs.execute("SELECT * FROM students")
    data = data.fetchall()
    print data
    MainApp().run()