module RailsSqlViews4::ConnectionAdapters::SQLite3Adapter

Public Instance Methods

base_tables(name = nil) click to toggle source
# File lib/rails_sql_views4/connection_adapters/sqlite3_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
nonview_tables(name = nil)
Alias for: base_tables
supports_drop_table_cascade?() click to toggle source
# File lib/rails_sql_views4/connection_adapters/sqlite3_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/sqlite3_adapter.rb, line 62
def supports_view_columns_definition?
  false
end
supports_views?() click to toggle source
# File lib/rails_sql_views4/connection_adapters/sqlite3_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/sqlite3_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/sqlite3_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