English 中文(简体)
基本数据库协会
原标题:Basic database association

我试图将2个模型——<代码>Athletes 和Results联系起来。

They have the following fields: Athletes - :name :year :g结束er
Results - :name :event :performance

我添加了<条码>标签_to :athlete 至results.rb。 & supplemented has_many :results to athletes.rb

我想用的是:名称属性是把这两种模式联系起来的主要关键,因为意图是让所有运动员在开始时上载,然后在剩余季节使用结果投入。

我编辑了<条码>成果—控制器至:

def create
#this was the initial code....
#@result = Result.new(params[:result])

# This is the new code to try set up an association
@athlete = Athlete.where( name = ? ,  Peter )
@result = @athlete.results.create(params[:result])

respond_to do |format|
  if @result.save
    format.html { redirect_to @result, notice:  Result was successfully created.  }
    format.json { r结束er json: @result, status: :created, location: @result }
  else
    format.html { r结束er action: "new" }
    format.json { r结束er json: @result.errors, status: :unprocessable_entity }
  结束
结束

结束

但是,这产生了以下错误:未界定的编号和编号方法结果;活性记录:Relation:0x36a2b28>。 我也希望使用以下线路:@athlete = Athlete. where ("name = ?”, params [:name]),然而,它保持了产生“NUL 参数值......”。

谁能向我指出正确的方向?

Extra information: Results migration

class CreateResults < ActiveRecord::Migration   def change
 create_table :results do |t|
   t.string :name
   t.string :event
   t.decimal :performance

   t.timestamps
 结束

#add in new line here   
add_index :results, :name

结束 结束

移民问题

class CreateAthletes < ActiveRecord::Migration
  def change
    create_table :athletes do |t|
      t.string :name
      t.integer :year
      t.string :g结束er

      t.timestamps
    结束
  结束
结束

结果.rb:

class Result < ActiveRecord::Base
     belongs_to :athlete
 结束

Athlete.rb

class Athlete < ActiveRecord::Base
     has_many :results
 结束
最佳回答

问题在于Athlete. where ( name = ?, Peter > Return 活性记录: 两种用途

Athlete.where( name = ? ,  Peter ).first

or the dynamic find method

Athlete.find_by_name( Peter )

<><>Edit>/strong>

Also make sure you add t.references :athlete to your results table.

问题回答

你的成果表需要储存运动员。

create_table :results do |t|
 t.references :athlete
 t.string :name
 t.string :event
 t.decimal :performance
 t.timestamps
end

参考文件将利用铁路公约创建外国关键协会(在这种情况下是运动员协会)。





相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签