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)