Module: Sequel::Plugins::Schema::ClassMethods

Defined in:
lib/sequel/plugins/schema.rb

Instance Method Summary collapse

Instance Method Details

#create_table ⇒ Object

Creates table, using the column information from set_schema.



22
23
24
25
26
 
# File 'lib/sequel/plugins/schema.rb', line 22

def create_table
  db.create_table(table_name, :generator=>@schema)
  @db_schema = get_db_schema(true)
  columns
end

#create_table! ⇒ Object

Drops the table if it exists and then runs create_table. Should probably not be used except in testing.



30
31
32
33
 
# File 'lib/sequel/plugins/schema.rb', line 30

def create_table!
  drop_table rescue nil
  create_table
end

#create_table? ⇒ Boolean

Creates the table unless the table already exists

Returns:

  • (Boolean) 


36
37
38
 
# File 'lib/sequel/plugins/schema.rb', line 36

def create_table?
  create_table unless table_exists?
end

#drop_table ⇒ Object

Drops table.



41
42
43
 
# File 'lib/sequel/plugins/schema.rb', line 41

def drop_table
  db.drop_table(table_name)
end

#schema ⇒ Object

Returns table schema created with set_schema for direct descendant of Model. Does not retreive schema information from the database, see db_schema if you want that.



48
49
50
 
# File 'lib/sequel/plugins/schema.rb', line 48

def schema
  @schema || (superclass.schema unless superclass == Model)
end

#set_schema(name = nil, &block) ⇒ Object

Defines a table schema (see Schema::Generator for more information).

This is only needed if you want to use the create_table/create_table! methods. Will also set the dataset if you provide a name, as well as setting the primary key if you defined one in the passed block.

In general, it is a better idea to use migrations for production code, as migrations allow changes to existing schema. set_schema is mostly useful for test code or simple examples.



61
62
63
64
65
 
# File 'lib/sequel/plugins/schema.rb', line 61

def set_schema(name = nil, &block)
  set_dataset(db[name]) if name
  @schema = Sequel::Schema::Generator.new(db, &block)
  set_primary_key(@schema.primary_key_name) if @schema.primary_key_name
end

#table_exists? ⇒ Boolean

Returns true if table exists, false otherwise.

Returns:

  • (Boolean) 


68
69
70
 
# File 'lib/sequel/plugins/schema.rb', line 68

def table_exists?
  db.table_exists?(table_name)
end