public function testInstance() { $record = []; $quoter = $this->getMockBuilder('Jivoo\\Data\\Query\\Expression\\Quoter')->getMock(); $quoter->method('quoteLiteral')->willReturnCallback(function ($type, $value) { return '"' . $value . '"'; }); $array = new ArrayLiteral(DataType::string(), array('foo', 'bar')); $this->assertEquals(array('foo', 'bar'), $array($record)); $this->assertEquals('("foo", "bar")', $array->toString($quoter)); }
public function testCreateTable() { $db = $this->getDb(); $adapter = new PostgresqlTypeAdapter($db); $db->expects($this->exactly(3))->method('execute')->withConsecutive([$this->equalTo('CREATE TABLE {FooBar} (' . 'id serial NOT NULL, ' . 'foo varchar(255) NOT NULL DEFAULT "bar", ' . 'CONSTRAINT "foo_bar_PRIMARY" PRIMARY KEY (id))')], [$this->equalTo('CREATE INDEX "foo_bar_foo_id" ON {FooBar} (foo, id)')], [$this->equalTo('CREATE UNIQUE INDEX "foo_bar_foo" ON {FooBar} (foo)')]); $def = new \Jivoo\Data\DefinitionBuilder(); $def->addAutoIncrementId(); $def->foo = DataType::string(255, false, "bar"); $def->addKey(['foo', 'id']); $def->addUnique('foo'); $adapter->createTable('FooBar', $def); }
public function testCreateTable() { $db = $this->getDb(); $adapter = new SqliteTypeAdapter($db); $db->expects($this->exactly(3))->method('execute')->withConsecutive([$this->equalTo('CREATE TABLE "foo_bar" (' . 'id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, ' . 'foo TEXT(255) NOT NULL DEFAULT "bar")')], [$this->equalTo('CREATE INDEX "foo_bar_foo_id" ON "foo_bar" (foo, id)')], [$this->equalTo('CREATE UNIQUE INDEX "foo_bar_foo" ON "foo_bar" (foo)')]); $def = new \Jivoo\Data\DefinitionBuilder(); $def->addAutoIncrementId(); $def->foo = DataType::string(255, false, "bar"); $def->addKey(['foo', 'id']); $def->addUnique('foo'); $adapter->createTable('FooBar', $def); }
public function testCreateTable() { $db = $this->getDb(); $adapter = new MysqlTypeAdapter($db); $db->expects($this->once())->method('execute')->with($this->equalTo('CREATE TABLE `foo_bar` (' . 'id INT UNSIGNED NOT NULL AUTO_INCREMENT, ' . 'foo VARCHAR(255) NOT NULL DEFAULT "bar", ' . 'PRIMARY KEY (id), ' . 'INDEX (foo, id), ' . 'UNIQUE (foo)' . ') CHARACTER SET utf8')); $def = new \Jivoo\Data\DefinitionBuilder(); $def->addAutoIncrementId(); $def->foo = DataType::string(255, false, "bar"); $def->addKey(['foo', 'id']); $def->addUnique('foo'); $adapter->createTable('FooBar', $def); }
public static function getDefinition() { $def = new DefinitionBuilder(); $def->addAutoIncrementId(); // Autoincrementing INT id $def->username = DataType::string(255); // Username VARCHAR(255) $def->password = DataType::string(255); // Password VARCHAR(255) $def->addtimeStamps(); // Timestamps: 'created' and 'updated' $def->addUnique('username', 'username'); // A unique index on the username field return $def; }
public function testParseAtomic() { $ast = ExpressionParser::parseAtomic(ExpressionParser::lex('foo')); $this->assertInstanceOf('Jivoo\\Data\\Query\\Expression\\FieldAccess', $ast); $this->assertEquals('foo', $ast->field); $ast = ExpressionParser::parseAtomic(ExpressionParser::lex('15.5')); $this->assertInstanceOf('Jivoo\\Data\\Query\\Expression\\Literal', $ast); $this->assertEquals(15.5, $ast->value); $ast = ExpressionParser::parseAtomic(ExpressionParser::lex('?', array(42))); $this->assertInstanceOf('Jivoo\\Data\\Query\\Expression\\Literal', $ast); $this->assertEquals(42, $ast->value); $ast = ExpressionParser::parseAtomic(ExpressionParser::lex('%_', array(DataType::string(), 'test'))); $this->assertInstanceOf('Jivoo\\Data\\Query\\Expression\\Literal', $ast); $this->assertEquals('test', $ast->value); $this->assertTrue($ast->type->isString()); $ast = ExpressionParser::parseAtomic(ExpressionParser::lex('%i()', array(array(1, 2, 3)))); $this->assertInstanceOf('Jivoo\\Data\\Query\\Expression\\ArrayLiteral', $ast); $this->assertEquals(array(1, 2, 3), $ast->values); }
protected function getDb() { $def = new DatabaseDefinitionBuilder(); $tableDef = new DefinitionBuilder(); $tableDef->a = DataType::string(); $tableDef->b = DataType::string(); $tableDef->c = DataType::string(); $def->addDefinition('Foo', $tableDef); $typeAdapter = $this->getMockBuilder('Jivoo\\Data\\Database\\TypeAdapter')->getMock(); $typeAdapter->method('encode')->willReturnCallback(function ($type, $value) { return '"' . $value . '"'; }); $db = $this->getMockBuilder('Jivoo\\Data\\Database\\Common\\SqlDatabase')->getMock(); $db->method('getTypeAdapter')->willReturn($typeAdapter); $db->method('getDefinition')->willReturn($def); $db->method('sqlLimitOffset')->willReturnCallback(function ($limit, $offset) { if (isset($offset)) { return 'LIMIT ' . $limit . ' OFFSET ' . $offset; } return 'LIMIT ' . $limit; }); $db->method('tableName')->willReturnCallback(function ($table) { return \Jivoo\Utilities::camelCaseToUnderscores($table); }); $db->method('quoteModel')->willReturnCallback(function ($model) { return '{' . $model . '}'; }); $db->method('quoteField')->willReturnCallback(function ($field) { return $field; }); $db->method('quoteLiteral')->willReturnCallback(function ($type, $value) { return '"' . $value . '"'; }); $db->method('quoteString')->willReturnCallback(function ($value) { return '"' . $value . '"'; }); return $db; }
/** * Convert output of SHOW COLUMN to DataType. * * @param array $row * Row result. * @throws TypeException If type unsupported. * @return DataType The type. */ private function toDataType($row) { $null = (isset($row['Null']) and $row['Null'] != 'NO'); $default = null; if (isset($row['Default'])) { $default = $row['Default']; } if (preg_match('/enum\\((.+)\\)/i', $row['Type'], $matches) === 1) { preg_match_all('/\'([^\']+)\'/', $matches[1], $matches); $values = $matches[1]; return DataType::enum($values, $null, $default); } preg_match('/ *([^ (]+) *(\\(([0-9]+)\\))? *(unsigned)? *?/i', $row['Type'], $matches); $actualType = strtolower($matches[1]); $length = isset($matches[3]) ? intval($matches[3]) : 0; $intFlags = 0; if (isset($matches[4])) { $intFlags |= DataType::UNSIGNED; } if (strpos($row['Extra'], 'auto_increment') !== false) { $intFlags |= DataType::SERIAL; } switch ($actualType) { case 'bigint': $intFlags |= DataType::BIG; return DataType::integer($intFlags, $null, isset($default) ? intval($default) : null); case 'smallint': $intFlags |= DataType::SMALL; return DataType::integer($intFlags, $null, isset($default) ? intval($default) : null); case 'tinyint': $intFlags |= DataType::TINY; return DataType::integer($intFlags, $null, isset($default) ? intval($default) : null); case 'int': return DataType::integer($intFlags, $null, isset($default) ? intval($default) : null); case 'double': return DataType::float($null, isset($default) ? floatval($default) : null); case 'varchar': return DataType::string($length, $null, $default); case 'blob': return DataType::binary($null, $default); case 'date': return DataType::date($null, isset($default) ? strtotime($default . ' UTC') : null); case 'datetime': return DataType::dateTime($null, isset($default) ? strtotime($default . ' UTC') : null); case 'text': return DataType::text($null, $default); } throw new TypeException('Unsupported MySQL type for column: ' . $row['Field']); }
/** * Convert output of SHOW COLUMN to DataType. * * @param array $row * Row result. * @throws TypeException If type unsupported. * @return DataType The type. */ private function toDataType($row) { $null = $row['is_nullable'] != 'NO'; $default = null; if (isset($row['column_default'])) { $default = $row['column_default']; } $type = $row['data_type']; if (strpos($type, 'int') !== false) { $intFlags = 0; if (preg_match('/^nextval\\(/', $default) === 1) { $intFlags = DataType::SERIAL; $default = null; } elseif (isset($default)) { $default = intval($default); } if (strpos($type, 'bigint') !== false) { return DataType::integer($intFlags | DataType::BIG, $null, $default); } if (strpos($type, 'smallint') !== false) { return DataType::integer($intFlags | DataType::SMALL, $null, $default); } return DataType::integer($intFlags, $null, $default); } if (strpos($type, 'double') !== false) { return DataType::float($null, isset($default) ? floatval($default) : null); } if (strpos($type, 'bool') !== false) { return DataType::boolean($null, isset($default) ? boolval($default) : null); } if (preg_match("/^'(.*)'::[a-z ]+\$/", $default, $matches) === 1) { $default = $matches[1]; } else { $default = null; } if (strpos($type, 'character') !== false) { $length = intval($row['character_maximum_length']); return DataType::string($length, $null, $default); } if (strpos($type, 'date') !== false) { return DataType::date($null, isset($default) ? strtotime($default . ' UTC') : null); } if (strpos($type, 'timestamp') !== false) { return DataType::dateTime($null, isset($default) ? strtotime($default . ' UTC') : null); } if (strpos($type, 'text') !== false) { return DataType::text($null, $default); } throw new TypeException('Unsupported PostgreSQL type "' . $row['data_type'] . '" for column: ' . $row['column_name']); }