protected static function define_sql_format_default_values($sql_format, $options)
{
///// sql_format-specific default options
$dbport = FALSE;
if (strcasecmp($sql_format, 'pgsql8') == 0) {
dbsteward::$create_languages = TRUE;
dbsteward::$quote_schema_names = FALSE;
dbsteward::$quote_table_names = FALSE;
dbsteward::$quote_column_names = FALSE;
$dbport = '5432';
} else {
if (strcasecmp($sql_format, 'mssql10') == 0) {
// needed for MSSQL keyword-named-columns like system_user
dbsteward::$quote_table_names = TRUE;
dbsteward::$quote_column_names = TRUE;
$dbport = '1433';
} else {
if (strcasecmp($sql_format, 'mysql5') == 0) {
dbsteward::$quote_schema_names = TRUE;
dbsteward::$quote_table_names = TRUE;
dbsteward::$quote_column_names = TRUE;
$dbport = '3306';
if (isset($options['useautoincrementoptions'])) {
mysql5::$use_auto_increment_table_options = TRUE;
}
if (isset($options['useschemaprefix'])) {
mysql5::$use_schema_name_prefix = TRUE;
}
}
}
}
if (strcasecmp($sql_format, 'pgsql8') != 0) {
if (isset($options['pgdataxml'])) {
dbsteward::error("pgdataxml parameter is not supported by " . dbsteward::get_sql_format() . " driver");
exit(1);
}
}
return $dbport;
}
protected function apply_options_pgsql8()
{
dbsteward::set_sql_format('pgsql8');
dbsteward::$quote_all_names = TRUE;
dbsteward::$create_languages = TRUE;
dbsteward::$quote_table_names = TRUE;
dbsteward::$quote_column_names = TRUE;
dbsteward::$quote_object_names = TRUE;
dbsteward::$always_recreate_views = TRUE;
// slony default options
dbsteward::$require_slony_id = FALSE;
dbsteward::$require_slony_set_id = FALSE;
dbsteward::$generate_slonik = FALSE;
}
