ActiveRecord::Base.connection.tables.each do |table|
result = ActiveRecord::Base.connection.execute("SELECT id FROM #{table} ORDER BY id DESC LIMIT 1") rescue ( puts "Warning: not procesing table #{table}. Id is missing?" ; next )
ai_val = result.any? ? result.first['id'].to_i + 1 : 1
puts "Resetting auto increment ID for #{table} to #{ai_val}"
ActiveRecord::Base.connection.execute("ALTER SEQUENCE #{table}_id_seq RESTART WITH #{ai_val}")
endArquivo da categoria: Banco de Dados
Wiring Up A Firestore Database to jQuery App
Flutter: Login App using REST API and SQFLite
Exemplos com MongoDB
How to install Apache, MySQL, PHP on macOS Mojave 10.14
How to reset PG Database on Heroku?
How to reset PG Database on Heroku?
- Step 1:
heroku restart - Step 2:
heroku pg:reset DATABASE(no need to change theDATABASE) - Step 3:
heroku run rake db:migrate - Step 4:
heroku run rake db:seed(if you have seed)
One liner
heroku restart; heroku pg:reset DATABASE --confirm APP-NAME; heroku run rake db:migrate
Note 1
Heroku doesn’t allow users from using rake db:reset, rake db:drop and rake db:create command. They only allow heroku pg:reset and rake db:migrate commands.
More info: https://devcenter.heroku.com/articles/rake
Note 2
If you have more than 1 remote, append --remote [your_remote_name] like this:
heroku run rake db:migrate --remote dev (dev is example remote here)