scripts/python/export-to-postgresql.py

83 #	samples
85 #		'samples' is the main table. It represents what instruction was executing at a point in time
90 #		'calls' represents function calls and is related to 'samples' by 'call_id' and 'return_id'.
124 #		'symbols' contains a record for each symbol.  Only symbols that have samples are present.
382 	do_query(query, 'CREATE TABLE samples ('
405 	do_query(query, 'CREATE TABLE samples ('
611 	' FROM samples')
621 	' INNER JOIN samples ON samples.id = ptwrite.id')
632 	' INNER JOIN samples ON samples.id = cbr.id')
642 	' INNER JOIN samples ON samples.id = mwait.id')
653 	' INNER JOIN samples ON samples.id = pwre.id')
662 	' INNER JOIN samples ON samples.id = exstop.id')
678 	' INNER JOIN samples ON samples.id = pwrx.id')
682 		'samples.id,'
683 		'samples.time,'
684 		'samples.cpu,'
708 	' INNER JOIN samples ON samples.id = coalesce(cbr.id, mwait.id, pwre.id, exstop.id, pwrx.id)'
709 	' INNER JOIN selected_events ON selected_events.id = samples.evsel_id'
710 	' ORDER BY samples.id')
837 	copy_output_file(sample_file,		"samples")
881 	do_query(query, 'ALTER TABLE samples         ADD PRIMARY KEY (id)')
907 	do_query(query, 'ALTER TABLE samples '
925 					'ADD CONSTRAINT callfk      FOREIGN KEY (call_id)      REFERENCES samples    (id),'
926 					'ADD CONSTRAINT returnfk    FOREIGN KEY (return_id)    REFERENCES samples    (id),'
933 					'ADD CONSTRAINT idfk        FOREIGN KEY (id)           REFERENCES samples   (id)')
935 					'ADD CONSTRAINT idfk        FOREIGN KEY (id)           REFERENCES samples   (id)')
937 					'ADD CONSTRAINT idfk        FOREIGN KEY (id)           REFERENCES samples   (id)')
939 					'ADD CONSTRAINT idfk        FOREIGN KEY (id)           REFERENCES samples   (id)')
941 					'ADD CONSTRAINT idfk        FOREIGN KEY (id)           REFERENCES samples   (id)')
943 					'ADD CONSTRAINT idfk        FOREIGN KEY (id)           REFERENCES samples   (id)')