Skip to content
Extraits de code Groupes Projets
user.py 1,41 ko
Newer Older
  • Learn to ignore specific revisions
  • Tom Godfroid's avatar
    Tom Godfroid a validé
    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"])