Exemple #1
0
def update_database(c, conn, users, subreddit: Subreddit):
    date = datetime.date.today()
    contributors = list()
    for contributor in subreddit.contributor(limit=0x7D0):
        contributors.append(contributor)
    for contributor in contributors:
        if users.count(contributor) == 0:
            contributor_name = contributor.name
            c.execute('INSERT INTO Users VALUES(?, ?)',
                      (contributor_name, date,))
            conn.commit()
    for user in users:
        if contributors.count(user) == 0:
            c.execute('DELETE FROM Users WHERE Username=?', (user,))
            conn.commit()
    print('Updated database\n')