mzagaja
commented
3 years ago Can you post the Rails log from the development submission? Specifically the section that looks like:
Started POST "/developments" for ::1 at 2021-03-22 11:16:58 -0400
Processing by DevelopmentsController#create as JSONAPI
Parameters: {"data"=>{"attributes"=>{"name"=>"Test with MEPA ID", "status"=>"planning", "descr"=>"Test", "prj_url"=>nil, "tagline"=>nil, "nhood"=>nil, "address"=>nil, "state"=>"MA", "zip_code"=>nil, "park_type"=>nil, "parcel_id"=>nil, "municipal"=>nil, "devlper"=>nil, "traffic_count_data"=>"https://www.google.com/", "height"=>nil, "stories"=>nil, "year_compl"=>2030, "prjarea"=>nil, "singfamhu"=>0, "smmultifam"=>0, "lgmultifam"=>0, "unknownhu"=>nil, "hu"=>0, "gqpop"=>nil, "rptdemp"=>nil, "commsf"=>0, "hotelrms"=>0, "onsitepark"=>nil, "total_cost"=>nil, "ret_sqft"=>0, "ofcmd_sqft"=>0, "indmf_sqft"=>0, "whs_sqft"=>0, "rnd_sqft"=>0, "ei_sqft"=>0, "other_sqft"=>0, "hotel_sqft"=>0, "unk_sqft"=>0, "latitude"=>42.365871579965614, "longitude"=>-71.09295709889464, "units_1bd"=>nil, "units_2bd"=>nil, "units_3bd"=>nil, "affrd_unit"=>nil, "aff_u30"=>nil, "aff_30_50"=>nil, "aff_50_80"=>nil, "aff_80p"=>nil, "aff_unknown"=>nil, "publicsqft"=>0, "mepa_id"=>123456, "rdv"=>false, "asofright"=>false, "ovr55"=>false, "clusteros"=>false, "phased"=>false, "stalled"=>false, "headqtrs"=>false, "mixed_use"=>false, "yrcomp_est"=>false, "flag"=>false, "created_at"=>nil, "updated_at"=>nil}, "relationships"=>{"user"=>{"data"=>{"type"=>"users", "id"=>"261"}}}, "type"=>"developments"}}
User Load (0.5ms) SELECT "users".* FROM "users" WHERE "users"."email" = $1 LIMIT $2 [["email", "mzagaja@mapc.org"], ["LIMIT", 1]]
(0.1ms) BEGIN
SQL (0.4ms) UPDATE "users" SET "current_sign_in_at" = $1, "last_sign_in_at" = $2, "sign_in_count" = $3, "updated_at" = $4 WHERE "users"."id" = $5 [["current_sign_in_at", "2021-03-22 15:16:58.928767"], ["last_sign_in_at", "2021-03-22 15:13:35.452357"], ["sign_in_count", 17465], ["updated_at", "2021-03-22 15:16:58.929240"], ["id", 261]]
(0.3ms) COMMIT
(0.2ms) BEGIN
SQL (7.7ms) INSERT INTO "developments" ("user_id", "rdv", "asofright", "ovr55", "clusteros", "phased", "stalled", "name", "status", "descr", "year_compl", "singfamhu", "smmultifam", "lgmultifam", "hu", "commsf", "hotelrms", "ret_sqft", "ofcmd_sqft", "indmf_sqft", "whs_sqft", "rnd_sqft", "ei_sqft", "other_sqft", "hotel_sqft", "latitude", "longitude", "mixed_use", "point", "created_at", "updated_at", "yrcomp_est", "headqtrs", "publicsqft", "unk_sqft", "mepa_id", "traffic_count_data", "mepa_id_present", "traffic_count_data_present") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39) RETURNING "id" [["user_id", 261], ["rdv", "f"], ["asofright", "f"], ["ovr55", "f"], ["clusteros", "f"], ["phased", "f"], ["stalled", "f"], ["name", "Test with MEPA ID"], ["status", "planning"], ["descr", "Test"], ["year_compl", 2030], ["singfamhu", 0], ["smmultifam", 0], ["lgmultifam", 0], ["hu", 0], ["commsf", 0], ["hotelrms", 0], ["ret_sqft", 0.0], ["ofcmd_sqft", 0.0], ["indmf_sqft", 0.0], ["whs_sqft", 0.0], ["rnd_sqft", 0.0], ["ei_sqft", 0.0], ["other_sqft", 0.0], ["hotel_sqft", 0.0], ["latitude", "42.3658715799656"], ["longitude", "-71.0929570988946"], ["mixed_use", "f"], ["point", "0020000001000010e6c051c5f30254ebbc40452ed4e1433e7a"], ["created_at", "2021-03-22 15:16:58.936568"], ["updated_at", "2021-03-22 15:16:58.936568"], ["yrcomp_est", "f"], ["headqtrs", "f"], ["publicsqft", 0], ["unk_sqft", 0], ["mepa_id", 123456], ["traffic_count_data", "https://www.google.com/"], ["mepa_id_present", "t"], ["traffic_count_data_present", "t"]]
atomtay
Resolves # 308.
Why is this change necessary?
We want to add MEPA ID and Traffic Count Data fields to the development model.
How does it address the issue?
It does this, along with adding filters, and as a bonus we update our migrations to point to the correct (latest) DB server as well.