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 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 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 get_registered_accounts_count():
cur = dblayer.run("SELECT COUNT(id) AS X FROM GoogleAccounts")
count = dblayer.getValue(cur, "X")
return count
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 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
