CartoDB / data-services

CARTO internal geocoder PostgreSQL extension
25 stars 11 forks source link

Add download and apply patches scripts #218

Closed iriberri closed 8 years ago

iriberri commented 8 years ago

Hey @rafatower,

I basically duplicated our current scripts but applied them to the patches. I generated them and uploaded them to a specific /patches folder inside version 0.0.1.

I separated this process from the download/load dumps procedure because in general patches will be applied in a different moment in time. It's been tested locally and running as expected:

ubuntu@cdb:~/www/production.cartodb.com/current/carlachecks$ sh geocoder_apply_patches.sh development_cartodb_user_367c0edc-b2ad-4bab-ad43-3d58a6179a93 cartodb_dev_user_367c0edc-b2ad-4bab-ad43-3d58a6179a93_db data_patches/*.sql

About to import the following files: data_patches/20160203_countries_bh_isocode.sql data_patches/20160622_countries_synonym_congo.sql

Importing data_patches/20160203_countries_bh_isocode.sql...
DELETE 1
Done with data_patches/20160203_countries_bh_isocode.sql.

Importing data_patches/20160622_countries_synonym_congo.sql...
INSERT 0 1
Done with data_patches/20160622_countries_synonym_congo.sql.
rafatower commented 8 years ago

fair enough :+1: moving on..