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