Here is probably a simple question for most of you, where I can’t seem
to update records in sqlite3 through a migration. Any suggestions
would be most appreciated…
With this code, nothing happens:
class AlterDataInDesigns < ActiveRecord::Migration
def self.up
execute “UPDATE designs SET name = ‘Liquid’ and file_name =
‘liquid’ WHERE id = ‘3’”
end
…
end
With this code, it changes the name to ‘0’??? (the difference is the
‘;’ added to the end)
class AlterDataInDesigns < ActiveRecord::Migration
def self.up
execute “UPDATE designs SET name = ‘Liquid’ and file_name =
‘liquid’ WHERE id = ‘3’;”
end
…
end