#!/usr/bin/env php <?php require 'dbscripts.module'; if (in_array('help', $_SERVER['argv'])) { print dbscripts_help('restore'); } else { $options = dbscripts_get_options($_SERVER['argv']); print dbscripts_restore($options['file'], $options['filter']); }
#!/usr/bin/env php <?php require 'dbscripts.module'; if (in_array('help', $_SERVER['argv'])) { print dbscripts_help('erase'); } else { $_SERVER['argv'][1] = isset($_SERVER['argv'][1]) ? $_SERVER['argv'][1] : 'full'; print dbscripts_erase($_SERVER['argv'][1]); }
#!/usr/bin/env php <?php require 'dbscripts.module'; require 'config.inc'; if (in_array('help', $_SERVER['argv'])) { print dbscripts_help('find'); } else { $options = $_SERVER['argv']; // Find all tables with auto_increment if (isset($options[1]) && $options[1] == 'increment') { $branch = isset($options[2]) ? $options[2] : 'development'; $filter_option = isset($options[3]) ? $options[3] : 'full'; $list = dbscripts_find_tables_with_increment($branch, $filter_option); print_r($list); // Find all possible references to a given table } elseif (isset($options[1]) && $options[1] == 'possible-references') { $branch = isset($options[3]) ? $options[3] : 'development'; $filter_option = isset($options[4]) ? $options[4] : 'full'; $list = array(); if (isset($options[2]) && $options[2] != 'all') { $table = $options[2]; $list = dbscripts_find_possible_table_references($table, $branch, $filter_option); } else { print "\n Please wait. This can take awhile. 'ctrl+c' to cancel.\n\n"; $table_list = dbscripts_find_tables_with_increment($branch, $filter_option); if (is_array($table_list)) { foreach ($table_list as $table) { $references = dbscripts_find_possible_table_references($table, $branch, $filter_option); if (is_array($references)) { $list[$table] = $references; }
#!/usr/bin/env php <?php require 'dbscripts.module'; if (in_array('help', $_SERVER['argv'])) { print dbscripts_help('merge'); } else { // Findout if the user wants to continue from a previous merge $continue = FALSE; if (in_array('continue', $_SERVER['argv'])) { $continue = TRUE; } // Reset the array by removing the other set variables foreach ($_SERVER['argv'] as $key => $variable) { if ($variable = 'continue') { unset($_SERVER['argv'][$key]); } } foreach ($_SERVER['argv'] as $variable) { $_SERVER['argv'][] = $variable; } $dev_db = isset($_SERVER['argv'][1]) ? $_SERVER['argv'][1] : FALSE; $lastmerge_db = isset($_SERVER['argv'][2]) ? $_SERVER['argv'][2] : FALSE; $prod_db = isset($_SERVER['argv'][3]) ? $_SERVER['argv'][3] : FALSE; print dbscripts_merge($dev_db, $lastmerge_db, $prod_db, $continue); }
#!/usr/bin/env php <?php require 'dbscripts.module'; if (in_array('help', $_SERVER['argv'])) { print dbscripts_help('dump'); } else { $options = dbscripts_get_options($_SERVER['argv']); print dbscripts_dump($options['branch'], $options['filter'], $options['last-merge']); }
#!/usr/bin/env php <?php require 'dbscripts.module'; if (in_array('help', $_SERVER['argv'])) { print dbscripts_help('raise_increments'); } else { $options = $_SERVER['argv']; if (isset($options[1]) && $options[1] != 'all') { if (isset($options[3])) { $table = $options[1]; $start_at = $options[2]; $change_to = $options[3]; $branch = isset($options[5]) ? $options[5] : 'development'; $filter_option = isset($options[6]) ? $options[6] : 'full'; print dbscripts_raise_table_increments($table, $start_at, $change_to, $branch, $filter_option); } else { print "\n\nMust provide a table, increment to start at, and increment to change to\n\n"; } } else { print dbscripts_raise_all_increments(); } }