Lines Matching full:query
144 # Note that some of the examples are not the most optimal SQL query.
204 # query = QSqlQuery(db)
207 # ret = query.exec_('SELECT * FROM call_paths_view WHERE id = ' + str(call_path_i…
209 # raise Exception("Query failed: " + query.lastError().text())
210 # if not query.next():
211 # raise Exception("Query failed")
212 … {3:<30} {4:>6} {5:<30}".format(query.value(0), query.value(1), query.value(2), query.value(3), …
213 # call_path_id = query.value(6)
318 raise Exception("Query failed: " + q.lastError().text())
323 query = QSqlQuery(db) variable
327 do_query(query, 'CREATE DATABASE ' + dbname)
331 query.finish()
332 query.clear()
338 query = QSqlQuery(db) variable
339 do_query(query, 'SET client_min_messages TO WARNING')
341 do_query(query, 'CREATE TABLE selected_events ('
344 do_query(query, 'CREATE TABLE machines ('
348 do_query(query, 'CREATE TABLE threads ('
354 do_query(query, 'CREATE TABLE comms ('
360 do_query(query, 'CREATE TABLE comm_threads ('
364 do_query(query, 'CREATE TABLE dsos ('
370 do_query(query, 'CREATE TABLE symbols ('
377 do_query(query, 'CREATE TABLE branch_types ('
382 do_query(query, 'CREATE TABLE samples ('
404 do_query(query, 'CREATE TABLE samples ('
431 do_query(query, 'CREATE TABLE call_paths ('
437 do_query(query, 'CREATE TABLE calls ('
453 do_query(query, 'CREATE TABLE ptwrite ('
458 do_query(query, 'CREATE TABLE cbr ('
464 do_query(query, 'CREATE TABLE mwait ('
469 do_query(query, 'CREATE TABLE pwre ('
475 do_query(query, 'CREATE TABLE exstop ('
479 do_query(query, 'CREATE TABLE pwrx ('
485 do_query(query, 'CREATE TABLE context_switches ('
496 do_query(query, 'CREATE VIEW machines_view AS '
504 do_query(query, 'CREATE VIEW dsos_view AS '
514 do_query(query, 'CREATE VIEW symbols_view AS '
525 do_query(query, 'CREATE VIEW threads_view AS '
535 do_query(query, 'CREATE VIEW comm_threads_view AS '
545 do_query(query, 'CREATE VIEW call_paths_view AS '
561 do_query(query, 'CREATE VIEW calls_view AS '
586 do_query(query, 'CREATE VIEW samples_view AS '
610 do_query(query, 'CREATE VIEW ptwrite_view AS '
620 do_query(query, 'CREATE VIEW cbr_view AS '
631 do_query(query, 'CREATE VIEW mwait_view AS '
641 do_query(query, 'CREATE VIEW pwre_view AS '
652 do_query(query, 'CREATE VIEW exstop_view AS '
661 do_query(query, 'CREATE VIEW pwrx_view AS '
677 do_query(query, 'CREATE VIEW power_events_view AS '
709 do_query(query, 'CREATE VIEW context_switches_view AS '
748 do_query(query, sql)
815 do_query(query, 'SELECT * FROM ' + table_name + ' LIMIT 1');
816 if query.next():
821 do_query(query, 'DROP VIEW ' + table_name + '_view');
822 do_query(query, 'DROP TABLE ' + table_name);
870 do_query(query, 'ALTER TABLE selected_events ADD PRIMARY KEY (id)')
871 do_query(query, 'ALTER TABLE machines ADD PRIMARY KEY (id)')
872 do_query(query, 'ALTER TABLE threads ADD PRIMARY KEY (id)')
873 do_query(query, 'ALTER TABLE comms ADD PRIMARY KEY (id)')
874 do_query(query, 'ALTER TABLE comm_threads ADD PRIMARY KEY (id)')
875 do_query(query, 'ALTER TABLE dsos ADD PRIMARY KEY (id)')
876 do_query(query, 'ALTER TABLE symbols ADD PRIMARY KEY (id)')
877 do_query(query, 'ALTER TABLE branch_types ADD PRIMARY KEY (id)')
878 do_query(query, 'ALTER TABLE samples ADD PRIMARY KEY (id)')
880 do_query(query, 'ALTER TABLE call_paths ADD PRIMARY KEY (id)')
882 do_query(query, 'ALTER TABLE calls ADD PRIMARY KEY (id)')
883 do_query(query, 'ALTER TABLE ptwrite ADD PRIMARY KEY (id)')
884 do_query(query, 'ALTER TABLE cbr ADD PRIMARY KEY (id)')
885 do_query(query, 'ALTER TABLE mwait ADD PRIMARY KEY (id)')
886 do_query(query, 'ALTER TABLE pwre ADD PRIMARY KEY (id)')
887 do_query(query, 'ALTER TABLE exstop ADD PRIMARY KEY (id)')
888 do_query(query, 'ALTER TABLE pwrx ADD PRIMARY KEY (id)')
889 do_query(query, 'ALTER TABLE context_switches ADD PRIMARY KEY (id)')
892 do_query(query, 'ALTER TABLE threads '
895 do_query(query, 'ALTER TABLE comms '
897 do_query(query, 'ALTER TABLE comm_threads '
900 do_query(query, 'ALTER TABLE dsos '
902 do_query(query, 'ALTER TABLE symbols '
904 do_query(query, 'ALTER TABLE samples '
914 do_query(query, 'ALTER TABLE call_paths '
918 do_query(query, 'ALTER TABLE calls '
925 do_query(query, 'CREATE INDEX pcpid_idx ON calls (parent_call_path_id)')
926 do_query(query, 'CREATE INDEX pid_idx ON calls (parent_id)')
927 do_query(query, 'ALTER TABLE comms ADD has_calls boolean')
928 …do_query(query, 'UPDATE comms SET has_calls = TRUE WHERE comms.id IN (SELECT DISTINCT comm_id FROM…
929 do_query(query, 'ALTER TABLE ptwrite '
931 do_query(query, 'ALTER TABLE cbr '
933 do_query(query, 'ALTER TABLE mwait '
935 do_query(query, 'ALTER TABLE pwre '
937 do_query(query, 'ALTER TABLE exstop '
939 do_query(query, 'ALTER TABLE pwrx '
941 do_query(query, 'ALTER TABLE context_switches '
952 do_query(query, 'DROP VIEW power_events_view');