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()