/**
* Creates and returns SQL command for dropping the sequence.
*
* @return string
*/
public static function get_drop_sql($node_schema, $node_sequences)
{
$table_name = mysql5::get_quoted_table_name(self::TABLE_NAME);
$seq_col = mysql5::get_quoted_column_name(self::SEQ_COL);
$sequences = dbx::to_array($node_sequences);
if (count($sequences) === 0) {
return '';
}
$sequence_names = "('" . implode("', '", array_map(function ($n) {
if ($n instanceof SimpleXMLElement) {
return $n['name'];
}
return $n;
}, $sequences)) . "')";
return "DELETE FROM {$table_name} WHERE {$seq_col} IN {$sequence_names};";
}
private static function diff_single($ofs, $old_seq, $new_seq)
{
$sql = array();
if (!dbsteward::$ignore_oldnames && !empty($new_seq['oldSequenceName'])) {
$sql[] = mysql5::get_quoted_column_name(mysql5_sequence::SEQ_COL) . " = '{$new_seq['name']}'";
}
if ($new_seq['inc'] == null && $old_seq['inc'] != null) {
$sql[] = mysql5::get_quoted_column_name(mysql5_sequence::INC_COL) . ' = DEFAULT';
}
if ($new_seq['inc'] != null && strcasecmp($new_seq['inc'], $old_seq['inc']) != 0) {
$sql[] = mysql5::get_quoted_column_name(mysql5_sequence::INC_COL) . ' = ' . $new_seq['inc'];
}
if ($new_seq['min'] == null && $old_seq['min'] != null) {
$sql[] = mysql5::get_quoted_column_name(mysql5_sequence::MIN_COL) . ' = DEFAULT';
} elseif ($new_seq['min'] != null && strcasecmp($new_seq['min'], $old_seq['min']) != 0) {
$sql[] = mysql5::get_quoted_column_name(mysql5_sequence::MIN_COL) . ' = ' . $new_seq['min'];
}
if ($new_seq['max'] == null && $old_seq['max'] != null) {
$sql[] = mysql5::get_quoted_column_name(mysql5_sequence::MAX_COL) . ' = DEFAULT';
} elseif ($new_seq['max'] != null && strcasecmp($new_seq['max'], $old_seq['max']) != 0) {
$sql[] = mysql5::get_quoted_column_name(mysql5_sequence::MAX_COL) . ' = ' . $new_seq['max'];
}
if ($new_seq['start'] != null && strcasecmp($new_seq['start'], $old_seq['start']) != 0) {
$sql[] = mysql5::get_quoted_column_name(mysql5_sequence::CUR_COL) . ' = ' . $new_seq['start'];
}
if ($new_seq['cycle'] == null && $old_seq['cycle'] != null) {
$sql[] = mysql5::get_quoted_column_name(mysql5_sequence::CYC_COL) . ' = DEFAULT';
} elseif ($new_seq['cycle'] != null && strcasecmp($new_seq['cycle'], $old_seq['cycle']) != 0) {
$value = strcasecmp($new_seq['cycle'], 'false') == 0 ? 'FALSE' : 'TRUE';
$sql[] = mysql5::get_quoted_column_name(mysql5_sequence::CYC_COL) . ' = ' . $value;
}
if (!empty($sql)) {
$out = "UPDATE " . mysql5::get_quoted_table_name(mysql5_sequence::TABLE_NAME);
$out .= "\nSET " . implode(",\n ", $sql);
$out .= "\nWHERE " . mysql5::get_quoted_column_name(mysql5_sequence::SEQ_COL) . " = ";
$out .= "'" . $old_seq['name'] . "'";
$ofs->write("{$out};\n");
}
}