Newer
Older
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
from mobility.db import get_db
### Data methods are methods that do not return User objects. They return plain data from the database.
def get_user_list():
db = get_db()
return db.execute('SELECT * FROM users ORDER BY username')
def search_by_email(email:str):
db = get_db()
return db.execute('SELECT * FROM users WHERE email=?', (email,)).fetchall()
### The User class handles a single user. It has functions to interact with the database.
class User:
def __init__(self, username, email, id=None):
self.id = id
self.username = username
self.email = email
def delete(self):
db = get_db()
db.execute("DELETE FROM users WHERE id=?", (self.id,))
db.commit()
def save(self):
db = get_db()
if self.id is None:
db.execute("INSERT INTO users(username, email) VALUES(?, ?)" , (self.username, self.email))
else:
db.execute("UPDATE users(username, email) SET username=?, email=? WHERE id=?" , (self.username, self.email, self.id))
db.commit()
### Static methods do not act on a specific user, they themselves return users
@staticmethod
def get(id:int):
db = get_db()
data = db.execute('SELECT * FROM users WHERE id=?', (id,)).fetchone()
if data is None:
return None
else:
return User(data["username"], data["email"], data["id"])