Class DataMapper::Adapters::Sqlite3Adapter::Mappings::Column
In: lib/data_mapper/adapters/sqlite3_adapter.rb
lib/data_mapper/adapters/sqlite3_adapter.rb
Parent: Object

Methods

Public Instance methods

[Source]

     # File lib/data_mapper/adapters/sqlite3_adapter.rb, line 97
 97:           def alter!
 98:             @adapter.connection do |db|
 99:               flush_sql_caches!
100:               backup_table = @adapter.table("#{@table.name}_backup")
101: 
102:               @table.columns.each do |column|
103:                 backup_table.add_column(column.name, column.type, column.options)
104:               end
105: 
106:               backup_table.temporary = true
107: 
108:               backup_table.create!
109:               
110:               sql = "INSERT INTO \#{backup_table.to_sql} SELECT \#{@table.columns.map { |c| c.to_sql }.join(', ')} FROM \#{@table.to_sql};\nDROP TABLE \#{@table.to_sql};\n\#{@table.to_create_sql};\nINSERT INTO \#{@table.to_sql} SELECT \#{backup_table.columns.map { |c| c.to_sql }.join(', ')} FROM \#{backup_table.to_sql};\n".compress_lines
111:               
112:               sql.split(';').each do |part|
113:                 db.create_command(part).execute_non_query
114:               end
115:               
116:               backup_table.drop!
117:               flush_sql_caches!
118:             end
119:           end

[Source]

     # File lib/data_mapper/adapters/sqlite3_adapter.rb, line 97
 97:           def alter!
 98:             @adapter.connection do |db|
 99:               flush_sql_caches!
100:               backup_table = @adapter.table("#{@table.name}_backup")
101: 
102:               @table.columns.each do |column|
103:                 backup_table.add_column(column.name, column.type, column.options)
104:               end
105: 
106:               backup_table.temporary = true
107: 
108:               backup_table.create!
109:               
110:               sql = "INSERT INTO \#{backup_table.to_sql} SELECT \#{@table.columns.map { |c| c.to_sql }.join(', ')} FROM \#{@table.to_sql};\nDROP TABLE \#{@table.to_sql};\n\#{@table.to_create_sql};\nINSERT INTO \#{@table.to_sql} SELECT \#{backup_table.columns.map { |c| c.to_sql }.join(', ')} FROM \#{backup_table.to_sql};\n".compress_lines
111:               
112:               sql.split(';').each do |part|
113:                 db.create_command(part).execute_non_query
114:               end
115:               
116:               backup_table.drop!
117:               flush_sql_caches!
118:             end
119:           end

[Source]

     # File lib/data_mapper/adapters/sqlite3_adapter.rb, line 127
127:           def drop!
128:             @adapter.connection do |db|
129:               @table.columns.delete(self)
130:               flush_sql_caches!
131:               
132:               backup_table = @adapter.table("#{@table.name}_backup")
133:               
134:               @table.columns.each do |column|
135:                 backup_table.add_column(column.name, column.type, column.options)
136:               end
137: 
138:               backup_table.temporary = true
139: 
140:               backup_table.create!
141:               
142:               sql = "INSERT INTO \#{backup_table.to_sql} SELECT \#{@table.columns.map { |c| c.to_sql }.join(', ')} FROM \#{@table.to_sql};\nDROP TABLE \#{@table.to_sql};\n\#{@table.to_create_sql};\nINSERT INTO \#{@table.to_sql} SELECT \#{backup_table.columns.map { |c| c.to_sql }.join(', ')} FROM \#{backup_table.to_sql};\n".compress_lines
143:               
144:               sql.split(';').each do |part|
145:                 db.create_command(part).execute_non_query
146:               end
147:               
148:               backup_table.drop!
149:               flush_sql_caches!
150:             end
151:           end

[Source]

     # File lib/data_mapper/adapters/sqlite3_adapter.rb, line 127
127:           def drop!
128:             @adapter.connection do |db|
129:               @table.columns.delete(self)
130:               flush_sql_caches!
131:               
132:               backup_table = @adapter.table("#{@table.name}_backup")
133:               
134:               @table.columns.each do |column|
135:                 backup_table.add_column(column.name, column.type, column.options)
136:               end
137: 
138:               backup_table.temporary = true
139: 
140:               backup_table.create!
141:               
142:               sql = "INSERT INTO \#{backup_table.to_sql} SELECT \#{@table.columns.map { |c| c.to_sql }.join(', ')} FROM \#{@table.to_sql};\nDROP TABLE \#{@table.to_sql};\n\#{@table.to_create_sql};\nINSERT INTO \#{@table.to_sql} SELECT \#{backup_table.columns.map { |c| c.to_sql }.join(', ')} FROM \#{backup_table.to_sql};\n".compress_lines
143:               
144:               sql.split(';').each do |part|
145:                 db.create_command(part).execute_non_query
146:               end
147:               
148:               backup_table.drop!
149:               flush_sql_caches!
150:             end
151:           end

[Source]

    # File lib/data_mapper/adapters/sqlite3_adapter.rb, line 89
89:           def serial_declaration
90:             "AUTOINCREMENT"
91:           end

[Source]

    # File lib/data_mapper/adapters/sqlite3_adapter.rb, line 89
89:           def serial_declaration
90:             "AUTOINCREMENT"
91:           end

[Source]

    # File lib/data_mapper/adapters/sqlite3_adapter.rb, line 93
93:           def size
94:             nil
95:           end

[Source]

    # File lib/data_mapper/adapters/sqlite3_adapter.rb, line 93
93:           def size
94:             nil
95:           end

[Validate]