Skip to content

Instantly share code, notes, and snippets.

@phistep
Last active December 14, 2015 02:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save phistep/5018106 to your computer and use it in GitHub Desktop.
Save phistep/5018106 to your computer and use it in GitHub Desktop.
Small script to migrate the database of [omilia](https://github.com/Ps0ke/omilia) from v1.0.0 to v1.1.0. It can easily be run directly from gist: $ ruby -e "$(curl https://gist.github.com/Ps0ke/5018106/raw/)"
require 'net/http'
require 'cgi'
require 'json'
require 'data_mapper'
require './models/dataset'
require './models/user'
def set foo, bar
true
end
require './config'
DataMapper.finalize.auto_upgrade!
Dataset.all.each do |dataset|
skip = nil
response = Net::HTTP.get(URI("http://imdbapi.poromenos.org/json/?name=#{CGI.escape(dataset.name)}"))
if response != 'null'
result = JSON.parse response
if result.keys.first != 'shows'
year = result[result.keys.first]['year']
update = dataset.update( :year => year )
if update
puts "Auto-update: '#{dataset.name}' to #{year}"
else
puts "Error: auto-update failed for '#{dataset.name}'"
end
else
puts "Skipping auto-update of '#{dataset.name}'"
end
else
puts "Skipping auto-update of '#{dataset.name}'"
end
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment