X-Git-Url: https://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=webtest%2Ftest_db.php;h=21a77ad0206559def4bdcde0084146ed5fe78616;hb=b5dae179f26df4000dc48a09acb49d5098265d25;hp=881705871f9d53e57dab621f3274b205b87c69d7;hpb=860fbd36c87a6da4a71ef5e42d661c555bb3b3d6;p=brisk.git
diff --git a/webtest/test_db.php b/webtest/test_db.php
index 8817058..21a77ad 100644
--- a/webtest/test_db.php
+++ b/webtest/test_db.php
@@ -2,7 +2,7 @@
/*
* brisk - test_db.php
*
- * Copyright (C) 2014 Matteo Nastasi
+ * Copyright (C) 2014-2015 Matteo Nastasi
* mailto: nastasi@alternativeoutput.it
* matteo.nastasi@milug.org
* web: http://www.alternativeoutput.it
@@ -75,7 +75,7 @@ function main() {
succ("CREATE TABLE test_ip");
foreach ($arr_ip as $i) {
- $v = ip2int($i);
+ $v = ip2four($i);
$msg = sprintf(" INSERT INTO test_ip [%s] val: [%d (%x)]", $i, $v, $v);
if ($bdb->query(sprintf("INSERT INTO test_ip (ip, atime) VALUES (%d, '1999-01-08 04:05:06');", $v)) == FALSE) {
@@ -85,6 +85,31 @@ function main() {
}
succ($msg);
}
+ printf("
\n");
+ foreach ($arr_ip as $i) {
+ $cmp = int2four(ip2int($i) & 0xffffff00);
+ $msk = int2four(0xffffff00);
+ $cmp_que = sprintf("SELECT * FROM test_ip WHERE (ip & %d = %d);", $msk, $cmp);
+ if (($cmp_pg = $bdb->query($cmp_que)) == FALSE) {
+ printf("%s
\n", $bdb->last_error());
+ fail("SELECT * FROM test_ip");
+ break;
+ }
+ succ($cmp_que);
+
+ for ($r = 0 ; $r < pg_numrows($cmp_pg) ; $r++) {
+ $cmp_obj = pg_fetch_object($cmp_pg, $r);
+
+ if ($ip_obj->ip & $msk != $cmp) {
+ fail(sprintf(" Expected: %s, retrieved: %s", int2ip($cmp), int2ip($ip_obj->ip & $msk)));
+ }
+ else {
+ succ(sprintf(" Expected: %s (%s)", int2ip($cmp), int2ip($cmp_obj->ip)));
+ }
+ // printf("RET IP: %d IP: %s
\n", $ip_obj->ip, $v));
+ }
+ }
+ printf("
\n");
if (($ip_pg = $bdb->query(sprintf("SELECT * FROM test_ip ORDER BY code;"))) == FALSE) {
printf("%s
\n", $bdb->last_error());