def delactivity(ext_id, user, password, context):
dbobj = sp.dbAccess()
dbobj.set_context(context)
if not dbobj.authent_user(user, password): return False
if dbobj.db_get_activity(user, ext_id):
if dbobj.db_del_activity(user, ext_id):
context.funlog().logger.info("The activity " + ext_id + " deleted")
else:
context.funlog().logger.info("The activity " + ext_id +
" NOT deleted")
else:
context.funlog().logger.info("The activity " + ext_id + " NOT found")
def setpersonal(date_time, data, user, password, context):
dbobj = sp.dbAccess()
dbobj.set_context(context)
if not dbobj.authent_user(user, password): return False
if dbobj.db_update_personal(date_time, data, user):
# if sp.db_insert_personal(date_time, data, user):
context.funlog().logger.info("The personal data SET: " + date_time +
" " + user + ", " + str(data))
else:
context.funlog().logger.info("The personal data " + date_time + " " +
user + " NOT set")
def plan_upload(plan_text, _override, _version, user_name, password, context):
dbobj = sp.dbAccess()
dbobj.set_context(context)
if not dbobj.authent_user(user_name, password): return False
profiles_txt = dbobj.db_get_profiles(user_name)
if profiles_txt:
res = sp.plan2csv(plan_text,
profiles_txt,
context,
act_id_suffix=' manual ' + _version)
csv_string = res['csv']
imTSS = res['imTSS']
print csv_string
print 'imTSS', imTSS
outf = open("plan_csv_output", "w")
outf.write(csv_string)
outf.close()
p = sp.SportProfiles(text=profiles_txt, parent=dbobj)
summ = sp.SportSummarize(csvstring=csv_string, profiles=p, parent=p)
summ.execute(user_name, delta_time_reset=False)
summ.persist(user_name, _version, override=_override)
#print csv_string
#print summ.summ
# sum=tcx_sum(tcx_string, profiles_txt, user_name, context)
#
# sum.persist(user_name, version, override=_override)
for item in imTSS:
addactivity.addactivity(item['datetime'],
item['discipline'],
item['duration'],
_version,
_override,
user_name,
password,
context,
rTSS=item['rTSS'],
hrTSS=item['hrTSS'],
TSS=item['TSS'],
sTSS=item['sTSS'])
else:
msg = "Profiles for user " + user_name + " not found id db"
context.funlog().logger.error(msg)
raise Exception(msg), None, sys.exc_info()[2]
def tcx_upload(tcx_string, _override, version, user_name, password, context):
dbobj = sp.dbAccess()
dbobj.set_context(context)
if not dbobj.authent_user(user_name, password): return False
profiles_txt = dbobj.db_get_profiles(user_name)
if profiles_txt:
sum = tcx_sum(tcx_string, profiles_txt, user_name, context)
#print sum.get_summarize()
sum.persist(user_name, version, override=_override)
else:
context.funlog().logger.error("Profiles for user " + user_name +
" not found id db")
def delversion(version, user, password, context):
dbobj = sp.dbAccess()
dbobj.set_context(context)
if not dbobj.authent_user(user, password): return False
del_rec = dbobj.db_del_version(user, version)
if del_rec != None:
if del_rec > 0:
context.funlog().logger.info("The version " + version +
" was deleted, " + str(del_rec) +
" activities")
else:
context.funlog().logger.info(
"The version " + version +
" was NOT deleted, 0 activities found")
else:
context.funlog().logger.info("delete sql error")
def profiles_upload(profiles_string, user_name, password, context):
dbobj=sp.dbAccess()
dbobj.set_context(context)
if not dbobj.authent_user(user_name, password): return False
p=sp.SportProfiles(text=profiles_string)
if context: p.set_context(context)
try:
if not dbobj.db_persist_profiles(profiles_string, user_name):
context.funlog().logger.error("Profile upload error, user name "+user_name)
else:
context.funlog().logger.error("Profile uploaded, user name "+user_name)
except Exception as e:
context.syslog().logger.error(e.message)
context.funlog().logger.error("Profile upload error, user name "+user_name)
raise e, None, sys.exc_info()[2]
def addactivity(date_time,
discipline,
duration,
version,
override,
user,
password,
_context,
rTSS=None,
hrTSS=None,
TSS=None,
sTSS=None):
dbobj = sp.dbAccess()
dbobj.set_context(_context)
if not dbobj.authent_user(user, password): return False
summ = sp.SportSummarize(context=_context)
ext_id = date_time + " " + discipline
summ.summ[ext_id] = defaultdict(lambda: 0)
summ.summ[ext_id] = {
"discipline": discipline,
"duration": duration,
"start_date_time": ut.strYmdHMS2datetime(date_time)
}
if rTSS:
summ.summ[ext_id]["rTSS"] = rTSS
summ.summ[ext_id]["rTSScover"] = duration
if hrTSS:
summ.summ[ext_id]["hrTSS"] = hrTSS
summ.summ[ext_id]["hrTSScover"] = duration
if TSS:
summ.summ[ext_id]["TSS"] = TSS
summ.summ[ext_id]["TSScover"] = duration
if sTSS:
summ.summ[ext_id]["sTSS"] = sTSS
summ.summ[ext_id]["sTSScover"] = duration
summ.persist(user, version, override)
print summ.summ
def listpersonal(user, password, context):
dbobj = sp.dbAccess()
dbobj.set_context(context)
if not dbobj.authent_user(user, password): return False
return dbobj.db_list_personal(user)
def listactivity(version,user, password,context):
dbobj=sp.dbAccess()
dbobj.set_context(context)
if not dbobj.authent_user(user, password): return False
return dbobj.db_list_activities(version, user)
