def get_spcific_distance(self): models = [] if self.root is None: return try: conn = SqliteByCSharp(self.root, self.cache) with conn as cmd: cmd.CommandText = """ select (samples.start_date+978336000) as "Start Date",(samples.end_date+978336000) as "End Date", samples.data_id,data_type, quantity,original_quantity,unit_strings.unit_string,data_provenances.origin_product_type,data_provenances.origin_build,data_provenances.local_product_type,data_provenances.local_build from samples left outer join quantity_samples on samples.data_id = quantity_samples.data_id left outer join unit_strings on quantity_samples.original_unit = unit_strings.RowID left outer join objects on samples.data_id = objects.data_id left outer join data_provenances on objects.provenance = data_provenances.RowID where data_type = 8 """ reader = cmd.ExecuteReader() while reader.Read(): try: cache_time = SqliteByCSharp.GetFloat(reader, 1) distance = SqliteByCSharp.GetFloat(reader, 4) spcific_distance = Health.System.DistanceRecord() spcific_distance.Time = TimeStamp.FromUnixTime( cache_time, False) spcific_distance.Distance = float(distance) models.append(spcific_distance) except Exception as e: print(e) except Exception as e: pass return models
def get_groups_member(self, node, account_id): g_node = node.GetByPath("nim_cache.db") if g_node is None: return try: conn = SqliteByCSharp(g_node, self.cache) with conn as cmd: cmd.CommandText = ''' select tid, account, nick, join_time from tuser ''' reader = cmd.ExecuteReader() while reader.Read(): try: chatroom_id = SqliteByCSharp.GetString(reader, 0) memeber_id = SqliteByCSharp.GetString(reader, 1) display_name = SqliteByCSharp.GetString(reader, 2) member = model_im.ChatroomMember() member.source = g_node.AbsolutePath member.account_id = account_id member.chatroom_id = chatroom_id member.member_id = memeber_id member.display_name = display_name if member.account_id and member.chatroom_id and member.member_id: self.bulletMessage.db_insert_table_chatroom_member( member) except Exception as e: pass except Exception as e: pass self.bulletMessage.db_commit()
def get_all_sendname(self, node): s_node = node.GetByPath("msg.db") if s_node is None: return try: conn = SqliteByCSharp(s_node, self.cache) with conn as cmd: cmd.CommandText = ''' select account, nick from sender_nick ''' reader = cmd.ExecuteReader() while reader.Read(): try: self.all_send_nick_name[SqliteByCSharp.GetString( reader, 0)] = SqliteByCSharp.GetString(reader, 1) except Exception as e: pass except Exception as e: pass
def get_groups(self, node, account_id): groups_node = node.GetByPath("nim_cache.db") if groups_node is None: return try: conn = SqliteByCSharp(groups_node, self.cache) with conn as cmd: cmd.CommandText = ''' select id,name,creator,level,count,introduce,create_time,icon from team ''' reader = cmd.ExecuteReader() while reader.Read(): try: chatroom_id = SqliteByCSharp.GetString(reader, 0) name = SqliteByCSharp.GetString(reader, 1) creator_id = SqliteByCSharp.GetString(reader, 2) max_member_count = SqliteByCSharp.GetInt64(reader, 3) member_count = SqliteByCSharp.GetInt64(reader, 4) notice = SqliteByCSharp.GetString(reader, 5) create_time = SqliteByCSharp.GetInt64(reader, 6) photo = SqliteByCSharp.GetString(reader, 7) self.group_list[chatroom_id] = name chatroom = model_im.Chatroom() chatroom.source = groups_node.AbsolutePath chatroom.account_id = account_id chatroom.chatroom_id = chatroom_id chatroom.name = name chatroom.creator_id = creator_id chatroom.max_member_count = max_member_count chatroom.member_count = member_count chatroom.notice = notice chatroom.photo = photo chatroom.type = 1 # 普通群 if chatroom.account_id and chatroom.chatroom_id: self.bulletMessage.db_insert_table_chatroom( chatroom) except Exception as e: print(e) except Exception as e: print(e) self.bulletMessage.db_commit()
def get_friend(self, node, account_id): f_node = node.GetByPath("nim_cache.db") if f_node is None: return try: conn = SqliteByCSharp(f_node, self.cache) with conn as cmd: cmd.CommandText = ''' select uinfo.account,uinfo.name,uinfo.icon,uinfo.sign,uinfo.gender,uinfo.email, uinfo.mobile from uinfo,friend where uinfo.account = friend.account ''' reader = cmd.ExecuteReader() while reader.Read(): try: friend_id = SqliteByCSharp.GetString(reader, 0) nickname = SqliteByCSharp.GetString(reader, 1) avtar = SqliteByCSharp.GetString(reader, 2) sign = SqliteByCSharp.GetString(reader, 3) gender = SqliteByCSharp.GetInt64(reader, 4) email = SqliteByCSharp.GetString(reader, 5) phone = SqliteByCSharp.GetString(reader, 6) self.friend_list[friend_id] = nickname friend = model_im.Friend() friend.source = f_node.AbsolutePath friend.account_id = account_id friend.friend_id = friend_id friend.nickname = nickname friend.photo = avtar friend.telephone = phone friend.signature = sign friend.email = email friend.type = model_im.FRIEND_TYPE_FRIEND if friend.account_id and friend.friend_id: self.bulletMessage.db_insert_table_friend(friend) except Exception as e: print(e) except Exception as e: print(e) self.bulletMessage.db_commit()
def get_fitness_record(self): models = [] if self.root is None: return try: conn = SqliteByCSharp(self.root, self.cache) with conn as cmd: cmd.CommandText = """ select (energy_burned_goal_date+978336000) as "Energy Burned Goal Date", (cache_index+978336000) as "cache_index", energy_burned,energy_burned_goal,active_hours,active_hours_goal,brisk_minutes,brisk_minutes_goal, steps,walk_distance from activity_caches """ reader = cmd.ExecuteReader() while reader.Read(): try: cache_time = SqliteByCSharp.GetFloat(reader, 1) energy_burned = SqliteByCSharp.GetFloat(reader, 2) # energy_burned_goal = SqliteByCSharp.GetFloat(reader, 3) active_hours = SqliteByCSharp.GetFloat(reader, 4) # active_hours_goal = SqliteByCSharp.GetFloat(reader, 5) brisk_minutes = SqliteByCSharp.GetFloat(reader, 6) # brisk_minutes_goal = SqliteByCSharp.GetFloat(reader, 7) step = SqliteByCSharp.GetFloat(reader, 8) walk_distance = SqliteByCSharp.GetFloat(reader, 9) fitness_record = Health.System.FitnessRecord() fitness_record.Activity = energy_burned fitness_record.Workout = brisk_minutes fitness_record.Standing = active_hours fitness_record.StepNumber = step fitness_record.Distance = walk_distance fitness_record.Time = TimeStamp.FromUnixTime( cache_time, False) models.append(fitness_record) except Exception as e: print(e) except Exception as e: pass return models
def get_account(self, node, account_id): a_node = node.GetByPath("nim_cache.db") if a_node is None: return try: conn = SqliteByCSharp(a_node, self.cache) with conn as cmd: cmd.CommandText = 'select account, name, icon, sign, gender, mobile from uinfo where account = {0}'.format( account_id) reader = cmd.ExecuteReader() while reader.Read(): try: a_id = SqliteByCSharp.GetString(reader, 0) nickname = SqliteByCSharp.GetString(reader, 1) avtar = SqliteByCSharp.GetString(reader, 2) sign = SqliteByCSharp.GetString(reader, 3) gender = SqliteByCSharp.GetInt64(reader, 4) phone = SqliteByCSharp.GetString(reader, 5) account = model_im.Account() account.source = a_node.AbsolutePath account.account_id = a_id account.nickname = nickname account.photo = avtar account.gender = gender account.signature = sign account.telephone = phone if account.account_id: self.bulletMessage.db_insert_table_account(account) except Exception as e: pass except Exception as e: pass self.bulletMessage.db_commit()