... | ... | @@ -72,7 +72,7 @@ else: |
|
|
```
|
|
|
In order to check the database for the fusion matlab output
|
|
|
```sql
|
|
|
flo_user="-d postgresql://flo3@ratchet.sips/flo3"
|
|
|
flo_user='-h ratchet -U ro flo3'
|
|
|
> psql $flo_user -c "SELECT job,size,output,context,file_name from stored_products where computation='flo.sw.fusion_matlab:FUSION_MATLAB' and output='fused_l1b' order by file_name;"
|
|
|
job | size | output | context | file_name
|
|
|
----------+-----------+-----------+-------------------------------------------------------------------------------------------------------+-------------------------------------------------
|
... | ... | @@ -92,8 +92,10 @@ psql $flo_user -c "SELECT job,size,context,file_name from stored_products where |
|
|
```
|
|
|
To remove old files:
|
|
|
```sql
|
|
|
psql $flo_user -c "SELECT job, size, context, file_name FROM stored_products WHERE computation='flo.sw.fusion_matlab:FUSION_MATLAB' and context->'satellite'='''snpp''' and context->'version'='''1.0dev0''' order by file_name" | less
|
|
|
psql $flo_user -c "DELETE FROM stored_products WHERE computation='flo.sw.fusion_matlab:FUSION_MATLAB' and context->'satellite'='''snpp''' and context->'version'='''1.0dev0'''"
|
|
|
sudo su - flo
|
|
|
flo_user_rw='-h ratchet flo3'
|
|
|
psql $flo_user_rw -c "SELECT job, size, context, file_name FROM stored_products WHERE computation='flo.sw.fusion_matlab:FUSION_MATLAB' and context->'satellite'='''snpp''' and context->'version'='''1.0dev0''' order by file_name" | less
|
|
|
psql $flo_user_rw -c "DELETE FROM stored_products WHERE computation='flo.sw.fusion_matlab:FUSION_MATLAB' and context->'satellite'='''snpp''' and context->'version'='''1.0dev0'''"
|
|
|
```
|
|
|
## Other Database Querys
|
|
|
|
... | ... | |