MigrationManagerDynamicTableTest::test_migrate_creates_custom_table()

Complexity

Conditions	1
Paths	1

Size

Total Lines	25
Code Lines	18

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
  public function test_migrate_creates_custom_table()
  {
    MigrationManager::migrate($this->pdo, $this->table);

It seems like $this->pdo can also be of type null; however, parameter $connection of Silviooosilva\CacheerPhp\Core\MigrationManager::migrate() does only seem to accept PDO, maybe add an additional type check?

    // Verify table exists (SQLite check)
    $stmt = $this->pdo->prepare("SELECT name FROM sqlite_master WHERE type='table' AND name = :t");
    $stmt->bindValue(':t', $this->table);
    $stmt->execute();
    $row = $stmt->fetch(PDO::FETCH_ASSOC);
    $this->assertNotFalse($row);

    // Verify basic insert/select using PDO
    $expiration = date('Y-m-d H:i:s', time() + 60);
    $stmt = $this->pdo->prepare("INSERT INTO {$this->table} (cacheKey, cacheData, cacheNamespace, expirationTime, created_at) VALUES (:k, :d, '', :e, :c)");
    $stmt->bindValue(':k', 'mk');
    $stmt->bindValue(':d', serialize(['a' => 1]));
    $stmt->bindValue(':e', $expiration);
    $stmt->bindValue(':c', date('Y-m-d H:i:s'));
    $this->assertTrue($stmt->execute());

    $stmt = $this->pdo->prepare("SELECT cacheData FROM {$this->table} WHERE cacheKey = :k LIMIT 1");
    $stmt->bindValue(':k', 'mk');
    $stmt->execute();
    $row = $stmt->fetch(PDO::FETCH_ASSOC);
    $this->assertEquals(['a' => 1], unserialize($row['cacheData']));
  }