Changeset 897 for trunk/Packages/Common/Database.php

Timestamp:

Jan 22, 2021, 12:04:30 AM (4 years ago)

Author:

chronos

Message:

• Modified: Setup module is always installed and enabled to be executed as base system module. From Setup module all other system modules can be installed.
• Added: Allow to install, uninstall, enable, disable and upgrade all user modules.
• Added: Created ModuleManager app module for managing other modules.
• Modified: Keep InstalledVersion for installed modules in ModulesConfig.php.
• Added: Distinction between system, library and application module types.

File:

• trunk/Packages/Common/Database.php (modified) (4 diffs)

trunk/Packages/Common/Database.php

@@ -44 +44 @@
   public bool $LogSQLQuery;
   public string $LogFile;
+  public string $Database;
 
   function __construct()
@@ -56 +57 @@
     $this->LogSQLQuery = false;
     $this->LogFile = dirname(__FILE__).'/../../Query.log';
+    $this->Database = '';
   }
 
@@ -63 +65 @@
       else if ($this->Type == 'pgsql') $ConnectionString = 'pgsql:dbname='.$Database.';host='.$Host;
       else $ConnectionString = '';
+    $this->Database = $Database;
     try {
       $this->PDO = new PDO($ConnectionString, $User, $Password);
-
     } catch (Exception $E)
     {
@@ -235 +237 @@
     $this->PDO->commit();
   }
+
+  public function TableExists(string $Name): bool
+  {
+    $DbResult = $this->query('SELECT * FROM information_schema.tables  WHERE table_schema = "'.$this->Database.
+    '" AND table_name = "'.$Name.'" LIMIT 1');
+    return $DbResult->num_rows != 0;
+  }
 }