On 21 February 2011 09:30, rogi <patrik.kel...@googlemail.com> wrote:
> class Worker < ActiveRecord::Base
> has_many :trainings
> has_many :courses, :through => :trainings
> belongs_to :ressort
>
> def firstname_and_name
> first_name+" "+last_name
> end
> end
>
> ---
> class Ressort < ActiveRecord::Base
> has_many :workers
> end
>
> ---
>
> class Course < ActiveRecord::Base
> has_many :trainings
> has_many :workers, :through => :trainings
> end
Please don't top post, it makes it difficult to follow the thread.
Insert your reply at appropriate point in previous message. Thanks.
This really makes no sense to me. Is it possible that you have some
old files (backup files for example) in the app/model folder that may
be confusing rails? Have a look and remove anything extra there. Are
you *absolutely* sure you are looking at the right files? I know it
seems a stupid question but I remember once I had made a complete copy
of an application as a temporary backup and was editing the files in
one folder and running the server in the other. It took me a little
time to work out why nothing I changed seemed to make any difference
:)
Colin
>
>
>
> On 20 Feb., 22:46, Colin Law <clan...@googlemail.com> wrote:
>> On 20 February 2011 16:59, rogi <patrik.kel...@googlemail.com> wrote:
>>
>> > irb(main):038:0> Ressort.find(1).workers
>> > NoMethodError: undefined method `workers' for #<Ressort:0x3215328>
>>
>> > irb(main):039:0> Worker.first.ressort
>> > ActiveRecord::StatementInvalid: SQLite3::SQLException: no such column:
>> > ressorts.worker_id: SELECT "ressorts".* FROM "re
>> > ssorts" WHERE ("ressorts".worker_id = 1) LIMIT 1
>>
>> Can you paste the contents of ressort.rb and worker.rb? Do not
>> re-type them, copy and paste here please.
>> Also db/schema.rb
>>
>> Colin
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> > => Worker(id: integer, first_name: string, last_name: string,
>> > created_at: datetime, updated_at: datetime, ressort_id: in
>> > teger)
>>
>> > class AddRessortIdToWorkers < ActiveRecord::Migration
>> > def self.up
>> > add_column :workers, :ressort_id, :integer
>> > end
>>
>> > def self.down
>> > remove_column :workers, :ressort_id
>> > end
>> > end
>>
>> > class CreateRessorts < ActiveRecord::Migration
>> > def self.up
>> > create_table :ressorts do |t|
>> > t.string :name
>> > t.text :description
>>
>> > t.timestamps
>> > end
>> > end
>>
>> > def self.down
>> > drop_table :ressorts
>> > end
>> > end
>>
>> > On Feb 20, 4:05 pm, Michael Pavling <pavl...@gmail.com> wrote:
>> >> On 20 February 2011 13:23, rogi <patrik.kel...@googlemail.com> wrote:
>>
>> >> > No:
>>
>> >> > ActiveRecord::StatementInvalid: SQLite3::SQLException: no such column:
>> >> > ressorts.worker_id: SELECT "ressorts".* FROM "ressorts" WHERE
>> >> > ("ressorts".worker_id = 1) LIMIT 1
>>
>> >> What command did you type to get this return value? It's certainly
>> >> weird if you asked for "Worker.first"... (or Worker.all.first)
>>
>> >> > irb(main):037:0> Ressort
>> >> > => Ressort(id: integer, name: string, description: text, created_at:
>> >> > datetime, updated_at: datetime)
>>
>> >> ...And what if you display "Worker"?
>>
>> >> I think your migrations would help too... I really don't think you've
>> >> quite got all the structure in place yet.
>>
>> > --
>> > You received this message because you are subscribed to the Google Groups
>> > "Ruby on Rails: Talk" group.
>> > To post to this group, send email to rubyonrails-talk@googlegroups.com.
>> > To unsubscribe from this group, send email to
>> > rubyonrails-talk+unsubscr...@googlegroups.com.
>> > For more options, visit this group
>> > athttp://groups.google.com/group/rubyonrails-talk?hl=en.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Ruby on Rails: Talk" group.
> To post to this group, send email to rubyonrails-talk@googlegroups.com.
> To unsubscribe from this group, send email to
> rubyonrails-talk+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/rubyonrails-talk?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
