def get_location_information_twitter(backup_dir, output_file):
try:
twitterPositionList = []
db_file_twitter = backup_dir + "/global.db"
resultList = _sqliteParser.parseDB(db_file_twitter)
twitter_id = resultList[1][2][2]
db_file_twitter = backup_dir + "/" + twitter_id + ".db"
resultList = _sqliteParser.parseDB(db_file_twitter)
for i in range(1, len(resultList[4])):
if str(resultList[4][i][2]) == twitter_id:
if str(resultList[4][i][10]) != "None":
lat = resultList[4][i][10]
long = resultList[4][i][11]
title = resultList[4][i][3]
readtime = resultList[4][i][6]
readtime = time.strftime("%x %X",
time.localtime(readtime / 1000))
output_file.write(
'%25s %7d %5d %10s %10s %s \n' %
("twitter", 100, 0, lat, long, str(readtime)))
twitterPositionList.append([
str(title),
str(lat),
str(long), "100",
str(readtime)
])
except:
twitterPositionList = []
return twitterPositionList
def get_location_information_twitter(backup_dir, output_file):
try:
twitterPositionList = []
db_file_twitter = backup_dir + "/global.db"
resultList = _sqliteParser.parseDB(db_file_twitter)
twitter_id = resultList[1][2][2]
db_file_twitter = backup_dir + "/" + twitter_id + ".db"
resultList = _sqliteParser.parseDB(db_file_twitter)
for i in range(1, len(resultList[4])):
if str(resultList[4][i][2]) == twitter_id:
if str(resultList[4][i][10]) != "None":
lat = resultList[4][i][10]
long = resultList[4][i][11]
title = resultList[4][i][3]
readtime = resultList[4][i][6]
readtime = time.strftime("%x %X", time.localtime(readtime / 1000))
output_file.write('%25s %7d %5d %10s %10s %s \n' % ("twitter", 100, 0, lat, long, str(readtime)))
twitterPositionList.append([str(title), str(lat), str(long), "100", str(readtime)])
except:
twitterPositionList = []
return twitterPositionList
def get_location_information_gmaps(backup_dir, outputFile):
try:
gMapsPositionList = []
db_file_gmaps = backup_dir + "/da_destination_history.db"
resultList = _sqliteParser.parseDB(db_file_gmaps)
# [['time', 'INTEGER'], ['dest_lat', 'INTEGER'], ['dest_lng', 'INTEGER'], ['dest_title', 'STRING'], ['dest_address', 'STRING'], ['dest_token', 'STRING'], ['source_lat', 'INTEGER'], ['source_lng', 'INTEGER'], ['day_of_week', 'INTEGER'], ['hour_of_day', 'INTEGER']]
i = 1
while i <= len(resultList) + 1:
if resultList[1][i][3] == None:
title = resultList[1][i][4]
else:
title = resultList[1][i][3]
title = title.replace("\xc3\xbc", "ue") # ue
title = title.replace("\xc3\xa4", "ae") # ae
title = title.replace("\xc3\xb6", "oe") # oe
title = title.replace("\xc3\x9c", "Ue") # Ue
title = title.replace("\xc3\x84", "Ae") # Ae
title = title.replace("\xc3\x96", "Oe") # Oe
title = title.replace("\xc3\x9f", "ss") # ss
lat = resultList[1][i][6]
if "-" in str(lat):
lat = str(lat)[0:3] + "." + str(lat)[3:]
else:
lat = str(lat)[0:2] + "." + str(lat)[2:]
long = resultList[1][i][7]
if "-" in str(long):
long = str(long)[0:3] + "." + str(long)[3:]
else:
long = str(long)[0:2] + "." + str(long)[2:]
readtime = resultList[1][i][0]
readtime = time.strftime("%x %X", time.localtime(readtime / 1000))
outputFile.write('%25s %7d %5d %10s %10s %s \n' %
("GMaps", 500, 0, lat, long, str(readtime)))
gMapsPositionList.append(
[str(title),
str(lat),
str(long), "500",
str(readtime)])
i = i + 1
except:
gMapsPositionList = []
return gMapsPositionList
def get_location_information_gmaps(backup_dir, outputFile):
try:
gMapsPositionList = []
db_file_gmaps = backup_dir + "/da_destination_history.db"
resultList = _sqliteParser.parseDB(db_file_gmaps)
# [['time', 'INTEGER'], ['dest_lat', 'INTEGER'], ['dest_lng', 'INTEGER'], ['dest_title', 'STRING'], ['dest_address', 'STRING'], ['dest_token', 'STRING'], ['source_lat', 'INTEGER'], ['source_lng', 'INTEGER'], ['day_of_week', 'INTEGER'], ['hour_of_day', 'INTEGER']]
i = 1
while i <= len(resultList) + 1:
if resultList[1][i][3] == None:
title = resultList[1][i][4]
else:
title = resultList[1][i][3]
title = title.replace("\xc3\xbc", "ue") # ue
title = title.replace("\xc3\xa4", "ae") # ae
title = title.replace("\xc3\xb6", "oe") # oe
title = title.replace("\xc3\x9c", "Ue") # Ue
title = title.replace("\xc3\x84", "Ae") # Ae
title = title.replace("\xc3\x96", "Oe") # Oe
title = title.replace("\xc3\x9f", "ss") # ss
lat = resultList[1][i][6]
if "-" in str(lat):
lat = str(lat)[0:3] + "." + str(lat)[3:]
else:
lat = str(lat)[0:2] + "." + str(lat)[2:]
long = resultList[1][i][7]
if "-" in str(long):
long = str(long)[0:3] + "." + str(long)[3:]
else:
long = str(long)[0:2] + "." + str(long)[2:]
readtime = resultList[1][i][0]
readtime = time.strftime("%x %X", time.localtime(readtime / 1000))
outputFile.write('%25s %7d %5d %10s %10s %s \n' % ("GMaps", 500, 0, lat, long, str(readtime)))
gMapsPositionList.append([str(title), str(lat), str(long), "500", str(readtime)])
i = i + 1
except:
gMapsPositionList = []
return gMapsPositionList
