Model WorkbenchObjectIdentifier

5 files changed, 48 insertions, 40 deletions

diff --git a/app/models/workbench_object_identifier.rb b/app/models/workbench_object_identifier.rb
new file mode 100644
index 000000000..18e0c89cc
--- /dev/null
+++ b/app/models/workbench_object_identifier.rb
@@ -0,0 +1,3 @@
+class WorkbenchObjectIdentifier < ActiveRecord::Base
+  belongs_to :workbench
+end
diff --git a/db/migrate/20170808124304_create_workbench_object_identifiers.rb b/db/migrate/20170808124304_create_workbench_object_identifiers.rb
new file mode 100644
index 000000000..b59936e72
--- /dev/null
+++ b/db/migrate/20170808124304_create_workbench_object_identifiers.rb
@@ -0,0 +1,11 @@
+class CreateWorkbenchObjectIdentifiers < ActiveRecord::Migration
+  def change
+    create_table :workbench_object_identifiers do |t|
+      t.string :object_class
+      t.integer :last_technical_id
+      t.references :workbench, index: true, foreign_key: true
+
+      t.timestamps null: false
+    end
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index 224518c94..1e59a4943 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -11,7 +11,7 @@
 #
 # It's strongly recommended that you check this file into your version control system.
 
-ActiveRecord::Schema.define(version: 20170808091929) do
+ActiveRecord::Schema.define(version: 20170808124304) do
 
   # These are extensions that must be enabled in order to support this database
   enable_extension "plpgsql"
@@ -211,13 +211,11 @@ ActiveRecord::Schema.define(version: 20170808091929) do
   end
 
   create_table "footnotes", id: :bigserial, force: :cascade do |t|
-    t.integer  "line_id",         limit: 8
+    t.integer  "line_id",    limit: 8
     t.string   "code"
     t.string   "label"
     t.datetime "created_at"
     t.datetime "updated_at"
-    t.string   "checksum"
-    t.string   "checksum_source"
   end
 
   create_table "footnotes_vehicle_journeys", id: false, force: :cascade do |t|
@@ -286,7 +284,7 @@ ActiveRecord::Schema.define(version: 20170808091929) do
     t.datetime "started_at"
     t.datetime "ended_at"
     t.string   "token_download"
-    t.string   "type",                  limit: 255
+    t.string   "type"
   end
 
   add_index "imports", ["referential_id"], name: "index_imports_on_referential_id", using: :btree
@@ -332,8 +330,6 @@ ActiveRecord::Schema.define(version: 20170808091929) do
     t.integer  "section_status",                    default: 0, null: false
     t.datetime "created_at"
     t.datetime "updated_at"
-    t.string   "checksum"
-    t.string   "checksum_source"
   end
 
   add_index "journey_patterns", ["objectid"], name: "journey_patterns_objectid_key", unique: true, using: :btree
@@ -542,8 +538,6 @@ ActiveRecord::Schema.define(version: 20170808091929) do
     t.string   "wayback"
     t.datetime "created_at"
     t.datetime "updated_at"
-    t.string   "checksum"
-    t.string   "checksum_source"
   end
 
   add_index "routes", ["objectid"], name: "routes_objectid_key", unique: true, using: :btree
@@ -552,13 +546,11 @@ ActiveRecord::Schema.define(version: 20170808091929) do
     t.string   "name"
     t.datetime "created_at"
     t.datetime "updated_at"
-    t.string   "objectid",                  null: false
-    t.integer  "object_version",  limit: 8
+    t.string   "objectid",                 null: false
+    t.integer  "object_version", limit: 8
     t.string   "creator_id"
-    t.integer  "route_id",        limit: 8
-    t.integer  "stop_point_ids",  limit: 8,              array: true
-    t.string   "checksum"
-    t.string   "checksum_source"
+    t.integer  "route_id",       limit: 8
+    t.integer  "stop_point_ids", limit: 8,              array: true
   end
 
   create_table "routing_constraints_lines", id: false, force: :cascade do |t|
@@ -610,7 +602,7 @@ ActiveRecord::Schema.define(version: 20170808091929) do
 
   create_table "stop_areas", id: :bigserial, force: :cascade do |t|
     t.integer  "parent_id",                       limit: 8
-    t.string   "objectid",                                                              null: false
+    t.string   "objectid",                                                            null: false
     t.integer  "object_version",                  limit: 8
     t.string   "creator_id"
     t.string   "name"
@@ -619,8 +611,8 @@ ActiveRecord::Schema.define(version: 20170808091929) do
     t.string   "registration_number"
     t.string   "nearest_topic_name"
     t.integer  "fare_code"
-    t.decimal  "longitude",                                   precision: 19, scale: 16
-    t.decimal  "latitude",                                    precision: 19, scale: 16
+    t.decimal  "longitude",                                 precision: 19, scale: 16
+    t.decimal  "latitude",                                  precision: 19, scale: 16
     t.string   "long_lat_type"
     t.string   "country_code"
     t.string   "street_name"
@@ -638,7 +630,7 @@ ActiveRecord::Schema.define(version: 20170808091929) do
     t.datetime "deleted_at"
     t.datetime "created_at"
     t.datetime "updated_at"
-    t.string   "stif_type",                       limit: 255
+    t.string   "stif_type"
   end
 
   add_index "stop_areas", ["name"], name: "index_stop_areas_on_name", using: :btree
@@ -687,43 +679,37 @@ ActiveRecord::Schema.define(version: 20170808091929) do
   add_index "tags", ["name"], name: "index_tags_on_name", unique: true, using: :btree
 
   create_table "time_table_dates", id: :bigserial, force: :cascade do |t|
-    t.integer "time_table_id",   limit: 8, null: false
+    t.integer "time_table_id", limit: 8, null: false
     t.date    "date"
-    t.integer "position",                  null: false
+    t.integer "position",                null: false
     t.boolean "in_out"
-    t.string  "checksum"
-    t.string  "checksum_source"
   end
 
   add_index "time_table_dates", ["time_table_id"], name: "index_time_table_dates_on_time_table_id", using: :btree
 
   create_table "time_table_periods", id: :bigserial, force: :cascade do |t|
-    t.integer "time_table_id",   limit: 8, null: false
+    t.integer "time_table_id", limit: 8, null: false
     t.date    "period_start"
     t.date    "period_end"
-    t.integer "position",                  null: false
-    t.string  "checksum"
-    t.string  "checksum_source"
+    t.integer "position",                null: false
   end
 
   add_index "time_table_periods", ["time_table_id"], name: "index_time_table_periods_on_time_table_id", using: :btree
 
   create_table "time_tables", id: :bigserial, force: :cascade do |t|
-    t.string   "objectid",                                null: false
-    t.integer  "object_version",  limit: 8,   default: 1
+    t.string   "objectid",                              null: false
+    t.integer  "object_version",  limit: 8, default: 1
     t.string   "creator_id"
     t.string   "version"
     t.string   "comment"
-    t.integer  "int_day_types",               default: 0
+    t.integer  "int_day_types",             default: 0
     t.date     "start_date"
     t.date     "end_date"
     t.integer  "calendar_id",     limit: 8
     t.datetime "created_at"
     t.datetime "updated_at"
-    t.string   "color",           limit: 255
+    t.string   "color"
     t.integer  "created_from_id"
-    t.string   "checksum"
-    t.string   "checksum_source"
   end
 
   add_index "time_tables", ["calendar_id"], name: "index_time_tables_on_calendar_id", using: :btree
@@ -800,8 +786,6 @@ ActiveRecord::Schema.define(version: 20170808091929) do
     t.string  "for_alighting"
     t.integer "departure_day_offset",                     default: 0
     t.integer "arrival_day_offset",                       default: 0
-    t.string  "checksum"
-    t.string  "checksum_source"
   end
 
   add_index "vehicle_journey_at_stops", ["stop_point_id"], name: "index_vehicle_journey_at_stops_on_stop_pointid", using: :btree
@@ -827,14 +811,12 @@ ActiveRecord::Schema.define(version: 20170808091929) do
     t.integer  "journey_category",                          default: 0, null: false
     t.datetime "created_at"
     t.datetime "updated_at"
-    t.string   "checksum"
-    t.string   "checksum_source"
   end
 
   add_index "vehicle_journeys", ["objectid"], name: "vehicle_journeys_objectid_key", unique: true, using: :btree
   add_index "vehicle_journeys", ["route_id"], name: "index_vehicle_journeys_on_route_id", using: :btree
 
-  create_table "worbench_object_identifiers", id: :bigserial, force: :cascade do |t|
+  create_table "workbench_object_identifiers", id: :bigserial, force: :cascade do |t|
     t.string   "object_class"
     t.integer  "last_technical_id"
     t.integer  "workbench_id"
@@ -842,7 +824,7 @@ ActiveRecord::Schema.define(version: 20170808091929) do
     t.datetime "updated_at",        null: false
   end
 
-  add_index "worbench_object_identifiers", ["workbench_id"], name: "index_worbench_object_identifiers_on_workbench_id", using: :btree
+  add_index "workbench_object_identifiers", ["workbench_id"], name: "index_workbench_object_identifiers_on_workbench_id", using: :btree
 
   create_table "workbenches", id: :bigserial, force: :cascade do |t|
     t.string   "name"
@@ -882,5 +864,5 @@ ActiveRecord::Schema.define(version: 20170808091929) do
   add_foreign_key "vehicle_journey_at_stops", "vehicle_journeys", name: "vjas_vj_fkey", on_delete: :cascade
   add_foreign_key "vehicle_journeys", "journey_patterns", name: "vj_jp_fkey", on_delete: :cascade
   add_foreign_key "vehicle_journeys", "routes", name: "vj_route_fkey", on_delete: :cascade
-  add_foreign_key "worbench_object_identifiers", "workbenches"
+  add_foreign_key "workbench_object_identifiers", "workbenches"
 end
diff --git a/spec/factories/workbench_object_identifiers.rb b/spec/factories/workbench_object_identifiers.rb
new file mode 100644
index 000000000..185b25596
--- /dev/null
+++ b/spec/factories/workbench_object_identifiers.rb
@@ -0,0 +1,7 @@
+FactoryGirl.define do
+  factory :workbench_object_identifier do
+    object_class "MyString"
+    last_technical_id 1
+    workbench nil
+  end
+end
diff --git a/spec/models/workbench_object_identifier_spec.rb b/spec/models/workbench_object_identifier_spec.rb
new file mode 100644
index 000000000..a8dd71d7f
--- /dev/null
+++ b/spec/models/workbench_object_identifier_spec.rb
@@ -0,0 +1,5 @@
+require 'rails_helper'
+
+RSpec.describe WorkbenchObjectIdentifier, type: :model do
+  it { should belong_to :workbench }
+end