scripts/python/export-to-sqlite.py

57 #	sqlite> select * from samples_view where id < 10;
59 #	sqlite> select * from samples_view where id < 10;
102 	printerr("where:  columns            'all' or 'branches'");
346 		'(SELECT host_or_guest FROM machines_view WHERE id = machine_id) AS host_or_guest,'
356 		'(SELECT short_name FROM dsos WHERE id=dso_id) AS dso,'
367 		'(SELECT host_or_guest FROM machines_view WHERE id = machine_id) AS host_or_guest,'
376 		'(SELECT comm FROM comms WHERE id = comm_id) AS command,'
378 		'(SELECT pid FROM threads WHERE id = thread_id) AS pid,'
379 		'(SELECT tid FROM threads WHERE id = thread_id) AS tid'
388 			'(SELECT name FROM symbols WHERE id = c.symbol_id) AS symbol,'
389 			'(SELECT dso_id FROM symbols WHERE id = c.symbol_id) AS dso_id,'
390 			'(SELECT dso FROM symbols_view  WHERE id = c.symbol_id) AS dso_short_name,'
394 			'(SELECT name FROM symbols WHERE id = p.symbol_id) AS parent_symbol,'
395 			'(SELECT dso_id FROM symbols WHERE id = p.symbol_id) AS parent_dso_id,'
396 			'(SELECT dso FROM symbols_view  WHERE id = p.symbol_id) AS parent_dso_short_name'
403 			'(SELECT pid FROM threads WHERE id = thread_id) AS pid,'
404 			'(SELECT tid FROM threads WHERE id = thread_id) AS tid,'
405 			'(SELECT comm FROM comms WHERE id = comm_id) AS command,'
409 			'(SELECT name FROM symbols WHERE id = symbol_id) AS symbol,'
429 		'(SELECT pid FROM threads WHERE id = thread_id) AS pid,'
430 		'(SELECT tid FROM threads WHERE id = thread_id) AS tid,'
431 		'(SELECT comm FROM comms WHERE id = comm_id) AS command,'
432 		'(SELECT name FROM selected_events WHERE id = evsel_id) AS event,'
434 		'(SELECT name FROM symbols WHERE id = symbol_id) AS symbol,'
436 		'(SELECT short_name FROM dsos WHERE id = dso_id) AS dso_short_name,'
438 		'(SELECT name FROM symbols WHERE id = to_symbol_id) AS to_symbol,'
440 		'(SELECT short_name FROM dsos WHERE id = to_dso_id) AS to_dso_short_name,'
441 		'(SELECT name FROM branch_types WHERE id = branch_type) AS branch_type_name,'
521 …'CASE WHEN selected_events.name=\'cbr\' THEN (SELECT cbr FROM cbr WHERE cbr.id = samples.id) ELSE …
522 …'CASE WHEN selected_events.name=\'cbr\' THEN (SELECT mhz FROM cbr WHERE cbr.id = samples.id) ELSE …
523 …'CASE WHEN selected_events.name=\'cbr\' THEN (SELECT percent FROM cbr WHERE cbr.id = samples.id) E…
524 …vents.name=\'mwait\' THEN (SELECT ' + emit_to_hex('hints') + ' FROM mwait WHERE mwait.id = samples…
525 ….name=\'mwait\' THEN (SELECT ' + emit_to_hex('extensions') + ' FROM mwait WHERE mwait.id = samples…
526 …'CASE WHEN selected_events.name=\'pwre\' THEN (SELECT cstate FROM pwre WHERE pwre.id = samples.id)…
527 …'CASE WHEN selected_events.name=\'pwre\' THEN (SELECT subcstate FROM pwre WHERE pwre.id = samples.…
528 …'CASE WHEN selected_events.name=\'pwre\' THEN (SELECT hw FROM pwre WHERE pwre.id = samples.id) ELS…
529 …'CASE WHEN selected_events.name=\'exstop\' THEN (SELECT exact_ip FROM exstop WHERE exstop.id = sam…
530 …'CASE WHEN selected_events.name=\'pwrx\' THEN (SELECT deepest_cstate FROM pwrx WHERE pwrx.id = sam…
531 …'CASE WHEN selected_events.name=\'pwrx\' THEN (SELECT last_cstate FROM pwrx WHERE pwrx.id = sample…
539 		' FROM pwrx WHERE pwrx.id = samples.id) ELSE "" END AS wake_reason'
542 	' WHERE selected_events.name IN (\'cbr\',\'mwait\',\'exstop\',\'pwre\',\'pwrx\')')
646 …do_query(query, 'UPDATE comms SET has_calls = 1 WHERE comms.id IN (SELECT DISTINCT comm_id FROM ca…