SoundSoftware Code Site

thirty_seven_signals:

  id: 1

  name: 37Signals

  rating: 4

TextDrive:

  id: 2

  name: TextDrive

  rating: 4

PlanetArgon:

  id: 3

  name: Planet Argon

  rating: 4

Google:

  id: 4

  name: Google

  rating: 4

Ionist:

  id: 5

  name: Ioni.st

  rating: 4

class Company < ActiveRecord::Base

  attr_protected :rating

  set_sequence_name :companies_nonstd_seq

  validates_presence_of :name

  def validate

    errors.add('rating', 'rating should not be 2') if rating == 2

  end  

end

class Developer < ActiveRecord::Base

  has_and_belongs_to_many :projects

end

class DeVeLoPeR < ActiveRecord::Base

  self.table_name = "developers"

end

david:

  id: 1

  name: David

  salary: 80000

jamis:

  id: 2

  name: Jamis

  salary: 150000

<% for digit in 3..10 %>

dev_<%= digit %>:

  id: <%= digit %>

  name: fixture_<%= digit %>

  salary: 100000

<% end %>

poor_jamis:

  id: 11

  name: Jamis

  salary: 9000

david_action_controller:

  developer_id: 1

  project_id: 2

  joined_on: 2004-10-10

david_active_record:

  developer_id: 1

  project_id: 1

  joined_on: 2004-10-10

jamis_active_record:

  developer_id: 2

  project_id: 1

class Project < ActiveRecord::Base

  has_and_belongs_to_many :developers, :uniq => true

end

action_controller:

  id: 2

  name: Active Controller

active_record:

  id: 1

  name: Active Record

witty_retort:

  id: 1

  topic_id: 1

  content: Birdman is better!

  created_at: <%= 6.hours.ago.to_s(:db) %>

  updated_at: nil

another:

  id: 2

  topic_id: 2

  content: Nuh uh!

  created_at: <%= 1.hour.ago.to_s(:db) %>

  updated_at: nil

class Reply < ActiveRecord::Base

  belongs_to :topic, :include => [:replies]

  validates_presence_of :content

end

CREATE TABLE 'companies' (

  'id' INTEGER PRIMARY KEY NOT NULL,

  'name' TEXT DEFAULT NULL,

  'rating' INTEGER DEFAULT 1

);

CREATE TABLE 'replies' (

  'id' INTEGER PRIMARY KEY NOT NULL, 

  'content' text, 

  'created_at' datetime, 

  'updated_at' datetime, 

  'topic_id' integer

);

CREATE TABLE 'topics' (

  'id' INTEGER PRIMARY KEY NOT NULL, 

  'title' varchar(255), 

  'subtitle' varchar(255), 

  'content' text, 

  'created_at' datetime, 

  'updated_at' datetime

);

CREATE TABLE 'developers' (

  'id' INTEGER PRIMARY KEY NOT NULL,

  'name' TEXT DEFAULT NULL,

  'salary' INTEGER DEFAULT 70000,

  'created_at' DATETIME DEFAULT NULL,

  'updated_at' DATETIME DEFAULT NULL

);

CREATE TABLE 'projects' (

  'id' INTEGER PRIMARY KEY NOT NULL,

  'name' TEXT DEFAULT NULL

);

CREATE TABLE 'developers_projects' (

  'developer_id' INTEGER NOT NULL,

  'project_id' INTEGER NOT NULL,

  'joined_on' DATE DEFAULT NULL,

  'access_level' INTEGER DEFAULT 1

);

class Topic < ActiveRecord::Base

  has_many :replies, :include => [:user], :dependent => :destroy

end

futurama:

  id: 1

  title: Isnt futurama awesome?

  subtitle: It really is, isnt it.

  content: I like futurama

  created_at: <%= 1.day.ago.to_s(:db) %>

  updated_at:

harvey_birdman:

  id: 2

  title: Harvey Birdman is the king of all men

  subtitle: yup

  content: It really is

  created_at: <%= 2.hours.ago.to_s(:db) %>

  updated_at:

rails:

  id: 3

  title: Rails is nice

  subtitle: It makes me happy

  content: except when I have to hack internals to fix pagination. even then really.

  created_at: <%= 20.minutes.ago.to_s(:db) %>