/** * Adds externalSystemId column to specific table if it does not exist * @param $tableName * @param $maxLength * @param $columnName */ public static function addExternalIdColumnIfMissing($tableName, $maxLength = 255, $columnName = null) { if (!isset($columnName)) { $columnName = static::EXTERNAL_SYSTEM_ID_COLUMN_NAME; } // check if external_system_id exists in fields $columnExists = ZurmoRedBean::$writer->doesColumnExist($tableName, $columnName); if (!$columnExists) { // if not, update model and add an external_system_id field $type = 'string'; $length = null; RedBeanModelMemberRulesToColumnAdapter::resolveStringTypeAndLengthByMaxLength($type, $length, $maxLength); $columns = array(); $columns[] = RedBeanModelMemberToColumnUtil::resolveColumnMetadataByHintType($columnName, $type, $length); $schema = CreateOrUpdateExistingTableFromSchemaDefinitionArrayUtil::getTableSchema($tableName, $columns); CreateOrUpdateExistingTableFromSchemaDefinitionArrayUtil::generateOrUpdateTableBySchemaDefinition($schema, new MessageLogger()); } }
/** * Provided modelClassName and rules for a member we resolve a column in table. * @param string $modelClassName * @param array $rules * @param $messageLogger * @return array|bool */ public static function resolve($modelClassName, array $rules, &$messageLogger) { if (empty($rules)) { return false; } $member = $rules[0][0]; assert('strpos($member, " ") === false'); $name = RedBeanModelMemberToColumnUtil::resolve($member); $type = null; $length = null; $notNull = null; $default = null; static::resolveColumnTypeAndLengthFromRules($modelClassName, $member, $rules, $type, $length, $notNull, $default, $messageLogger); if (!isset($type)) { return false; } return RedBeanModelMemberToColumnUtil::resolveColumnMetadataByHintType($name, $type, $length, null, $notNull, $default, null); }
protected static function resolvePolymorphicTypeColumnByLinkName($linkName) { $linkName .= '_type'; return RedBeanModelMemberToColumnUtil::resolveColumnMetadataByHintType($linkName); }
protected function createImportTempTable($columnCount, $tableName) { $importColumns = array(); for ($i = 0; $i < $columnCount; $i++) { $columnName = 'column_' . $i; $importColumns[] = RedBeanModelMemberToColumnUtil::resolveColumnMetadataByHintType($columnName, 'string', 50); } ImportDatabaseUtil::createTableByTableNameAndImportColumns($tableName, $importColumns); }
protected static function getReservedColumnMetadata() { $columns = array(); $reservedColumnsTypes = array('status' => 'integer', 'serializedMessages' => 'string', 'analysisStatus' => 'integer', 'serializedAnalysisMessages' => 'string'); foreach ($reservedColumnsTypes as $columnName => $type) { $length = null; $unsigned = null; if ($type === 'string') { // populate the proper type given it would be 1024 char string depending on db type. RedBeanModelMemberRulesToColumnAdapter::resolveStringTypeAndLengthByMaxLength($type, $length, 1024); } else { // forcing integers to be unsigned $unsigned = DatabaseCompatibilityUtil::resolveUnsignedByHintType($type, false); } // last argument is false because we do not want these column names to be resolved to lower characters $columns[] = RedBeanModelMemberToColumnUtil::resolveColumnMetadataByHintType($columnName, $type, $length, $unsigned, null, null, null, false); } return $columns; }
/** * @depends testResolveForeignKeyColumnMetadataWithRelatedModelClassName */ public function testResolveColumnMetadataByHintTypeWithStringWithoutId() { $unresolvedName = 'memberNameGoesHere'; $columnDefinition = RedBeanModelMemberToColumnUtil::resolveColumnMetadataByHintType($unresolvedName); $this->assertNotEmpty($columnDefinition); $this->assertCount(6, $columnDefinition); $this->assertArrayHasKey('name', $columnDefinition); $this->assertEquals('membernamegoeshere', $columnDefinition['name']); $this->assertArrayHasKey('type', $columnDefinition); $this->assertEquals('VARCHAR(255)', $columnDefinition['type']); $this->assertArrayHasKey('unsigned', $columnDefinition); $this->assertNull($columnDefinition['unsigned']); $this->assertArrayHasKey('notNull', $columnDefinition); $this->assertEquals('NULL', $columnDefinition['notNull']); // Not Coding Standard $this->assertArrayHasKey('collation', $columnDefinition); $this->assertEquals('COLLATE utf8_unicode_ci', $columnDefinition['collation']); $this->assertArrayHasKey('default', $columnDefinition); $this->assertEquals('DEFAULT NULL', $columnDefinition['default']); // Not Coding Standard $this->assertArrayNotHasKey('length', $columnDefinition); }