Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
public:lta_tricks [2020-04-10 10:08]
Reinoud Bokhorst [Examples]
public:lta_tricks [2020-07-21 13:53] (current)
Thomas Jürges Updated link for Python stager API releases
Line 51: Line 51:
 There is a server that gives the option to run your own queries on the database [[https://​lta-dbview.lofar.eu/​|https://​lta-dbview.lofar.eu/​]] There is a server that gives the option to run your own queries on the database [[https://​lta-dbview.lofar.eu/​|https://​lta-dbview.lofar.eu/​]]
  
-A useful query might be this one, that gives you all files for a certain Obs Id (SAS VIC tree ID).<​code>​+A useful query might be this one, that gives you all files for a certain Obs Id (SAS VIC tree ID). 
 +<​code>​ 
 SELECT fo.URI, dp."​dataProductType",​ dp."​dataProductIdentifier",​ SELECT fo.URI, dp."​dataProductType",​ dp."​dataProductIdentifier",​
  ​dp."​processIdentifier"​  ​dp."​processIdentifier"​
Line 61: Line 63:
   AND fo.data_object = dp."​object_id"​   AND fo.data_object = dp."​object_id"​
   AND dp."​isValid">​ 0   AND dp."​isValid">​ 0
 +
 </​code>​ </​code>​
  
Line 77: Line 80:
   AND fo.data_object = dp."​object_id"​   AND fo.data_object = dp."​object_id"​
   AND dp."​isValid">​ 0   AND dp."​isValid">​ 0
 +
 </​code>​ </​code>​
  
Line 85: Line 89:
 Once you have installed the client, set up your user name and password. These are the same as for MoM. Remember that this is just a different interface to the LTA catalogue: you will need the same credentials as for the web interface. Once you have installed the client, set up your user name and password. These are the same as for MoM. Remember that this is just a different interface to the LTA catalogue: you will need the same credentials as for the web interface.
  
-After installing the LTA client, the file .awe/​Environment.cfg will appear in your home directory (if not, then create one). Make sure the file at least contains the following lines:<​file>​+After installing the LTA client, the file .awe/​Environment.cfg will appear in your home directory (if not, then create one). Make sure the file at least contains the following lines: 
 +<​file>​ 
 [global] [global]
 database_user ​      : <your username>​ database_user ​      : <your username>​
 database_password ​  : <your password>​ database_password ​  : <your password>​
 +
 </​file>​ </​file>​
  
Line 120: Line 127:
  
 pprint(result) pprint(result)
 +
 </​code>​ </​code>​
  
Line 134: Line 142:
 Pointing found RA 95.561458 DEC 24.584056 Pointing found RA 95.561458 DEC 24.584056
 ..etc.. ..etc..
 +
 </​code>​ </​code>​
  
Line 151: Line 160:
     Observation     Observation
 from awlofar.toolbox.LtaStager import LtaStager, LtaStagerError from awlofar.toolbox.LtaStager import LtaStager, LtaStagerError
 +
 </​code>​ </​code>​
  
Line 197: Line 207:
     stager = LtaStager()     stager = LtaStager()
     stager.stage_uris(uris)     stager.stage_uris(uris)
 +
  
 </​code>​ </​code>​
Line 255: Line 266:
     for project in (project1, project2) :     for project in (project1, project2) :
         stager.stage_uris(uris[project])         stager.stage_uris(uris[project])
 +
 </​code>​ </​code>​
  
Line 305: Line 317:
     stager = LtaStager()     stager = LtaStager()
     stager.stage_uris(uris)     stager.stage_uris(uris)
 +
  
 </​code>​ </​code>​
Line 318: Line 331:
 print(len(query)) print(len(query))
 # 1800 # 1800
 +
 </​code>​ </​code>​
  
Line 346: Line 360:
 for pipeline in query_pipelines : for pipeline in query_pipelines :
     print("​Pipeline:​ %s, %s, %s" % (type(pipeline).__name__,​ pipeline.pipelineName,​ pipeline.releaseDate))     print("​Pipeline:​ %s, %s, %s" % (type(pipeline).__name__,​ pipeline.pipelineName,​ pipeline.releaseDate))
- 
  
 # Data products # Data products
Line 353: Line 366:
 for product in query_products : for product in query_products :
     print("​Product:​ %s, %s, %s, %s" % (product.dataProductIdentifier,​ product.dataProductIdentifierSource,​ product.dataProductType,​ product.releaseDate))     print("​Product:​ %s, %s, %s, %s" % (product.dataProductIdentifier,​ product.dataProductIdentifierSource,​ product.dataProductType,​ product.releaseDate))
 +
 </​code>​ </​code>​
 +
 ===== Python Module for Staging ===== ===== Python Module for Staging =====
  
-The python interaction with the LTA catalog can be complemented with the use of a specific module developed to give users more control over their staging requests. ​ The module is made available **[[https://​git.astron.nl/​ro/​lofar_stager_api/​-/​tags|here]]** and its functions are mostly self-explanatory.+The python interaction with the LTA catalog can be complemented with the use of a specific module developed to give users more control over their staging requests. The module is made available **[[https://​git.astron.nl/​ro/​lofar_stager_api/​-/​releases|here]]** and its functions are mostly self-explanatory. 
 + 
 +**Alternatively to the .awe/​Environment.cfg described above, user credentials can also be provided via a file ~/​.stagingrc with credentials of your Lofar account**, similar to ./wgetrc: 
 +<​code>​
  
-**Alternatively to the .awe/​Environment.cfg described above, user credentials can also be provided via a file ~/​.stagingrc with credentials of your Lofar account**, similar to ./​wgetrc:<​code>​ 
   user=XXX   user=XXX
   password=YYY   password=YYY
 +
 </​code>​ </​code>​
  
Line 397: Line 415:
   - Status ​     ->     on hold   - Status ​     ->     on hold
   - User id      ->     1919   - User id      ->     1919
 +
 </​code>​ </​code>​
  
  
  • Last modified: 2020-04-10 10:08
  • by Reinoud Bokhorst