ImboIntegrationTest\Database\DoctrineTest::setUp PHP Method

    public function setUp()
    {
        if (!extension_loaded('PDO')) {
            $this->markTestSkipped('PDO is required to run this test');
        }
        if (!extension_loaded('pdo_sqlite')) {
            $this->markTestSkipped('pdo_sqlite is required to run this test');
        }
        if (!class_exists('Doctrine\\DBAL\\DriverManager')) {
            $this->markTestSkipped('Doctrine is required to run this test');
        }
        // Create tmp tables
        $this->pdo = new PDO('sqlite::memory:');
        $this->pdo->query("\n            CREATE TABLE IF NOT EXISTS imageinfo (\n                id INTEGER PRIMARY KEY NOT NULL,\n                user TEXT NOT NULL,\n                imageIdentifier TEXT NOT NULL,\n                size INTEGER NOT NULL,\n                extension TEXT NOT NULL,\n                mime TEXT NOT NULL,\n                added INTEGER NOT NULL,\n                updated INTEGER NOT NULL,\n                width INTEGER NOT NULL,\n                height INTEGER NOT NULL,\n                checksum TEXT NOT NULL,\n                originalChecksum TEXT NOT NULL,\n                UNIQUE (user,imageIdentifier)\n            )\n        ");
        $this->pdo->query("\n            CREATE TABLE IF NOT EXISTS metadata (\n                id INTEGER PRIMARY KEY NOT NULL,\n                imageId KEY INTEGER NOT NULL,\n                tagName TEXT NOT NULL,\n                tagValue TEXT NOT NULL\n            )\n        ");
        $this->pdo->query("\n            CREATE TABLE IF NOT EXISTS shorturl (\n                shortUrlId TEXT PRIMARY KEY NOT NULL,\n                user TEXT NOT NULL,\n                imageIdentifier TEXT NOT NULL,\n                extension TEXT,\n                query TEXT NOT NULL\n            )\n        ");
        $this->pdo->query("\n            CREATE INDEX shorturlparams ON shorturl (\n                user,\n                imageIdentifier,\n                extension,\n                query\n            )\n        ");
        parent::setUp();
    }