View Single Post
Posts: 398 | Thanked: 301 times | Joined on Sep 2007 @ Texas
#248
If the sqlite code stays, you'll also need to take into account the name change between PR1.2 and PR1.x. Maybe the below?

Originally Posted by Frank Banul View Post
Code:
        try:
            connection = sqlite3.connect(os.path.join(os.environ['HOME'], '.rtcom-eventlogger', 'el-v1.db'))
        except:
            connection = sqlite3.connect(os.path.join(os.environ['HOME'], '.rtcom-eventlogger', 'el.db'))
        cursor = connection.cursor()        
        cursor.execute('SELECT id FROM Events')
        id_array = cursor.fetchall()  
        seq_id = max(id_array)[0] + 1