module RailsSqlViews4::ConnectionAdapters::SQLiteAdapter
Public Instance Methods
base_tables(name = nil)
click to toggle source
# File lib/rails_sql_views4/connection_adapters/sqlite_adapter.rb, line 24 def base_tables(name = nil) sql = <<-SQL SELECT name FROM sqlite_master WHERE (type = 'table') AND NOT name = 'sqlite_sequence' SQL execute(sql, name).map do |row| row[0] end end
Also aliased as: nonview_tables
supports_drop_table_cascade?()
click to toggle source
# File lib/rails_sql_views4/connection_adapters/sqlite_adapter.rb, line 8 def supports_drop_table_cascade? return false end
supports_view_columns_definition?()
click to toggle source
# File lib/rails_sql_views4/connection_adapters/sqlite_adapter.rb, line 62 def supports_view_columns_definition? false end
supports_views?()
click to toggle source
# File lib/rails_sql_views4/connection_adapters/sqlite_adapter.rb, line 4 def supports_views? true end
view_select_statement(view, name = nil)
click to toggle source
Get the view select statement for the specified table.
# File lib/rails_sql_views4/connection_adapters/sqlite_adapter.rb, line 50 def view_select_statement(view, name = nil) sql = <<-SQL SELECT sql FROM sqlite_master WHERE name = '#{view}' AND NOT name = 'sqlite_sequence' SQL #TODO # (select_value(sql, name).gsub("CREATE VIEW #{view} AS ", "")) or raise "No view called #{view} found" (select_value(sql, name).gsub("CREATE VIEW \"#{view}\" AS ", "")) or raise "No view called #{view} found" end
views(name = nil)
click to toggle source
# File lib/rails_sql_views4/connection_adapters/sqlite_adapter.rb, line 37 def views(name = nil) sql = <<-SQL SELECT name FROM sqlite_master WHERE type = 'view' AND NOT name = 'sqlite_sequence' SQL execute(sql, name).map do |row| row[0] end end