Module: Listable::ConnectionAdapters::MySQLExtensions

Includes:
ConcatenationMethods::Function
Defined in:
lib/listable/connection_adapters.rb

Instance Method Summary collapse

Methods included from ConcatenationMethods::Function

#concat

Instance Method Details

#views ⇒ Object 



65
66
67
68
69
70
71
72
73
74
75
 
# File 'lib/listable/connection_adapters.rb', line 65

def views()
  query = "    SHOW FULL TABLES \n    IN \#{quote_table_name(current_database)} \n    WHERE TABLE_TYPE LIKE 'VIEW'\n  SQL\n\n  execute_and_free(query, 'SCHEMA') do |result|\n    result.collect { |field| field.first }\n  end\nend\n"