API tools faq
paste
Guest User

Untitled

a guest
Apr 21st, 2018
113
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.47 KB | None | 0 0
raw download clone embed print report
  1. merb -i
  2. ~ Loaded DEVELOPMENT Environment...
  3. ~ loading gem 'merb_datamapper' from ...
  4. ~ Connecting to database...
  5. D, [2008-05-03T17:03:49.285756 #8140] DEBUG -- : SELECT "name" FROM "sqlite_master" WHERE "type" = "table" AND "name" = 'photos'
  6. D, [2008-05-03T17:03:49.289698 #8140] DEBUG -- : CREATE TABLE "photos" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "filename" TEXT)
  7. D, [2008-05-03T17:03:49.376383 #8140] DEBUG -- : SELECT "name" FROM "sqlite_master" WHERE "type" = "table" AND "name" = 'listings'
  8. D, [2008-05-03T17:03:49.377804 #8140] DEBUG -- : CREATE TABLE "listings" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" TEXT, "description" TEXT, "sqft" TEXT, "type" TEXT, "term" TEXT, "address" TEXT)
  9. D, [2008-05-03T17:03:49.451093 #8140] DEBUG -- : SELECT "name" FROM "sqlite_master" WHERE "type" = "table" AND "name" = 'districts'
  10. D, [2008-05-03T17:03:49.452196 #8140] DEBUG -- : CREATE TABLE "districts" ("id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "name" TEXT, "number" INTEGER)
  11. ~ Compiling routes...
  12. ~ Using 'share-nothing' cookie sessions (4kb limit per client)
  13. irb(main):001:0> l=Listing.create({:type=>'test',:sqft=>'test',:term=>'test',:name=>'test2',:description=>'Testing............ .................... ................. ............ ........', :address=>'test'})
  14. D, [2008-05-03T17:03:50.755414 #8140] DEBUG -- : INSERT INTO "listings" ("type", "sqft", "term", "name", "address", "description") VALUES ('Listing', 'test', 'test', 'test2', 'test', 'Testing............ .................... ................. ............ ........')
  15. => #<Listing:0x..fb62f261c @new_record=false, @type="Listing", @sqft="test", @term="test", @name="test2", @district_id=nil, @description="Testing............ .................... ................. ............ ........", @address="test", @id=1>
  16. irb(main):002:0>
  17. irb(main):003:0* l2=Listing.create({:type=>'test',:sqft=>'test',:term=>'test',:name=>'test2',:description=>'Testing............ .................... ................. ............ ........', :address=>'test'})
  18. D, [2008-05-03T17:03:50.844359 #8140] DEBUG -- : INSERT INTO "listings" ("type", "sqft", "term", "name", "address", "description") VALUES ('Listing', 'test', 'test', 'test2', 'test', 'Testing............ .................... ................. ............ ........')
  19. => #<Listing:0x..fb62e6bb4 @new_record=false, @type="Listing", @sqft="test", @term="test", @name="test2", @district_id=nil, @description="Testing............ .................... ................. ............ ........", @address="test", @id=2>
  20. irb(main):004:0>
  21. irb(main):005:0* d=District.create({:name=>"South Beach",:number=>"2"})
  22. D, [2008-05-03T17:03:50.896867 #8140] DEBUG -- : INSERT INTO "districts" ("number", "name") VALUES ('2', 'South Beach')
  23. => #<District:0x..fb62e1358 @new_record=false, @number="2", @name="South Beach", @id=1>
  24. irb(main):006:0>
  25. irb(main):007:0* d.listings << l
  26. => [#<Listing:0x..fb62f261c @new_record=false, @type="Listing", @sqft="test", @term="test", @name="test2", @district_id=1, @description="Testing............ .................... ................. ............ ........", @address="test", @id=1>]
  27. irb(main):008:0> d.listings << l2
  28. => [#<Listing:0x..fb62f261c @new_record=false, @type="Listing", @sqft="test", @term="test", @name="test2", @district_id=1, @description="Testing............ .................... ................. ............ ........", @address="test", @id=1>, #<Listing:0x..fb62e6bb4 @new_record=false, @type="Listing", @sqft="test", @term="test", @name="test2", @district_id=1, @description="Testing............ .................... ................. ............ ........", @address="test", @id=2>]
  29. irb(main):009:0>
  30. irb(main):010:0* d.save
  31. D, [2008-05-03T17:03:50.963269 #8140] DEBUG -- : UPDATE "listings" SET "district_id" = NULL WHERE "district_id" = 1 AND id NOT IN (1, 2)
  32. E, [2008-05-03T17:03:50.964065 #8140] ERROR -- : Your query failed.
  33. no such column: district_id
  34. QUERY: "UPDATE "listings" SET "district_id" = NULL WHERE "district_id" = 1 AND id NOT IN (1, 2)" (DataObject::QueryError)
  35. /usr/local/lib/ruby/gems/1.8/gems/do_sqlite3-0.2.3/lib/do_sqlite3.rb:143:in `execute_non_query'
  36. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/associations/has_many_association.rb:87:in `save_without_validation'
  37. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/adapters/data_object_adapter.rb:82:in `connection'
  38. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/support/connection_pool.rb:67:in `hold'
  39. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/adapters/data_object_adapter.rb:82:in `connection'
  40. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/associations/has_many_association.rb:75:in `save_without_validation'
  41. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/adapters/data_object_adapter.rb:230:in `save'
  42. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/adapters/data_object_adapter.rb:229:in `each'
  43. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/adapters/data_object_adapter.rb:229:in `save'
  44. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/context.rb:60:in `save'
  45. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/persistence.rb:151:in `save'
  46. (irb):10:in `irb_binding'
  47. /usr/local/lib/ruby/1.8/irb/workspace.rb:52:in `irb_binding'
  48. /usr/local/lib/ruby/1.8/irb/workspace.rb:52
  49. E, [2008-05-03T17:03:50.968259 #8140] ERROR -- : Your query failed.
  50. no such column: district_id
  51. QUERY: "UPDATE "listings" SET "district_id" = NULL WHERE "district_id" = 1 AND id NOT IN (1, 2)" (DataObject::QueryError)
  52. /usr/local/lib/ruby/gems/1.8/gems/do_sqlite3-0.2.3/lib/do_sqlite3.rb:143:in `execute_non_query'
  53. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/associations/has_many_association.rb:87:in `save_without_validation'
  54. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/adapters/data_object_adapter.rb:82:in `connection'
  55. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/support/connection_pool.rb:67:in `hold'
  56. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/adapters/data_object_adapter.rb:82:in `connection'
  57. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/associations/has_many_association.rb:75:in `save_without_validation'
  58. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/adapters/data_object_adapter.rb:230:in `save'
  59. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/adapters/data_object_adapter.rb:229:in `each'
  60. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/adapters/data_object_adapter.rb:229:in `save'
  61. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/context.rb:60:in `save'
  62. /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/persistence.rb:151:in `save'
  63. (irb):10:in `irb_binding'
  64. /usr/local/lib/ruby/1.8/irb/workspace.rb:52:in `irb_binding'
  65. /usr/local/lib/ruby/1.8/irb/workspace.rb:52
  66. DataObject::QueryError: Your query failed.
  67. no such column: district_id
  68. QUERY: "UPDATE "listings" SET "district_id" = NULL WHERE "district_id" = 1 AND id NOT IN (1, 2)"
  69. from /usr/local/lib/ruby/gems/1.8/gems/do_sqlite3-0.2.3/lib/do_sqlite3.rb:143:in `execute_non_query'
  70. from /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/associations/has_many_association.rb:87:in `save_without_validation'
  71. from /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/adapters/data_object_adapter.rb:82:in `connection'
  72. from /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/support/connection_pool.rb:67:in `hold'
  73. from /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/adapters/data_object_adapter.rb:82:in `connection'
  74. from /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/associations/has_many_association.rb:75:in `save_without_validation'
  75. from /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/adapters/data_object_adapter.rb:230:in `save'
  76. from /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/adapters/data_object_adapter.rb:229:in `each'
  77. from /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/adapters/data_object_adapter.rb:229:in `save'
  78. from /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/context.rb:60:in `save'
  79. from /usr/local/lib/ruby/gems/1.8/gems/datamapper-0.3.0/lib/data_mapper/persistence.rb:151:in `save'
  80. from (irb):10
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!