public function __construct()
{
$this->app = Factory::getSlimApp();
$this->container = $this->app->getContainer();
$this->logger = $this->container->logger;
$this->db = Factory::getDb();
}
public static function deleteFromTable($filter, $table)
{
$logger = Factory::getSlimApp()->getContainer()->logger;
try {
$db = Factory::getDb();
$deleteStatement = $db->delete()->from($table)->where(...$filter);
$affectedRows = $deleteStatement->execute();
$logger->info("affected rows are " . $affectedRows);
if ($affectedRows) {
return ["success" => true, "message" => "Delete successful."];
} else {
return ["success" => false, "message" => "Delete failed for " . json_encode($filter) . " from {$table}.\n SQL: " . $deleteStatement->__toString() . "\n" . json_encode($db->errorInfo())];
}
} catch (Exception $e) {
throw $e;
}
}
