/**
* @return string
*/
public function getReturnedClassName()
{
return Tools::capitalize(Tools::removeSFromTableName($this->returnType));
}
private function writeT_Models()
{
$save_dir = Generator::$relativeTModelSaveDir;
foreach ($this->tables as $table) {
$fileName = 't_' . Tools::removeSFromTableName($table->getName()) . '.php';
$file = fopen($save_dir . $fileName, "w");
fwrite($file, $this->T_ModelToString($table));
fclose($file);
}
}
/**
* WARNING ! Foreign denomination is inverted compared with constraints query result
*
* @param string $foreignTable
* @param string $foreignColumn
* @param string $foreignColumnClean
* @param string $tableName
* @param string $columnType
* @return string
*/
public function writeOneToManyProcedure($foreignTable, $foreignColumn, $foreignColumnClean, $tableName, $columnType)
{
$procedureName = strtolower('otm_' . $foreignTable . 'from' . Tools::removeSFromTableName($tableName) . '_' . $foreignColumnClean);
$pdo = PDOS::getInstance();
$pdo->exec("\n CREATE OR REPLACE function " . $procedureName . "(foreign_column " . $columnType . ")\n RETURNS SETOF " . $foreignTable . " AS\n 'SELECT * FROM " . $foreignTable . " WHERE " . $foreignColumn . " = \$1'\n LANGUAGE sql VOLATILE\n COST 100\n ROWS 1000;\n ALTER function " . $procedureName . "(" . $columnType . ")\n OWNER TO \"" . DBUSER . "\";");
return $procedureName;
}
