public function getGetterName()
{
return "get" . SbUtils::wordUnderscoreToCamelCase($this->name);
}
public function getScheme($options = array())
{
$connection = $this->getConnection();
$ignoreTables = array();
if (array_key_exists('ignore', $options) && is_array($options['ignore'])) {
$ignoreTables = $options['ignore'];
}
$tables = array();
$tablesList = $connection->listTables();
foreach ($tablesList as $table) {
if (in_array($table, $ignoreTables)) {
continue;
}
$columns = array();
$primary = array();
$columnsList = $connection->describeColumns($table);
foreach ($columnsList as $column) {
$columns[] = $column->getName();
if ($column->isPrimary()) {
$primary[] = $column->getName();
}
}
$tables[$table] = array('name' => $table, 'model' => SbUtils::wordUnderscoreToCamelCase($table), 'columns' => $columns, 'primary' => $primary);
}
foreach ($tables as $table => &$tableFields) {
$refs = $connection->describeReferences($table);
$indexes = $connection->describeIndexes($table);
foreach ($indexes as $index) {
$tableFields['indexes'][] = [$index->getName(), $index->getColumns(), $index->getType()];
}
foreach ($refs as $ref) {
$referencedTable = $ref->getReferencedTable();
$columns = $ref->getColumns();
$referencedColumns = $ref->getReferencedColumns();
$firstReferencedColumn = reset($referencedColumns);
$firstColumn = reset($columns);
if (in_array($firstColumn, $tableFields['primary']) && in_array($firstReferencedColumn, $tables[$referencedTable]['primary'])) {
$tableFields['ref_one_to_one'][] = array('column' => $firstColumn, 'model' => $tables[$referencedTable]['model'], 'ref_column' => $firstReferencedColumn);
$tables[$referencedTable]['ref_one_to_one'][] = array('column' => $firstReferencedColumn, 'model' => $tableFields['model'], 'ref_column' => $firstColumn);
} else {
$tableFields['ref_many_to_one'][] = array('column' => $firstColumn, 'model' => $tables[$referencedTable]['model'], 'ref_column' => $firstReferencedColumn);
$tables[$referencedTable]['ref_one_to_many'][] = array('column' => $firstReferencedColumn, 'model' => $tableFields['model'], 'ref_column' => $firstColumn);
}
}
}
$modelIdx = [];
foreach ($tables as $tableName => $table) {
$modelIdx[$table['model']] = $tableName;
}
foreach ($tables as $tableName => $table) {
if (isset($table['ref_one_to_many'])) {
foreach ($table['ref_one_to_many'] as $oneToManyRef) {
$joinModel = $oneToManyRef['model'];
$joinTable = $tables[$modelIdx[$joinModel]];
if (isset($joinTable['ref_many_to_one'])) {
foreach ($joinTable['ref_many_to_one'] as $manyToOneRef) {
$secondJoinModel = $manyToOneRef['model'];
if ($table['model'] != $secondJoinModel) {
if (!array_key_exists('ref_many_to_many', $tables[$tableName])) {
$tables[$tableName]['ref_many_to_many'] = [];
}
$tables[$tableName]['ref_many_to_many'][] = ['intermediate_column' => $oneToManyRef['column'], 'intermediate_model' => $oneToManyRef['model'], 'intermediate_ref_column' => $oneToManyRef['ref_column'], 'column' => $manyToOneRef['column'], 'model' => $manyToOneRef['model'], 'ref_column' => $manyToOneRef['ref_column']];
}
}
}
}
}
}
return $tables;
}
