Add Database Models

This commit adds the following models by running their corresponding generators:

Venue: represents the building

  rails generate model Venue name:string slug:string:index

Floor: represents a floor within a building

  rails generate model Floor \
    name:string \
    slug:string:index \
    venue:references

Section: represents a collection of seats on a Floor

  rails generate model Section \
    name:string \
    slug:string:index \
    floor:references \
    price:integer

Seat: represents a seat in a Section, along with its x,y coordinates for rendering it

  rails generate model Seat \
    section:references \
    row:string:index \
    number:string:index \
    x:integer \
    y:integer

After running the generators, but before migrating, ensure that each column has null: false passed as an argument to ensure each is declared with a NOT NULL constraint.


      app/models/floor.rb

diff --git a/app/models/floor.rb b/app/models/floor.rb
new file mode 100644
index 0000000..9c9fe5f
--- /dev/null
+++ b/app/models/floor.rb
@@ -0,0 +1,6 @@
+class Floor < ApplicationRecord
+  belongs_to :venue
+
+  has_many :sections
+  has_many :seats, through: :sections
+end


      app/models/seat.rb

diff --git a/app/models/seat.rb b/app/models/seat.rb
new file mode 100644
index 0000000..ee2368c
--- /dev/null
+++ b/app/models/seat.rb
@@ -0,0 +1,3 @@
+class Seat < ApplicationRecord
+  belongs_to :section
+end


      app/models/section.rb

diff --git a/app/models/section.rb b/app/models/section.rb
new file mode 100644
index 0000000..8fe2b6a
--- /dev/null
+++ b/app/models/section.rb
@@ -0,0 +1,5 @@
+class Section < ApplicationRecord
+  belongs_to :floor
+
+  has_many :seats
+end


      app/models/venue.rb

diff --git a/app/models/venue.rb b/app/models/venue.rb
new file mode 100644
index 0000000..4a7a6a3
--- /dev/null
+++ b/app/models/venue.rb
@@ -0,0 +1,3 @@
+class Venue < ApplicationRecord
+  has_many :floors
+end


      db/migrate/20190525135948_create_venues.rb

diff --git a/db/migrate/20190525135948_create_venues.rb b/db/migrate/20190525135948_create_venues.rb
new file mode 100644
index 0000000..6dd48d1
--- /dev/null
+++ b/db/migrate/20190525135948_create_venues.rb
@@ -0,0 +1,11 @@
+class CreateVenues < ActiveRecord::Migration[6.0]
+  def change
+    create_table :venues do |t|
+      t.string :name, null: false
+      t.string :slug, null: false
+
+      t.timestamps
+    end
+    add_index :venues, :slug
+  end
+end


      db/migrate/20190525135958_create_floors.rb

diff --git a/db/migrate/20190525135958_create_floors.rb b/db/migrate/20190525135958_create_floors.rb
new file mode 100644
index 0000000..03fce7b
--- /dev/null
+++ b/db/migrate/20190525135958_create_floors.rb
@@ -0,0 +1,12 @@
+class CreateFloors < ActiveRecord::Migration[6.0]
+  def change
+    create_table :floors do |t|
+      t.string :name, null: false
+      t.string :slug, null: false
+      t.references :venue, null: false, foreign_key: true
+
+      t.timestamps
+    end
+    add_index :floors, :slug
+  end
+end


      db/migrate/20190525140021_create_sections.rb

diff --git a/db/migrate/20190525140021_create_sections.rb b/db/migrate/20190525140021_create_sections.rb
new file mode 100644
index 0000000..869decf
--- /dev/null
+++ b/db/migrate/20190525140021_create_sections.rb
@@ -0,0 +1,13 @@
+class CreateSections < ActiveRecord::Migration[6.0]
+  def change
+    create_table :sections do |t|
+      t.string :name, null: false
+      t.string :slug, null: false
+      t.references :floor, null: false, foreign_key: true
+      t.integer :price, null: false
+
+      t.timestamps
+    end
+    add_index :sections, :slug
+  end
+end


      db/migrate/20190525141044_create_seats.rb

diff --git a/db/migrate/20190525141044_create_seats.rb b/db/migrate/20190525141044_create_seats.rb
new file mode 100644
index 0000000..d14ae55
--- /dev/null
+++ b/db/migrate/20190525141044_create_seats.rb
@@ -0,0 +1,15 @@
+class CreateSeats < ActiveRecord::Migration[6.0]
+  def change
+    create_table :seats do |t|
+      t.references :section, null: false, foreign_key: true
+      t.string :row, null: false
+      t.string :number, null: false
+      t.integer :x, null: false
+      t.integer :y, null: false
+
+      t.timestamps
+    end
+    add_index :seats, :row
+    add_index :seats, :number
+  end
+end


      db/schema.rb

diff --git a/db/schema.rb b/db/schema.rb
new file mode 100644
index 0000000..c81f663
--- /dev/null
+++ b/db/schema.rb
@@ -0,0 +1,63 @@
+# 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.
+#
+# This file is the source Rails uses to define your schema when running `rails
+# db:schema:load`. When creating a new database, `rails db:schema:load` tends to
+# be faster and is potentially less error prone than running all of your
+# migrations from scratch. Old migrations may fail to apply correctly if those
+# migrations use external dependencies or application code.
+#
+# It's strongly recommended that you check this file into your version control system.
+
+ActiveRecord::Schema.define(version: 2019_05_25_141044) do
+
+  # These are extensions that must be enabled in order to support this database
+  enable_extension "plpgsql"
+
+  create_table "floors", force: :cascade do |t|
+    t.string "name"
+    t.string "slug"
+    t.bigint "venue_id", null: false
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.index ["slug"], name: "index_floors_on_slug"
+    t.index ["venue_id"], name: "index_floors_on_venue_id"
+  end
+
+  create_table "seats", force: :cascade do |t|
+    t.bigint "section_id", null: false
+    t.string "row", null: false
+    t.string "number", null: false
+    t.integer "x", null: false
+    t.integer "y", null: false
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.index ["number"], name: "index_seats_on_number"
+    t.index ["row"], name: "index_seats_on_row"
+    t.index ["section_id"], name: "index_seats_on_section_id"
+  end
+
+  create_table "sections", force: :cascade do |t|
+    t.string "name"
+    t.string "slug"
+    t.bigint "floor_id", null: false
+    t.integer "price"
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.index ["floor_id"], name: "index_sections_on_floor_id"
+    t.index ["slug"], name: "index_sections_on_slug"
+  end
+
+  create_table "venues", force: :cascade do |t|
+    t.string "name"
+    t.string "slug"
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.index ["slug"], name: "index_venues_on_slug"
+  end
+
+  add_foreign_key "floors", "venues"
+  add_foreign_key "seats", "sections"
+  add_foreign_key "sections", "floors"
+end


      test/fixtures/floors.yml

diff --git a/test/fixtures/floors.yml b/test/fixtures/floors.yml
new file mode 100644
index 0000000..0ac1b3e
--- /dev/null
+++ b/test/fixtures/floors.yml
@@ -0,0 +1,11 @@
+# Read about fixtures at https://api.rubyonrails.org/classes/ActiveRecord/FixtureSet.html
+
+one:
+  name: MyString
+  slug: MyString
+  venue: one
+
+two:
+  name: MyString
+  slug: MyString
+  venue: two


      test/fixtures/seats.yml

diff --git a/test/fixtures/seats.yml b/test/fixtures/seats.yml
new file mode 100644
index 0000000..d83517f
--- /dev/null
+++ b/test/fixtures/seats.yml
@@ -0,0 +1,15 @@
+# Read about fixtures at https://api.rubyonrails.org/classes/ActiveRecord/FixtureSet.html
+
+one:
+  section: one
+  row: MyString
+  number: MyString
+  x: 1
+  'y': 1
+
+two:
+  section: two
+  row: MyString
+  number: MyString
+  x: 1
+  'y': 1


      test/fixtures/sections.yml

diff --git a/test/fixtures/sections.yml b/test/fixtures/sections.yml
new file mode 100644
index 0000000..c30eb05
--- /dev/null
+++ b/test/fixtures/sections.yml
@@ -0,0 +1,13 @@
+# Read about fixtures at https://api.rubyonrails.org/classes/ActiveRecord/FixtureSet.html
+
+one:
+  name: MyString
+  slug: MyString
+  floor: one
+  price: 
+
+two:
+  name: MyString
+  slug: MyString
+  floor: two
+  price:


      test/fixtures/venues.yml

diff --git a/test/fixtures/venues.yml b/test/fixtures/venues.yml
new file mode 100644
index 0000000..0cd0283
--- /dev/null
+++ b/test/fixtures/venues.yml
@@ -0,0 +1,9 @@
+# Read about fixtures at https://api.rubyonrails.org/classes/ActiveRecord/FixtureSet.html
+
+one:
+  name: MyString
+  slug: MyString
+
+two:
+  name: MyString
+  slug: MyString


      test/models/floor_test.rb

diff --git a/test/models/floor_test.rb b/test/models/floor_test.rb
new file mode 100644
index 0000000..65c5512
--- /dev/null
+++ b/test/models/floor_test.rb
@@ -0,0 +1,7 @@
+require 'test_helper'
+
+class FloorTest < ActiveSupport::TestCase
+  # test "the truth" do
+  #   assert true
+  # end
+end


      test/models/seat_test.rb

diff --git a/test/models/seat_test.rb b/test/models/seat_test.rb
new file mode 100644
index 0000000..3c87cbc
--- /dev/null
+++ b/test/models/seat_test.rb
@@ -0,0 +1,7 @@
+require 'test_helper'
+
+class SeatTest < ActiveSupport::TestCase
+  # test "the truth" do
+  #   assert true
+  # end
+end


      test/models/section_test.rb

diff --git a/test/models/section_test.rb b/test/models/section_test.rb
new file mode 100644
index 0000000..b8b5039
--- /dev/null
+++ b/test/models/section_test.rb
@@ -0,0 +1,7 @@
+require 'test_helper'
+
+class SectionTest < ActiveSupport::TestCase
+  # test "the truth" do
+  #   assert true
+  # end
+end


      test/models/venue_test.rb

diff --git a/test/models/venue_test.rb b/test/models/venue_test.rb
new file mode 100644
index 0000000..bf495c6
--- /dev/null
+++ b/test/models/venue_test.rb
@@ -0,0 +1,7 @@
+require 'test_helper'
+
+class VenueTest < ActiveSupport::TestCase
+  # test "the truth" do
+  #   assert true
+  # end
+end