Class: ActiveRecord::ConnectionAdapters::SQLite3Adapter

Inherits:
SQLiteAdapter show all
Defined in:
lib/empty_eye/active_record/connection_adapters/sqlite3_adapter.rb

Instance Method Summary collapse

Methods inherited from AbstractAdapter

#ordinary_table_exists?, #view_exists?

Instance Method Details

#tables(name = 'SCHEMA', table_name = nil) ⇒ Object

:nodoc:



5
6
7
8
9
10
11
12
13
14
15
16
 
# File 'lib/empty_eye/active_record/connection_adapters/sqlite3_adapter.rb', line 5

def tables(name = 'SCHEMA', table_name = nil) #:nodoc:
  sql = "    SELECT name\n    FROM sqlite_master\n    WHERE (type = 'table' OR type = 'view') AND NOT name = 'sqlite_sequence'\n  SQL\n  sql << \" AND name = \#{quote_table_name(table_name)}\" if table_name\n\n  exec_query(sql, name).map do |row|\n    row['name']\n  end\nend\n"

#tables_without_views(name = 'SCHEMA', table_name = nil) ⇒ Object

:nodoc:



18
19
20
21
22
23
24
25
26
27
28
29
 
# File 'lib/empty_eye/active_record/connection_adapters/sqlite3_adapter.rb', line 18

def tables_without_views(name = 'SCHEMA', table_name = nil) #:nodoc:
  sql = "    SELECT name\n    FROM sqlite_master\n    WHERE type = 'table' AND NOT name = 'sqlite_sequence'\n  SQL\n  sql << \" AND name = \#{quote_table_name(table_name)}\" if table_name\n\n  exec_query(sql, name).map do |row|\n    row['name']\n  end\nend\n"

#views(name = 'SCHEMA', table_name = nil) ⇒ Object

:nodoc:



31
32
33
34
35
36
37
38
39
40
41
42
 
# File 'lib/empty_eye/active_record/connection_adapters/sqlite3_adapter.rb', line 31

def views(name = 'SCHEMA', table_name = nil) #:nodoc:
  sql = "    SELECT name\n    FROM sqlite_master\n    WHERE type = 'view' AND NOT name = 'sqlite_sequence'\n  SQL\n  sql << \" AND name = \#{quote_table_name(table_name)}\" if table_name\n\n  exec_query(sql, name).map do |row|\n    row['name']\n  end\nend\n"