Class: Lafcadio::CreateTableStatement

Inherits:
Object
  • Object
show all
Defined in:
lib/lafcadio/schema.rb

Overview

:nodoc:

Constant Summary collapse

@@simple_field_clauses = 
{
  BooleanField => 'bool', BinaryField => 'blob', DateField => 'date', 
  DomainObjectField => 'int', FloatField => 'float',
  DateTimeField => 'datetime', IntegerField => 'int',
  StringField => 'varchar(255)', TextListField => 'varchar(255)',
  TimeStampField => 'timestamp'
}

Instance Method Summary collapse

Constructor Details

#initialize(domain_class) ⇒ CreateTableStatement

Returns a new instance of CreateTableStatement.



13
14
15
 
# File 'lib/lafcadio/schema.rb', line 13

def initialize( domain_class )
  @domain_class = domain_class
end

Instance Method Details

#definition_terms(field) ⇒ Object 



17
18
19
20
21
22
23
 
# File 'lib/lafcadio/schema.rb', line 17

def definition_terms( field )
  definitionTerms = []
  definitionTerms << field.db_field_name
  definitionTerms << type_clause( field )
  definitionTerms << 'not null' if field.not_nil
  definitionTerms.join( ' ' )
end

#to_sql ⇒ Object 



25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
 
# File 'lib/lafcadio/schema.rb', line 25

def to_sql
  createDefinitions = []
  createDefinitions <<
    "#{ @domain_class.sql_primary_key_name } int not null auto_increment"
  createDefinitions <<
      "primary key (#{ @domain_class.sql_primary_key_name })"
  @domain_class.class_fields.each { |field|
    createDefinitions << definition_terms( field )
  }
  "create table \#{ @domain_class.table_name } (\n\#{ createDefinitions.join(\",\\n  \") }\n);\n  SQL\nend\n"

#type_clause(field) ⇒ Object 



41
42
43
44
45
46
47
48
49
50
 
# File 'lib/lafcadio/schema.rb', line 41

def type_clause( field )
  if ( type_clause = @@simple_field_clauses[field.class] )
    type_clause
  elsif ( field.class <= EnumField )
    singleQuotedValues = field.enums.keys.collect! { |enumValue|
      "'#{ enumValue }'"
    }
    "enum( #{ singleQuotedValues.join( ', ' ) } )"
  end
end