2 * Copyright (c) 2006 Teodor Sigaev <teodor@sigaev.ru>
5 * Redistribution and use in source and binary forms, with or without
6 * modification, are permitted provided that the following conditions
8 * 1. Redistributions of source code must retain the above copyright
9 * notice, this list of conditions and the following disclaimer.
10 * 2. Redistributions in binary form must reproduce the above copyright
11 * notice, this list of conditions and the following disclaimer in the
12 * documentation and/or other materials provided with the distribution.
13 * 3. Neither the name of the author nor the names of any co-contributors
14 * may be used to endorse or promote products derived from this software
15 * without specific prior written permission.
17 * THIS SOFTWARE IS PROVIDED BY CONTRIBUTORS ``AS IS'' AND ANY EXPRESS
18 * OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
19 * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
20 * ARE DISCLAIMED. IN NO EVENT SHALL CONTRIBUTORS BE LIABLE FOR ANY
21 * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
22 * DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE
23 * GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
24 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER
25 * IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
26 * OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN
27 * IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
37 sb_add(StringBuf *b, char *s, int length)
42 if ( b->strlen + length + 1 >= b->length ) {
43 if ( b->str == NULL || b->length == 0 ) {
44 b->length = (length + 1)*4;
45 b->str = (char*)malloc( sizeof(char) * b->length );
49 while( b->strlen + length + 1 >= b->length );
50 b->str = (char*)realloc( b->str, sizeof(char) * b->length );
54 fatal("Not enough memory (%d bytes)\n", b->length);
57 memcpy(b->str + b->strlen, s, length);
59 b->str[ b->strlen ] = '\0';
65 "DROP TABLE IF EXISTS fb_create CASCADE;\n"
66 "DROP TABLE IF EXISTS fb_search CASCADE;\n"
67 "DROP TABLE IF EXISTS fb_row CASCADE;\n",
72 "--init configuration\n"
73 "CREATE TABLE fb_create (\n"
74 " id integer PRIMARY KEY,\n"
75 " rdbms text NOT NULL,\n"
76 " f_gin boolean NOT NULL,\n"
77 " f_gist boolean NOT NULL,\n"
78 " f_func boolean NOT NULL,\n"
79 " rows integer NOT NULL,\n"
80 " elapsed double precision NOT NULL\n"
87 "CREATE TABLE fb_search (\n"
88 "--link to fb_create.id\n"
89 " id integer NOT NULL,\n"
90 " f_and boolean NOT NULL,\n"
91 " f_or boolean NOT NULL,\n"
92 " nclients integer NOT NULL,\n"
93 " nqueries integer NOT NULL,\n"
94 " nres integer NOT NULL,\n"
95 " elapsed double precision NOT NULL\n"
102 "CREATE TABLE fb_row (\n"
103 "--link to fb_create.id\n"
104 " id integer NOT NULL,\n"
105 " f_and boolean NOT NULL,\n"
106 " f_or boolean NOT NULL,\n"
107 " nclients integer NOT NULL,\n"
108 " query text NOT NULL,\n"
109 " nres integer NOT NULL,\n"
110 " elapsed double precision NOT NULL\n"