almarklein / itemdb Goto Github PK

    db = itemdb.ItemDB(dbname)
    db.ensure_table("all","!videoid","status")

s_thread_fastlane
    db.ensure_table("all","!videoid","status")  
  File "D:\Program Files\anaconda3\lib\site-packages\itemdb.py", line 211, in ensure_table      
    self._ensure_table_helper1(table_name, indices, missing_indices)
  File "D:\Program Files\anaconda3\lib\site-packages\itemdb.py", line 217, in _ensure_table_helper1
    self._ensure_table_helper2(table_name, indices)
  File "D:\Program Files\anaconda3\lib\site-packages\itemdb.py", line 251, in _ensure_table_helper2
    cur.execute(text)
sqlite3.OperationalError: near "all": syntax error

    db=context['db']
    tables=db.get_table_names()
    print('current operating db:',tables)

    for t in tables:
        list = db.select_all(t)  # -> list of 2 items
        # print('------',t,'---------',list)
        if t=='scrape':
            for i in list:
                if i['post_link']==post_link:

                    print('-------------','table',t,'has record\n',i['post_id'])

    tablename ="scrape"    
    # print('check link exist',post_link,db.select(tablename, "post_link==?",post_link))
    try:
        count = len(db.select(tablename, "post_link==?",post_link))
        if count>0:
            print('found exising record',count,'--,',post_link)
            records=db.select(tablename, "post_link==?",post_link)
            for r in records:
                print('!!!!!!!!!',r['post_id'])
            return True
        else:
            return False
    except:
        return False

db = itemdb.ItemDB("transgamers")
print( db.get_table_names())
print(db.count_all("scrape"))