http://snippets.dzone.com/posts Thu, 24 Jul 2008 04:38:08 GMT DZone Snippets: sequences code http://snippets.dzone.com/posts/show/3021 If loading data through fixtures or other means with hard-coded IDs, database sequences may need to be adjusted. This is written for Oracle. <br /> <br /><code> <br />namespace :db do <br /> task :adjust_sequences => :environment do <br /> ActiveRecord::Base.connection.tables.each do |table| <br /> begin <br /> count = ActiveRecord::Base.count_by_sql("SELECT MAX(id) FROM #{table}") <br /> seq = "#{table}_seq" <br /> ActiveRecord::Base.connection.execute("DROP SEQUENCE #{seq}") <br /> ActiveRecord::Base.connection.execute("CREATE SEQUENCE #{seq} START WITH #{count+1}") <br /> rescue => ex <br /> puts "Failed for #{table} with #{ex.class}" <br /> end <br /> end <br /> end <br />end <br /></code> Mon, 20 Nov 2006 07:22:13 GMT http://snippets.dzone.com/posts/show/3021 dcmanges (Dan Manges)