Code Coverage |
||||||||||
Lines |
Functions and Methods |
Classes and Traits |
||||||||
| Total | |
0.00% |
0 / 15 |
|
0.00% |
0 / 2 |
CRAP | |
0.00% |
0 / 1 |
| SQLiteAccess | |
0.00% |
0 / 15 |
|
0.00% |
0 / 2 |
42 | |
0.00% |
0 / 1 |
| connect | |
0.00% |
0 / 8 |
|
0.00% |
0 / 1 |
12 | |||
| postConnect | |
0.00% |
0 / 7 |
|
0.00% |
0 / 1 |
12 | |||
| 1 | <?php |
| 2 | |
| 3 | /** |
| 4 | * @package ClientDLDB |
| 5 | * @copyright BerlinOnline Stadtportal GmbH & Co. KG |
| 6 | **/ |
| 7 | |
| 8 | namespace BO\Zmsdldb; |
| 9 | |
| 10 | /** |
| 11 | * |
| 12 | */ |
| 13 | class SQLiteAccess extends PDOAccess |
| 14 | { |
| 15 | const DEFAULT_DATABASE_NAME = 'dldb_frontend_dev'; |
| 16 | const DEFAULT_DATABASE_PATH = __DIR__; |
| 17 | |
| 18 | protected function connect(array $options) |
| 19 | { |
| 20 | try { |
| 21 | $databasePath = rtrim(($options['databasePath'] ?? static::DEFAULT_DATABASE_PATH), \DIRECTORY_SEPARATOR); |
| 22 | |
| 23 | if (!is_dir($databasePath)) { |
| 24 | mkdir($databasePath); |
| 25 | } |
| 26 | $database = ($options['database'] ?? static::DEFAULT_DATABASE_NAME) . '.db'; |
| 27 | $dsn = 'sqlite:' . $databasePath . \DIRECTORY_SEPARATOR . $database; |
| 28 | |
| 29 | $this->pdo = new \PDO($dsn); |
| 30 | } catch (\Exception $e) { |
| 31 | throw $e; |
| 32 | } |
| 33 | } |
| 34 | |
| 35 | protected function postConnect() |
| 36 | { |
| 37 | try { |
| 38 | $this->beginTransaction(); |
| 39 | $shemaQuerys = include(__DIR__ . '/shema/sqlite.php'); |
| 40 | |
| 41 | foreach ($shemaQuerys as $query) { |
| 42 | $this->exec($query); |
| 43 | } |
| 44 | $this->commit(); |
| 45 | } catch (\Exception $e) { |
| 46 | throw $e; |
| 47 | } |
| 48 | } |
| 49 | } |