test/dummy/log/test.log in ip_to_country-0.0.3 vs test/dummy/log/test.log in ip_to_country-0.1.0
- old
+ new
@@ -3769,5 +3769,552 @@
from geoips where ip_to >= 3232235778)) LIMIT 1
[1m[36mIpToCountry::Geoip Load (0.8ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
from geoips where ip_to >= 3232235778)) LIMIT 1[0m
[1m[35mIpToCountry::Geoip Load (0.8ms)[0m SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
from geoips where ip_to >= 3232235778)) LIMIT 1
+Connecting to database specified by database.yml
+Connecting to database specified by database.yml
+ [1m[36m (0.5ms)[0m [1mSELECT "schema_migrations"."version" FROM "schema_migrations" [0m
+Migrating to CreateGeoips (1)
+Unable to load geoip, underlying cause No such file to load -- geoip
+
+ /home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:317:in `rescue in depend_on'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:312:in `depend_on'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:225:in `require_dependency'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:767:in `try_to_load_dependency'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:782:in `block in require_fixture_classes'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `each'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `require_fixture_classes'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:762:in `fixtures'
+/home/vince/Projets/ip_to_country/test/test_helper.rb:32:in `<class:TestCase>'
+/home/vince/Projets/ip_to_country/test/test_helper.rb:29:in `<top (required)>'
+/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `require'
+/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `<top (required)>'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `require'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `block (2 levels) in <main>'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `each'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `block in <main>'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `select'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `<main>'
+ [1m[35m (0.4ms)[0m ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "geoips" DISABLE TRIGGER ALL
+ [1m[36m (0.2ms)[0m [1mBEGIN[0m
+ [1m[35mFixture Delete (0.8ms)[0m DELETE FROM "geoips"
+ [1m[36mFixture Insert (0.6ms)[0m [1mINSERT INTO "geoips" ("ip_from_string", "ip_to_string", "ip_from", "ip_to", "country_code", "country_name") VALUES ('192.168.1.1', '192.168.1.20', 3232235777, 3232235794, 'wd', 'wonderland')[0m
+ [1m[35m (22.0ms)[0m COMMIT
+ [1m[36m (0.6ms)[0m [1mALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "geoips" ENABLE TRIGGER ALL[0m
+ [1m[35m (0.2ms)[0m BEGIN
+ [1m[36mIpToCountry::Geoip Load (1.2ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35m (0.2ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (66.6ms)[0m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+
+ [1m[36m (0.8ms)[0m [1mROLLBACK[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36m (0.1ms)[0m [1mROLLBACK[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36m (61.0ms)[0m [1m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+[0m
+ [1m[35m (1.9ms)[0m ALTER TABLE geoips RENAME TO tmp;
+ ALTER TABLE geoips_tempo RENAME TO geoips;
+ ALTER TABLE tmp RENAME TO geoips_tempo;
+ DROP TABLE geoips_tempo;
+
+ [1m[36mIpToCountry::Geoip Load (0.9ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 35037184) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 35037184)) LIMIT 1[0m
+ [1m[35m (0.8ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.2ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (22.7ms)[0m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+
+ [1m[36m (1.5ms)[0m [1m ALTER TABLE geoips RENAME TO tmp;
+ ALTER TABLE geoips_tempo RENAME TO geoips;
+ ALTER TABLE tmp RENAME TO geoips_tempo;
+ DROP TABLE geoips_tempo;
+[0m
+ [1m[35m (0.8ms)[0m ROLLBACK
+ [1m[36mIpToCountry::Geoip Load (2.3ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35mIpToCountry::Geoip Load (1.9ms)[0m SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1
+ [1m[36mIpToCountry::Geoip Load (0.8ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35mIpToCountry::Geoip Load (0.9ms)[0m SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1
+Connecting to database specified by database.yml
+ [1m[36m (0.3ms)[0m [1mSELECT "schema_migrations"."version" FROM "schema_migrations" [0m
+Migrating to CreateGeoips (1)
+Unable to load geoip, underlying cause No such file to load -- geoip
+
+ /home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:317:in `rescue in depend_on'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:312:in `depend_on'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:225:in `require_dependency'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:767:in `try_to_load_dependency'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:782:in `block in require_fixture_classes'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `each'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `require_fixture_classes'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:762:in `fixtures'
+/home/vince/Projets/ip_to_country/test/test_helper.rb:28:in `<class:TestCase>'
+/home/vince/Projets/ip_to_country/test/test_helper.rb:25:in `<top (required)>'
+/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `require'
+/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `<top (required)>'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `require'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `block (2 levels) in <main>'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `each'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `block in <main>'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `select'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `<main>'
+ [1m[35m (0.4ms)[0m ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "geoips" DISABLE TRIGGER ALL
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35mFixture Delete (0.7ms)[0m DELETE FROM "geoips"
+ [1m[36mFixture Insert (0.6ms)[0m [1mINSERT INTO "geoips" ("ip_from_string", "ip_to_string", "ip_from", "ip_to", "country_code", "country_name") VALUES ('192.168.1.1', '192.168.1.20', 3232235777, 3232235794, 'wd', 'wonderland')[0m
+ [1m[35m (14.4ms)[0m COMMIT
+ [1m[36m (0.2ms)[0m [1mALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "geoips" ENABLE TRIGGER ALL[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36mIpToCountry::Geoip Load (1.2ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35m (0.2ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (48.6ms)[0m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+
+ [1m[36m (1.1ms)[0m [1mROLLBACK[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36m (0.1ms)[0m [1mROLLBACK[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36m (37.5ms)[0m [1m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+[0m
+ [1m[35m (2.1ms)[0m ALTER TABLE geoips RENAME TO tmp;
+ ALTER TABLE geoips_tempo RENAME TO geoips;
+ ALTER TABLE tmp RENAME TO geoips_tempo;
+ DROP TABLE geoips_tempo;
+
+ [1m[36mIpToCountry::Geoip Load (1.1ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 35037184) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 35037184)) LIMIT 1[0m
+ [1m[35m (0.7ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (22.9ms)[0m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+
+ [1m[36m (1.5ms)[0m [1m ALTER TABLE geoips RENAME TO tmp;
+ ALTER TABLE geoips_tempo RENAME TO geoips;
+ ALTER TABLE tmp RENAME TO geoips_tempo;
+ DROP TABLE geoips_tempo;
+[0m
+ [1m[35m (0.9ms)[0m ROLLBACK
+ [1m[36mIpToCountry::Geoip Load (12.7ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35mIpToCountry::Geoip Load (0.9ms)[0m SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1
+ [1m[36mIpToCountry::Geoip Load (0.9ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35mIpToCountry::Geoip Load (0.8ms)[0m SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1
+Connecting to database specified by database.yml
+ [1m[36m (6.9ms)[0m [1mSELECT "schema_migrations"."version" FROM "schema_migrations" [0m
+Migrating to CreateGeoips (1)
+Unable to load geoip, underlying cause No such file to load -- geoip
+
+ /home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:317:in `rescue in depend_on'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:312:in `depend_on'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:225:in `require_dependency'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:767:in `try_to_load_dependency'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:782:in `block in require_fixture_classes'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `each'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `require_fixture_classes'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:762:in `fixtures'
+/home/vince/Projets/ip_to_country/test/test_helper.rb:28:in `<class:TestCase>'
+/home/vince/Projets/ip_to_country/test/test_helper.rb:25:in `<top (required)>'
+/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `require'
+/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `<top (required)>'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `require'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `block (2 levels) in <main>'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `each'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `block in <main>'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `select'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `<main>'
+ [1m[35m (9.4ms)[0m ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "geoips" DISABLE TRIGGER ALL
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35mFixture Delete (22.6ms)[0m DELETE FROM "geoips"
+ [1m[36mFixture Insert (55.1ms)[0m [1mINSERT INTO "geoips" ("ip_from_string", "ip_to_string", "ip_from", "ip_to", "country_code", "country_name") VALUES ('192.168.1.1', '192.168.1.20', 3232235777, 3232235794, 'wd', 'wonderland')[0m
+ [1m[35m (87.3ms)[0m COMMIT
+ [1m[36m (0.3ms)[0m [1mALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "geoips" ENABLE TRIGGER ALL[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36mIpToCountry::Geoip Load (17.3ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35m (0.2ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.2ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (236.1ms)[0m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+
+ [1m[36m (0.6ms)[0m [1mROLLBACK[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36m (0.1ms)[0m [1mROLLBACK[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36m (26.8ms)[0m [1m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+[0m
+ [1m[35m (32.8ms)[0m ALTER TABLE geoips RENAME TO tmp;
+ ALTER TABLE geoips_tempo RENAME TO geoips;
+ ALTER TABLE tmp RENAME TO geoips_tempo;
+ DROP TABLE geoips_tempo;
+
+ [1m[36mIpToCountry::Geoip Load (0.8ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 35037184) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 35037184)) LIMIT 1[0m
+ [1m[35m (0.7ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.2ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (125.5ms)[0m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+
+ [1m[36m (1.3ms)[0m [1m ALTER TABLE geoips RENAME TO tmp;
+ ALTER TABLE geoips_tempo RENAME TO geoips;
+ ALTER TABLE tmp RENAME TO geoips_tempo;
+ DROP TABLE geoips_tempo;
+[0m
+ [1m[35m (0.7ms)[0m ROLLBACK
+ [1m[36mIpToCountry::Geoip Load (5.8ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35mIpToCountry::Geoip Load (0.7ms)[0m SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1
+ [1m[36mIpToCountry::Geoip Load (0.8ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35mIpToCountry::Geoip Load (1.3ms)[0m SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1
+Connecting to database specified by database.yml
+ [1m[36m (0.5ms)[0m [1mSELECT "schema_migrations"."version" FROM "schema_migrations" [0m
+Migrating to CreateGeoips (1)
+Unable to load geoip, underlying cause No such file to load -- geoip
+
+ /home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:317:in `rescue in depend_on'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:312:in `depend_on'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:225:in `require_dependency'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:767:in `try_to_load_dependency'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:782:in `block in require_fixture_classes'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `each'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `require_fixture_classes'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:762:in `fixtures'
+/home/vince/Projets/ip_to_country/test/test_helper.rb:28:in `<class:TestCase>'
+/home/vince/Projets/ip_to_country/test/test_helper.rb:25:in `<top (required)>'
+/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `require'
+/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `<top (required)>'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `require'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `block (2 levels) in <main>'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `each'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `block in <main>'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `select'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `<main>'
+ [1m[35m (29.3ms)[0m ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "geoips" DISABLE TRIGGER ALL
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35mFixture Delete (0.6ms)[0m DELETE FROM "geoips"
+ [1m[36mFixture Insert (0.5ms)[0m [1mINSERT INTO "geoips" ("ip_from_string", "ip_to_string", "ip_from", "ip_to", "country_code", "country_name") VALUES ('192.168.1.1', '192.168.1.20', 3232235777, 3232235794, 'wd', 'wonderland')[0m
+ [1m[35m (18.5ms)[0m COMMIT
+ [1m[36m (0.3ms)[0m [1mALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "geoips" ENABLE TRIGGER ALL[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36mIpToCountry::Geoip Load (35.6ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35m (0.2ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (74.7ms)[0m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+
+ [1m[36m (0.6ms)[0m [1mROLLBACK[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36m (0.1ms)[0m [1mROLLBACK[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36m (37.1ms)[0m [1m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+[0m
+ [1m[35m (1.9ms)[0m ALTER TABLE geoips RENAME TO tmp;
+ ALTER TABLE geoips_tempo RENAME TO geoips;
+ ALTER TABLE tmp RENAME TO geoips_tempo;
+ DROP TABLE geoips_tempo;
+
+ [1m[36mIpToCountry::Geoip Load (1.4ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 35037184) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 35037184)) LIMIT 1[0m
+ [1m[35m (1.2ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.2ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (16.8ms)[0m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+
+ [1m[36m (2.4ms)[0m [1m ALTER TABLE geoips RENAME TO tmp;
+ ALTER TABLE geoips_tempo RENAME TO geoips;
+ ALTER TABLE tmp RENAME TO geoips_tempo;
+ DROP TABLE geoips_tempo;
+[0m
+ [1m[35m (0.9ms)[0m ROLLBACK
+ [1m[36mIpToCountry::Geoip Load (14.0ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35mIpToCountry::Geoip Load (0.9ms)[0m SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1
+ [1m[36mIpToCountry::Geoip Load (0.7ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35mIpToCountry::Geoip Load (0.7ms)[0m SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1
+Connecting to database specified by database.yml
+ [1m[36m (7.4ms)[0m [1mSELECT "schema_migrations"."version" FROM "schema_migrations" [0m
+Migrating to CreateGeoips (1)
+Unable to load geoip, underlying cause No such file to load -- geoip
+
+ /home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:317:in `rescue in depend_on'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:312:in `depend_on'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:225:in `require_dependency'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:767:in `try_to_load_dependency'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:782:in `block in require_fixture_classes'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `each'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `require_fixture_classes'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:762:in `fixtures'
+/home/vince/Projets/ip_to_country/test/test_helper.rb:28:in `<class:TestCase>'
+/home/vince/Projets/ip_to_country/test/test_helper.rb:25:in `<top (required)>'
+/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `require'
+/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `<top (required)>'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `require'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `block (2 levels) in <main>'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `each'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `block in <main>'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `select'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `<main>'
+ [1m[35m (9.4ms)[0m ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "geoips" DISABLE TRIGGER ALL
+ [1m[36m (0.2ms)[0m [1mBEGIN[0m
+ [1m[35mFixture Delete (10.6ms)[0m DELETE FROM "geoips"
+ [1m[36mFixture Insert (71.1ms)[0m [1mINSERT INTO "geoips" ("ip_from_string", "ip_to_string", "ip_from", "ip_to", "country_code", "country_name") VALUES ('192.168.1.1', '192.168.1.20', 3232235777, 3232235794, 'wd', 'wonderland')[0m
+ [1m[35m (90.0ms)[0m COMMIT
+ [1m[36m (0.3ms)[0m [1mALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "geoips" ENABLE TRIGGER ALL[0m
+ [1m[35m (0.2ms)[0m BEGIN
+ [1m[36mIpToCountry::Geoip Load (21.3ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35m (0.2ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (209.1ms)[0m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+
+ [1m[36m (1.2ms)[0m [1mROLLBACK[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36m (0.2ms)[0m [1mROLLBACK[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36m (24.7ms)[0m [1m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+[0m
+ [1m[35m (53.3ms)[0m ALTER TABLE geoips RENAME TO tmp;
+ ALTER TABLE geoips_tempo RENAME TO geoips;
+ ALTER TABLE tmp RENAME TO geoips_tempo;
+ DROP TABLE geoips_tempo;
+
+ [1m[36mIpToCountry::Geoip Load (1.3ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 35037184) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 35037184)) LIMIT 1[0m
+ [1m[35m (1.3ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.2ms)[0m ROLLBACK
+ [1m[36m (0.2ms)[0m [1mBEGIN[0m
+ [1m[35m (23.2ms)[0m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+
+ [1m[36m (2.5ms)[0m [1m ALTER TABLE geoips RENAME TO tmp;
+ ALTER TABLE geoips_tempo RENAME TO geoips;
+ ALTER TABLE tmp RENAME TO geoips_tempo;
+ DROP TABLE geoips_tempo;
+[0m
+ [1m[35m (1.0ms)[0m ROLLBACK
+ [1m[36mIpToCountry::Geoip Load (1.8ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35mIpToCountry::Geoip Load (1.2ms)[0m SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1
+ [1m[36mIpToCountry::Geoip Load (1.2ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35mIpToCountry::Geoip Load (1.2ms)[0m SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1
+Connecting to database specified by database.yml
+ [1m[36m (0.4ms)[0m [1mSELECT "schema_migrations"."version" FROM "schema_migrations" [0m
+Migrating to CreateGeoips (1)
+Unable to load geoip, underlying cause No such file to load -- geoip
+
+ /home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:317:in `rescue in depend_on'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:312:in `depend_on'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:225:in `require_dependency'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:767:in `try_to_load_dependency'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:782:in `block in require_fixture_classes'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `each'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `require_fixture_classes'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:762:in `fixtures'
+/home/vince/Projets/ip_to_country/test/test_helper.rb:28:in `<class:TestCase>'
+/home/vince/Projets/ip_to_country/test/test_helper.rb:25:in `<top (required)>'
+/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `require'
+/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `<top (required)>'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `require'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `block (2 levels) in <main>'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `each'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `block in <main>'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `select'
+/home/vince/.rvm/gems/ruby-1.9.3-head/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `<main>'
+ [1m[35m (0.3ms)[0m ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "geoips" DISABLE TRIGGER ALL
+ [1m[36m (0.2ms)[0m [1mBEGIN[0m
+ [1m[35mFixture Delete (0.4ms)[0m DELETE FROM "geoips"
+ [1m[36mFixture Insert (0.5ms)[0m [1mINSERT INTO "geoips" ("ip_from_string", "ip_to_string", "ip_from", "ip_to", "country_code", "country_name") VALUES ('192.168.1.1', '192.168.1.20', 3232235777, 3232235794, 'wd', 'wonderland')[0m
+ [1m[35m (15.3ms)[0m COMMIT
+ [1m[36m (0.1ms)[0m [1mALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "geoips" ENABLE TRIGGER ALL[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36mIpToCountry::Geoip Load (1.2ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35m (0.2ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (32.7ms)[0m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+
+ [1m[36m (0.6ms)[0m [1mROLLBACK[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36m (0.1ms)[0m [1mROLLBACK[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36m (17.6ms)[0m [1m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+[0m
+ [1m[35m (1.6ms)[0m ALTER TABLE geoips RENAME TO tmp;
+ ALTER TABLE geoips_tempo RENAME TO geoips;
+ ALTER TABLE tmp RENAME TO geoips_tempo;
+ DROP TABLE geoips_tempo;
+
+ [1m[36mIpToCountry::Geoip Load (0.9ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 35037184) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 35037184)) LIMIT 1[0m
+ [1m[35m (0.7ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (24.0ms)[0m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+
+ [1m[36m (1.9ms)[0m [1m ALTER TABLE geoips RENAME TO tmp;
+ ALTER TABLE geoips_tempo RENAME TO geoips;
+ ALTER TABLE tmp RENAME TO geoips_tempo;
+ DROP TABLE geoips_tempo;
+[0m
+ [1m[35m (0.8ms)[0m ROLLBACK
+ [1m[36mIpToCountry::Geoip Load (14.7ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35mIpToCountry::Geoip Load (0.7ms)[0m SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1
+ [1m[36mIpToCountry::Geoip Load (0.8ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35mIpToCountry::Geoip Load (1.2ms)[0m SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1
+Connecting to database specified by database.yml
+ [1m[36m (0.6ms)[0m [1mSELECT "schema_migrations"."version" FROM "schema_migrations" [0m
+Migrating to CreateGeoips (1)
+Unable to load geoip, underlying cause No such file to load -- geoip
+
+ /home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:317:in `rescue in depend_on'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:312:in `depend_on'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activesupport-3.2.13/lib/active_support/dependencies.rb:225:in `require_dependency'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:767:in `try_to_load_dependency'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:782:in `block in require_fixture_classes'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `each'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:779:in `require_fixture_classes'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/activerecord-3.2.13/lib/active_record/fixtures.rb:762:in `fixtures'
+/home/vince/Projets/ip_to_country/test/test_helper.rb:28:in `<class:TestCase>'
+/home/vince/Projets/ip_to_country/test/test_helper.rb:25:in `<top (required)>'
+/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `require'
+/home/vince/Projets/ip_to_country/test/geoip_test.rb:2:in `<top (required)>'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `require'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:10:in `block (2 levels) in <main>'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `each'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:9:in `block in <main>'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `select'
+/home/vince/.rvm/gems/ruby-2.0.0-p0/gems/rake-10.0.4/lib/rake/rake_test_loader.rb:4:in `<main>'
+ [1m[35m (0.3ms)[0m ALTER TABLE "schema_migrations" DISABLE TRIGGER ALL;ALTER TABLE "geoips" DISABLE TRIGGER ALL
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35mFixture Delete (0.5ms)[0m DELETE FROM "geoips"
+ [1m[36mFixture Insert (0.5ms)[0m [1mINSERT INTO "geoips" ("ip_from_string", "ip_to_string", "ip_from", "ip_to", "country_code", "country_name") VALUES ('192.168.1.1', '192.168.1.20', 3232235777, 3232235794, 'wd', 'wonderland')[0m
+ [1m[35m (22.9ms)[0m COMMIT
+ [1m[36m (0.2ms)[0m [1mALTER TABLE "schema_migrations" ENABLE TRIGGER ALL;ALTER TABLE "geoips" ENABLE TRIGGER ALL[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36mIpToCountry::Geoip Load (2.1ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35m (0.3ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.1ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (31.9ms)[0m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+
+ [1m[36m (0.7ms)[0m [1mROLLBACK[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36m (0.2ms)[0m [1mROLLBACK[0m
+ [1m[35m (0.1ms)[0m BEGIN
+ [1m[36m (15.4ms)[0m [1m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+[0m
+ [1m[35m (1.5ms)[0m ALTER TABLE geoips RENAME TO tmp;
+ ALTER TABLE geoips_tempo RENAME TO geoips;
+ ALTER TABLE tmp RENAME TO geoips_tempo;
+ DROP TABLE geoips_tempo;
+
+ [1m[36mIpToCountry::Geoip Load (0.8ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 35037184) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 35037184)) LIMIT 1[0m
+ [1m[35m (0.6ms)[0m ROLLBACK
+ [1m[36m (0.1ms)[0m [1mBEGIN[0m
+ [1m[35m (0.2ms)[0m ROLLBACK
+ [1m[36m (0.2ms)[0m [1mBEGIN[0m
+ [1m[35m (40.7ms)[0m DROP TABLE IF EXISTS geoips_tempo;
+ CREATE TABLE geoips_tempo AS SELECT * FROM geoips WHERE ip_from = -1;
+
+ [1m[36m (2.0ms)[0m [1m ALTER TABLE geoips RENAME TO tmp;
+ ALTER TABLE geoips_tempo RENAME TO geoips;
+ ALTER TABLE tmp RENAME TO geoips_tempo;
+ DROP TABLE geoips_tempo;
+[0m
+ [1m[35m (1.3ms)[0m ROLLBACK
+ [1m[36mIpToCountry::Geoip Load (16.6ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35mIpToCountry::Geoip Load (1.3ms)[0m SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1
+ [1m[36mIpToCountry::Geoip Load (1.2ms)[0m [1mSELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1[0m
+ [1m[35mIpToCountry::Geoip Load (1.2ms)[0m SELECT "geoips".* FROM "geoips" WHERE (ip_from = (select max(ip_from) from geoips where ip_from <= 3232235778) and ip_to = (select min(ip_to)
+ from geoips where ip_to >= 3232235778)) LIMIT 1