Module: Sequel::Access::DatabaseMethods

Defined in:
lib/sequel/adapters/shared/access.rb

Instance Method Summary collapse

Instance Method Details

#database_type ⇒ Object

Access uses type :access as the database_type



5
6
7
 
# File 'lib/sequel/adapters/shared/access.rb', line 5

def database_type
  :access
end

#serial_primary_key_options ⇒ Object

Access uses type Counter for an autoincrementing keys



15
16
17
 
# File 'lib/sequel/adapters/shared/access.rb', line 15

def serial_primary_key_options
  {:primary_key => true, :type=>:Counter}
end

#tables ⇒ Object

Doesn’t work, due to security restrictions on MSysObjects



10
11
12
 
# File 'lib/sequel/adapters/shared/access.rb', line 10

def tables
  from(:MSysObjects).filter(:Type=>1, :Flags=>0).select_map(:Name).map{|x| x.to_sym}
end