/tests/sql.php (9df07612f8b892adee2ea841194ac84b1a4f8449) (3454 bytes) (mode 100644) (type blob)
<?php
error_reporting(E_ALL | E_STRICT);
ini_set("track_errors", "On");
$rg_sql_debug = 100;
$INC = dirname(__FILE__) . "/../inc";
require_once(dirname(__FILE__) . "/config.php");
require_once($INC . "/init.inc.php");
require_once($INC . "/log.inc.php");
require_once($INC . "/sql.inc.php");
rg_log_set_file("sql.log");
require_once("common.php");
rg_log('');
rg_log_enter('db: drop \'test\' table...');
$sql = "DROP TABLE IF EXISTS test";
$res = rg_sql_query($db, $sql);
if ($res === FALSE) {
rg_log("Cannot create table 'test' (" . rg_sql_error() . ")!");
exit(1);
}
rg_log_exit();
rg_log('');
rg_log_enter('db: test creation of a table...');
$sql = "CREATE TABLE test (id TEXT PRIMARY KEY"
. ", f1 TEXT DEFAULT '', f2 TEXT DEFAULT '')";
$res = rg_sql_query($db, $sql);
if ($res === FALSE) {
rg_log("Cannot create table 'test' (" . rg_sql_error() . ")!");
exit(1);
}
rg_log_exit();
rg_log('');
rg_log_enter('db: test insert...');
$sql = "INSERT INTO test (id) VALUES ('aaa')";
$res = rg_sql_query($db, $sql);
if ($res === FALSE) {
rg_log("Cannot insert!");
exit(1);
}
rg_sql_free_result($res);
rg_log_exit();
rg_log('');
rg_log_enter('db: test insert with the same key...');
// We do not want a err- file to be created
$k = md5('Internal error: INSERT INTO test (id) VALUES (\'aaa\'): ERROR: duplicate key value violates unique constraint "test_pkey"' . "\n" . 'DETAIL: Key (id)=(aaa) already exists. (23505)');
$rg_error_core_seen[$k] = 1;
$sql = "INSERT INTO test (id) VALUES ('aaa')";
$res = @rg_sql_query($db, $sql);
if ($res !== FALSE) {
rg_log("I can do double insert, not good!");
exit(1);
}
unset($rg_error_core_seen[$k]);
rg_log_exit();
rg_log('');
rg_log_enter('db: test delete...');
$sql = "DELETE FROM test WHERE id = 'aaa'";
$res = rg_sql_query($db, $sql);
if ($res === FALSE) {
rg_log("Cannot delete!");
exit(1);
}
rg_sql_free_result($res);
rg_log_exit();
rg_log('');
rg_log_enter('db: test prepare with named values...');
$sql = "INSERT INTO test(id, f1, f2) VALUES (@@id@@, @@f@@, @@f@@)";
$params = array("id" => "myid", "f" => "value", "junk" => "aaa");
$res = rg_sql_query_params($db, $sql, $params);
if ($res === FALSE) {
rg_log("Cannot insert into test using @@x@@!");
exit(1);
}
rg_sql_free_result($res);
$sql = "SELECT * FROM test WHERE id = 'myid'";
$res = rg_sql_query($db, $sql);
$row = rg_sql_fetch_array($res);
if (strcmp($row['f1'], "value") != 0) {
rg_log("Seems that insert with @@x@@ are not working!");
exit(1);
}
rg_sql_free_result($res);
rg_log_exit();
rg_log('');
rg_log_enter('Testing rg_sql_fields...');
$r = rg_sql_fields($db, 'test');
if (($r === FALSE) || (count($r) != 3) || !isset($r['id'])) {
rg_log_ml('r: ' . print_r($r, TRUE));
rg_log('We do not have correct file names!');
exit(1);
}
rg_log_exit();
rg_log('');
rg_log_enter('Testing a unique key violation with ignore...');
$ignore = array(RG_SQL_UNIQUE_VIOLATION);
$params = array('id' => 'myid', 'f2' => 'bla');
$sql = 'INSERT INTO test VALUES (@@id@@, @@f2@@)';
$res = rg_sql_query_params_ignore($db, $sql, $params, $ignore, $ignore_kicked);
if ($res !== FALSE) {
rg_log('res is not false!');
exit(1);
}
if (!strstr($rg_internal_error_last, 'duplicate key value violates unique')) {
rg_log('rg_internal_error_last does not contain something'
. ' about duplicate key'
. ' [' . $rg_internal_error_last . ']!');
exit(1);
}
rg_log_exit();
// TODO: test rg_sql_last_id
rg_sql_close($db);
rg_log("OK!");
Mode |
Type |
Size |
Ref |
File |
100644 |
blob |
9 |
f3c7a7c5da68804a1bdf391127ba34aed33c3cca |
.exclude |
100644 |
blob |
108 |
acc2186b1d357966e09df32afcea14933f5f0c78 |
.gitignore |
100644 |
blob |
375 |
1f425bcd2049c526744d449511094fc045ceac74 |
AUTHORS |
100644 |
blob |
1847 |
fd1f7a627adc85dec9ebd72ae9e6b4c941b82f8f |
History.txt |
100644 |
blob |
34520 |
dba13ed2ddf783ee8118c6a581dbf75305f816a3 |
LICENSE |
100644 |
blob |
3624 |
1c4ccf9cceb2e56ae71334442aff3183b242c333 |
Makefile.in |
100644 |
blob |
5325 |
96c40d868ce10b715299085ccffb30f96a730cf3 |
README |
100644 |
blob |
190331 |
0418946bd5fc97da80f0bbd2e918c657536c01e6 |
TODO |
100644 |
blob |
1294 |
f22911eb777f0695fcf81ad686eac133eb11fcc4 |
TODO-plans |
100644 |
blob |
203 |
a2863c67c3da44126b61a15a6f09738c25e0fbe0 |
TODO.perf |
100644 |
blob |
967 |
56bbaa7c937381fb10a2907b6bbe056ef8cc824a |
TODO.vm |
040000 |
tree |
- |
21928e906ad2907a55c2e81c2a8b0502b586b8a0 |
artwork |
100644 |
blob |
5328 |
d5be4cc3f15d059ad8d267d800c602e9774816a8 |
compare.csv |
100755 |
blob |
30 |
92c4bc48245c00408cd7e1fd89bc1a03058f4ce4 |
configure |
040000 |
tree |
- |
811af39b8be55c3a36147dd06b040e86de4e9d4a |
debian |
040000 |
tree |
- |
7108e9538d908ff384482155efcaef836a057a2c |
docker |
040000 |
tree |
- |
f67d3605efbd6422a8acdd953578991139266391 |
docs |
100755 |
blob |
18252 |
e2438615edba7066a730ed6a796a5302263f1f37 |
duilder |
100644 |
blob |
536 |
b791516f9ec08c038e61269e0c5f38446a61e59b |
duilder.conf |
040000 |
tree |
- |
e330b65f3c3eea427853842a05410579de6175bd |
hooks |
040000 |
tree |
- |
e6ef0396dd7f12664ea681377807bdedf09ad13f |
inc |
040000 |
tree |
- |
e255ce234c3993998edc12bc7e93fff555376eda |
misc |
100644 |
blob |
6012 |
7cf5090db19ef7b7a1a4d962f2588464ff4f1c1f |
rocketgit.spec |
040000 |
tree |
- |
85421cbfb018ff4b0eebb1741e2dcfcc72f81ada |
root |
040000 |
tree |
- |
870e96f0afc7d85c97505a878609d386f81748d8 |
samples |
040000 |
tree |
- |
589b9039f8bbb597747e4e78cdfc26be35ead352 |
scripts |
040000 |
tree |
- |
454044f7e286fe13ec18598fce6b613190f52e5e |
selinux |
100755 |
blob |
256 |
462ccd108c431f54e380cdac2329129875a318b5 |
spell_check.sh |
040000 |
tree |
- |
d9260d3cf0d6490be720312893600a8041bf991b |
techdocs |
040000 |
tree |
- |
5dbc11970335b2e208d92e525d2b6ef49dcce3c3 |
tests |
040000 |
tree |
- |
e810d7397575886ef495708d571eb3675f6928ba |
tools |
Hints:
Before first commit, do not forget to setup your git environment:
git config --global user.name "your_name_here"
git config --global user.email "your@email_here"
Clone this repository using HTTP(S):
git clone https://rocketgit.com/user/catalinux/rocketgit
Clone this repository using ssh (do not forget to upload a key first):
git clone ssh://rocketgit@ssh.rocketgit.com/user/catalinux/rocketgit
Clone this repository using git:
git clone git://git.rocketgit.com/user/catalinux/rocketgit
You are allowed to anonymously push to this repository.
This means that your pushed commits will automatically be transformed into a
merge request:
... clone the repository ...
... make some changes and some commits ...
git push origin main