protected function quoteTestCommon($format, $additional_invalid = array()) { dbsteward::set_sql_format($format); dbsteward::$quote_all_names = FALSE; dbsteward::$quote_illegal_identifiers = FALSE; $invalid_prefixes = array_merge(array('in$', '0in'), $additional_invalid); foreach (array('schema', 'table', 'column', 'object', 'function') as $object) { foreach (array(TRUE, FALSE) as $quoted) { dbsteward::${"quote_{$object}_names"} = $quoted; // attempt valid identifiers $valid_name = "valid_{$format}_{$object}_" . ($quoted ? 'quoted' : 'unquoted') . "_identifier123"; $expected = $quoted ? $format::QUOTE_CHAR . $valid_name . $format::QUOTE_CHAR : $valid_name; $this->assertEquals($expected, call_user_func("{$format}::get_quoted_{$object}_name", $valid_name), "During call to {$format}::get_quoted_{$object}_name"); // attempt invalid identifiers - expect exceptions $invalid_names = array_map(function ($prefix) use($valid_name) { return $prefix . $valid_name; }, $invalid_prefixes); $invalid_names[] = $format::QUOTE_CHAR . $valid_name . $format::QUOTE_CHAR; foreach ($invalid_names as $invalid_name) { if ($quoted) { // only expect an exception if not quoted... } else { try { call_user_func("{$format}::get_quoted_{$object}_name", $invalid_name); } catch (Exception $ex) { $this->assertContains('Illegal identifier', $ex->getMessage()); continue; } $this->fail("Expected 'Illegal identifier' exception, but no exception was thrown for identifier '{$invalid_name}'"); } } } } }
public function setUp() { dbsteward::set_sql_format('mysql5'); dbsteward::$quote_all_names = true; mysql5::$swap_function_delimiters = TRUE; mysql5::$use_auto_increment_table_options = FALSE; mysql5::$use_schema_name_prefix = FALSE; }
public function setUp() { dbsteward::$quote_all_names = FALSE; dbsteward::$quote_schema_names = FALSE; dbsteward::$quote_table_names = FALSE; dbsteward::$quote_column_names = FALSE; dbsteward::$quote_function_names = FALSE; dbsteward::$quote_object_names = FALSE; dbsteward::$quote_illegal_identifiers = FALSE; dbsteward::$quote_reserved_identifiers = FALSE; }
/** * Tests that functions referenced as default values for columns * 1) do not result in build failures * 2) generate sane SQL on build */ public function testBuildColumnSQL() { $xml = <<<XML <dbsteward> <database> <role> <application>dbsteward_phpunit_app</application> <owner>deployment</owner> <replication/> <readonly/> </role> </database> <schema name="dbsteward" owner="ROLE_OWNER"> <function name="test" returns="integer" owner="ROLE_OWNER" cachePolicy="VOLATILE" description="always returns 5, is a test function"> <functionDefinition language="plpgsql" sqlFormat="pgsql8"> BEGIN RETURN 5; END </functionDefinition> </function> </schema> <schema name="hotel" owner="ROLE_OWNER"> <table name="rate" owner="ROLE_OWNER" primaryKey="rate_id" primaryKeyName="rate_pkey"> <tableOption sqlFormat="pgsql8" name="with" value="(oids=false)"/> <column name="rate_id" type="integer" null="false"/> <column name="rate_group_id" null="false" foreignSchema="hotel" foreignTable="rate_group" foreignColumn="rate_group_id" foreignKeyName="rate_rate_group_id_fkey" foreignOnUpdate="NO_ACTION" foreignOnDelete="NO_ACTION"/> <column name="rate_name" type="character varying(120)"/> <column name="rate_value" type="numeric"/> </table> <table name="rate_group" owner="ROLE_OWNER" primaryKey="rate_group_id" primaryKeyName="rate_group_pkey"> <tableOption sqlFormat="pgsql8" name="with" value="(oids=false)"/> <column name="rate_group_id" type="integer" null="false" default="dbsteward.test()"/> <column name="rate_group_name" type="character varying(100)"/> <column name="rate_group_enabled" type="boolean" null="false" default="true"/> </table> </schema> </dbsteward> XML; $expected = <<<EXP ALTER TABLE "hotel"."rate" ALTER COLUMN "rate_id" SET NOT NULL; ALTER TABLE "hotel"."rate" ALTER COLUMN "rate_group_id" SET NOT NULL; ALTER TABLE "hotel"."rate_group" ALTER COLUMN "rate_group_id" SET DEFAULT dbsteward.test(); ALTER TABLE "hotel"."rate_group" ALTER COLUMN "rate_group_id" SET NOT NULL; ALTER TABLE "hotel"."rate_group" ALTER COLUMN "rate_group_enabled" SET DEFAULT true; ALTER TABLE "hotel"."rate_group" ALTER COLUMN "rate_group_enabled" SET NOT NULL; EXP; dbsteward::$quote_all_names = TRUE; $this->set_xml_content_a($xml); $this->build_db('pgsql8'); $actual = file_get_contents(dirname(__FILE__) . '/../testdata/unit_test_xml_a_build.sql'); $this->assertContains($expected, $actual); }
public function setUp() { dbsteward::set_sql_format('mysql5'); dbsteward::$quote_all_names = TRUE; dbsteward::$quote_schema_names = TRUE; dbsteward::$quote_table_names = TRUE; dbsteward::$quote_column_names = TRUE; dbsteward::$quote_function_names = TRUE; dbsteward::$quote_object_names = TRUE; dbsteward::$ignore_oldnames = FALSE; mysql5::$use_auto_increment_table_options = FALSE; mysql5::$use_schema_name_prefix = FALSE; }
/** * @group pgsql8 */ public function testTableColumnTypeQuotingPgsql8() { dbsteward::set_sql_format('pgsql8'); dbsteward::$quote_all_names = TRUE; dbsteward::$single_stage_upgrade = TRUE; $doc_empty = simplexml_load_string($this->xml_empty); $doc_empty = xml_parser::composite_doc(FALSE, $doc_empty); dbsteward::$old_database = $doc_empty; $doc = simplexml_load_string($this->xml); $doc = xml_parser::composite_doc(FALSE, $doc); dbsteward::$new_database = $doc; $table_dependency = xml_parser::table_dependency_order($doc); //var_dump(xml_parser::format_xml($doc_empty->saveXML())); //var_dump(xml_parser::format_xml($doc->saveXML())); $schema = $doc->schema; $table = $schema->table; // make sure the type is named with quoting as part of a definition build $expected = "CREATE TYPE \"schema1\".\"enumCamelCaseType\" AS ENUM ('Read','Write','Delete');"; $mofs = new mock_output_file_segmenter(); pgsql8::build_schema($doc, $mofs, $table_dependency); $actual = trim($mofs->_get_output()); $this->assertContains($expected, $actual); // make sure the type is referred to with quoting in a table creation as part of a definition build $expected_column = '"table_shable_mode" "enumCamelCaseType"'; $this->assertContains($expected_column, $actual); // make sure the type is referred to with quoting when generating table create statements $expected = '"table_shable_mode" "enumCamelCaseType"'; $sql = pgsql8_table::get_creation_sql($schema, $table); $this->assertContains($expected, $sql); // make sure create table quotes the type name $expected = '"table_shable_mode" "enumCamelCaseType"'; $mofs = new mock_output_file_segmenter(); var_dump(dbx::get_tables($schema)); pgsql8_diff_tables::diff_tables($mofs, $mofs, NULL, $schema); $actual = trim($mofs->_get_output()); $this->assertContains($expected, $actual); // make sure insert statements are made that match the XML definition $expected = "INSERT INTO \"schema1\".\"table_shable\" (\"table_shable_id\", \"table_shable_value\", \"table_shable_mode\") VALUES (1, E'shim sham', BETA);"; $actual = trim(pgsql8_diff_tables::get_data_sql(NULL, NULL, $schema, $table, FALSE)); $this->assertContains($expected, $actual); }
public function testColumnCaseChange() { $lower = <<<XML <schema name="test0" owner="NOBODY"> <table name="table" owner="NOBODY"> <column name="column" type="int" /> </table> </schema> XML; $upper_with_oldname = <<<XML <schema name="test0" owner="NOBODY"> <table name="table" owner="NOBODY"> <column name="CoLuMn" type="int" oldColumnName="column" /> </table> </schema> XML; $upper_without_oldname = <<<XML <schema name="test0" owner="NOBODY"> <table name="table" owner="NOBODY"> <column name="CoLuMn" type="int" /> </table> </schema> XML; // when quoting is off, a change in case is a no-op dbsteward::$quote_all_names = FALSE; dbsteward::$quote_column_names = FALSE; $this->common_diff($lower, $upper_without_oldname, '', ''); // when quoting is on, a change in case results in a rename dbsteward::$quote_all_names = TRUE; dbsteward::$quote_column_names = TRUE; $this->common_diff($lower, $upper_with_oldname, "-- column rename from oldColumnName specification\nALTER TABLE \"test0\".\"table\" RENAME COLUMN \"column\" TO \"CoLuMn\";", ''); // but, if oldColumnName is not given when doing case sensitive renames, it should throw try { $this->common_diff($lower, $upper_without_oldname, 'NO EXPECTED OUTPUT', 'NO EXPECTED OUTPUT'); } catch (Exception $e) { $this->assertContains('ambiguous operation', strtolower($e->getMessage())); return; } $this->fail("Expected an 'ambiguous operation' exception due to column case change, got nothing."); }
public function setUp() { dbsteward::set_sql_format('pgsql8'); dbsteward::$quote_all_names = TRUE; }
public function setUp() { dbsteward::$quote_all_names = true; $this->doc_with = simplexml_load_string($this->xml_with); $this->doc_without = simplexml_load_string($this->xml_without); }
public function arg_parse($argv) { $short_opts = 'hvq'; $long_opts = array("sqlformat::", "xml::", "oldxml::", "newxml::", "pgdataxml::", "xmldatainsert::", "outputfile::", "dbschemadump::", "slonikconvert::", "slonycompare::", "slonydiffold::", "slonydiffnew::", "slonyidin::", "slonyidout::", "slonyidstartvalue::", "slonyidsetvalue::", "oldsql::", "newsql::", "dbhost::", "dbport::", "dbname::", "dbuser::", "dbpassword::", "requireslonyid::", "requireslonysetid::", "generateslonik::", "quoteschemanames::", "quotetablenames::", "quotecolumnnames::", "quoteallnames::", "quoteillegalnames::", "quotereservednames::", "onlyschemasql::", "onlydatasql::", "onlytable::", "singlestageupgrade::", "maxstatementsperfile::", "ignoreoldnames::", "ignorecustomroles::", "ignoreprimarykeyerrors::", "dbdatadiff::", "xmlsort::", "xmlconvert::", "xmlcollectdataaddendums::", "useautoincrementoptions::", "useschemaprefix::", "outputdir::", "outputfileprefix::", "debug"); $options = getopt($short_opts, $long_opts); self::set_verbosity($options); if (count($argv) == 1 || isset($options['help']) || isset($options['h'])) { $c = new Colors\Color(); $c->setTheme(array('header' => array('underline', 'dark_gray'), 'keyword' => array('green'), 'value' => array('yellow'))); echo $c->colorize(self::usage()) . PHP_EOL; exit(1); } $files = array('old' => array(), 'new' => array(), 'pgdata' => array()); ///// XML file parameter sanity checks if (isset($options['xml'])) { if (count($options['xml']) > 0 && isset($options['oldxml']) && count($options['oldxml']) > 0) { dbsteward::error("Parameter error: xml and oldxml options are not to be mixed. Did you mean newxml?"); exit(1); } if (count($options['xml']) > 0 && isset($options['newxml']) && count($options['newxml']) > 0) { dbsteward::error("Parameter error: xml and newxml options are not to be mixed. Did you mean oldxml?"); exit(1); } } if (isset($options['oldxml']) && count($options['oldxml']) > 0 && (!isset($options['newxml']) || count($options['newxml']) == 0)) { dbsteward::error("Parameter error: oldxml needs newxml specified for differencing to occur"); exit(1); } if ((!isset($options['oldxml']) || count($options['oldxml']) == 0) && (isset($options['newxml']) && count($options['newxml']) > 0)) { dbsteward::error("Parameter error: oldxml needs newxml specified for differencing to occur"); exit(1); } ///// database connectivity values $dbhost = FALSE; if (isset($options["dbhost"]) && strlen($options["dbhost"]) > 0) { $dbhost = $options["dbhost"]; } // $dbport set in sql_format defaults section $dbport = NULL; if (isset($options["dbport"]) && strlen($options["dbport"]) > 0) { $dbport = $options["dbport"]; } $dbname = FALSE; if (isset($options["dbname"]) && strlen($options["dbname"]) > 0) { $dbname = $options["dbname"]; } $dbuser = FALSE; if (isset($options["dbuser"]) && strlen($options["dbuser"]) > 0) { $dbuser = $options["dbuser"]; } if (isset($options['dbpassword'])) { if ($options['dbpassword'] === false) { // treat --dbpassword as the empty password, because // --dbpassword='' doesn't show up in $options $this->cli_dbpassword = ''; } else { $this->cli_dbpassword = $options['dbpassword']; } } ///// SQL DDL DML DCL output flags if (isset($options["onlyschemasql"])) { dbsteward::$only_schema_sql = TRUE; } if (isset($options["onlydatasql"])) { dbsteward::$only_data_sql = TRUE; } if (isset($options['onlytable'])) { $onlytables = $options['onlytable']; if (!is_array($onlytables)) { $onlytables = array($onlytables); } foreach ($onlytables as $onlytable) { $onlytable_schema = 'public'; $onlytable_table = $onlytable; if (strpos($onlytable_table, '.') !== FALSE) { $chunks = explode('.', $onlytable_table); $onlytable_schema = $chunks[0]; $onlytable_table = $chunks[1]; } if (!isset(dbsteward::$limit_to_tables[$onlytable_schema])) { dbsteward::$limit_to_tables[$onlytable_schema] = array(); } dbsteward::$limit_to_tables[$onlytable_schema][] = $onlytable_table; } } ///// common parameter for output file for converter functions // for modes that can do it, omitting this parameter will cause output to be directed to stdout $output_file = FALSE; if (isset($options["outputfile"]) && strlen($options["outputfile"]) > 0) { $output_file = $options["outputfile"]; } if (isset($options["maxstatementsperfile"])) { if (!is_numeric($options["maxstatementsperfile"])) { throw new exception("maxstatementsperfile passed is not a number"); } dbsteward::$output_file_statement_limit = $options["maxstatementsperfile"]; } ///// XML parsing switches if (isset($options["singlestageupgrade"])) { dbsteward::$single_stage_upgrade = TRUE; // don't recreate views when in single stage upgrade mode // @TODO: make view diffing smart enough that this doesn't need to be done dbsteward::$always_recreate_views = FALSE; } if (isset($options["ignoreoldnames"])) { dbsteward::$ignore_oldnames = TRUE; } if (isset($options["ignorecustomroles"])) { dbsteward::$ignore_custom_roles = TRUE; } if (isset($options["ignoreprimarykeyerrors"])) { dbsteward::$ignore_primary_key_errors = TRUE; } if (isset($options["requireslonyid"])) { dbsteward::$require_slony_id = TRUE; } if (isset($options["requireslonysetid"])) { dbsteward::$require_slony_set_id = TRUE; } if (isset($options["generateslonik"])) { dbsteward::$generate_slonik = TRUE; } if (isset($options["slonyidstartvalue"])) { if ($options["slonyidstartvalue"] < 1) { throw new exception("slonyidstartvalue must be greater than 0"); } dbsteward::$slonyid_start_value = $options["slonyidstartvalue"]; } if (isset($options["slonyidsetvalue"])) { if ($options["slonyidsetvalue"] < 1) { throw new exception("slonyidsetvalue must be greater than 0"); } dbsteward::$slonyid_set_value = $options["slonyidsetvalue"]; } ///// determine the operation and check arguments for each $mode = dbsteward::MODE_UNKNOWN; if (isset($options['xmldatainsert'])) { if (!isset($options['xml'])) { throw new exception("xmldatainsert needs xml parameter defined"); } $mode = dbsteward::MODE_XML_DATA_INSERT; } elseif (isset($options["xmlsort"])) { $mode = dbsteward::MODE_XML_SORT; } elseif (isset($options["xmlconvert"])) { $mode = dbsteward::MODE_XML_CONVERT; } elseif (isset($options['xml']) && count($options['xml']) > 0) { $mode = dbsteward::MODE_BUILD; } elseif (isset($options['newxml']) && count($options['newxml']) > 0) { $mode = dbsteward::MODE_DIFF; } elseif (isset($options["dbschemadump"])) { if (strlen($dbhost) === FALSE) { throw new exception("dbschemadump error: dbhost not specified"); } elseif (strlen($dbname) === FALSE) { throw new exception("dbschemadump error: dbname not specified"); } elseif (strlen($dbuser) === FALSE) { throw new exception("dbschemadump error: dbuser not specified"); } elseif ($output_file === FALSE) { throw new exception("dbschemadump error: outputfile not specified"); } $mode = dbsteward::MODE_EXTRACT; } elseif (isset($options['dbdatadiff'])) { if (strlen($dbhost) === FALSE) { throw new exception("dbdatadiff error: dbhost not specified"); } elseif (strlen($dbname) === FALSE) { throw new exception("dbdatadiff error: dbname not specified"); } elseif (strlen($dbuser) === FALSE) { throw new exception("dbdatadiff error: dbuser not specified"); } $mode = dbsteward::MODE_DB_DATA_DIFF; } elseif (isset($options["oldsql"]) || isset($options["newsql"])) { if ($output_file === FALSE) { throw new exception("sql diff error: you must specify an outputfile for this mode"); } $mode = dbsteward::MODE_SQL_DIFF; } elseif (isset($options["slonikconvert"])) { $mode = dbsteward::MODE_SLONIK_CONVERT; } elseif (isset($options["slonycompare"])) { $mode = dbsteward::MODE_SLONY_COMPARE; } elseif (isset($options["slonydiffold"])) { $mode = dbsteward::MODE_SLONY_DIFF; } elseif (isset($options["slonyidin"])) { // check to make sure output is not same as input if (isset($options["slonyidout"])) { if (strcmp($options["slonyidin"], $options["slonyidout"]) == 0) { throw new exception("slonyidin and slonyidout file paths should not be the same"); } } $mode = dbsteward::MODE_XML_SLONY_ID; } ///// File output location specificity if (isset($options['outputdir'])) { if (strlen($options['outputdir']) == 0) { throw new exception("outputdir is blank, must specify a value for this option"); } if (!is_dir($options['outputdir'])) { throw new exception("outputdir is not a directory; this must be a writable directory"); } dbsteward::$file_output_directory = $options['outputdir']; } if (isset($options['outputfileprefix'])) { if (strlen($options['outputfileprefix']) == 0) { throw new exception("outputfileprefix is blank, must specify a value for this option"); } dbsteward::$file_output_prefix = $options['outputfileprefix']; } ///// For the appropriate modes, composite the input XML ///// and figure out the SQL format of it $force_sql_format = FALSE; if (isset($options['sqlformat'])) { $force_sql_format = $options['sqlformat']; } $target_sql_format = FALSE; switch ($mode) { case dbsteward::MODE_BUILD: $files = (array) $options['xml']; $target_sql_format = xml_parser::get_sql_format($files); break; case dbsteward::MODE_DIFF: $old_files = (array) $options['oldxml']; $new_files = (array) $options['newxml']; $old_target = xml_parser::get_sql_format($old_files); $new_target = xml_parser::get_sql_format($new_files); // prefer the new sql_format $target_sql_format = $new_target ?: $old_target; break; } $xml_collect_data_addendums = 0; if (isset($options["xmlcollectdataaddendums"]) && $options["xmlcollectdataaddendums"] > 0) { $xml_collect_data_addendums = (int) $options["xmlcollectdataaddendums"]; if ($mode != dbsteward::MODE_BUILD) { throw new Exception("--xmlcollectdataaddendums is only supported for fresh builds"); } if ($xml_collect_data_addendums > count($files)) { throw new Exception("Cannot collect more data addendums then files provided"); } } // announce our defined version before doing any configuration announcements or tasks dbsteward::notice("DBSteward Version " . self::VERSION); ///// set the global SQL format $sql_format = dbsteward::reconcile_sql_format($target_sql_format, $force_sql_format); dbsteward::notice("Using sqlformat={$sql_format}"); dbsteward::set_sql_format($sql_format); if (is_null($dbport)) { $dbport = dbsteward::define_sql_format_default_values($sql_format, $options); } // user-specified overrides for identifier quoting if (isset($options["quoteschemanames"])) { dbsteward::$quote_schema_names = TRUE; } if (isset($options["quotetablenames"])) { dbsteward::$quote_table_names = TRUE; } if (isset($options["quotecolumnnames"])) { dbsteward::$quote_column_names = TRUE; } if (isset($options["quoteallnames"])) { dbsteward::$quote_all_names = TRUE; } if (isset($options["quoteillegalnames"])) { dbsteward::$quote_illegal_identifiers = TRUE; } if (isset($options["quotereservednames"])) { dbsteward::$quote_reserved_identifiers = TRUE; } switch ($mode) { case dbsteward::MODE_XML_DATA_INSERT: dbsteward::xml_data_insert($options['xml'], $options['xmldatainsert']); break; case dbsteward::MODE_XML_SORT: dbsteward::xml_sort($options['xmlsort']); break; case dbsteward::MODE_XML_CONVERT: dbsteward::xml_convert($options['xmlconvert']); break; case dbsteward::MODE_XML_SLONY_ID: dbsteward::info("Compositing XML file for Slony ID processing.."); $files = (array) $options['slonyidin']; $db_doc = xml_parser::xml_composite($files); dbsteward::info("XML files " . implode(' ', $files) . " composited"); $output_prefix = dbsteward::calculate_file_output_prefix($files); $composite_file = $output_prefix . '_composite.xml'; $db_doc = xml_parser::sql_format_convert($db_doc); xml_parser::vendor_parse($db_doc); dbsteward::notice("Saving composite as " . $composite_file); xml_parser::save_doc($composite_file, $db_doc); dbsteward::notice("Slony ID numbering any missing attributes"); dbsteward::info("slonyidstartvalue = " . dbsteward::$slonyid_start_value); dbsteward::info("slonyidsetvalue = " . dbsteward::$slonyid_set_value); $slonyid_doc = xml_parser::slonyid_number($db_doc); $slonyid_numbered_file = $output_prefix . '_slonyid_numbered.xml'; // if specified, use output file value instead of auto suffix if (isset($options["slonyidout"])) { $slonyid_numbered_file = $options["slonyidout"]; } dbsteward::notice("Saving Slony ID numbered XML as " . $slonyid_numbered_file); xml_parser::save_doc($slonyid_numbered_file, $slonyid_doc); break; case dbsteward::MODE_BUILD: dbsteward::info("Compositing XML files.."); $addendums_doc = NULL; if ($xml_collect_data_addendums > 0) { dbsteward::info("Collecting {$xml_collect_data_addendums} data addendums"); } $db_doc = xml_parser::xml_composite($files, $xml_collect_data_addendums, $addendums_doc); if (isset($options['pgdataxml']) && count($options['pgdataxml'])) { $pg_data_files = (array) $options['pgdataxml']; dbsteward::info("Compositing pgdata XML files on top of XML composite.."); xml_parser::xml_composite_pgdata($db_doc, $pg_data_files); dbsteward::info("postgres data XML files [" . implode(' ', $pg_data_files) . "] composited."); } dbsteward::info("XML files " . implode(' ', $files) . " composited"); $output_prefix = dbsteward::calculate_file_output_prefix($files); $composite_file = $output_prefix . '_composite.xml'; $db_doc = xml_parser::sql_format_convert($db_doc); xml_parser::vendor_parse($db_doc); dbsteward::notice("Saving composite as " . $composite_file); xml_parser::save_doc($composite_file, $db_doc); if ($addendums_doc !== NULL) { $addendums_file = $output_prefix . '_addendums.xml'; dbsteward::notice("Saving addendums as {$addendums_file}"); xml_parser::save_doc($addendums_file, $addendums_doc); } format::build($output_prefix, $db_doc); break; case dbsteward::MODE_DIFF: dbsteward::info("Compositing old XML files.."); $old_db_doc = xml_parser::xml_composite($old_files); dbsteward::info("Old XML files " . implode(' ', $old_files) . " composited"); dbsteward::info("Compositing new XML files.."); $new_db_doc = xml_parser::xml_composite($new_files); if (isset($options['pgdataxml']) && count($options['pgdataxml'])) { $pg_data_files = (array) $options['pgdataxml']; dbsteward::info("Compositing pgdata XML files on top of new XML composite.."); xml_parser::xml_composite_pgdata($new_db_doc, $pg_data_files); dbsteward::info("postgres data XML files [" . implode(' ', $pg_data_files) . "] composited"); } dbsteward::info("New XML files " . implode(' ', $new_files) . " composited"); $old_output_prefix = dbsteward::calculate_file_output_prefix($old_files); $old_composite_file = $old_output_prefix . '_composite.xml'; $old_db_doc = xml_parser::sql_format_convert($old_db_doc); xml_parser::vendor_parse($old_db_doc); dbsteward::notice("Saving oldxml composite as " . $old_composite_file); xml_parser::save_doc($old_composite_file, $old_db_doc); $new_output_prefix = dbsteward::calculate_file_output_prefix($new_files); $new_composite_file = $new_output_prefix . '_composite.xml'; $new_db_doc = xml_parser::sql_format_convert($new_db_doc); xml_parser::vendor_parse($new_db_doc); dbsteward::notice("Saving newxml composite as " . $new_composite_file); xml_parser::save_doc($new_composite_file, $new_db_doc); format::build_upgrade($old_output_prefix, $old_composite_file, $old_db_doc, $old_files, $new_output_prefix, $new_composite_file, $new_db_doc, $new_files); break; case dbsteward::MODE_EXTRACT: $output = format::extract_schema($dbhost, $dbport, $dbname, $dbuser, $this->cli_dbpassword); dbsteward::notice("Saving extracted database schema to " . $output_file); if (!file_put_contents($output_file, $output)) { throw new exception("Failed to save extracted database schema to " . $output_file); } break; case dbsteward::MODE_DB_DATA_DIFF: // dbdatadiff files are defined with --dbdatadiff not --xml $dbdatadiff_files = (array) $options['dbdatadiff']; dbsteward::info("Compositing XML files.."); $addendums_doc = NULL; if ($xml_collect_data_addendums > 0) { dbsteward::info("Collecting {$xml_collect_data_addendums} data addendums"); } $db_doc = xml_parser::xml_composite($dbdatadiff_files, $xml_collect_data_addendums, $addendums_doc); if (isset($options['pgdataxml']) && count($options['pgdataxml'])) { $pg_data_files = (array) $options['pgdataxml']; dbsteward::info("Compositing pgdata XML files on top of XML composite.."); xml_parser::xml_composite_pgdata($db_doc, $pg_data_files); dbsteward::info("postgres data XML files [" . implode(' ', $pg_data_files) . "] composited."); } dbsteward::info("XML files " . implode(' ', $dbdatadiff_files) . " composited"); $output_prefix = dbsteward::calculate_file_output_prefix($dbdatadiff_files); $composite_file = $output_prefix . '_composite.xml'; $db_doc = xml_parser::sql_format_convert($db_doc); xml_parser::vendor_parse($db_doc); dbsteward::notice("Saving composite as " . $composite_file); xml_parser::save_doc($composite_file, $db_doc); $output = format::compare_db_data($db_doc, $dbhost, $dbport, $dbname, $dbuser, $this->cli_dbpassword); if (!file_put_contents($output_file, $output)) { throw new exception("Failed to save extracted database schema to " . $output_file); } break; case dbsteward::MODE_SQL_DIFF: format::sql_diff($options["oldsql"], $options["newsql"], $output_file); break; case dbsteward::MODE_SLONIK_CONVERT: $output = slony1_slonik::convert($options["slonikconvert"]); if ($output_file !== FALSE) { dbsteward::notice("Saving slonikconvert output to " . $output_file); if (!file_put_contents($output, $output_file)) { throw new exception("Failed to save slonikconvert output to " . $output_file); } } else { echo $output; } break; case dbsteward::MODE_SLONY_COMPARE: pgsql8::slony_compare($options["slonycompare"]); break; case dbsteward::MODE_SLONY_DIFF: pgsql8::slony_diff($options["slonydiffold"], $options["slonydiffnew"]); break; case dbsteward::MODE_UNKNOWN: default: throw new Exception("No operation specified!"); } }
public function setUp() { dbsteward::$quote_all_names = true; }
/** * */ public function tearDown() { dbsteward::$quote_all_names = static::$last_quote_all_names; parent::tearDown(); }
public function testCompositeForeignKeyReferentialConstraints() { dbsteward::$quote_all_names = false; dbsteward::$quote_schema_names = false; dbsteward::$quote_table_names = false; dbsteward::$quote_column_names = false; dbsteward::$quote_function_names = false; dbsteward::$quote_object_names = false; $sql = <<<SQL CREATE TABLE dummy (foo int, bar varchar(32), PRIMARY KEY (foo, bar)); CREATE TABLE test ( id int PRIMARY KEY, foo int, bar varchar(32), FOREIGN KEY (foo, bar) REFERENCES dummy (foo, bar) ON UPDATE NO ACTION ON DELETE SET NULL ); SQL; $schemaname = __CLASS__; $expected = <<<XML <foreignKey columns="foo, bar" foreignSchema="{$schemaname}" foreignTable="dummy" foreignColumns="foo, bar" constraintName="test_foo_fkey" onUpdate="NO_ACTION" onDelete="SET_NULL"/> XML; $schema = $this->extract($sql); foreach ($schema->table as $table) { if ((string) $table['name'] == 'test') { $this->assertEquals(simplexml_load_string($expected), $table->foreignKey); return; } } }
protected function apply_options_mysql5() { dbsteward::set_sql_format('mysql5'); dbsteward::$quote_schema_names = TRUE; dbsteward::$quote_table_names = TRUE; dbsteward::$quote_column_names = TRUE; dbsteward::$quote_all_names = TRUE; mysql5::$swap_function_delimiters = TRUE; mysql5::$use_auto_increment_table_options = FALSE; mysql5::$use_schema_name_prefix = FALSE; }
public function testExceptionIsThrownWithDupes() { dbsteward::set_sql_format('pgsql8'); dbsteward::$quote_all_names = TRUE; dbsteward::$single_stage_upgrade = TRUE; $doc_empty = simplexml_load_string($this->xml_empty); $doc_empty = xml_parser::composite_doc(FALSE, $doc_empty); dbsteward::$old_database = $doc_empty; $doc = simplexml_load_string($this->xml); $doc = xml_parser::composite_doc(FALSE, $doc); dbsteward::$new_database = $doc; $table_dependency = xml_parser::table_dependency_order($doc); $schema = $doc->schema; $table = $schema->table; // make sure the type is named with quoting as part of a definition build $mofs = new mock_output_file_segmenter(); try { pgsql8::build_schema($doc, $mofs, $table_dependency); } catch (Exception $e) { $this->assertContains('duplicate index name', strtolower($e->getMessage())); return; } $this->fail("build_schema did not detect duplicate index names"); }