Changeset e05a982 in osmose-frontend


Ignore:
Timestamp:
Feb 8, 2014 11:06:42 PM (6 years ago)
Author:
Jocelyn Jaubert <jocelyn.jaubert@…>
Branches:
master
Children:
fb953a3
Parents:
8aa5487
Message:

Change pg_base to osmose_frontend

Location:
tools
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • tools/cron.sh

    r712a157 re05a982  
    33set -e 
    44 
    5 DATABASE=osmose 
     5DATABASE=osmose_frontend 
    66 
    77psql -d $DATABASE -c "DELETE FROM dynpoi_status WHERE date < now()-interval '7 day' AND status = 'done';" 
  • tools/database/item_menu_update.sh

    r0aa309f re05a982  
    44  echo $i 
    55  lang=`echo $i | cut -d'_' -f3 | cut -d. -f1` 
    6   cat $i | sed "s/'/''/g" | sed "s/ *\([0-9]*\) *| \(.*\)/update dynpoi_item set menu = coalesce(menu, hstore('$lang','')) || hstore('$lang', '\2') where item = \1;/" | psql osmose 
     6  cat $i | sed "s/'/''/g" | sed "s/ *\([0-9]*\) *| \(.*\)/update dynpoi_item set menu = coalesce(menu, hstore('$lang','')) || hstore('$lang', '\2') where item = \1;/" | psql osmose_frontend 
    77done 
  • tools/utils.py

    re5ad5cd re05a982  
    1010pg_user           = "osmose" 
    1111pg_pass           = "clostAdtoi" 
    12 pg_base           = "osmose" 
     12pg_base           = "osmose_frontend" 
    1313website           = "osmose.openstreetmap.fr" 
    1414 
Note: See TracChangeset for help on using the changeset viewer.