X-Git-Url: http://sigaev.ru/git/gitweb.cgi?p=ftsbench.git;a=blobdiff_plain;f=utils.c;fp=utils.c;h=213f2fba6afbeadedaac80bedf8e4759f8c776e5;hp=cf058161eba487c27a9353823cdc38aab5f3fbbf;hb=430dd7ec2f63bd59274f832a28d45eb6cf737cbd;hpb=588023124f3e78b6b78b96679fb41cd0fa061ccc

diff --git a/utils.c b/utils.c
index cf05816..213f2fb 100644
--- a/utils.c
+++ b/utils.c
@@ -61,4 +61,56 @@ sb_add(StringBuf *b, char *s, int length)
 	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
+	);
+}