scripts/python/export-to-sqlite.py

69 # difference is  the 'transaction' column of the 'samples' table which is
206 	do_query(query, 'CREATE TABLE samples ('
228 	do_query(query, 'CREATE TABLE samples ('
446 	' FROM samples')
456 	' INNER JOIN samples ON samples.id = ptwrite.id')
467 	' INNER JOIN samples ON samples.id = cbr.id')
477 	' INNER JOIN samples ON samples.id = mwait.id')
488 	' INNER JOIN samples ON samples.id = pwre.id')
497 	' INNER JOIN samples ON samples.id = exstop.id')
513 	' INNER JOIN samples ON samples.id = pwrx.id')
517 		'samples.id,'
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 …\' THEN (SELECT ' + emit_to_hex('hints') + ' FROM mwait WHERE mwait.id = samples.id) ELSE "" END A…
525 …EN (SELECT ' + emit_to_hex('extensions') + ' FROM mwait WHERE mwait.id = samples.id) ELSE "" END A…
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 …ents.name=\'exstop\' THEN (SELECT exact_ip FROM exstop WHERE exstop.id = samples.id) ELSE "" END A…
530 …ents.name=\'pwrx\' THEN (SELECT deepest_cstate FROM pwrx WHERE pwrx.id = samples.id) ELSE "" END A…
531 …_events.name=\'pwrx\' THEN (SELECT last_cstate FROM pwrx WHERE pwrx.id = samples.id) ELSE "" END A…
539 		' FROM pwrx WHERE pwrx.id = samples.id) ELSE "" END AS wake_reason'
540 	' FROM samples'
587 …sample_query.prepare("INSERT INTO samples VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, …
589 …sample_query.prepare("INSERT INTO samples VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, …