b->str[ b->strlen ] = '\0';
}
+void
+printScheme() {
+ fputs(
+ "DROP TABLE IF EXISTS fb_create CASCADE;\n"
+ "DROP TABLE IF EXISTS fb_search CASCADE;\n"
+ "DROP TABLE IF EXISTS fb_row CASCADE;\n",
+ stdout
+ );
+ fputs(
+ "--init configuration\n"
+ "CREATE TABLE fb_create (\n"
+ " id integer PRIMARY KEY,\n"
+ " rdbms text NOT NULL,\n"
+ " f_gin boolean NOT NULL,\n"
+ " f_gist boolean NOT NULL,\n"
+ " f_func boolean NOT NULL,\n"
+ " rows integer NOT NULL,\n"
+ " elapsed double precision NOT NULL\n"
+ ");\n",
+ stdout
+ );
+
+ fputs(
+ "--summary stats\n"
+ "CREATE TABLE fb_search (\n"
+ " id integer NOT NULL,\n"
+ "--link to fb_create.id\n"
+ " f_and boolean NOT NULL,\n"
+ " f_or boolean NOT NULL,\n"
+ " nclients integer NOT NULL,\n"
+ " nqueries integer NOT NULL,\n"
+ " nres integer NOT NULL,\n"
+ " elapsed double precision NOT NULL\n"
+ ");\n",
+ stdout
+ );
+
+ fputs(
+ "--stat per query\n"
+ "CREATE TABLE fb_row (\n"
+ "--link to fb_create.id\n"
+ " id integer NOT NULL,\n"
+ " f_and boolean NOT NULL,\n"
+ " f_or boolean NOT NULL,\n"
+ " nclients integer NOT NULL,\n"
+ " query text NOT NULL,\n"
+ " nres integer NOT NULL,\n"
+ " elapsed double precision NOT NULL\n"
+ ");\n",
+ stdout
+ );
+}