module Upsert::MergeFunction::Mysql::ClassMethods

Public Instance Methods

clear(connection) click to toggle source

stackoverflow.com/questions/733349/list-of-stored-procedures-functions-mysql-command-line

# File lib/upsert/merge_function/mysql.rb, line 11
def clear(connection)
  connection.execute("SHOW PROCEDURE STATUS WHERE Db = DATABASE() AND Name LIKE '#{MergeFunction::NAME_PREFIX}%'").map do |row|
    row['Name'] || row['ROUTINE_NAME']
  end.each do |name|
    connection.execute "DROP PROCEDURE IF EXISTS #{connection.quote_ident(name)}"
  end
end