sq3: show SQLite error messages on stderr by default
[iv.d.git] / sq3 / sq3_test.d
blob690f61fc73ce42a4d32a8b434213c9c7d8770ab8
1 /* Invisible Vector Library
2 * coded by Ketmar // Invisible Vector <ketmar@ketmar.no-ip.org>
3 * Understanding is not required. Only obedience.
5 * This program is free software: you can redistribute it and/or modify
6 * it under the terms of the GNU General Public License as published by
7 * the Free Software Foundation, version 3 of the License ONLY.
9 * This program is distributed in the hope that it will be useful,
10 * but WITHOUT ANY WARRANTY; without even the implied warranty of
11 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 * GNU General Public License for more details.
14 * You should have received a copy of the GNU General Public License
15 * along with this program. If not, see <http://www.gnu.org/licenses/>.
17 module sq3_test /*is aliced*/;
19 import std.stdio;
21 import iv.alice;
22 import iv.sq3;
25 ////////////////////////////////////////////////////////////////////////////////
26 void main () {
27 auto db = Database("/tmp/pktool.db");
28 foreach (ref row; db.statement("SELECT * FROM packages WHERE id >= :idl AND id <= :idh").bind(":idl", 1).bind("idh", 5).range) {
29 writeln("index=", row.index_, "; id=", row.id!uint, "; name=", row.name);
31 auto rng = db.statement("SELECT * FROM packages WHERE id=:id").bind("id", 1).range;
32 if (rng.empty) {
33 writeln("NO 1!");
34 } else {
35 writeln(rng.front.name!SQ3Text);
36 rng.popFront();
37 assert(rng.empty);
39 writeln(isUTF8ValidSQ3("abc"));
40 writeln(isUTF8ValidSQ3("хуйaхуй!"));
41 writeln(isUTF8ValidSQ3(n"ÈÕÊaÈÕÊ!"));