tests/test-autoexecute-update.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

<?php

require __DIR__ . "/../adodb.inc.php";

$db = NewADOConnection("sqlite3");
$db->Connect(":memory:");

$db->Execute("CREATE TABLE users(id primary key, name, year_of_birth)");
$db->Execute("INSERT INTO users VALUES (1, 'John', 2000)");
$db->Execute("INSERT INTO users VALUES (2, 'Jane', 1981)");

$new_value = 2000;

$db->autoExecute(
    table: "users",
    fields_values: ["year_of_birth" => $new_value],
    mode: "UPDATE",
    where: "id = 2",
    forceUpdate: false,
);

$updated_value = $db->GetOne("SELECT year_of_birth FROM users WHERE id = 2");

if ($updated_value != $new_value) {
    die("ERROR: updated_value $updated_value != new_value $new_value");
}

echo "Finished.\n";