FU5ZCQDH

1import sqlite3
2from sqlite3 import Error
3
4def cConn():
5    conn = None
6    try:
7        conn = sqlite3.connect("feed_list.db3")
8    except Error as e:
9        print(e)
10        
11    return conn
12
13def cTable():
14    sql = "create table if not exists rssFeed (id integer primary key, shortname text, title text, description text, link text, date_added text);"
15    conn = cConn()
16
17    try:
18        c = conn.cursor()
19        c.execute(sql)
20    except Error as e:
21        print(e)
22        
23def cInsert(record):
24    sql = '''insert into rssFeed (shortname, title, description, link, date_added) values (?,?,?,?,?)'''
25    conn = cConn()
26    cur = conn.cursor()
27    cur.execute(sql, record)
28    conn.commit()
29    cur.close()
30        
31        
32def cSelect(id, shortname):
33    sql = "select * from rssFeed"
34    if id != "":
35        sql += " where id=" + str(id)
36    elif shortname != "":
37        sql += " where shortname='" + str(shortname) + "'"
38        
39    conn = cConn()
40    cur = conn.cursor()
41    cur.execute(sql)
42    
43    return cur.fetchall()