/** * Test from unix time */ public function testFromUnixTime() { $this->assertEquals('2016-02-05T19:33:57+0000', MySQLite::mysql_from_unixtime(1454700837)); $this->assertEquals('2008-10-22T18:40:37+0000', MySQLite::mysql_from_unixtime(1224700837)); }
/** * Test the rand function */ public function testRand() { $pdo = new PDO("sqlite::memory:", null, null, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]); MySQLite::createFunctions($pdo); $pdo->exec("CREATE TABLE testing(id INT PRIMARY KEY NOT NULL)"); $stmt = $pdo->prepare("INSERT INTO testing (id) VALUES (?)"); for ($x = 0; $x <= 10; $x++) { $stmt->execute([$x]); } $results = []; for ($x = 0; $x < 20; $x++) { $results[] = $pdo->query('SELECT id FROM testing ORDER BY RAND() LIMIT 1')->fetch(PDO::FETCH_COLUMN); } $this->assertNotEquals(array_slice($results, 0, 10), array_slice($results, 10, 10)); }