import utilme dbo = utilme.Database(db_host='127.0.0.1', db_usr='******', db_pwd='wave', db_type='mysql') # ============================================= # MANAGE db # ============================================= # === CREATE # --- create db # dbo.create_db('DB_MOUNTS') # --- create tb # tbname = 'targets' # dicts = {'id': 'INT', # 'name': 'CHAR', # 'shortname': 'CHAR', # 'country': 'CHAR', # 'lat': 'FLOAT', # 'lon': 'FLOAT'} # dbo.create_tb(dbname='DB_MOUNTS', tbname=tbname, dicts=dicts, primarykey='id') # === DELETE # --- delete db # dbo.delete_db('DB_MOUNTS')
import utilme # - connect to database f = file('./conf/credentials_mysql.txt') (db_usr, db_pwd) = f.readline().split(' ') dbo = utilme.Database(db_host='127.0.0.1', db_usr=db_usr, db_pwd=db_pwd, db_type='mysql') # ============================================= # MANAGE db # ============================================= # === CREATE # --- create db # dbo.create_db('DB_MOUNTS') # --- create tb # tbname = 'targets' # dicts = {'id': 'INT', # 'name': 'CHAR', # 'shortname': 'CHAR', # 'country': 'CHAR', # 'lat': 'FLOAT', # 'lon': 'FLOAT'} # dbo.create_tb(dbname='DB_MOUNTS', tbname=tbname, dicts=dicts, primarykey='id') # === DELETE # --- delete db
# filename='S2*MSIL1C*', # 'S2*MSIL2A*', # # 'cloudcoverpercentage': '[0 TO 2]', # filter_products=1, # => filter products if acquired at same minute, keep only tiles where intersection percentage with footprint is max) # download_pnode=optn['download_pnode'], # download_dir=optn['download_dir'], # maxrecords=100, ) p = tasks.query(optn, optn_s1, optn_s2) # p[1].getQuicklook() # print p[1].metadata.title print('=> products found in scihub:') fetchme.Scihub().print_product_title(p) print('=> products found in scihub which are not in DB_MOUNTS:') dbo = utilme.Database() p_in, p_new = dbo.dbmounts_isproduct_archived(p) pnew_title = fetchme.Scihub().print_product_title(p_new) # === DOWNLOAD + LOAD to archive if download: download_pnew = 1 # >> download new products only (else calculates md5sum and downloads if inconsistent) download_pidx = None # [2, 3, 4] # >> None=>download full product list; [0]=>download first product in list download_pnode = 'fullproduct' # >> None | 'quicklook' | 'fullproduct' download_rootdir = '/home/sebastien/DATA/data_satellite/' load_2dbarchive = 1 # --- select product(s) to download within productlist if download_pnew: p = p_new