Owen - just saw your 'posted on wrong thread' note. I guess you can disregard the schema etc. I put up a minute ago ...
On Jun 15, 6:36 am, Ronbo <[email protected]> wrote: > Hi Owen, > > At the moment, there are only a handful of 'units' (less than 10), 3 > activities, and one project for dev purposes. The indexing is the > default applied by hobo. I don't see a way to attach files to posts, > so the schema is inline here: > > # This file is auto-generated from the current state of the database. > Instead of editing this file, > # please use the migrations feature of Active Record to incrementally > modify your database, and > # then regenerate this schema definition. > # > # Note that this schema.rb definition is the authoritative source for > your database schema. If you need > # to create the application database on another system, you should be > using db:schema:load, not running > # all the migrations from scratch. The latter is a flawed and > unsustainable approach (the more migrations > # you'll amass, the slower it'll run and the greater likelihood for > issues). > # > # It's strongly recommended to check this file into your version > control system. > > ActiveRecord::Schema.define(:version => 20100611134617) do > > create_table "activities", :force => true do |t| > t.string "name" > t.datetime "created_at" > t.datetime "updated_at" > t.text "description" > t.boolean "verified" > t.integer "project_id" > end > > add_index "activities", ["project_id"], :name => > "index_activities_on_project_id" > > create_table "proj_units", :force => true do |t| > t.datetime "created_at" > t.datetime "updated_at" > t.integer "project_id" > t.integer "unit_id" > t.integer "position" > end > > add_index "proj_units", ["project_id"], :name => > "index_proj_units_on_project_id" > add_index "proj_units", ["unit_id"], :name => > "index_proj_units_on_unit_id" > > create_table "projects", :force => true do |t| > t.string "name" > t.text "description" > t.date "start_date" > t.date "end_date" > t.datetime "created_at" > t.datetime "updated_at" > end > > create_table "unit_activities", :force => true do |t| > t.datetime "created_at" > t.datetime "updated_at" > t.integer "activity_id" > t.integer "unit_id" > t.integer "position" > end > > add_index "unit_activities", ["activity_id"], :name => > "index_unit_activities_on_activity_id" > add_index "unit_activities", ["unit_id"], :name => > "index_unit_activities_on_unit_id" > > create_table "units", :force => true do |t| > t.string "name" > t.datetime "created_at" > t.datetime "updated_at" > t.boolean "verified" > end > > create_table "users", :force => true do |t| > t.string "crypted_password", :limit => 40 > t.string "salt", :limit => 40 > t.string "remember_token" > t.datetime "remember_token_expires_at" > t.string "name" > t.string "email_address" > t.boolean "administrator", :default => > false > t.datetime "created_at" > t.datetime "updated_at" > t.string "state", :default => > "active" > t.datetime "key_timestamp" > end > > add_index "users", ["state"], :name => "index_users_on_state" > > end > > On Jun 14, 8:49 pm, Owen Dall <[email protected]> wrote: > > > BTW, can you give us some stats on how many cities, countries, etc and what > > indexing you have on tables. A copy of schema.rb would be useful for > > discussion purposes. > > > At Barquin we tend to use very different indexing strategies based on the DB > > engine and data composition rather than try to tweak the SQL. > > > Thanks, > > > Owen > > > On Mon, Jun 14, 2010 at 8:32 PM, Ronbo <[email protected]> wrote: > > > Great, Owen. Thanks for the clarification. > > > > On Jun 14, 8:29 pm, Owen Dall <[email protected]> wrote: > > > > Sorry--meant ask them (Tom, Bryan, Matt, Kevin, etc.) for an opinion of > > > the > > > > best way to do it now... > > > > > My personal goal for for Hobo is to provide as much as possible data > > > logic > > > > w/o dropping down to SQL for most common patterns. > > > > > Of course it can't be always avoided, but the goal is, IMHO, to > > > > encapsulate as much as possible in the DSL. > > > > > -Owen > > > > > On Mon, Jun 14, 2010 at 7:32 PM, Ronbo <[email protected]> wrote: > > > > > Owen, > > > > > > Not clear on your gist. 'Defer' in what sense? Thanks. > > > > > > On Jun 14, 1:17 pm, Owen Dall <[email protected]> wrote: > > > > > > Need to defer to one of the Big Guns.... > > > > > > > On Mon, Jun 14, 2010 at 11:27 AM, Ronbo <[email protected]> > > > wrote: > > > > > > > Not sure who changed the thread title or why. This post is to > > > > > > > (hopefully) reset it. > > > > > > > > On Jun 14, 7:54 am, Ronbo <[email protected]> wrote: > > > > > > > > Here is what gets echo'd by default. Not a lot of detail here. > > > Please > > > > > > > > let me know if you need more. > > > > > > > > > ActiveRecord::UnknownAttributeError (unknown attribute: > > > position): > > > > > > > > hobo (1.0.1) lib/hobo/model.rb:399:in `send' > > > > > > > > hobo (1.0.1) lib/hobo/model.rb:399:in `attributes=' > > > > > > > > hobo (1.0.1) lib/hobo/permissions.rb:194:in > > > > > `user_update_attributes' > > > > > > > > hobo (1.0.1) lib/hobo/permissions.rb:171:in `with_acting_user' > > > > > > > > hobo (1.0.1) lib/hobo/permissions.rb:193:in > > > > > `user_update_attributes' > > > > > > > > hobo (1.0.1) lib/hobo/model_controller.rb:757:in > > > > > > > > `hobo_reorder' > > > > > > > > hobosupport (1.0.1) lib/hobo_support.rb:29:in > > > > > > > > `each_with_index' > > > > > > > > hobo (1.0.1) lib/hobo/model_controller.rb:756:in `each' > > > > > > > > hobo (1.0.1) lib/hobo/model_controller.rb:756:in > > > `each_with_index' > > > > > > > > hobo (1.0.1) lib/hobo/model_controller.rb:756:in > > > > > > > > `hobo_reorder' > > > > > > > > app/controllers/units_controller.rb:13:in `reorder' > > > > > > > > hobo (1.0.1) lib/hobo/controller.rb:23:in `call' > > > > > > > > hobo (1.0.1) lib/hobo/controller.rb:23:in `included_in_class' > > > > > > > > > Rendered rescues/_trace (159.2ms) > > > > > > > > Rendered rescues/_request_and_response (0.4ms) > > > > > > > > Rendering rescues/layout (internal_server_error) > > > > > > > > > On Jun 12, 7:21 pm, Owen <[email protected]> wrote: > > > > > > > > > > Yeh, If we can get this example working I'll write it up. If > > > not, > > > > > we > > > > > > > > > should add this kind functionality to Hobo. > > > > > > > > > > Thanks, > > > > > > > > > -Owen > > > > > > > > > > On Jun 11, 5:07 pm, kevinpfromnm <[email protected]> > > > wrote: > > > > > > > > > > > hmm... can you post a stack trace as a gist? > > > > > > > > > > > On Jun 11, 4:27 am, Ronbo <[email protected]> wrote: > > > > > > > > > > > > Hi Kevin - that makes sense. Where I am confused is that > > > the > > > > > > > position > > > > > > > > > > > column *is* being populated when the item is initially > > > added to > > > > > the > > > > > > > > > > > list. If I create a new Activity and add three items to > > > > > > > > > > > it, > > > > > looking > > > > > > > > > > > manually at the join table, the position column has 1,2,3, > > > as > > > > > > > > > > > positions. So I don't see where nil is an issue. The > > > problem is > > > > > > > that > > > > > > > > > > > they do not update when dragged. That is when I get the > > > > > "Unknown > > > > > > > > > > > Attribute: position" error, and the column has not updated > > > - is > > > > > > > still > > > > > > > > > > > 1,2,3 > > > > > > > > > > > > On Jun 10, 9:30 pm, kevinpfromnm <[email protected]> > > > > > wrote: > > > > > > > > > > > > > position in list is relative. can't adjust one's point > > > in > > > > > list > > > > > > > based > > > > > > > > > > > > off a nil value. that'd be my guess since you said the > > > > > column > > > > > > > was > > > > > > > > > > > > present. > > > > > > > > > > > > > On Jun 10, 3:39 pm, Ronbo <[email protected]> > > > wrote: > > > > > > > > > > > > > > Ok, thanks. > > > > > > > > > > > > > > I'm not sure either what you mean by this (referring > > > > > > > > > > > > > to > > > the > > > > > > > position > > > > > > > > > > > > > column not updating: > > > > > > > > > > > > > > (not available) means nil value IIRC. since you had > > > > > existing > > > > > > > values, > > > > > > > > > > > > > you'll need to populate the values. > > > > > > > > > > > > > > Since I get "unknown attribute: position", is the > > > problem > > > > > that > > > > > > > the > > > > > > > > > > > > > unit model does not know where position is? Or is it > > > some > > > > > other > > > > > > > issue? > > > > > > > > > > > > > > On Jun 10, 5:35 pm, kevinpfromnm < > > > [email protected]> > > > > > > > wrote: > > > > > > > > > > > > > > > that's what I meant. so the position would be per > > > > > activity. > > > > > > > > > > > > > > > On Jun 10, 3:21 pm, Ronbo <[email protected]> > > > > > wrote: > > > > > > > > > > > > > > > > Thanks Kevin, > > > > > > > > > > > > > > > > Not sure what you mean about scope to activity. I > > > have > > > > > > > > > > > > > > > acts_as_list :scope => :activity on the join now. > > > > > > > > > > > > > > > > On Jun 10, 2:27 pm, kevinpfromnm < > > > > > [email protected]> > > > > > > > wrote: > > > > > > > > > > > > > > > > > (not available) means nil value IIRC. since you > > > had > > > > > > > existing values, > > > > > > > > > > > > > > > > you'll need to populate the values. oh, you'll > > > also > > > > > need > > > > > > > to scope the > > > > > > > > > > > > > > > > acts_as_list to the activity as well > > > > > > > > > > > > > > > > > On Jun 10, 8:49 am, Ronbo < > > > [email protected]> > > > > > > > wrote: > > > > > > > > > > > > > > > > > > OK. I just added > > > > > > > > > > > > > > > > > <view:unit_activity.position/> > > > to > > > > > the > > > > > > > view and get > > > > > > > > > > > > > > > > > (Not Available) when I render the page. > > > > > > > > > > > > > > > > > > In the unit_activity table, the position > > > > > > > > > > > > > > > > > column > > > is > > > > > > > being populated > > > > > > > > > > > > > > > > > when the units are added to an activity, but > > > not > > ... > > read more » -- You received this message because you are subscribed to the Google Groups "Hobo Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/hobousers?hl=en.
