blob: a2ccc13b36b6cdfcc4744462328827aa21d60ade (
plain)
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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
|
<?php
/*
* File: ratatoeskr/sys/db.php
*
* Helper functions for dealing with MySQL.
*
* License:
* This file is part of Ratatöskr.
* Ratatöskr is licensed unter the MIT / X11 License.
* See "ratatoeskr/licenses/ratatoeskr" for more information.
*/
use r7r\cms\sys\Database;
use r7r\cms\sys\Env;
use r7r\cms\sys\DbTransaction;
if (!defined("SETUP")) {
require_once(dirname(__FILE__) . "/../config.php");
}
require_once(dirname(__FILE__) . "/utils.php");
// The global database connection.
// It's usage is deprecated, use the Database object supplied by Env::database() instead.
/** @var PDO|null $db_con */
$db_con = null;
/**
* Establish the global connection to the MySQL database.
* This sets the global {@see $db_con}.
*
* @deprecated Use the {@see Database} object supplied by {@see Env::database()} instead.
*/
function db_connect(): void
{
global $db_con;
$db_con = Env::getGlobal()->database()->getPdo();
}
/**
* Substitutes "PREFIX_" in the input string with the prefix from the config.
*
* @param mixed|string $q
* @return string
* @deprecated Use {@see Database::subPrefix()} instead.
*/
function sub_prefix($q): string
{
return Env::getGlobal()->database()->subPrefix((string)$q);
}
/**
* Prepares a SQL statement using the global DB connection.
* This will also replace "PREFIX_" with the prefix defined in 'config.php'.
*
* @param mixed|string $q The query / statement to prepare.
* @return PDOStatement
*
* @deprecated Use {@see Database::prepStmt()} instead.
*/
function prep_stmt($q): PDOStatement
{
return Env::getGlobal()->database()->prepStmt((string)$q);
}
/**
* Prepares statement (1st argument) with {@see prep_stmt()} and executes it with the remaining arguments.
*
* @param mixed ...$args
* @return PDOStatement
*
* @deprecated Use {@see Database::query()} instead.
*/
function qdb(...$args): PDOStatement
{
if (count($args) < 1) {
throw new InvalidArgumentException("qdb needs at least 1 argument");
}
return Env::getGlobal()->database()->query((string)$args[0], ...array_slice($args, 1));
}
/**
* Makes using transactions easier.
*
* @deprecated Use {@see DbTransaction} instead.
*/
class Transaction
{
/** @var DbTransaction */
private $tx;
/**
* Start a new transaction.
*/
public function __construct()
{
$this->tx = new DbTransaction(Env::getGlobal()->database());
}
/**
* Commit the transaction.
*/
public function commit(): void
{
$this->tx->commit();
}
/**
* Roll the transaction back.
*/
public function rollback(): void
{
$this->tx->rollback();
}
}
|
