DBScriptRunner.php 560 B

123456789101112131415161718192021222324
  1. <?php
  2. //Let's see if we've got a database set up in settings.ini
  3. try{
  4. ApplicationSettings::GetSetting("database", "database");
  5. } catch(Exception $e){
  6. return;
  7. }
  8. include_once 'Model/DBObject.php';
  9. class DBScriptRunner{
  10. public static function RunAllScripts(){
  11. $schemas=glob("DB Scripts/*.sql");
  12. $PDO=DBObject::GetPDO();
  13. foreach ($schemas as $schema)
  14. $PDO->query(file_get_contents($schema));
  15. }
  16. public static function RunScript($file) {
  17. $PDO=DBObject::GetPDO();
  18. $PDO->query(file_get_contents("DB Scripts/".$file));
  19. }
  20. }