X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=src%2FDatabase%2FDBA.php;h=0c0fd0f80d30839cf94261d08dfee5a0f9a63334;hb=3f2b0b9422915529a0ea585aa4325b6d2f2f65cd;hp=2e4fb376712e381bc45b338b61689d3e428547c3;hpb=360614d2cf3aceeb763ef1281ad5236878f5d735;p=friendica.git

diff --git a/src/Database/DBA.php b/src/Database/DBA.php
index 2e4fb37671..0c0fd0f80d 100644
--- a/src/Database/DBA.php
+++ b/src/Database/DBA.php
@@ -42,6 +42,11 @@ class DBA
 	 */
 	const NULL_DATETIME = '0001-01-01 00:00:00';
 
+	/**
+	 * Lowest possible datetime(6) value
+	 */
+	const NULL_DATETIME6 = '0001-01-01 00:00:00.000000';
+
 	public static function connect(): bool
 	{
 		return DI::dba()->connect();
@@ -205,7 +210,7 @@ class DBA
 	 * Please use DBA::delete, DBA::insert, DBA::update, ... instead
 	 *
 	 * @param string $sql SQL statement
-	 * @return boolean Was the query successfull? False is returned only if an error occurred
+	 * @return boolean Was the query successful? False is returned only if an error occurred
 	 * @throws \Exception
 	 */
 	public static function e(string $sql): bool
@@ -420,7 +425,7 @@ class DBA
 	 * @param array|boolean $old_fields array with the old field values that are about to be replaced (true = update on duplicate, false = don't update identical fields)
 	 * @param array         $params     Parameters: "ignore" If set to "true" then the update is done with the ignore parameter
 	 *
-	 * @return boolean was the update successfull?
+	 * @return boolean was the update successful?
 	 * @throws \Exception
 	 */
 	public static function update(string $table, array $fields, array $condition, $old_fields = [], array $params = []): bool
@@ -517,7 +522,7 @@ class DBA
 	 * Build the table query substring from one or more tables, with or without a schema.
 	 *
 	 * Expected formats:
-	 * - table
+	 * - [table]
 	 * - [table1, table2, ...]
 	 * - [schema1 => table1, schema2 => table2, table3, ...]
 	 *
@@ -527,7 +532,7 @@ class DBA
 	public static function buildTableString(array $tables): string
 	{
 		// Quote each entry
-		return implode(',', array_map(['self', 'quoteIdentifier'], $tables));
+		return implode(',', array_map([self::class, 'quoteIdentifier'], $tables));
 	}
 
 	/**
@@ -717,7 +722,7 @@ class DBA
 	{
 		$groupby_string = '';
 		if (!empty($params['group_by'])) {
-			$groupby_string = " GROUP BY " . implode(', ', array_map(['self', 'quoteIdentifier'], $params['group_by']));
+			$groupby_string = " GROUP BY " . implode(', ', array_map([self::class, 'quoteIdentifier'], $params['group_by']));
 		}
 
 		$order_string = '';
@@ -821,6 +826,27 @@ class DBA
 		return DI::dba()->processlist();
 	}
 
+	/**
+	 * Optimizes tables
+	 *
+	 * @param string $table a given table
+	 *
+	 * @return bool True, if successfully optimized, otherwise false
+	 * @throws \Exception
+	 */
+	public static function optimizeTable(string $table): bool
+	{
+		return DI::dba()->optimizeTable($table);
+	}
+
+	/**
+	 * Kill sleeping database processes
+	 */
+	public static function deleteSleepingProcesses()
+	{
+		DI::dba()->deleteSleepingProcesses();
+	}
+
 	/**
 	 * Fetch a database variable
 	 *