Module: RailsSqlViews::ConnectionAdapters::SQLiteAdapter

Defined in:
lib/rails_sql_views/connection_adapters/sqlite_adapter.rb

Instance Method Summary collapse

Instance Method Details

#base_tables(name = nil) ⇒ Object Also known as: nonview_tables 



24
25
26
27
28
29
30
31
32
33
34
 
# File 'lib/rails_sql_views/connection_adapters/sqlite_adapter.rb', line 24

def base_tables(name = nil)
  sql = "    SELECT name\n    FROM sqlite_master\n    WHERE (type = 'table') AND NOT name = 'sqlite_sequence'\n  SQL\n\n  execute(sql, name).map do |row|\n    row[0]\n  end        \nend\n"

#supports_drop_table_cascade? ⇒ Boolean

Returns:

  • (Boolean) 


8
9
10
 
# File 'lib/rails_sql_views/connection_adapters/sqlite_adapter.rb', line 8

def supports_drop_table_cascade?
  return false 
end

#supports_view_columns_definition? ⇒ Boolean

Returns:

  • (Boolean) 


60
61
62
 
# File 'lib/rails_sql_views/connection_adapters/sqlite_adapter.rb', line 60

def supports_view_columns_definition?
  false
end

#supports_views? ⇒ Boolean

Returns:

  • (Boolean) 


4
5
6
 
# File 'lib/rails_sql_views/connection_adapters/sqlite_adapter.rb', line 4

def supports_views?
  true
end

#tables(name = nil) ⇒ Object

:nodoc:



12
13
14
15
16
17
18
19
20
21
22
 
# File 'lib/rails_sql_views/connection_adapters/sqlite_adapter.rb', line 12

def tables(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\n  execute(sql, name).map do |row|\n    row[0]\n  end\nend\n"

#view_select_statement(view, name = nil) ⇒ Object

Get the view select statement for the specified table.



50
51
52
53
54
55
56
57
58
 
# File 'lib/rails_sql_views/connection_adapters/sqlite_adapter.rb', line 50

def view_select_statement(view, name = nil)
  sql = "    SELECT sql\n    FROM sqlite_master\n    WHERE name = '\#{view}' AND NOT name = 'sqlite_sequence'\n  SQL\n  \n  (select_value(sql, name).gsub(\"CREATE VIEW \#{view} AS \", \"\")) or raise \"No view called \#{view} found\"\nend\n"

#views(name = nil) ⇒ Object 



37
38
39
40
41
42
43
44
45
46
47
 
# File 'lib/rails_sql_views/connection_adapters/sqlite_adapter.rb', line 37

def views(name = nil)
  sql = "    SELECT name\n    FROM sqlite_master\n    WHERE type = 'view' AND NOT name = 'sqlite_sequence'\n  SQL\n\n  execute(sql, name).map do |row|\n    row[0]\n  end\nend\n"