/**
  * @group mysql5
  */
 public function testFullBuildMysql5()
 {
     $this->apply_options_mysql5();
     $this->setup_mysql5();
     // build base full, check contents
     $base_db_doc = xml_parser::xml_composite(array($this->xml_file_a, $this->xml_file_a));
     mysql5::build($this->output_prefix, $base_db_doc);
     $text = file_get_contents($this->output_prefix . '_build.sql');
     // make sure NOT NULL is specified for action column
     $this->assertContains('`action` character varying(16) NOT NULL', $text);
     // make sure NOT NULL is NOT specified for description column
     $this->assertNotContains('`description` character varying(200) NOT NULL', $text);
     // build base + strict, check contents
     $strict_db_doc = xml_parser::xml_composite(array($this->xml_file_a, $this->xml_file_b));
     mysql5::build($this->output_prefix, $strict_db_doc);
     $text = file_get_contents($this->output_prefix . '_build.sql');
     // make sure NOT NULL is specified for action column
     $this->assertContains('`action` character varying(16) NOT NULL', $text);
     // make sure NOT NULL is specified for description column
     $this->assertContains('`description` character varying(200) NOT NULL', $text);
     // build base + strict + new table, check contents
     $addtable_db_doc = xml_parser::xml_composite(array($this->xml_file_a, $this->xml_file_b, $this->xml_file_c));
     mysql5::build($this->output_prefix, $addtable_db_doc);
     $text = file_get_contents($this->output_prefix . '_build.sql');
     // make sure NOT NULL is specified for resolution column
     $this->assertContains('`resolution` character varying(16) NOT NULL', $text);
     // make sure NOT NULL is NOT specified for points column
     $this->assertNotContains('`points` int NOT NULL', $text);
 }
 protected function build_db_mysql5()
 {
     $this->apply_options_mysql5();
     // build the DDL first, incase dbsteward code wants to throw about something
     mysql5::build($this->output_prefix, xml_parser::xml_composite(array($this->xml_file_a)));
     $this->mysql5->create_db();
     // build initial "A" database
     $this->mysql5->run_file($this->output_prefix . '_build.sql');
 }