/** * When called will return the credential contents as an associative array. */ public function testWhenCalledWillReturnTheCredentialContentsAsAnAssociativeArray() { $object = MySQLCredentials::build(StringLiteral::fromNative($this->username), StringLiteral::fromNative($this->password), StringLiteral::fromNative($this->hostnameLiteral), StringLiteral::fromNative($this->database)); $response = $object->toArray(); $expected = ['username' => 'Alphanum_123', 'password' => 'Alphanum1234567890-=~!#$%^&*()[]_+?<>', 'host' => 'localhost', 'database' => 'employees_2016']; static::assertEquals($expected, $response); }
public static function getInstanceSample() { $name = StringLiteral::fromNative('sample_table_name'); $fields = TableFieldCollection::build([TableField::build(StringLiteral::fromNative('sample-name'), FieldType::fromNative('varchar(123)'), true, FieldKeyType::fromNative('sample-key'), FieldDefaultValue::fromNative('sample-default'), StringLiteral::fromNative('sample-extra'))]); $indexes = TableIndexCollection::build([TableIndex::build(new StringLiteral('sample-table'), new StringLiteral('sample-nonUnique'), new StringLiteral('sample-keyName'), new StringLiteral('sample-seqInIndex'), new StringLiteral('sample-columnName'), new StringLiteral('sample-collation'), new StringLiteral('sample-cardinality'), new StringLiteral('sample-subPart'), new StringLiteral('sample-packed'), false, new StringLiteral('sample-indexType'), new StringLiteral('sample-comment'), new StringLiteral('sample-indexComment'))]); $instance = Table::build($name, $fields, $indexes); return $instance; }
/** * When entries are passed at build time then return them as an array. */ public function testWhenEntriesArePassedThenStoreThem() { $fields = [TableField::build(StringLiteral::fromNative('id'), FieldType::fromNative('int(3)'), false, FieldKeyType::fromNative('PRI'), FieldDefaultValue::fromNative(''), StringLiteral::fromNative('')), TableField::build(StringLiteral::fromNative('name'), FieldType::fromNative('varchar(255)'), false, FieldKeyType::fromNative(''), FieldDefaultValue::fromNative(''), StringLiteral::fromNative(''))]; $instance = TableFieldCollection::build($fields); $response = $instance->toArray(); $expected = [['name' => 'id', 'type' => 'int(3)', 'null' => false, 'key' => 'PRI', 'default' => '', 'extra' => ''], ['name' => 'name', 'type' => 'varchar(255)', 'null' => false, 'key' => '', 'default' => '', 'extra' => '']]; static::assertEquals($expected, $response); }
/** * When isNull is not boolean will throw exception. * * @expectedException \InvalidArgumentException * @expectedExceptionMessage The isNull argument doesn't have a boolean value. */ public function testWhenIsNullIsNotBooleanWillThrowException() { $name = 'sample-name'; $type = 'varchar(123)'; $key = 'sample-key'; $default = 'sample-default'; $extra = 'sample-extra'; TableField::build(StringLiteral::fromNative($name), FieldType::fromNative($type), 'isNull', FieldKeyType::fromNative($key), FieldDefaultValue::fromNative($default), StringLiteral::fromNative($extra)); }
/** * Store entries. */ public function testStoreEntries() { $name = StringLiteral::fromNative('sample_table_name'); $fields = TableFieldCollection::build([]); $indexes = TableIndexCollection::build([]); $instance = Table::build($name, $fields, $indexes); static::assertInstanceOf(Table::class, $instance); $helper = \ClassHelper::instance($instance); static::assertSame($name, $helper->name); static::assertSame($fields, $helper->fields); static::assertSame($indexes, $helper->indexes); }
public function buildIndex($table, $nonUnique, $keyName, $seqInIndex, $columnName, $collation, $cardinality, $subPart, $packed, $isNull, $indexType, $comment, $indexComment) { $tableAttribute = StringLiteral::fromNative($table); $nonUniqueAttribute = StringLiteral::fromNative($nonUnique); $keyNameAttribute = StringLiteral::fromNative($keyName); $seqInIndexAttribute = StringLiteral::fromNative($seqInIndex); $columnNameAttribute = StringLiteral::fromNative($columnName); $collationAttribute = StringLiteral::fromNative($collation); $cardinalityAttribute = StringLiteral::fromNative($cardinality); $subPartAttribute = null === $subPart ? NullValue::create() : StringLiteral::fromNative($subPart); $packedAttribute = null === $packed ? NullValue::create() : StringLiteral::fromNative($packed); $isNullAttribute = (bool) $isNull; $indexTypeAttribute = StringLiteral::fromNative($indexType); $commentAttribute = StringLiteral::fromNative($comment); $indexCommentAttribute = StringLiteral::fromNative($indexComment); return TableIndex::build($tableAttribute, $nonUniqueAttribute, $keyNameAttribute, $seqInIndexAttribute, $columnNameAttribute, $collationAttribute, $cardinalityAttribute, $subPartAttribute, $packedAttribute, $isNullAttribute, $indexTypeAttribute, $commentAttribute, $indexCommentAttribute); }
/** * @param string $tableName * @param \DatabaseInspect\Persistence\Models\TableField[] $fieldEntries * @param \DatabaseInspect\Persistence\Models\TableIndex[] $indexEntries * * @return static */ public function buildTableFromPersistence($tableName, $fieldEntries, $indexEntries) { $tableName = StringLiteral::fromNative($tableName); $indexCollection = $this->buildTableIndexCollectionFromPersistence($indexEntries); $fieldCollection = $this->buildTableFieldCollectionFromPersistence($fieldEntries); $table = Table::build($tableName, $fieldCollection, $indexCollection); return $table; }
/** * When an invalid native is supplied then throw exception. * @expectedException \DatabaseInspect\Attributes\Exceptions\InvalidNativeArgumentException */ public function testWhenAnInvalidNativeIsSuppliedThenThrowException() { $value = 123; StringLiteral::fromNative($value); }