summaryrefslogtreecommitdiffstats
path: root/codebase
diff options
context:
space:
mode:
Diffstat (limited to 'codebase')
-rw-r--r--codebase/db_common.php12
-rw-r--r--codebase/db_excel.php4
-rw-r--r--codebase/db_filesystem.php4
-rw-r--r--codebase/db_mssql.php2
-rw-r--r--codebase/db_mysqli.php2
-rw-r--r--codebase/db_oracle.php2
-rw-r--r--codebase/db_pdo.php2
-rw-r--r--codebase/db_phpci.php2
-rw-r--r--codebase/db_postgre.php2
-rw-r--r--codebase/db_sasql.php2
-rw-r--r--codebase/db_sqlite.php2
-rw-r--r--codebase/db_sqlite3.php2
-rw-r--r--codebase/db_sqlsrv.php2
13 files changed, 23 insertions, 17 deletions
diff --git a/codebase/db_common.php b/codebase/db_common.php
index 9f1a8cd..8929631 100644
--- a/codebase/db_common.php
+++ b/codebase/db_common.php
@@ -667,6 +667,12 @@ abstract class DBDataWrapper extends DataWrapper{
return $this->query($this->select_query($select,$source->get_source(),$where,$sort,$source->get_start(),$source->get_count()));
}
+ public function queryOne($sql){
+ $res = $this->query($sql);
+ if ($res)
+ return $this->get_next($res);
+ return false;
+ }
public function get_size($source){
$count = new DataRequestConfig($source);
@@ -896,7 +902,7 @@ abstract class DBDataWrapper extends DataWrapper{
@return
sql result set
*/
- abstract protected function query($sql);
+ abstract public function query($sql);
/*! returns next record from result set
@param res
@@ -909,7 +915,7 @@ abstract class DBDataWrapper extends DataWrapper{
@return
new id value, for newly inserted row
*/
- abstract protected function get_new_id();
+ abstract public function get_new_id();
/*! escape data to prevent sql injections
@param data
unescaped data
@@ -994,7 +1000,7 @@ class MySQLDBDataWrapper extends DBDataWrapper{
return mysql_fetch_assoc($res);
}
- protected function get_new_id(){
+ public function get_new_id(){
return mysql_insert_id($this->connection);
}
diff --git a/codebase/db_excel.php b/codebase/db_excel.php
index 14050e1..6c0e347 100644
--- a/codebase/db_excel.php
+++ b/codebase/db_excel.php
@@ -96,10 +96,10 @@ class ExcelDBDataWrapper extends DBDataWrapper {
return $excRes;
}
- protected function query($sql) {
+ public function query($sql) {
}
- protected function get_new_id() {
+ public function get_new_id() {
}
public function escape($data) {
diff --git a/codebase/db_filesystem.php b/codebase/db_filesystem.php
index 7817be5..b3d16d2 100644
--- a/codebase/db_filesystem.php
+++ b/codebase/db_filesystem.php
@@ -134,10 +134,10 @@ class FileSystemDBDataWrapper extends DBDataWrapper {
return $result;
}
- protected function query($sql) {
+ public function query($sql) {
}
- protected function get_new_id() {
+ public function get_new_id() {
}
public function escape($data) {
diff --git a/codebase/db_mssql.php b/codebase/db_mssql.php
index 0bbcf63..0acab93 100644
--- a/codebase/db_mssql.php
+++ b/codebase/db_mssql.php
@@ -28,7 +28,7 @@ class MsSQLDBDataWrapper extends DBDataWrapper{
return mssql_fetch_assoc($res);
}
- protected function get_new_id(){
+ public function get_new_id(){
/*
MSSQL doesn't support identity or auto-increment fields
Insert SQL returns new ID value, which stored in last_id field
diff --git a/codebase/db_mysqli.php b/codebase/db_mysqli.php
index 806fcda..6740a3b 100644
--- a/codebase/db_mysqli.php
+++ b/codebase/db_mysqli.php
@@ -18,7 +18,7 @@ class MySQLiDBDataWrapper extends MySQLDBDataWrapper{
return $res->fetch_assoc();
}
- protected function get_new_id(){
+ public function get_new_id(){
return $this->connection->insert_id;
}
diff --git a/codebase/db_oracle.php b/codebase/db_oracle.php
index 55fe683..064d55a 100644
--- a/codebase/db_oracle.php
+++ b/codebase/db_oracle.php
@@ -40,7 +40,7 @@ class OracleDBDataWrapper extends DBDataWrapper{
return $data;
}
- protected function get_new_id(){
+ public function get_new_id(){
/*
Oracle doesn't support identity or auto-increment fields
Insert SQL returns new ID value, which stored in last_id field
diff --git a/codebase/db_pdo.php b/codebase/db_pdo.php
index c008adb..d1ad4d8 100644
--- a/codebase/db_pdo.php
+++ b/codebase/db_pdo.php
@@ -45,7 +45,7 @@ class PDODBDataWrapper extends DBDataWrapper{
return $data;
}
- protected function get_new_id(){
+ public function get_new_id(){
return $this->connection->lastInsertId();
}
diff --git a/codebase/db_phpci.php b/codebase/db_phpci.php
index 3f4221b..f5b317c 100644
--- a/codebase/db_phpci.php
+++ b/codebase/db_phpci.php
@@ -28,7 +28,7 @@ class PHPCIDBDataWrapper extends DBDataWrapper{
return $data;
}
- protected function get_new_id(){
+ public function get_new_id(){
return $this->connection->insert_id();
}
diff --git a/codebase/db_postgre.php b/codebase/db_postgre.php
index 011bd47..a7d1598 100644
--- a/codebase/db_postgre.php
+++ b/codebase/db_postgre.php
@@ -32,7 +32,7 @@ class PostgreDBDataWrapper extends DBDataWrapper{
return pg_fetch_assoc($res);
}
- protected function get_new_id(){
+ public function get_new_id(){
$res = pg_query( $this->connection, "SELECT LASTVAL() AS seq");
$data = pg_fetch_assoc($res);
pg_free_result($res);
diff --git a/codebase/db_sasql.php b/codebase/db_sasql.php
index 85959df..025f5ef 100644
--- a/codebase/db_sasql.php
+++ b/codebase/db_sasql.php
@@ -20,7 +20,7 @@ class SaSQLDBDataWrapper extends DBDataWrapper{
return sasql_fetch_assoc($res);
}
- protected function get_new_id(){
+ public function get_new_id(){
return sasql_insert_id($this->connection);
}
diff --git a/codebase/db_sqlite.php b/codebase/db_sqlite.php
index cd8de9d..04df7e5 100644
--- a/codebase/db_sqlite.php
+++ b/codebase/db_sqlite.php
@@ -23,7 +23,7 @@ class SQLiteDBDataWrapper extends DBDataWrapper{
return $data;
}
- protected function get_new_id(){
+ public function get_new_id(){
return sqlite_last_insert_rowid($this->connection);
}
diff --git a/codebase/db_sqlite3.php b/codebase/db_sqlite3.php
index de284cf..349490b 100644
--- a/codebase/db_sqlite3.php
+++ b/codebase/db_sqlite3.php
@@ -22,7 +22,7 @@ class SQLite3DBDataWrapper extends DBDataWrapper{
return $res->fetchArray();
}
- protected function get_new_id(){
+ public function get_new_id(){
return $this->connection->lastInsertRowID();
}
diff --git a/codebase/db_sqlsrv.php b/codebase/db_sqlsrv.php
index 1908e7b..1b27020 100644
--- a/codebase/db_sqlsrv.php
+++ b/codebase/db_sqlsrv.php
@@ -51,7 +51,7 @@ class SQLSrvDBDataWrapper extends DBDataWrapper{
return $data;
}
- protected function get_new_id(){
+ public function get_new_id(){
/*
MSSQL doesn't support identity or auto-increment fields
Insert SQL returns new ID value, which stored in last_id field
generated by cgit v1.1 at 2025-05-11 22:30:49 +0000