def get_users_by_feed(feed_id):
conn, cursor = database.open_cursor()
cursor.execute("SELECT user_id FROM userfeeds WHERE feed_id = ?",
(feed_id, ))
dados = cursor.fetchall()
database.close_cursor(conn, cursor)
return dados
def get(userid):
conn, cursor = database.open_cursor()
cursor.execute("SELECT * FROM users WHERE userid = ?", (userid,))
dados = cursor.fetchone()
database.close_cursor(conn, cursor)
try:
return dados[0]
except Exception:
return False
def add(userid):
user_id = get(userid)
if(not user_id):
conn, cursor = database.open_cursor()
cursor.execute("INSERT INTO users VALUES (?, ?)", (None, userid))
conn.commit()
user_id = cursor.lastrowid
database.close_cursor(conn, cursor)
return user_id
def add(url):
feed_id = get(url)
if (not feed_id):
conn, cursor = database.open_cursor()
cursor.execute("INSERT INTO feeds VALUES (?, ?)", (None, url))
conn.commit()
feed_id = cursor.lastrowid
database.close_cursor(conn, cursor)
return feed_id
def get(guid, feed_id):
conn, cursor = database.open_cursor()
cursor.execute("SELECT * FROM links WHERE guid = ? AND feed_id = ?",
(guid, feed_id))
dados = cursor.fetchone()
database.close_cursor(conn, cursor)
try:
return dados[0]
except Exception:
return False
def add(guid, feed_id):
link_id = link.get(guid, feed_id)
if (not link_id):
conn, cursor = database.open_cursor()
cursor.execute("INSERT INTO links VALUES (?, ?, ?)",
(None, guid, feed_id))
conn.commit()
link_id = cursor.lastrowid
database.close_cursor(conn, cursor)
return link_id
def get_all():
conn, cursor = database.open_cursor()
cursor.execute("SELECT * FROM users")
return cursor.fetchall()