Module: Sequel::Access::DatabaseMethods

Extended by:
Database::ResetIdentifierMangling
Included in:
Sequel::ADO::Access::DatabaseMethods
Defined in:
lib/sequel/adapters/shared/access.rb

Instance Method Summary collapse

Methods included from Database::ResetIdentifierMangling

extended

Instance Method Details

#database_type ⇒ Object

Access uses type :access as the database_type



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

def database_type
  :access
end

#rename_table(from_table, to_table) ⇒ Object

Access doesn’t support renaming tables from an SQL query, so create a copy of the table and then drop the from table.



22
23
24
25
 
# File 'lib/sequel/adapters/shared/access.rb', line 22

def rename_table(from_table, to_table)
  create_table(to_table, :as=>from(from_table))
  drop_table(from_table)
end

#serial_primary_key_options ⇒ Object

Access uses type Counter for an autoincrementing keys



28
29
30
 
# File 'lib/sequel/adapters/shared/access.rb', line 28

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