/**
  * Sets the schema export PDF properties
  *
  * @return void
  */
 protected function setProperties()
 {
     $props = 'libraries/properties/';
     include_once "{$props}/plugins/SchemaPluginProperties.class.php";
     include_once "{$props}/options/groups/OptionsPropertyRootGroup.class.php";
     include_once "{$props}/options/groups/OptionsPropertyMainGroup.class.php";
     include_once "{$props}/options/items/BoolPropertyItem.class.php";
     include_once "{$props}/options/items/SelectPropertyItem.class.php";
     $schemaPluginProperties = new SchemaPluginProperties();
     $schemaPluginProperties->setText('PDF');
     $schemaPluginProperties->setExtension('pdf');
     $schemaPluginProperties->setMimeType('application/pdf');
     // create the root group that will be the options field for
     // $schemaPluginProperties
     // this will be shown as "Format specific options"
     $exportSpecificOptions = new OptionsPropertyRootGroup();
     $exportSpecificOptions->setName("Format Specific Options");
     // specific options main group
     $specificOptions = new OptionsPropertyMainGroup();
     $specificOptions->setName("general_opts");
     // add options common to all plugins
     $this->addCommonOptions($specificOptions);
     // create leaf items and add them to the group
     $leaf = new BoolPropertyItem();
     $leaf->setName('all_tables_same_width');
     $leaf->setText(__('Same width for all tables'));
     $specificOptions->addProperty($leaf);
     $leaf = new SelectPropertyItem();
     $leaf->setName("orientation");
     $leaf->setText(__('Orientation'));
     $leaf->setValues(array('L' => __('Landscape'), 'P' => __('Portrait')));
     $specificOptions->addProperty($leaf);
     $leaf = new SelectPropertyItem();
     $leaf->setName("paper");
     $leaf->setText(__('Paper size'));
     $leaf->setValues($this->_getPaperSizeArray());
     $specificOptions->addProperty($leaf);
     $leaf = new BoolPropertyItem();
     $leaf->setName('show_grid');
     $leaf->setText(__('Show grid'));
     $specificOptions->addProperty($leaf);
     $leaf = new BoolPropertyItem();
     $leaf->setName('with_doc');
     $leaf->setText(__('Data Dictionary'));
     $specificOptions->addProperty($leaf);
     $leaf = new SelectPropertyItem();
     $leaf->setName("table_order");
     $leaf->setText(__('Order of the tables'));
     $leaf->setValues(array('' => __('None'), 'name_asc' => __('Name (Ascending)'), 'name_desc' => __('Name (Descending)')));
     $specificOptions->addProperty($leaf);
     // add the main group to the root group
     $exportSpecificOptions->addProperty($specificOptions);
     // set the options for the schema export plugin property item
     $schemaPluginProperties->setOptions($exportSpecificOptions);
     $this->properties = $schemaPluginProperties;
 }
 /**
  * Sets the export CSV for Excel properties
  *
  * @return void
  */
 protected function setProperties()
 {
     $props = 'libraries/properties/';
     include_once "{$props}/plugins/ExportPluginProperties.class.php";
     include_once "{$props}/options/groups/OptionsPropertyRootGroup.class.php";
     include_once "{$props}/options/groups/OptionsPropertyMainGroup.class.php";
     include_once "{$props}/options/items/TextPropertyItem.class.php";
     include_once "{$props}/options/items/BoolPropertyItem.class.php";
     include_once "{$props}/options/items/SelectPropertyItem.class.php";
     include_once "{$props}/options/items/HiddenPropertyItem.class.php";
     $exportPluginProperties = new ExportPluginProperties();
     $exportPluginProperties->setText('CSV for MS Excel');
     $exportPluginProperties->setExtension('csv');
     $exportPluginProperties->setMimeType('text/comma-separated-values');
     $exportPluginProperties->setOptionsText(__('Options'));
     // create the root group that will be the options field for
     // $exportPluginProperties
     // this will be shown as "Format specific options"
     $exportSpecificOptions = new OptionsPropertyRootGroup();
     $exportSpecificOptions->setName("Format Specific Options");
     // general options main group
     $generalOptions = new OptionsPropertyMainGroup();
     $generalOptions->setName("general_opts");
     // create primary items and add them to the group
     $leaf = new TextPropertyItem();
     $leaf->setName('null');
     $leaf->setText(__('Replace NULL with:'));
     $generalOptions->addProperty($leaf);
     $leaf = new BoolPropertyItem();
     $leaf->setName('removeCRLF');
     $leaf->setText(__('Remove carriage return/line feed characters within columns'));
     $generalOptions->addProperty($leaf);
     $leaf = new BoolPropertyItem();
     $leaf->setName('columns');
     $leaf->setText(__('Put columns names in the first row'));
     $generalOptions->addProperty($leaf);
     $leaf = new SelectPropertyItem();
     $leaf->setName('edition');
     $leaf->setValues(array('win' => 'Windows', 'mac_excel2003' => 'Excel 2003 / Macintosh', 'mac_excel2008' => 'Excel 2008 / Macintosh'));
     $leaf->setText(__('Excel edition:'));
     $generalOptions->addProperty($leaf);
     $leaf = new HiddenPropertyItem();
     $leaf->setName('structure_or_data');
     $generalOptions->addProperty($leaf);
     // add the main group to the root group
     $exportSpecificOptions->addProperty($generalOptions);
     // set the options for the export plugin property item
     $exportPluginProperties->setOptions($exportSpecificOptions);
     $this->properties = $exportPluginProperties;
 }
Example #3
0
 /**
  * Sets the import plugin properties.
  * Called in the constructor.
  *
  * @return void
  */
 protected function setProperties()
 {
     $props = 'libraries/properties/';
     include_once "{$props}/plugins/ImportPluginProperties.class.php";
     include_once "{$props}/options/groups/OptionsPropertyRootGroup.class.php";
     include_once "{$props}/options/groups/OptionsPropertyMainGroup.class.php";
     include_once "{$props}/options/items/SelectPropertyItem.class.php";
     include_once "{$props}/options/items/BoolPropertyItem.class.php";
     $importPluginProperties = new ImportPluginProperties();
     $importPluginProperties->setText('SQL');
     $importPluginProperties->setExtension('sql');
     $importPluginProperties->setOptionsText(__('Options'));
     $compats = $GLOBALS['dbi']->getCompatibilities();
     if (count($compats) > 0) {
         $values = array();
         foreach ($compats as $val) {
             $values[$val] = $val;
         }
         // create the root group that will be the options field for
         // $importPluginProperties
         // this will be shown as "Format specific options"
         $importSpecificOptions = new OptionsPropertyRootGroup();
         $importSpecificOptions->setName("Format Specific Options");
         // general options main group
         $generalOptions = new OptionsPropertyMainGroup();
         $generalOptions->setName("general_opts");
         // create primary items and add them to the group
         $leaf = new SelectPropertyItem();
         $leaf->setName("compatibility");
         $leaf->setText(__('SQL compatibility mode:'));
         $leaf->setValues($values);
         $leaf->setDoc(array('manual_MySQL_Database_Administration', 'Server_SQL_mode'));
         $generalOptions->addProperty($leaf);
         $leaf = new BoolPropertyItem();
         $leaf->setName("no_auto_value_on_zero");
         $leaf->setText(__('Do not use <code>AUTO_INCREMENT</code> for zero values'));
         $leaf->setDoc(array('manual_MySQL_Database_Administration', 'Server_SQL_mode', 'sqlmode_no_auto_value_on_zero'));
         $generalOptions->addProperty($leaf);
         // add the main group to the root group
         $importSpecificOptions->addProperty($generalOptions);
         // set the options for the import plugin property item
         $importPluginProperties->setOptions($importSpecificOptions);
     }
     $this->properties = $importPluginProperties;
 }
 /**
  * Sets the schema export Dia properties
  *
  * @return void
  */
 protected function setProperties()
 {
     $props = 'libraries/properties/';
     include_once "{$props}/plugins/SchemaPluginProperties.class.php";
     include_once "{$props}/options/groups/OptionsPropertyRootGroup.class.php";
     include_once "{$props}/options/groups/OptionsPropertyMainGroup.class.php";
     include_once "{$props}/options/items/BoolPropertyItem.class.php";
     include_once "{$props}/options/items/SelectPropertyItem.class.php";
     $schemaPluginProperties = new SchemaPluginProperties();
     $schemaPluginProperties->setText('Dia');
     $schemaPluginProperties->setExtension('dia');
     $schemaPluginProperties->setMimeType('application/dia');
     // create the root group that will be the options field for
     // $schemaPluginProperties
     // this will be shown as "Format specific options"
     $exportSpecificOptions = new OptionsPropertyRootGroup();
     $exportSpecificOptions->setName("Format Specific Options");
     // specific options main group
     $specificOptions = new OptionsPropertyMainGroup();
     $specificOptions->setName("general_opts");
     // add options common to all plugins
     $this->addCommonOptions($specificOptions);
     $leaf = new SelectPropertyItem();
     $leaf->setName("orientation");
     $leaf->setText(__('Orientation'));
     $leaf->setValues(array('L' => __('Landscape'), 'P' => __('Portrait')));
     $specificOptions->addProperty($leaf);
     $leaf = new SelectPropertyItem();
     $leaf->setName("paper");
     $leaf->setText(__('Paper size'));
     $leaf->setValues($this->_getPaperSizeArray());
     $specificOptions->addProperty($leaf);
     // add the main group to the root group
     $exportSpecificOptions->addProperty($specificOptions);
     // set the options for the schema export plugin property item
     $schemaPluginProperties->setOptions($exportSpecificOptions);
     $this->properties = $schemaPluginProperties;
 }
 /**
  * Sets the export CodeGen properties
  *
  * @return void
  */
 protected function setProperties()
 {
     $props = 'libraries/properties/';
     include_once "{$props}/plugins/ExportPluginProperties.class.php";
     include_once "{$props}/options/groups/OptionsPropertyRootGroup.class.php";
     include_once "{$props}/options/groups/OptionsPropertyMainGroup.class.php";
     include_once "{$props}/options/items/HiddenPropertyItem.class.php";
     include_once "{$props}/options/items/SelectPropertyItem.class.php";
     $exportPluginProperties = new ExportPluginProperties();
     $exportPluginProperties->setText('CodeGen');
     $exportPluginProperties->setExtension('cs');
     $exportPluginProperties->setMimeType('text/cs');
     $exportPluginProperties->setOptionsText(__('Options'));
     // create the root group that will be the options field for
     // $exportPluginProperties
     // this will be shown as "Format specific options"
     $exportSpecificOptions = new OptionsPropertyRootGroup();
     $exportSpecificOptions->setName("Format Specific Options");
     // general options main group
     $generalOptions = new OptionsPropertyMainGroup();
     $generalOptions->setName("general_opts");
     // create primary items and add them to the group
     $leaf = new HiddenPropertyItem();
     $leaf->setName("structure_or_data");
     $generalOptions->addProperty($leaf);
     $leaf = new SelectPropertyItem();
     $leaf->setName("format");
     $leaf->setText(__('Format:'));
     $leaf->setValues($this->_getCgFormats());
     $generalOptions->addProperty($leaf);
     // add the main group to the root group
     $exportSpecificOptions->addProperty($generalOptions);
     // set the options for the export plugin property item
     $exportPluginProperties->setOptions($exportSpecificOptions);
     $this->properties = $exportPluginProperties;
 }
Example #6
0
 /**
  * Sets the export SQL properties
  *
  * @return void
  */
 protected function setProperties()
 {
     global $plugin_param;
     $hide_sql = false;
     $hide_structure = false;
     if ($plugin_param['export_type'] == 'table' && !$plugin_param['single_table']) {
         $hide_structure = true;
         $hide_sql = true;
     }
     if (!$hide_sql) {
         $props = 'libraries/properties/';
         include_once "{$props}/plugins/ExportPluginProperties.class.php";
         include_once "{$props}/options/groups/OptionsPropertyRootGroup.class.php";
         include_once "{$props}/options/groups/OptionsPropertyMainGroup.class.php";
         include_once "{$props}/options/groups/OptionsPropertySubgroup.class.php";
         include_once "{$props}/options/items/BoolPropertyItem.class.php";
         include_once "{$props}/options/items/MessageOnlyPropertyItem.class.php";
         include_once "{$props}/options/items/RadioPropertyItem.class.php";
         include_once "{$props}/options/items/SelectPropertyItem.class.php";
         include_once "{$props}/options/items/TextPropertyItem.class.php";
         $exportPluginProperties = new ExportPluginProperties();
         $exportPluginProperties->setText('SQL');
         $exportPluginProperties->setExtension('sql');
         $exportPluginProperties->setMimeType('text/x-sql');
         $exportPluginProperties->setOptionsText(__('Options'));
         // create the root group that will be the options field for
         // $exportPluginProperties
         // this will be shown as "Format specific options"
         $exportSpecificOptions = new OptionsPropertyRootGroup();
         $exportSpecificOptions->setName("Format Specific Options");
         // general options main group
         $generalOptions = new OptionsPropertyMainGroup();
         $generalOptions->setName("general_opts");
         // comments
         $subgroup = new OptionsPropertySubgroup();
         $subgroup->setName("include_comments");
         $leaf = new BoolPropertyItem();
         $leaf->setName('include_comments');
         $leaf->setText(__('Display comments <i>(includes info such as export' . ' timestamp, PHP version, and server version)</i>'));
         $subgroup->setSubgroupHeader($leaf);
         $leaf = new TextPropertyItem();
         $leaf->setName('header_comment');
         $leaf->setText(__('Additional custom header comment (\\n splits lines):'));
         $subgroup->addProperty($leaf);
         $leaf = new BoolPropertyItem();
         $leaf->setName('dates');
         $leaf->setText(__('Include a timestamp of when databases were created, last' . ' updated, and last checked'));
         $subgroup->addProperty($leaf);
         if (!empty($GLOBALS['cfgRelation']['relation'])) {
             $leaf = new BoolPropertyItem();
             $leaf->setName('relation');
             $leaf->setText(__('Display foreign key relationships'));
             $subgroup->addProperty($leaf);
         }
         if (!empty($GLOBALS['cfgRelation']['mimework'])) {
             $leaf = new BoolPropertyItem();
             $leaf->setName('mime');
             $leaf->setText(__('Display MIME types'));
             $subgroup->addProperty($leaf);
         }
         $generalOptions->addProperty($subgroup);
         // enclose in a transaction
         $leaf = new BoolPropertyItem();
         $leaf->setName("use_transaction");
         $leaf->setText(__('Enclose export in a transaction'));
         $leaf->setDoc(array('programs', 'mysqldump', 'option_mysqldump_single-transaction'));
         $generalOptions->addProperty($leaf);
         // disable foreign key checks
         $leaf = new BoolPropertyItem();
         $leaf->setName("disable_fk");
         $leaf->setText(__('Disable foreign key checks'));
         $leaf->setDoc(array('manual_MySQL_Database_Administration', 'server-system-variables', 'sysvar_foreign_key_checks'));
         $generalOptions->addProperty($leaf);
         // compatibility maximization
         $compats = PMA_DBI_getCompatibilities();
         if (count($compats) > 0) {
             $values = array();
             foreach ($compats as $val) {
                 $values[$val] = $val;
             }
             $leaf = new SelectPropertyItem();
             $leaf->setName("compatibility");
             $leaf->setText(__('Database system or older MySQL server to maximize output' . ' compatibility with:'));
             $leaf->setValues($values);
             $leaf->setDoc(array('manual_MySQL_Database_Administration', 'Server_SQL_mode'));
             $generalOptions->addProperty($leaf);
             unset($values);
         }
         // server export options
         if ($plugin_param['export_type'] == 'server') {
             $leaf = new BoolPropertyItem();
             $leaf->setName("drop_database");
             $leaf->setText(sprintf(__('Add %s statement'), '<code>DROP DATABASE</code>'));
             $generalOptions->addProperty($leaf);
         }
         // what to dump (structure/data/both)
         $subgroup = new OptionsPropertySubgroup();
         $subgroup->setName("dump_table");
         $subgroup->setText("Dump table");
         $leaf = new RadioPropertyItem();
         $leaf->setName('structure_or_data');
         $leaf->setValues(array('structure' => __('structure'), 'data' => __('data'), 'structure_and_data' => __('structure and data')));
         $subgroup->setSubgroupHeader($leaf);
         $generalOptions->addProperty($subgroup);
         // add the main group to the root group
         $exportSpecificOptions->addProperty($generalOptions);
         // structure options main group
         if (!$hide_structure) {
             $structureOptions = new OptionsPropertyMainGroup();
             $structureOptions->setName("structure");
             $structureOptions->setText(__('Object creation options'));
             $structureOptions->setForce('data');
             // begin SQL Statements
             $subgroup = new OptionsPropertySubgroup();
             $leaf = new MessageOnlyPropertyItem();
             $leaf->setName('add_statements');
             $leaf->setText(__('Add statements:'));
             $subgroup->setSubgroupHeader($leaf);
             if ($plugin_param['export_type'] != 'table') {
                 $leaf = new BoolPropertyItem();
                 $leaf->setName('create_database');
                 $create_clause = '<code>CREATE DATABASE / USE</code>';
                 $leaf->setText(sprintf(__('Add %s statement'), $create_clause));
                 $subgroup->addProperty($leaf);
             }
             if ($plugin_param['export_type'] == 'table') {
                 if (PMA_Table::isView($GLOBALS['db'], $GLOBALS['table'])) {
                     $drop_clause = '<code>DROP VIEW</code>';
                 } else {
                     $drop_clause = '<code>DROP TABLE</code>';
                 }
             } else {
                 if (PMA_DRIZZLE) {
                     $drop_clause = '<code>DROP TABLE</code>';
                 } else {
                     $drop_clause = '<code>DROP TABLE / VIEW / PROCEDURE' . ' / FUNCTION</code>';
                     if (PMA_MYSQL_INT_VERSION > 50100) {
                         $drop_clause .= '<code> / EVENT</code>';
                     }
                 }
             }
             $leaf = new BoolPropertyItem();
             $leaf->setName('drop_table');
             $leaf->setText(sprintf(__('Add %s statement'), $drop_clause));
             $subgroup->addProperty($leaf);
             // Drizzle doesn't support procedures and functions
             if (!PMA_DRIZZLE) {
                 $leaf = new BoolPropertyItem();
                 $leaf->setName('procedure_function');
                 $leaf->setText(sprintf(__('Add %s statement'), '<code>CREATE PROCEDURE / FUNCTION' . (PMA_MYSQL_INT_VERSION > 50100 ? ' / EVENT</code>' : '</code>')));
                 $subgroup->addProperty($leaf);
             }
             // begin CREATE TABLE statements
             $subgroup_create_table = new OptionsPropertySubgroup();
             $leaf = new BoolPropertyItem();
             $leaf->setName('create_table_statements');
             $leaf->setText(__('<code>CREATE TABLE</code> options:'));
             $subgroup_create_table->setSubgroupHeader($leaf);
             $leaf = new BoolPropertyItem();
             $leaf->setName('if_not_exists');
             $leaf->setText('<code>IF NOT EXISTS</code>');
             $subgroup_create_table->addProperty($leaf);
             $leaf = new BoolPropertyItem();
             $leaf->setName('auto_increment');
             $leaf->setText('<code>AUTO_INCREMENT</code>');
             $subgroup_create_table->addProperty($leaf);
             $subgroup->addProperty($subgroup_create_table);
             $structureOptions->addProperty($subgroup);
             $leaf = new BoolPropertyItem();
             $leaf->setName("backquotes");
             $leaf->setText(__('Enclose table and column names with backquotes ' . '<i>(Protects column and table names formed with' . ' special characters or keywords)</i>'));
             $structureOptions->addProperty($leaf);
             // add the main group to the root group
             $exportSpecificOptions->addProperty($structureOptions);
         }
         // begin Data options
         $dataOptions = new OptionsPropertyMainGroup();
         $dataOptions->setName("data");
         $dataOptions->setText(__('Data creation options'));
         $dataOptions->setForce('structure');
         $leaf = new BoolPropertyItem();
         $leaf->setName("truncate");
         $leaf->setText(__('Truncate table before insert'));
         $dataOptions->addProperty($leaf);
         // begin SQL Statements
         $subgroup = new OptionsPropertySubgroup();
         $leaf = new MessageOnlyPropertyItem();
         $leaf->setText(__('Instead of <code>INSERT</code> statements, use:'));
         $subgroup->setSubgroupHeader($leaf);
         // Not supported in Drizzle
         if (!PMA_DRIZZLE) {
             $leaf = new BoolPropertyItem();
             $leaf->setName("delayed");
             $leaf->setText(__('<code>INSERT DELAYED</code> statements'));
             $leaf->setDoc(array('manual_MySQL_Database_Administration', 'insert_delayed'));
             $subgroup->addProperty($leaf);
         }
         $leaf = new BoolPropertyItem();
         $leaf->setName("ignore");
         $leaf->setText(__('<code>INSERT IGNORE</code> statements'));
         $leaf->setDoc(array('manual_MySQL_Database_Administration', 'insert'));
         $subgroup->addProperty($leaf);
         $dataOptions->addProperty($subgroup);
         // Function to use when dumping dat
         $leaf = new SelectPropertyItem();
         $leaf->setName("type");
         $leaf->setText(__('Function to use when dumping data:'));
         $leaf->setValues(array('INSERT' => 'INSERT', 'UPDATE' => 'UPDATE', 'REPLACE' => 'REPLACE'));
         $dataOptions->addProperty($leaf);
         /* Syntax to use when inserting data */
         $subgroup = new OptionsPropertySubgroup();
         $leaf = new MessageOnlyPropertyItem();
         $leaf->setText(__('Syntax to use when inserting data:'));
         $subgroup->setSubgroupHeader($leaf);
         $leaf = new RadioPropertyItem();
         $leaf->setName("insert_syntax");
         $leaf->setText(__('<code>INSERT IGNORE</code> statements'));
         $leaf->setValues(array('complete' => __('include column names in every <code>INSERT</code> statement' . ' <br /> &nbsp; &nbsp; &nbsp; Example: <code>INSERT INTO' . ' tbl_name (col_A,col_B,col_C) VALUES (1,2,3)</code>'), 'extended' => __('insert multiple rows in every <code>INSERT</code> statement' . '<br /> &nbsp; &nbsp; &nbsp; Example: <code>INSERT INTO' . ' tbl_name VALUES (1,2,3), (4,5,6), (7,8,9)</code>'), 'both' => __('both of the above<br /> &nbsp; &nbsp; &nbsp; Example:' . ' <code>INSERT INTO tbl_name (col_A,col_B) VALUES (1,2,3),' . ' (4,5,6), (7,8,9)</code>'), 'none' => __('neither of the above<br /> &nbsp; &nbsp; &nbsp; Example:' . ' <code>INSERT INTO tbl_name VALUES (1,2,3)</code>')));
         $subgroup->addProperty($leaf);
         $dataOptions->addProperty($subgroup);
         // Max length of query
         $leaf = new TextPropertyItem();
         $leaf->setName("max_query_size");
         $leaf->setText(__('Maximal length of created query'));
         $dataOptions->addProperty($leaf);
         // Dump binary columns in hexadecimal
         $leaf = new BoolPropertyItem();
         $leaf->setName("hex_for_blob");
         $leaf->setText(__('Dump binary columns in hexadecimal notation' . ' <i>(for example, "abc" becomes 0x616263)</i>'));
         $dataOptions->addProperty($leaf);
         // Drizzle works only with UTC timezone
         if (!PMA_DRIZZLE) {
             // Dump time in UTC
             $leaf = new BoolPropertyItem();
             $leaf->setName("utc_time");
             $leaf->setText(__('Dump TIMESTAMP columns in UTC <i>(enables TIMESTAMP columns' . ' to be dumped and reloaded between servers in different' . ' time zones)</i>'));
             $dataOptions->addProperty($leaf);
         }
         // add the main group to the root group
         $exportSpecificOptions->addProperty($dataOptions);
         // set the options for the export plugin property item
         $exportPluginProperties->setOptions($exportSpecificOptions);
         $this->properties = $exportPluginProperties;
     }
 }