-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathupdate_rmrk_db.sh
34 lines (26 loc) · 1.52 KB
/
update_rmrk_db.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
#!/bin/bash
pg_login="<your_pg_login>"
pg_pass="<your_pg_password>"
pg_db_name="rmrk"
pg_host="localhost"
pg_connect="postgresql://$pg_login:$pg_pass@$pg_host/$pg_db_name"
home_dir="/home/ubuntu"
cd $home_dir
ipfs_vLite=`dig precon-lite.rmrk.link TXT | grep ipfs | cut -f 2 -d '"' | cut -f 2 -d '='`
url_vLite="http://cloudflare-ipfs.com/$ipfs_vLite"
ipfs_v1=`dig precon-mkt.rmrk.app TXT | grep ipfs | cut -f 2 -d '"' | cut -f 2 -d '='`
url_v1="http://cloudflare-ipfs.com/$ipfs_v1"
ipfs_v2=`dig precon-rmrk2.rmrk.link TXT | grep ipfs | cut -f 2 -d '"' | cut -f 2 -d '='`
url_v2="http://cloudflare-ipfs.com/$ipfs_v2"
wget $url_vLite -O $home_dir/dump_vLite.dump
wget $url_v1 -O $home_dir/dump_v1.dump
wget $url_v2 -O $home_dir/dump_v2.dump
last_block_vLite=`psql "$pg_connect" -t -c "select lastBlock from lastblock_vlite;" | tr -d ' ' | head -1`
last_block_v1=`psql "$pg_connect" -t -c "select lastBlock from lastblock_v1;" | tr -d ' ' | head -1`
last_block_v2=`psql "$pg_connect" -t -c "select lastBlock from lastblock_v2;" | tr -d ' ' | head -1`
python3 $home_dir/rmrk2psql.py -i $home_dir/dump_vLite.dump -o $home_dir/output_vLite.sql -v -b $last_block_vLite
python3 $home_dir/rmrk2psql.py -i $home_dir/dump_v1.dump -o $home_dir/output_v1.sql -v -b $last_block_v1
python3 $home_dir/rmrk2psql.py -i $home_dir/dump_v2.dump -o $home_dir/output_v2.sql -v -b $last_block_v2
psql "$pg_connect" -f $home_dir/output_vLite.sql
psql "$pg_connect" -f $home_dir/output_v1.sql
psql "$pg_connect" -f $home_dir/output_v2.sql