Class | DataMapper::Adapters::Sqlite3Adapter::Mappings::Column |
In: |
lib/data_mapper/adapters/sqlite3_adapter.rb
lib/data_mapper/adapters/sqlite3_adapter.rb |
Parent: | Object |
# 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
# 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
# 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
# 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
# File lib/data_mapper/adapters/sqlite3_adapter.rb, line 89 89: def serial_declaration 90: "AUTOINCREMENT" 91: end
# File lib/data_mapper/adapters/sqlite3_adapter.rb, line 89 89: def serial_declaration 90: "AUTOINCREMENT" 91: end