scripts/python/export-to-sqlite.py

160 query = QSqlQuery(db)
162 do_query(query, 'PRAGMA journal_mode = OFF')
163 do_query(query, 'BEGIN TRANSACTION')
165 do_query(query, 'CREATE TABLE selected_events ('
168 do_query(query, 'CREATE TABLE machines ('
172 do_query(query, 'CREATE TABLE threads ('
178 do_query(query, 'CREATE TABLE comms ('
184 do_query(query, 'CREATE TABLE comm_threads ('
188 do_query(query, 'CREATE TABLE dsos ('
194 do_query(query, 'CREATE TABLE symbols ('
201 do_query(query, 'CREATE TABLE branch_types ('
206 	do_query(query, 'CREATE TABLE samples ('
229 	do_query(query, 'CREATE TABLE samples ('
257 	do_query(query, 'CREATE TABLE call_paths ('
263 	do_query(query, 'CREATE TABLE calls ('
279 do_query(query, 'CREATE TABLE ptwrite ('
284 do_query(query, 'CREATE TABLE cbr ('
290 do_query(query, 'CREATE TABLE mwait ('
295 do_query(query, 'CREATE TABLE pwre ('
301 do_query(query, 'CREATE TABLE exstop ('
305 do_query(query, 'CREATE TABLE pwrx ('
311 do_query(query, 'CREATE TABLE context_switches ('
325 	do_query(query, 'SELECT printf("") FROM machines')
336 do_query(query, 'CREATE VIEW machines_view AS '
344 do_query(query, 'CREATE VIEW dsos_view AS '
354 do_query(query, 'CREATE VIEW symbols_view AS '
365 do_query(query, 'CREATE VIEW threads_view AS '
375 do_query(query, 'CREATE VIEW comm_threads_view AS '
385 	do_query(query, 'CREATE VIEW call_paths_view AS '
401 	do_query(query, 'CREATE VIEW calls_view AS '
426 do_query(query, 'CREATE VIEW samples_view AS '
451 do_query(query, 'CREATE VIEW ptwrite_view AS '
461 do_query(query, 'CREATE VIEW cbr_view AS '
472 do_query(query, 'CREATE VIEW mwait_view AS '
482 do_query(query, 'CREATE VIEW pwre_view AS '
493 do_query(query, 'CREATE VIEW exstop_view AS '
502 do_query(query, 'CREATE VIEW pwrx_view AS '
518 do_query(query, 'CREATE VIEW power_events_view AS '
547 do_query(query, 'CREATE VIEW context_switches_view AS '
570 do_query(query, 'END TRANSACTION')
616 	do_query(query, 'BEGIN TRANSACTION')
632 	do_query(query, 'SELECT * FROM ' + table_name + ' LIMIT 1');
633 	if query.next():
638 	do_query(query, 'DROP VIEW ' + table_name + '_view');
639 	do_query(query, 'DROP TABLE ' + table_name);
642 	do_query(query, 'END TRANSACTION')
646 		do_query(query, 'CREATE INDEX pcpid_idx ON calls (parent_call_path_id)')
647 		do_query(query, 'CREATE INDEX pid_idx ON calls (parent_id)')
648 		do_query(query, 'ALTER TABLE comms ADD has_calls boolean')
649 		do_query(query, 'UPDATE comms SET has_calls = 1 WHERE comms.id IN (SELECT DISTINCT comm_id FROM calls)')
655 		do_query(query, 'DROP VIEW power_events_view');