scripts/python/export-to-postgresql.py

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_id))
209 #                           raise Exception("Query failed: " + query.lastError().text())
210 #                   if not query.next():
212 #                   print "{0:>6}  {1:>10}  {2:>9}  {3:<30}  {4:>6}  {5:<30}".format(query.value(0), query.value(1), query.value(2), query.value(3), query.value(4), query.value(5))
213 #                   call_path_id = query.value(6)
323 query = QSqlQuery(db)
327 	do_query(query, 'CREATE DATABASE ' + dbname)
331 query.finish()
332 query.clear()
338 query = QSqlQuery(db)
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 ('
405 	do_query(query, 'CREATE TABLE samples ('
433 	do_query(query, 'CREATE TABLE call_paths ('
439 	do_query(query, 'CREATE TABLE calls ('
455 do_query(query, 'CREATE TABLE ptwrite ('
460 do_query(query, 'CREATE TABLE cbr ('
466 do_query(query, 'CREATE TABLE mwait ('
471 do_query(query, 'CREATE TABLE pwre ('
477 do_query(query, 'CREATE TABLE exstop ('
481 do_query(query, 'CREATE TABLE pwrx ('
487 do_query(query, 'CREATE TABLE context_switches ('
498 do_query(query, 'CREATE VIEW machines_view AS '
506 do_query(query, 'CREATE VIEW dsos_view AS '
516 do_query(query, 'CREATE VIEW symbols_view AS '
527 do_query(query, 'CREATE VIEW threads_view AS '
537 do_query(query, 'CREATE VIEW comm_threads_view AS '
547 	do_query(query, 'CREATE VIEW call_paths_view AS '
563 	do_query(query, 'CREATE VIEW calls_view AS '
588 do_query(query, 'CREATE VIEW samples_view AS '
613 do_query(query, 'CREATE VIEW ptwrite_view AS '
623 do_query(query, 'CREATE VIEW cbr_view AS '
634 do_query(query, 'CREATE VIEW mwait_view AS '
644 do_query(query, 'CREATE VIEW pwre_view AS '
655 do_query(query, 'CREATE VIEW exstop_view AS '
664 do_query(query, 'CREATE VIEW pwrx_view AS '
680 do_query(query, 'CREATE VIEW power_events_view AS '
712 do_query(query, 'CREATE VIEW context_switches_view AS '
751 	do_query(query, sql)
818 	do_query(query, 'SELECT * FROM ' + table_name + ' LIMIT 1');
819 	if query.next():
824 	do_query(query, 'DROP VIEW ' + table_name + '_view');
825 	do_query(query, 'DROP TABLE ' + table_name);
873 	do_query(query, 'ALTER TABLE selected_events ADD PRIMARY KEY (id)')
874 	do_query(query, 'ALTER TABLE machines        ADD PRIMARY KEY (id)')
875 	do_query(query, 'ALTER TABLE threads         ADD PRIMARY KEY (id)')
876 	do_query(query, 'ALTER TABLE comms           ADD PRIMARY KEY (id)')
877 	do_query(query, 'ALTER TABLE comm_threads    ADD PRIMARY KEY (id)')
878 	do_query(query, 'ALTER TABLE dsos            ADD PRIMARY KEY (id)')
879 	do_query(query, 'ALTER TABLE symbols         ADD PRIMARY KEY (id)')
880 	do_query(query, 'ALTER TABLE branch_types    ADD PRIMARY KEY (id)')
881 	do_query(query, 'ALTER TABLE samples         ADD PRIMARY KEY (id)')
883 		do_query(query, 'ALTER TABLE call_paths      ADD PRIMARY KEY (id)')
885 		do_query(query, 'ALTER TABLE calls           ADD PRIMARY KEY (id)')
886 	do_query(query, 'ALTER TABLE ptwrite         ADD PRIMARY KEY (id)')
887 	do_query(query, 'ALTER TABLE cbr             ADD PRIMARY KEY (id)')
888 	do_query(query, 'ALTER TABLE mwait           ADD PRIMARY KEY (id)')
889 	do_query(query, 'ALTER TABLE pwre            ADD PRIMARY KEY (id)')
890 	do_query(query, 'ALTER TABLE exstop          ADD PRIMARY KEY (id)')
891 	do_query(query, 'ALTER TABLE pwrx            ADD PRIMARY KEY (id)')
892 	do_query(query, 'ALTER TABLE context_switches ADD PRIMARY KEY (id)')
895 	do_query(query, 'ALTER TABLE threads '
898 	do_query(query, 'ALTER TABLE comms '
900 	do_query(query, 'ALTER TABLE comm_threads '
903 	do_query(query, 'ALTER TABLE dsos '
905 	do_query(query, 'ALTER TABLE symbols '
907 	do_query(query, 'ALTER TABLE samples '
917 		do_query(query, 'ALTER TABLE call_paths '
921 		do_query(query, 'ALTER TABLE calls '
928 		do_query(query, 'CREATE INDEX pcpid_idx ON calls (parent_call_path_id)')
929 		do_query(query, 'CREATE INDEX pid_idx ON calls (parent_id)')
930 		do_query(query, 'ALTER TABLE comms ADD has_calls boolean')
931 		do_query(query, 'UPDATE comms SET has_calls = TRUE WHERE comms.id IN (SELECT DISTINCT comm_id FROM calls)')
932 	do_query(query, 'ALTER TABLE ptwrite '
934 	do_query(query, 'ALTER TABLE  cbr '
936 	do_query(query, 'ALTER TABLE  mwait '
938 	do_query(query, 'ALTER TABLE  pwre '
940 	do_query(query, 'ALTER TABLE  exstop '
942 	do_query(query, 'ALTER TABLE  pwrx '
944 	do_query(query, 'ALTER TABLE  context_switches '
955 		do_query(query, 'DROP VIEW power_events_view');