129 #define BUILDIDS "buildids9"  macro
148   "create table if not exists " BUILDIDS "_files (\n"
153   "create table if not exists " BUILDIDS "_buildids (\n"
157   "create table if not exists " BUILDIDS "_file_mtime_scanned (\n"
163 …"        foreign key (file) references " BUILDIDS "_files(id) on update cascade on delete cascade,…
166   "create table if not exists " BUILDIDS "_f_de (\n"
172 …"        foreign key (file) references " BUILDIDS "_files(id) on update cascade on delete cascade,…
173 …"        foreign key (buildid) references " BUILDIDS "_buildids(id) on update cascade on delete ca…
176   "create table if not exists " BUILDIDS "_f_s (\n"
181 …"        foreign key (file) references " BUILDIDS "_files(id) on update cascade on delete cascade,…
182 …"        foreign key (artifactsrc) references " BUILDIDS "_files(id) on update cascade on delete c…
183 …"        foreign key (buildid) references " BUILDIDS "_buildids(id) on update cascade on delete ca…
186   "create table if not exists " BUILDIDS "_r_de (\n"
193 …"        foreign key (file) references " BUILDIDS "_files(id) on update cascade on delete cascade,…
194 …"        foreign key (content) references " BUILDIDS "_files(id) on update cascade on delete casca…
195 …"        foreign key (buildid) references " BUILDIDS "_buildids(id) on update cascade on delete ca…
198 …"create table if not exists " BUILDIDS "_r_sref (\n" // outgoing dwarf sourcefile references from …
201 …"        foreign key (artifactsrc) references " BUILDIDS "_files(id) on update cascade on delete c…
202 …"        foreign key (buildid) references " BUILDIDS "_buildids(id) on update cascade on delete ca…
205   "create table if not exists " BUILDIDS "_r_sdef (\n" // rpm contents that may satisfy sref
209 …"        foreign key (file) references " BUILDIDS "_files(id) on update cascade on delete cascade,…
210 …"        foreign key (content) references " BUILDIDS "_files(id) on update cascade on delete casca…
214   "create view if not exists " BUILDIDS "_query_d as \n"
217   "        from " BUILDIDS "_buildids b, " BUILDIDS "_files f0, " BUILDIDS "_f_de n\n"
221 …"        from " BUILDIDS "_buildids b, " BUILDIDS "_files f0, " BUILDIDS "_files f1, " BUILDIDS "_…
225   "create view if not exists " BUILDIDS "_query_e as \n"
228   "        from " BUILDIDS "_buildids b, " BUILDIDS "_files f0, " BUILDIDS "_f_de n\n"
232 …"        from " BUILDIDS "_buildids b, " BUILDIDS "_files f0, " BUILDIDS "_files f1, " BUILDIDS "_…
236   "create view if not exists " BUILDIDS "_query_s as \n"
239 …"        from " BUILDIDS "_buildids b, " BUILDIDS "_files f0, " BUILDIDS "_files fs, " BUILDIDS "_…
243 …"        from " BUILDIDS "_buildids b, " BUILDIDS "_files f0, " BUILDIDS "_files f1, " BUILDIDS "_…
244   "        " BUILDIDS "_r_sdef sd, " BUILDIDS "_r_sref sr, " BUILDIDS "_r_de sde\n"
249   "drop view if exists " BUILDIDS "_stats;\n"
250   "create view if not exists " BUILDIDS "_stats as\n"
251   "          select 'file d/e' as label,count(*) as quantity from " BUILDIDS "_f_de\n"
252   "union all select 'file s',count(*) from " BUILDIDS "_f_s\n"
253   "union all select 'archive d/e',count(*) from " BUILDIDS "_r_de\n"
254   "union all select 'archive sref',count(*) from " BUILDIDS "_r_sref\n"
255   "union all select 'archive sdef',count(*) from " BUILDIDS "_r_sdef\n"
256   "union all select 'buildids',count(*) from " BUILDIDS "_buildids\n"
257   "union all select 'filenames',count(*) from " BUILDIDS "_files\n"
258   "union all select 'files scanned (#)',count(*) from " BUILDIDS "_file_mtime_scanned\n"
259 …"union all select 'files scanned (mb)',coalesce(sum(size)/1024/1024,0) from " BUILDIDS "_file_mtim…
1619 …          "select mtime, sourcetype, source0, source1 from " BUILDIDS "_query_d where buildid = ? "  in handle_buildid()
1627 …          "select mtime, sourcetype, source0, source1 from " BUILDIDS "_query_e where buildid = ? "  in handle_buildid()
1639 …"select mtime, sourcetype, source0, source1 from " BUILDIDS "_query_s where buildid = ? and artifa…  in handle_buildid()
2771 …sqlite_ps ps_f_upsert_buildids (db, "file-buildids-intern", "insert or ignore into " BUILDIDS "_bu…  in thread_main_scanner()
2772 …sqlite_ps ps_f_upsert_files (db, "file-files-intern", "insert or ignore into " BUILDIDS "_files VA…  in thread_main_scanner()
2774                           "insert or ignore into " BUILDIDS "_f_de "  in thread_main_scanner()
2776                           "values ((select id from " BUILDIDS "_buildids where hex = ?),"  in thread_main_scanner()
2778                           "        (select id from " BUILDIDS "_files where name = ?), ?);");  in thread_main_scanner()
2780                          "insert or ignore into " BUILDIDS "_f_s "  in thread_main_scanner()
2782                          "values ((select id from " BUILDIDS "_buildids where hex = ?),"  in thread_main_scanner()
2783                          "        (select id from " BUILDIDS "_files where name = ?),"  in thread_main_scanner()
2784                          "        (select id from " BUILDIDS "_files where name = ?),"  in thread_main_scanner()
2787                         "select 1 from " BUILDIDS "_file_mtime_scanned where sourcetype = 'F' "  in thread_main_scanner()
2788 …                   "and file = (select id from " BUILDIDS "_files where name = ?) and mtime = ?;");  in thread_main_scanner()
2790 …            "insert or ignore into " BUILDIDS "_file_mtime_scanned (sourcetype, file, mtime, size)"  in thread_main_scanner()
2791 …                        "values ('F', (select id from " BUILDIDS "_files where name = ?), ?, ?);");  in thread_main_scanner()
2794 …sqlite_ps ps_r_upsert_buildids (db, "rpm-buildid-intern", "insert or ignore into " BUILDIDS "_buil…  in thread_main_scanner()
2795 …sqlite_ps ps_r_upsert_files (db, "rpm-file-intern", "insert or ignore into " BUILDIDS "_files VALU…  in thread_main_scanner()
2797 …"insert or ignore into " BUILDIDS "_r_de (buildid, debuginfo_p, executable_p, file, mtime, content…  in thread_main_scanner()
2798                           "(select id from " BUILDIDS "_buildids where hex = ?), ?, ?, "  in thread_main_scanner()
2799                           "(select id from " BUILDIDS "_files where name = ?), ?, "  in thread_main_scanner()
2800                           "(select id from " BUILDIDS "_files where name = ?));");  in thread_main_scanner()
2802 …                        "insert or ignore into " BUILDIDS "_r_sref (buildid, artifactsrc) values ("  in thread_main_scanner()
2803                             "(select id from " BUILDIDS "_buildids where hex = ?), "  in thread_main_scanner()
2804                             "(select id from " BUILDIDS "_files where name = ?));");  in thread_main_scanner()
2806 …                        "insert or ignore into " BUILDIDS "_r_sdef (file, mtime, content) values ("  in thread_main_scanner()
2807                             "(select id from " BUILDIDS "_files where name = ?), ?,"  in thread_main_scanner()
2808                             "(select id from " BUILDIDS "_files where name = ?));");  in thread_main_scanner()
2810                       "select 1 from " BUILDIDS "_file_mtime_scanned where "  in thread_main_scanner()
2811 …  "sourcetype = 'R' and file = (select id from " BUILDIDS "_files where name = ?) and mtime = ?;");  in thread_main_scanner()
2813 …            "insert or ignore into " BUILDIDS "_file_mtime_scanned (sourcetype, file, mtime, size)"  in thread_main_scanner()
2814 …                        "values ('R', (select id from " BUILDIDS "_files where name = ?), ?, ?);");  in thread_main_scanner()
3055                       "select label,quantity from " BUILDIDS "_stats");  in database_stats_report()
3094                        BUILDIDS "_file_mtime_scanned s, " BUILDIDS "_files f "  in groom()
3096 …sqlite_ps files_del_f_de (db, "nuke f_de", "delete from " BUILDIDS "_f_de where file = ? and mtime…  in groom()
3097 …sqlite_ps files_del_r_de (db, "nuke r_de", "delete from " BUILDIDS "_r_de where file = ? and mtime…  in groom()
3098   sqlite_ps files_del_scan (db, "nuke f_m_s", "delete from " BUILDIDS "_file_mtime_scanned "  in groom()
3134                           "delete from " BUILDIDS "_buildids "  in groom()
3135 … "where not exists (select 1 from " BUILDIDS "_f_de d where " BUILDIDS "_buildids.id = d.buildid) "  in groom()
3136 …  "and not exists (select 1 from " BUILDIDS "_r_de d where " BUILDIDS "_buildids.id = d.buildid)");  in groom()
3426 …extra_ddl.push_back("create index if not exists " BUILDIDS "_r_sref_arc on " BUILDIDS "_r_sref(art…  in main()
3427 …ra_ddl.push_back("delete from " BUILDIDS "_r_sdef where not exists (select 1 from " BUILDIDS "_r_s…  in main()
3428       extra_ddl.push_back("drop index if exists " BUILDIDS "_r_sref_arc;");  in main()