Ruby/ActiveRecord/Insert
Материал из Wiki.crossplatform.ru
(Различия между версиями)
ViGOur (Обсуждение | вклад) м (1 версия: Импорт выборки материалов по Ruby) |
Текущая версия на 18:01, 13 сентября 2010
Add record to database with save method
=begin drop database Contact; create database Contact; use Contact; CREATE TABLE Employee ( id int unsigned not null auto_increment primary key, Name VARCHAR(50), Phone VARCHAR(15), departmentId int ); CREATE TABLE Department( id int unsigned not null auto_increment primary key, Name VARCHAR(50), Phone VARCHAR(15) ); =end require "rubygems" require "activerecord" ActiveRecord::Base.establish_connection( :adapter => "mysql", :host => "localhost", :username => "root", :database => "Contact") class Employee < ActiveRecord::Base set_table_name "employee" belongs_to :department end class Department < ActiveRecord::Base set_table_name "department" end department = Department.find_or_create_by_Name("B") account = Employee.new account.Name = "AAA" account.department = department account.save