6 |
|
|
7 |
echo "** insert new data in master **" |
echo "** insert new data in master **" |
8 |
|
|
9 |
dir=/home/dpavlin/private/adsl |
$psql -p 5001 -c 'copy spajanja (start_t,stop_t,download,upload,duration,ip) from stdin;' < data/200608.txt |
|
$dir/fix_date.pl $dir/200608.txt | $psql -p 5001 -c 'copy spajanja (start_t,stop_t,download,upload,duration,ip) from stdin;' |
|
10 |
|
|
11 |
echo "** after new data **" |
echo "** after new data **" |
12 |
|
|
22 |
echo "** OK **" |
echo "** OK **" |
23 |
|
|
24 |
echo "** following SHOULD RETURN ERROR! **" |
echo "** following SHOULD RETURN ERROR! **" |
25 |
$dir/fix_date.pl $dir/200609.txt | $psql -p 5002 -c 'copy spajanja (start_t,stop_t,download,upload,duration,ip) from stdin;' |
$psql -p 5002 -c 'copy spajanja (start_t,stop_t,download,upload,duration,ip) from stdin;' < data/200609.txt |