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
> > > > when
> > > > > > reordered from
> > > > > > > > > > > > > > > > the acts_as_list view.
>
> > > > > > > > > > > > > > > > Could this be a permission or scope problem
> > caused
> > > > by
> > > > > > 'position' being
> > > > > > > > > > > > > > > > on the join table?
>
> > > > > > > > > > > > > > > > Thanks,
>
> > > > > > > > > > > > > > > > On Jun 9, 5:28 pm, Ronbo <
> > [email protected]>
> > > > > > wrote:
>
> > > > > > > > > > > > > > > > > Yup. I have a 'position' column on the join
> > > > table.
>
> > > > > > > > > > > > > > > > > On Jun 9, 5:06 pm, kevinpfromnm <
> > > > > > [email protected]> wrote:
>
> > > > > > > > > > > > > > > > > > hmm... you've already done the migration
> > after
> > > > > > declaring the
> > > > > > > > > > > > > > > > > > acts_as_list?
>
> > > > > > > > > > > > > > > > > > On Jun 9, 2:46 pm, Ronbo <
> > > > [email protected]>
> > > > > > wrote:
>
> > > > > > > > > > > > > > > > > > > Thanks again. The tips are really
> > > > appreciated.
>
> > > > > > > > > > > > > > > > > > > I added the hobo_reorder as shown below.
> > The
> > > > page
> > > > > > now renders properly
> > > > > > > > > > > > > > > > > > > (with the sortable-collection UI
> > controls).
>
> > > > > > > > > > > > > > > > > > > class UnitsController <
> > ApplicationController
> > > > > > > > > > > > > > > > > > > hobo_model_controller
> > > > > > > > > > > > > > > > > > > auto_actions :all
>
> > > > > > > > > > > > > > > > > > > def reorder
> > > > > > > > > > > > > > > > > > > hobo_reorder
> > > > > > > > > > > > > > > > > > > end
> > > > > > > > > > > > > > > > > > > end
>
> > > > > > > > > > > > > > > > > > > The page now renders properly (with the
> > > > > > sortable-collection UI
> > > > > > > > > > > > > > > > > > > controls), but moving a list item fails
> > to
> > > > update
> > > > > > the position with
> > > > > > > > > > > > > > > > > > > the following error:
> > > > > > > > > > > > > > > > > > > ActiveRecord::UnknownAttributeError
> > (unknown
> > > > > > attribute: position):
>
> > > > > > > > > > > > > > > > > > > I have the position declared on the join
> > > > > > relation:
> > > > > > > > > > > > > > > > > > > has_many :unit_activities, :order =>
> > > > :position
>
> > > > > > > > > > > > > > > > > > > Is this the right place, or is there
> > > > something
> > > > > > else I need to tweak to
> > > > > > > > > > > > > > > > > > > get this going?
> > > > > > > > > > > > > > > > > > > I'm getting closer...
>
> > > > > > > > > > > > > > > > > > > On Jun 9, 2:46 pm, kevinpfromnm <
> > > > > > [email protected]> wrote:
>
> > > > > > > > > > > > > > > > > > > > you need the method on the controller
> > for
> > > > it, I
> > > > > > can't remember if it's
> > > > > > > > > > > > > > > > > > > > something special or just standard
> > update
> > > > > > methods.
>
> > > > > > > > > > > > > > > > > > > > On Jun 9, 12:41 pm, Ronbo <
> > > > > > [email protected]> wrote:
>
> > > > > > > > > > > > > > > > > > > > > Hi Kevin,
>
> > > > > > > > > > > > > > > > > > > > > Do you mean something like:
>
> > > > > > > > > > > > > > > > > > > > > class Activity < ActiveRecord::Base
> > > > > > > > > > > > > > > > > > > > > has_many :unit_activities, :order
> > =>
> > > > > > :position
> > > > > > > > > > > > > > > > > > > > > has_many :units, :through =>
> > > > > > :unit_activities
>
> > > > > > > > > > > > > > > > > > > > > ....
>
> > > > > > > > > > > > > > > > > > > > > class UnitActivity <
> > ActiveRecord::Base
> > > > > > > > > > > > > > > > > > > > > belongs_to :activity
> > > > > > > > > > > > > > > > > > > > > belongs_to :unit
> > > > > > > > > > > > > > > > > > > > > acts_as_list :scope => :activity
>
> ...
>
> 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.
