Feature upgrade to9 lts

Classes/Domain/Consistence/AbstractConsistence.php

@@ -27,8 +27,9 @@ namespace SGalinski\SgConsistence\Domain\Consistence;
  ***************************************************************/
 
 use TYPO3\CMS\Core\Authentication\BackendUserAuthentication;
+use TYPO3\CMS\Core\Database\ConnectionPool;
 use TYPO3\CMS\Core\SingletonInterface;
-use TYPO3\CMS\Core\Database\DatabaseConnection;
+use TYPO3\CMS\Core\Utility\GeneralUtility;
 use TYPO3\CMS\Extbase\DomainObject\DomainObjectInterface;
 
 /**
@@ -108,9 +109,15 @@ abstract class AbstractConsistence implements SingletonInterface, ConsistenceInt
 
 		$objectUid = $object->getUid();
 
-		/** @var $db DatabaseConnection */
-		$db = $GLOBALS['TYPO3_DB'];
-		$db->exec_UPDATEquery($tableName, 'uid = ' . $objectUid, $updatedFields);
+		$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable($tableName);
+		$queryBuilder->update($tableName)
+			->where(
+				$queryBuilder->expr()->eq('uid', $queryBuilder->createNamedParameter($objectUid, \PDO::PARAM_INT))
+			);
+		foreach ($updatedFields as $field => $value) {
+			$queryBuilder->set($field, $value, TRUE);
+		}
+		$queryBuilder->execute();
 
 		$updatedFieldsAsString = '';
 		foreach ($updatedFields as $key => $value) {
@@ -147,13 +154,13 @@ abstract class AbstractConsistence implements SingletonInterface, ConsistenceInt
 			return;
 		}
 
-		/** @var $db DatabaseConnection */
-		$db = $GLOBALS['TYPO3_DB'];
-		$db->exec_INSERTquery($tableName, $fields);
-
+		$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable($tableName);
+		$queryBuilder->insert($tableName)
+			->values($fields)
+			->execute();
 		$message = 'Consistence Update: Insert Object';
 		$message .= ' | Table: "' . $tableName . '"';
-		$message .= ' | New UID: "' . $db->sql_insert_id() . '"';
+		$message .= ' | New UID: "' . $queryBuilder->getConnection()->lastInsertId() . '"';
 		$this->writeUpdateLog($message);
 	}
 
@@ -169,9 +176,10 @@ abstract class AbstractConsistence implements SingletonInterface, ConsistenceInt
 			return;
 		}
 
-		/** @var $db DatabaseConnection */
-		$db = $GLOBALS['TYPO3_DB'];
-		$db->exec_DELETEquery($tableName, $where);
+		$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable($tableName);
+		$queryBuilder->delete($tableName)
+			->where($where)
+			->execute();
 
 		$message = 'Consistence Update: Delete Object';
 		$message .= ' | Table: "' . $tableName . '"';