def auto_sync_get_synctime(): cur = dblayer.run("SELECT value FROM Prefs where name='auto_sync_time'") time = dblayer.getValue(cur, "value") if not time is None: return time.split(':') else: return None
def check_username_existence(username): cur = dblayer.run("SELECT COUNT(id) AS X FROM GoogleAccounts WHERE "\ "username = ?", (username,)) count = dblayer.getValue(cur, "X") if count > 0: return True else: return False
def get_registered_accounts_count(): cur = dblayer.run("SELECT COUNT(id) AS X FROM GoogleAccounts") count = dblayer.getValue(cur, "X") return count
def eventExistsLocally(id): cur = dblayer.run("SELECT lid FROM Xrefs WHERE gid=?", (id,)) if cur: return dblayer.getValue(cur, 'lid') else: return None
def getLocalIdFromGoogleId(gid): cur = dblayer.run("SELECT lid FROM Xrefs WHERE gid=?", (gid,)) if cur: return dblayer.getValue(cur, 'lid') else: return None
def auto_sync_get_syncid(): cur = dblayer.run("SELECT value FROM Prefs where name='auto_sync_id'") count = dblayer.getValue(cur, "value") return count
def eventExistsLocally(id): cur = dblayer.run("SELECT lid FROM Xrefs WHERE gid=?", (id, )) if cur: return dblayer.getValue(cur, 'lid') else: return None
def getLocalIdFromGoogleId(gid): cur = dblayer.run("SELECT lid FROM Xrefs WHERE gid=?", (gid, )) if cur: return dblayer.getValue(cur, 'lid') else: return None