Lines Matching full:query
182 def QueryExec(query, stmt): argument
183 ret = query.exec_(stmt)
185 raise Exception("Query failed: " + query.lastError().text())
539 query = QSqlQuery(self.glb.db)
544 …QueryExec(query, "SELECT call_path_id, name, short_name, COUNT(calls.id), SUM(return_time - call_t…
554 while query.next():
556 insn_cnt = int(query.value(5))
557 cyc_cnt = int(query.value(6))
558 branch_count = int(query.value(7))
562 branch_count = int(query.value(5))
563 …ld_count, self.comm_id, self.thread_id, query.value(0), query.value(1), query.value(2), query.valu…
626 query = QSqlQuery(self.glb.db)
627 QueryExec(query, "SELECT thread_id, pid, tid"
631 while query.next():
632 …oItem(self.glb, self.params, self.child_count, self.dbid, query.value(0), query.value(1), query.va…
647 query = QSqlQuery(glb.db)
648 QueryExec(query, "SELECT id, comm FROM comms" + if_has_calls)
649 while query.next():
650 if not query.value(0):
652 …child_item = CallGraphLevelOneItem(glb, params, self.child_count, query.value(0), query.value(1), …
670 def FindSelect(self, value, pattern, query): argument
688 self.DoFindSelect(query, match)
690 def Found(self, query, found): argument
692 return self.FindPath(query)
695 def FindValue(self, value, pattern, query, last_value, last_pattern): argument
697 found = query.first()
699 self.FindSelect(value, pattern, query)
700 found = query.next()
701 return self.Found(query, found)
703 def FindNext(self, query): argument
704 found = query.next()
706 found = query.first()
707 return self.Found(query, found)
709 def FindPrev(self, query): argument
710 found = query.previous()
712 found = query.last()
713 return self.Found(query, found)
717 ids = self.FindValue(c.value, c.pattern, c.query, c.last_value, c.last_pattern)
719 ids = self.FindNext(c.query)
721 ids = self.FindPrev(c.query)
727 self.value, self.direction, self.pattern, self.query, self.last_value, self.last_pattern = x
772 def DoFindSelect(self, query, match): argument
773 QueryExec(query, "SELECT call_path_id, comm_id, thread_id"
782 def FindPath(self, query): argument
783 # Turn the query result into a list of ids that the tree view can walk
786 parent_id = query.value(0)
799 ids.insert(0, query.value(2))
800 ids.insert(0, query.value(1))
828 query = QSqlQuery(self.glb.db)
829 …QueryExec(query, "SELECT calls.id, name, short_name, call_time, return_time - call_time" + ipc_str…
836 while query.next():
838 insn_cnt = int(query.value(5))
839 cyc_cnt = int(query.value(6))
840 branch_count = int(query.value(7))
844 branch_count = int(query.value(5))
845 …ld_count, self.comm_id, self.thread_id, query.value(0), query.value(1), query.value(2), query.valu…
908 query = QSqlQuery(self.glb.db)
909 QueryExec(query, "SELECT thread_id, pid, tid"
913 while query.next():
914 …oItem(self.glb, self.params, self.child_count, self.dbid, query.value(0), query.value(1), query.va…
929 query = QSqlQuery(glb.db)
930 QueryExec(query, "SELECT id, comm FROM comms" + if_has_calls)
931 while query.next():
932 if not query.value(0):
934 …child_item = CallTreeLevelOneItem(glb, params, self.child_count, query.value(0), query.value(1), s…
968 def DoFindSelect(self, query, match): argument
969 QueryExec(query, "SELECT calls.id, comm_id, thread_id"
977 def FindPath(self, query): argument
978 # Turn the query result into a list of ids that the tree view can walk
981 parent_id = query.value(0)
991 ids.insert(0, query.value(2))
992 ids.insert(0, query.value(1))
1176 query = QSqlQuery(db)
1177 QueryExec(query, "SELECT comm_threads.comm_id, comms.c_time, comms.exec_flag"
1184 while query.next():
1186 first = query.value(0)
1187 if query.value(2) and Decimal(query.value(1)) <= Decimal(time):
1188 last = query.value(0)
1302 query = QSqlQuery(db)
1303 QueryExec(query, "SELECT id, c_time"
1310 while query.next():
1311 comm_id = query.value(0)
1314 time = query.value(1)
1322 query = QSqlQuery(db)
1323 QueryExec(query, "SELECT time, thread_out_id, thread_in_id, comm_out_id, comm_in_id, flags"
1328 while query.next():
1329 flags = int(query.value(5))
1332 …if last_thread_id == query.value(1) and last_comm_id is not None and last_comm_id != query.value(3…
1333 self.SelectComms(db, last_thread_id, last_comm_id, last_time, query.value(0))
1338 hregion = self.HRegion(db, query.value(1), query.value(3), start_time)
1340 time = query.value(0)
1341 comm_id = query.value(4)
1342 thread_id = query.value(2)
1351 query = QSqlQuery(db)
1352 QueryExec(query, "SELECT pid, tid FROM threads WHERE id = " + str(thread_id))
1353 if query.next():
1354 pid = query.value(0)
1355 tid = query.value(1)
1359 query = QSqlQuery(db)
1360 QueryExec(query, "SELECT comm FROM comms WHERE id = " + str(comm_id))
1361 if query.next():
1362 comm = query.value(0)
1421 query = QSqlQuery(db)
1422 QueryExec(query, "SELECT DISTINCT cpu"
1425 while query.next():
1426 cpus.append(int(query.value(0)))
2551 self.query = QSqlQuery(self.db)
2565 QueryExec(self.query, stmt)
2568 if not self.query.next():
2570 if not self.query.next():
2572 self.last_id = self.query.value(0)
2573 return self.prep(self.query)
2911 query = QSqlQuery(self.glb.db)
2913 …QueryExec(query, "SELECT cpu, to_dso_id, to_symbol_id, to_sym_offset, short_name, long_name, build…
2918 if not query.next():
2920 cpu = query.value(0)
2921 dso = query.value(1)
2922 sym = query.value(2)
2925 off = query.value(3)
2926 short_name = query.value(4)
2927 long_name = query.value(5)
2928 build_id = query.value(6)
2929 sym_start = query.value(7)
2930 ip = query.value(8)
2932 QueryExec(query, "SELECT samples.dso_id, symbol_id, sym_offset, sym_start"
2938 if not query.next():
2940 if query.value(0) != dso:
2943 bsym = query.value(1)
2944 boff = query.value(2)
2945 bsym_start = query.value(3)
3038 def BranchDataPrepBr(query, data): argument
3039 data.append(tohex(query.value(8)).rjust(16) + " " + query.value(9) + offstr(query.value(10)) +
3040 " (" + dsoname(query.value(11)) + ")" + " -> " +
3041 tohex(query.value(12)) + " " + query.value(13) + offstr(query.value(14)) +
3042 " (" + dsoname(query.value(15)) + ")")
3044 def BranchDataPrepIPC(query, data): argument
3045 insn_cnt = query.value(16)
3046 cyc_cnt = query.value(17)
3052 def BranchDataPrep(query): argument
3055 data.append(query.value(i))
3056 BranchDataPrepBr(query, data)
3059 def BranchDataPrepWA(query): argument
3061 data.append(query.value(0))
3063 data.append("{:>19}".format(query.value(1)))
3065 data.append(query.value(i))
3066 BranchDataPrepBr(query, data)
3069 def BranchDataWithIPCPrep(query): argument
3072 data.append(query.value(i))
3073 BranchDataPrepIPC(query, data)
3074 BranchDataPrepBr(query, data)
3077 def BranchDataWithIPCPrepWA(query): argument
3079 data.append(query.value(0))
3081 data.append("{:>19}".format(query.value(1)))
3083 data.append(query.value(i))
3084 BranchDataPrepIPC(query, data)
3085 BranchDataPrepBr(query, data)
3410 query = QSqlQuery(self.glb.db)
3412 ret = query.exec_(stmt)
3414 while query.next():
3415 ids.append(str(query.value(0)))
3441 query = QSqlQuery(glb.db)
3442 QueryExec(query, "SELECT id, time FROM samples ORDER BY id DESC LIMIT 1")
3443 if query.next():
3444 self.last_id = int(query.value(0))
3452 def IdBetween(self, query, lower_id, higher_id, order): argument
3453 …QueryExec(query, "SELECT id FROM samples WHERE id > " + str(lower_id) + " AND id < " + str(higher_…
3454 if query.next():
3455 return True, int(query.value(0))
3460 query = QSqlQuery(self.glb.db)
3463 QueryExec(query, "SELECT time FROM samples WHERE id = " + str(next_id))
3464 if not query.next():
3465 ok, dbid = self.IdBetween(query, lower_id, next_id, "DESC")
3467 ok, dbid = self.IdBetween(query, next_id, higher_id, "")
3471 QueryExec(query, "SELECT time FROM samples WHERE id = " + str(next_id))
3472 next_time = int(query.value(0))
3651 query = QSqlQuery(db)
3652 QueryExec(query, "SELECT name FROM selected_events WHERE id > 0 ORDER BY id")
3653 while query.next():
3654 events.append(query.value(0))
3660 query = QSqlQuery(db)
3662 QueryExec(query, "SELECT " + columns + " FROM " + table + " " + sql + " LIMIT 1")
3734 def SQLTableDataPrep(self, query, count): argument
3737 data.append(query.value(i))
3750 query = QSqlQuery(glb.db)
3752 QueryExec(query, "PRAGMA table_info(" + table_name + ")")
3753 while query.next():
3754 column_headers.append(query.value(1))
3765 …QueryExec(query, "SELECT column_name FROM information_schema.columns WHERE table_schema = '" + sch…
3766 while query.next():
3767 column_headers.append(query.value(0))
3775 def samples_view_DataPrep(self, query, count): argument
3777 data.append(query.value(0))
3779 data.append("{:>19}".format(query.value(1)))
3781 data.append(query.value(i))
3784 def samples_DataPrep(self, query, count): argument
3787 data.append(query.value(i))
3789 data.append("{:>19}".format(query.value(9)))
3791 data.append(query.value(i))
4118 query = QSqlQuery(glb.db)
4120 …QueryExec(query, "SELECT name FROM sqlite_master WHERE type IN ( 'table' , 'view' ) ORDER BY name")
4122 …QueryExec(query, "SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' A…
4123 while query.next():
4124 tables.append(query.value(0))
4505 query = QSqlQuery(db)
4506 QueryExec(query, "SELECT VERSION()")
4507 if query.next():
4508 v_str = query.value(0)
4518 query = QSqlQuery(db)
4519 QueryExec(query, "SELECT sqlite_version()")
4520 if query.next():
4521 return query.value(0)
4922 query = QSqlQuery(self.db)
4923 QueryExec(query, "SELECT id FROM machines WHERE pid = -1")
4924 if query.next():
4925 self.host_machine_id = query.value(0)
4936 query = QSqlQuery(self.db)
4938 QueryExec(query, sql)
4941 if query.next():
4942 return Decimal(query.value(0))