Class: CabooseRets::Schema

Inherits:
Caboose::Utilities::Schema
  • Object
show all
Defined in:
app/models/caboose_rets/schema.rb,
app/models/caboose_rets/schema_past.rb

Class Method Summary collapse

Class Method Details

.indexesObject



12
13
14
15
16
# File 'app/models/caboose_rets/schema_past.rb', line 12

def self.indexes
  {
    CabooseRets::Media => [:media_id]
  }
end

.load_dataObject



364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
# File 'app/models/caboose_rets/schema.rb', line 364

def self.load_data

  # bt = Caboose::BlockType.where(:name => 'layout_rets').first
  # if bt.nil?
  #     cat = Caboose::BlockTypeCategory.where(:name => 'Layouts').first
  #     bt = Caboose::BlockType.create(:name => 'layout_rets', :description => 'RETS Layout', :block_type_category_id => cat.id, :allow_child_blocks => false, :field_type => 'block')
  # end

  # Caboose::Site.where(:use_rets => true).reorder(:id).all.each do |site|
  #   home_page = Caboose::Page.index_page(site.id)

  #   # Check that the rets layout is applied to the site
  #   bt.add_to_site(site.id)

  #   # Verify that the site has all the rets pages created and each page has the rets layout
  #   rets_page = Caboose::Page.where(:site_id => site.id, :alias => 'rets').first
  #   rets_page = Caboose::Page.create(:site_id => site.id, :alias => 'rets', :slug => 'rets', :uri => 'rets', :title => 'RETS', :parent_id => home_page.id) if rets_page.nil?

  #   pages = []
  #   if !Caboose::Page.where(:site_id => site.id, :alias => 'property').exists?
  #     then pages << Caboose::Page.create(:site_id => site.id, :slug => 'properties'       , :alias => 'property'         , :uri => 'property'         , :title => 'Properties'              , :parent_id => rets_page.id)
  #   end    
  #   if !Caboose::Page.where(:site_id => site.id, :alias => 'open-houses'      ).exists?
  #     then pages << Caboose::Page.create(:site_id => site.id, :slug => 'open-houses'      , :alias => 'open-houses'      , :uri => 'open-houses'      , :title => 'Open Houses'             , :parent_id => rets_page.id)
  #   end
  #   if !Caboose::Page.where(:site_id => site.id, :alias => 'agents'           ).exists?
  #     then pages << Caboose::Page.create(:site_id => site.id, :slug => 'agents'           , :alias => 'agents'           , :uri => 'agents'           , :title => 'Agents'                  , :parent_id => rets_page.id)
  #   end
  #   if !Caboose::Page.where(:site_id => site.id, :alias => 'saved-searches'   ).exists?
  #     then pages << Caboose::Page.create(:site_id => site.id, :slug => 'saved-searches'   , :alias => 'saved-searches'   , :uri => 'saved-searches'   , :title => 'Saved Searches'          , :parent_id => rets_page.id)
  #   end
  #   if !Caboose::Page.where(:site_id => site.id, :alias => 'saved-properties' ).exists?
  #     then pages << Caboose::Page.create(:site_id => site.id, :slug => 'saved-properties' , :alias => 'saved-properties' , :uri => 'saved-properties' , :title => 'Saved Properties'        , :parent_id => rets_page.id)
  #   end

  #     pages.each do |p|
  #       Caboose::Block.where(:page_id =>  p.id).destroy_all
  #       Caboose::Block.create(:page_id => p.id, :block_type_id => bt.id, :name => bt.name)

  #       viewers = Caboose::PagePermission.where(:page_id => home_page.id, :action => 'view').pluck(:role_id)
  #       editors = Caboose::PagePermission.where(:page_id => home_page.id, :action => 'edit').pluck(:role_id)
  #       Caboose::Page.update_authorized_for_action(p.id, 'view', viewers)
  #       Caboose::Page.update_authorized_for_action(p.id, 'edit', editors)
  #     end
  #   end
end

.removed_columnsObject



10
11
12
13
14
# File 'app/models/caboose_rets/schema.rb', line 10

def self.removed_columns
  {
    CabooseRets::SavedProperty => [:mls_acct]
  }
end

.renamed_tablesObject

Tables (in order) that were renamed in the development of the gem.



4
5
6
7
8
# File 'app/models/caboose_rets/schema.rb', line 4

def self.renamed_tables
  {
    :property              => :rets_properties
  }
end

.schemaObject

The schema of the database { Model => [[name, data_type, options]] }



18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
# File 'app/models/caboose_rets/schema.rb', line 18

def self.schema
    {
      CabooseRets::Agent => [
        [ :agent_number                 , :text    ],
        [ :cell_phone                   , :text    ],
        [ :direct_work_phone            , :text    ],
        [ :email                        , :text    ],
        [ :fax_phone                    , :text    ],
        [ :first_name                   , :text    ],
        [ :full_name                    , :text    ],
        [ :generational_name            , :text    ],
        [ :last_name                    , :text    ],
        [ :matrix_unique_id             , :text    ],
        [ :matrix_modified_dt           , :text    ],
        [ :middle_name                  , :text    ],
        [ :mls                          , :text    ],
        [ :mls_id                       , :text    ],
        [ :office_mui                   , :text    ],
        [ :office_mls_id                , :text    ],
        [ :office_phone                 , :text    ],
        [ :other_phone                  , :text    ],
        [ :phone_toll_free              , :text    ],
        [ :phone_voice_mail             , :text    ],
        [ :photo_count                  , :text    ],
        [ :photo_modification_timestamp , :text    ],
        [ :sort_order                   , :integer ],
        [ :slug                         , :text     ],
        [ :last_updated                 , :datetime ]
      ],
      CabooseRets::AgentMeta => [
        [ :la_code             , :string     ],
        [ :hide                , :boolean     , { :default => false }],
        [ :bio                 , :text       ],
        [ :contact_info        , :text       ],
        [ :assistant_to        , :string     ],
        [ :designation         , :string     ],
        [ :image_location      , :string     ],
        [ :image               , :attachment ],
        [ :accepts_listings             , :boolean     , { :default => true }],
        [ :weight              , :float       , { :default => 1 } ]
      ], 
      CabooseRets::Office => [
        [ :lo_addr1                     , :text ],
        [ :lo_addr2                     , :text ],
        [ :lo_city                      , :text ],
        [ :lo_email                     , :text ],
        [ :lo_fax_phone                 , :text ],
        [ :lo_mail_addr                 , :text ],
        [ :lo_mail_care_of              , :text ],
        [ :lo_mail_city                 , :text ],        
        [ :lo_mail_postal_code          , :text ],
        [ :lo_mail_postal_code_plus4    , :text ],
        [ :lo_mail_state_or_province    , :text ],
        [ :matrix_unique_id             , :text ],
        [ :lo_matrix_modified_dt        , :text ],
        [ :lo_mls                       , :text ],
        [ :lo_mls_id                    , :text ],
        [ :lo_office_contact_mui        , :text ],
        [ :lo_office_contact_mls_id     , :text ],        
        [ :lo_office_long_name          , :text ],
        [ :lo_office_name               , :text ],
        [ :lo_phone                     , :text ],
        [ :lo_photo_count               , :text ],
        [ :photo_modification_timestamp , :text ],        
        [ :state                        , :text ],
        [ :street_address               , :text ],
        [ :street_city                  , :text ],
        [ :street_postal_code           , :text ],
        [ :street_postal_code_plus4     , :text ],
        [ :street_state_or_province     , :text ],
        [ :web_facebook                 , :text ],
        [ :web_linked_in                , :text ],
        [ :web_page_address             , :text ],
        [ :web_twitter                  , :text ],
        [ :zip                          , :text ]
      ],
      CabooseRets::OpenHouse => [
        [ :active_yn          , :text ],
        [ :description        , :text ],
        [ :end_time           , :text ],
        [ :entry_order        , :text ],
        [ :listing_mui        , :text ],
        [ :matrix_unique_id   , :text ],
        [ :matrix_modified_dt , :text ],
        [ :open_house_date    , :text ],
        [ :open_house_type    , :text ],
        [ :provider_key       , :text ],
        [ :refreshments       , :text ],
        [ :start_time         , :text ],
        [ :hide, :boolean     , { :default => false }]
      ],
      CabooseRets::Property => [
        [ :alternate_link                       , :string],
        [ :access                               , :text],
        [ :acreage                              , :decimal],
        [ :acreage_source                       , :text],
        [ :active_open_house_count              , :text],
        [ :adjoining_land_use                   , :text],
        [ :age                                  , :text],
        [ :annual_taxes                         , :text],
        [ :appliances                           , :text],
        [ :area                                 , :text],
        [ :attic                                , :text],
        [ :available_date                       , :text],
        [ :basement                             , :text],
        [ :basement_yn                          , :text],
        [ :baths_full                           , :integer],
        [ :baths_half                           , :integer],
        [ :baths_total                          , :decimal],
        [ :beds_total                           , :integer],
        [ :book_number                          , :text],
        [ :book_page                            , :text],
        [ :book_type                            , :text],
        [ :building_type                        , :text],
        [ :business_included_yn                 , :text],
        [ :buyer_name                           , :text],
        [ :city                                 , :text],
        [ :city_community                       , :text],
        [ :closing                              , :text],
        [ :co_list_agent_mui                    , :text],
        [ :co_list_agent_direct_work_phone      , :text],
        [ :co_list_agent_full_name              , :text],
        [ :co_list_agent_email                  , :text],
        [ :co_list_agent_mls_id                 , :text],
        [ :co_list_office_mui                   , :text],
        [ :co_list_office_mls_id                , :text],
        [ :co_list_office_name                  , :text],
        [ :co_list_office_phone                 , :text],
        [ :completion_date                      , :text],
        [ :comp_tenant_rep                      , :text],
        [ :construction                         , :text],
        [ :construction_status                  , :text],
        [ :cooling                              , :text],
        [ :county_or_parish                     , :text],
        [ :current_price                        , :text],
        [ :date_created                         , :text],
        [ :date_leased                          , :text],
        [ :date_modified                        , :text],
        [ :deposit                              , :text],
        [ :dining_room                          , :text],
        [ :directions                           , :text],
        [ :display_address_on_internet_yn       , :text],
        [ :dom                                  , :text],
        [ :driveway                             , :text],
        [ :elementary_school                    , :text],
        [ :exists_struct                        , :text],
        [ :expenses_association                 , :text],
        [ :expenses_insurance                   , :text],
        [ :expenses_maintenance                 , :text],
        [ :expenses_management                  , :text],
        [ :expenses_other                       , :text],
        [ :expenses_tax                         , :text],
        [ :expenses_utility                     , :text],
        [ :exterior_features                    , :text],
        [ :fireplace                            , :text],
        [ :fireplace_features                   , :string ],
        [ :flood_plain                          , :text],
        [ :flooring                             , :text],
        [ :foreclosure_sale_date                , :text],
        [ :foreclosure_yn                       , :text],
        [ :fsboyn                               , :text],
        [ :garage                               , :text],
        [ :garage_spaces                        , :string ],
        [ :heating                              , :text],
        [ :high_school                          , :text],
        [ :hoa_amenities                        , :text],
        [ :hoa_fee                              , :text],
        [ :hoa_included_in_rent_yn              , :text],
        [ :hoa_term                             , :text],
        [ :hoa_term_mandatory_yn                , :text],
        [ :homestead_yn                         , :text],
        [ :idx_opt_in_yn                        , :text],
        [ :income_other                         , :text],
        [ :income_rental                        , :text],
        [ :interior_features                    , :text],
        [ :land_features_extras                 , :text],
        [ :landscaping                          , :text],
        [ :latitude                             , :float],
        [ :laundry                              , :text],
        [ :legal_description                    , :text],
        [ :legal_lot                            , :text],
        [ :legal_section                        , :text],
        [ :levels                               , :text],
        [ :list_agent_mui                       , :text],
        [ :list_agent_direct_work_phone         , :text],
        [ :list_agent_email                     , :text],
        [ :list_agent_full_name                 , :text],
        [ :list_agent_mls_id                    , :text],
        [ :listing_contract_date                , :text],
        [ :list_office_mui                      , :text],
        [ :list_office_mls_id                   , :text],
        [ :list_office_name                     , :text],
        [ :list_office_phone                    , :text],
        [ :list_price                           , :decimal],
        [ :longitude                            , :float],
        [ :lot_description                      , :text],
        [ :lot_dimensions                       , :text],
        [ :lot_dim_source                       , :text],
        [ :management                           , :text],
        [ :master_bed_level                     , :text],
        [ :matrix_unique_id                     , :text],
        [ :matrix_modified_dt                   , :text],
        [ :max_sqft                             , :text],
        [ :middle_school                        , :text],
        [ :mineral_rights                       , :text],
        [ :min_sqft                             , :text],
        [ :misc_indoor_featuresa                , :text],
        [ :mls                                  , :text],
        [ :mls_number                           , :text],
        [ :municipality                         , :text],
        [ :net_op_inc                           , :text],
        [ :open_house_count                     , :text],
        [ :open_house_public_count              , :text],
        [ :open_house_public_upcoming           , :text],
        [ :open_house_upcoming                  , :text],
        [ :original_entry_timestamp             , :text],
        [ :parcel_number                        , :text],
        [ :pending_date                         , :text],
        [ :pets_allowed_yn                      , :text],
        [ :photo_count                          , :text],
        [ :photo_modification_timestamp         , :text],
        [ :pool                                 , :text],
        [ :porch_patio                          , :text],
        [ :possession                           , :text],
        [ :possible_uses                        , :text],
        [ :postal_code                          , :text],
        [ :postal_code_plus4                    , :text],
        [ :price_per_acre                       , :text],
        [ :price_sqft                           , :text],
        [ :property_name                        , :text],
        [ :property_subtype                     , :text],
        [ :property_type                        , :text],
        [ :property_use                         , :text],
        [ :prop_mgmt_comp                       , :text],
        [ :public_remarks                       , :text],
        [ :refrigerator_included_yn             , :text],
        [ :rental_rate_type                     , :text],
        [ :rent_incl                            , :text],
        [ :representative_agent_mui             , :text],
        [ :res_style                            , :text],
        [ :restrictions                         , :text],
        [ :road_frontage                        , :text],
        [ :roof                                 , :text],
        [ :roofage                              , :text],
        [ :room_count                           , :text],
        [ :security_features                    , :text],
        [ :service_type                         , :text],
        [ :sewer                                , :text],
        [ :sold_terms                           , :text],
        [ :sprinkler                            , :text],
        [ :sqft_source                          , :text],
        [ :sqft_total                           , :decimal],
        [ :state_or_province                    , :text],
        [ :status                               , :text],
        [ :status_contractual_search_date       , :text],
        [ :street_dir_prefix                    , :text],
        [ :street_dir_suffix                    , :text],
        [ :street_name                          , :text],
        [ :street_number                        , :text],
        [ :street_number_numeric                , :text],
        [ :street_suffix                        , :text],
        [ :street_view_param                    , :text],
        [ :style                                , :text],
        [ :subdivision                          , :text],
        [ :topography                           , :text],
        [ :total_num_units                      , :text],
        [ :total_num_units_occupied             , :text],
        [ :transaction_type                     , :text],
        [ :unit_count                           , :text],
        [ :unit_number                          , :text],
        [ :utilities                            , :text],
        [ :virtual_tour1                        , :text],
        [ :vow_allowed_avmyn                    , :text],
        [ :vow_allowed_third_party_comm_yn      , :text],
        [ :washer_dryer_included                , :text],
        [ :water                                , :text],
        [ :waterfronts                          , :text],
        [ :waterfront_yn                        , :text],
        [ :water_heater                         , :text],
        [ :windows                              , :text],
        [ :window_treatments                    , :text],
        [ :year_built                           , :text],
        [ :yr_blt_source                        , :text],
        [ :zoning                               , :text],
        [ :zoning_northport                     , :text],
        [ :zoning_tusc                          , :text]
      ], 
      CabooseRets::Log => [
        [ :class_name, :string ],
        [ :object_id, :string ],
        [ :text, :text ],
        [ :timestamp, :datetime ]
      ],
      CabooseRets::Media => [
        [ :photo_modification_timestamp      , :string     ],
        [ :file_name                         , :string     ],
        [ :media_mui                         , :string     ],
        [ :media_order                       , :integer     , { :default => 0 }],
        [ :media_remarks                     , :text       ],
        [ :media_type                        , :text       ],
        [ :url                               , :text       ],
        [ :image                             , :attachment ],
        [ :file                              , :attachment ],
        [ :media                             , :bytea      ]
      ],
      CabooseRets::SavedProperty => [
        [ :user_id         , :integer ],
        [ :mls_number      , :string ],
        [ :date_saved,     :datetime ]
      ],
      CabooseRets::SavedSearch => [
        [ :user_id       , :integer   ],
        [ :params        , :text      ],
        [ :date_created  , :timestamp ],
        [ :date_last     , :timestamp ],
        [ :interval      , :integer   ],
        [ :property_type , :string    ],
        [ :uri           , :text      ],
        [ :notify        , :boolean   ]
      ],
      CabooseRets::SearchOption => [
        [ :name            , :string ],
        [ :field           , :string ],
        [ :value           , :string ],
        [ :flag_for_delete , :boolean , { :default => false }]
      ],
      Caboose::Site => [
        [ :use_rets , :boolean, { :default => false }]
      ],
      Caboose::User => [
        [ :rets_agent_mls_id , :string ]
      ],
      CabooseRets::RetsConfig => [
        [ :site_id, :integer ],
        [ :office_mls, :string ],
        [ :office_mui, :string ],
        [ :agent_mls, :string ],
        [ :agent_mui, :string ],
        [ :rets_url, :string ],
        [ :rets_username, :string ],
        [ :rets_password, :string ],
        [ :default_sort, :string ]
      ]
  }
end