/**
* Get the table for the current model.
*
* @return Table|null
*/
public static function getTable()
{
$class = implode('', array_slice(explode('\\', static::class), -1));
if (static::$tableName === null) {
static::$tableName = Str::pluralize(Str::snakeCase($class));
}
$alias = Str::pluralize(Str::snakeCase($class));
return Table::find(static::$tableName, $alias);
}
/**
* Get the field names for a given table.
*
* @param Table $table The table
*
* @return string[] An array of field names
*/
public function relationshipsForTable(Table $table)
{
$database = $this->instance->databaseName;
$relationships = [];
// Fetch all the to-one relationships
$result = $this->client->query("SELECT `constraint_name`, `column_name`, `referenced_table_name`, `referenced_column_name` FROM `information_schema`.`key_column_usage` WHERE `referenced_table_name` IS NOT NULL AND `table_schema`='{$database}' AND `table_name`='{$table->name}'");
if ($result !== false) {
// Loop through the relationships, and add each one to the array
while ($data = $result->fetch(PDO::FETCH_ASSOC)) {
$relationships[Str::singularize($data['referenced_table_name'])] = (object) ['column' => $data['column_name'], 'table' => $data['referenced_table_name'], 'references' => $data['referenced_column_name']];
}
}
// Fetch all the to-many relationships
$result = $this->client->query("SELECT `constraint_name`, `column_name`, `table_name`, `referenced_column_name` FROM `information_schema`.`key_column_usage` WHERE `table_name` IS NOT NULL AND `table_schema`='{$database}' AND `referenced_table_name`='{$table->name}'");
// If no results are returned, return an empty array
if ($result !== false) {
// Loop through the relationships, and add each one to the array
while ($data = $result->fetch(PDO::FETCH_ASSOC)) {
$relationships[Str::pluralize($data['table_name'])] = (object) ['column' => $data['referenced_column_name'], 'table' => $data['table_name'], 'references' => $data['column_name']];
}
}
return $relationships;
}
