perf scripts python: export-to-sqlite.py: Export all sample flags

[linux.git] / tools / perf / scripts / python / export-to-sqlite.py

diff --git a/tools/perf/scripts/python/export-to-sqlite.py b/tools/perf/scripts/python/export-to-sqlite.py
index 8043a7272a56dcacc8ea3924cfd7a94b8d517adc..73c992feb1b97539f50e38c2540bc6456486bbaa 100644 (file)
--- a/tools/perf/scripts/python/export-to-sqlite.py
+++ b/tools/perf/scripts/python/export-to-sqlite.py
@@ -223,7 +223,8 @@ if branches:
                'in_tx          boolean,'
                'call_path_id   bigint,'
                'insn_count     bigint,'
                'in_tx          boolean,'
                'call_path_id   bigint,'
                'insn_count     bigint,'

-               'cyc_count      bigint)')
+               'cyc_count      bigint,'
+               'flags          integer)')

 else:
        do_query(query, 'CREATE TABLE samples ('
                'id             integer         NOT NULL        PRIMARY KEY,'
 else:
        do_query(query, 'CREATE TABLE samples ('
                'id             integer         NOT NULL        PRIMARY KEY,'


@@ -249,7 +250,8 @@ else:
                'in_tx          boolean,'
                'call_path_id   bigint,'
                'insn_count     bigint,'
                'in_tx          boolean,'
                'call_path_id   bigint,'
                'insn_count     bigint,'

-               'cyc_count      bigint)')
+               'cyc_count      bigint,'
+               'flags          integer)')

 
 if perf_db_export_calls or perf_db_export_callchains:
        do_query(query, 'CREATE TABLE call_paths ('
 
 if perf_db_export_calls or perf_db_export_callchains:
        do_query(query, 'CREATE TABLE call_paths ('


@@ -442,7 +444,8 @@ do_query(query, 'CREATE VIEW samples_view AS '
                'in_tx,'
                'insn_count,'
                'cyc_count,'
                'in_tx,'
                'insn_count,'
                'cyc_count,'

-               'CASE WHEN cyc_count=0 THEN CAST(0 AS FLOAT) ELSE ROUND(CAST(insn_count AS FLOAT) / cyc_count, 2) END AS IPC'
+               'CASE WHEN cyc_count=0 THEN CAST(0 AS FLOAT) ELSE ROUND(CAST(insn_count AS FLOAT) / cyc_count, 2) END AS IPC,'
+               'flags'

        ' FROM samples')
 
 do_query(query, 'CREATE VIEW ptwrite_view AS '
        ' FROM samples')
 
 do_query(query, 'CREATE VIEW ptwrite_view AS '


@@ -584,9 +587,9 @@ branch_type_query = QSqlQuery(db)
 branch_type_query.prepare("INSERT INTO branch_types VALUES (?, ?)")
 sample_query = QSqlQuery(db)
 if branches:
 branch_type_query.prepare("INSERT INTO branch_types VALUES (?, ?)")
 sample_query = QSqlQuery(db)
 if branches:

-       sample_query.prepare("INSERT INTO samples VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")
+       sample_query.prepare("INSERT INTO samples VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")

 else:
 else:

-       sample_query.prepare("INSERT INTO samples VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")
+       sample_query.prepare("INSERT INTO samples VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")

 if perf_db_export_calls or perf_db_export_callchains:
        call_path_query = QSqlQuery(db)
        call_path_query.prepare("INSERT INTO call_paths VALUES (?, ?, ?, ?)")
 if perf_db_export_calls or perf_db_export_callchains:
        call_path_query = QSqlQuery(db)
        call_path_query.prepare("INSERT INTO call_paths VALUES (?, ?, ?, ?)")


@@ -618,7 +621,7 @@ def trace_begin():
        comm_table(0, "unknown", 0, 0, 0)
        dso_table(0, 0, "unknown", "unknown", "")
        symbol_table(0, 0, 0, 0, 0, "unknown")
        comm_table(0, "unknown", 0, 0, 0)
        dso_table(0, 0, "unknown", "unknown", "")
        symbol_table(0, 0, 0, 0, 0, "unknown")

-       sample_table(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)
+       sample_table(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

        if perf_db_export_calls or perf_db_export_callchains:
                call_path_table(0, 0, 0, 0)
                call_return_table(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)
        if perf_db_export_calls or perf_db_export_callchains:
                call_path_table(0, 0, 0, 0)
                call_return_table(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)


@@ -703,11 +706,11 @@ def sample_table(*x):
        if branches:
                for xx in x[0:15]:
                        sample_query.addBindValue(str(xx))
        if branches:
                for xx in x[0:15]:
                        sample_query.addBindValue(str(xx))

-               for xx in x[19:24]:
+               for xx in x[19:25]:

                        sample_query.addBindValue(str(xx))
                do_query_(sample_query)
        else:
                        sample_query.addBindValue(str(xx))
                do_query_(sample_query)
        else:

-               bind_exec(sample_query, 24, x)
+               bind_exec(sample_query, 25, x)

 
 def call_path_table(*x):
        bind_exec(call_path_query, 4, x)
 
 def call_path_table(*x):
        bind_exec(call_path_query, 4, x)