Friday, September 29, 2017
Using seed.rb, from what I can gather, can only add data (i.e. if record already exists it creates duplicates).
The data transformation(table) will be changed fairly regularly (i.e. if I spot a venue listing that should not be included I define a transformation rather than delete it manually, this way if a similar thing happens again it will automatically be removed. As the data comes from external listings sites and facebook groups the transformation will need constantly tweaking based observations. It may be I have to do this by loading the data into staging tables and process them. Just looking for some pointers.
Ben
On Friday, September 29, 2017 at 4:32:58 PM UTC+1, Hassan Schroeder wrote:
-- The data transformation(table) will be changed fairly regularly (i.e. if I spot a venue listing that should not be included I define a transformation rather than delete it manually, this way if a similar thing happens again it will automatically be removed. As the data comes from external listings sites and facebook groups the transformation will need constantly tweaking based observations. It may be I have to do this by loading the data into staging tables and process them. Just looking for some pointers.
Ben
On Friday, September 29, 2017 at 4:32:58 PM UTC+1, Hassan Schroeder wrote:
On Fri, Sep 29, 2017 at 7:57 AM, Ben Edwards <lo...@funkytwig.com> wrote:
> In my application I have reference data tables that I setup on my staging
> server and then when it is tested I want to move it to production.
So use only the reference data to seed the production database.
Is this something you expect to have to do more than once? Will the
reference data change over time? If it's a one-off thing I'd probably
just do a DB dump of the relevant tables and be done with it...
--
Hassan Schroeder ------------------------ hassan.s...@gmail.com
twitter: @hassan
Consulting Availability : Silicon Valley or remote
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/30cbf996-c637-4828-a777-a58a0245adf7%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment