Class: ActiveRecord::ConnectionAdapters::SQLiteAdapter

Inherits:

AbstractAdapter

• Object
• AbstractAdapter
• ActiveRecord::ConnectionAdapters::SQLiteAdapter

Defined in:

lib/citier/sql_adapters.rb

Instance Method Summary

• #tables(name = nil) ⇒ Object

Instance Method Details

#tables(name = nil) ⇒ Object

# File 'lib/citier/sql_adapters.rb', line 18

def tables(name = nil) 
  sql = "  SELECT name\n  FROM sqlite_master\n  WHERE (type = 'table' or type='view') AND NOT name = 'sqlite_sequence'\n  SQL\n  # Modification : the where clause was intially WHERE type = 'table' AND NOT name = 'sqlite_sequence' \n  #                now it is WHERE (type = 'table' or type='view') AND NOT name = 'sqlite_sequence'\n  # this modification is made to consider tables AND VIEWS as tables\n\n  execute(sql, name).map do |row|\n    row['name']\n  end\nend\n"