Commits · 1e515b86416020fd8a762dfbbb4aa9a23f802332 · RadioObservatory / LOFAR · GitLab

Snippets Groups Projects

Oct 26, 2015
- Task #8291: added tables and view for projects. There is no trigger yet, which... · 1e515b86
  Jorrit Schaap authored 9 years ago
  
  Task #8291: added tables and view for projects. There is no trigger yet, which links a directory to a project
  1e515b86
Oct 23, 2015
- Task #8291: layout, font sizes · 8878085b
  Jorrit Schaap authored 9 years ago
  
  8878085b
- Task #8291: added method directory_id to find a directory_id by site_id and dir name · cd763241
  Jorrit Schaap authored 9 years ago
  
  cd763241
Oct 22, 2015
- Task #8291: string format type %d -> %s · 047ed81a
  Jorrit Schaap authored 9 years ago
  
  047ed81a
- Task #8291: use faster directoty_stats table to get aggegate results. · 88cff9ec
  Jorrit Schaap authored 9 years ago
  
  88cff9ec
- Task #8291: added trigger and helper table to fill new directory_stats table... · 7c73af31
  Jorrit Schaap authored 9 years ago
  
  Task #8291: added trigger and helper table to fill new directory_stats table with aggregates of fileinfo for faster selects which are usually at dir level and not at individual file level
  7c73af31
- Task #8291: improved cumulative and delta trends. Added totals. · 497ac388
  Jorrit Schaap authored 9 years ago
  
  497ac388
Oct 20, 2015
- Task #8291: added cumulative and delta trends · 93700558
  Jorrit Schaap authored 9 years ago
  
  93700558
- Task #8291: minor fixes · ffc0f794
  Jorrit Schaap authored 9 years ago
  
  ffc0f794
- Task #8291: moved humanreadablesize method to module utils. added monthRanges... · edec9511
  Jorrit Schaap authored 9 years ago
  
  Task #8291: moved humanreadablesize method to module utils. added monthRanges method. use utils methods in report.
  edec9511
- Task #8291: added methods numFilesInSite totalFileSizeInSite · 722c4b0b
  Jorrit Schaap authored 9 years ago
  
  722c4b0b
- Task #8291: added method datetimeRangeOfFilesInTree · a1f29b67
  Jorrit Schaap authored 9 years ago
  
  a1f29b67
- Task #8291: plot pie chart with usages per site · c0dcf8a9
  Jorrit Schaap authored 9 years ago
  
  c0dcf8a9
- Task #8291: print changes for current month in report · 8a546318
  Jorrit Schaap authored 9 years ago
  
  8a546318
Oct 19, 2015
- Task #8291: made several query methods optionally date_bounded · 81fda38b
  Jorrit Schaap authored 9 years ago
  
  81fda38b
- Task #8291: added methods numFilesInDirectory and numFilesInTree · 18455a5a
  Jorrit Schaap authored 9 years ago
  
  18455a5a
- Task #8291: added simple cmd line report tool · 031e9408
  Jorrit Schaap authored 9 years ago
  
  031e9408
- Task #8291: added create_db_ltastorageoverview.sql · 0f3d7fc5
  Jorrit Schaap authored 9 years ago
  
  0f3d7fc5
- Task #8291: added view site_directory_file · 83ecb560
  Jorrit Schaap authored 9 years ago
  
  83ecb560
- Task #8291: moved all sql create code to create_db_ltastorageoverview.sql script · ef2e1b85
  Jorrit Schaap authored 9 years ago
  
  ef2e1b85
- Task #8291: logging · 23c51b94
  Jorrit Schaap authored 9 years ago
  
  23c51b94
Oct 16, 2015
- Task #8291: removed obsolete methods · 45e79172
  Jorrit Schaap authored 9 years ago
  
  45e79172
- Task #8291: insert list of files in one transaction for speed · 9a1aa0dc
  Jorrit Schaap authored 9 years ago
  
  9a1aa0dc
- Task #8291: use site visit stats to load balance which site is scraped next · 6dd7374c
  Jorrit Schaap authored 9 years ago
  
  6dd7374c
- Task #8291: gather visit stats per site · 5881c4ed
  Jorrit Schaap authored 9 years ago
  
  5881c4ed
- Task #8291: create view site_scraper_last_directoy_visit · 793859e1
  Jorrit Schaap authored 9 years ago
  
  793859e1
- Task #8291: create view site_directory_tree · 385f4955
  Jorrit Schaap authored 9 years ago
  
  385f4955
- Task #8291: create view root_directories and use it. PRAGMA foreign_keys = ON · 3a65973a
  Jorrit Schaap authored 9 years ago
  
  3a65973a
- Task #8291: check for None · d5f26346
  Jorrit Schaap authored 9 years ago
  
  d5f26346
- Task #8291: removed obsolete imports and code · 1f49e5d1
  Jorrit Schaap authored 9 years ago
  
  1f49e5d1
- Task #8291: partial indexes are not supported on all platforms · 1b503d72
  Jorrit Schaap authored 9 years ago
  
  1b503d72
- Task #8291: fixed typo · 261b72f0
  Jorrit Schaap authored 9 years ago
  
  261b72f0
- Task #8291: improved get_sites_usages method · 4bb68ac2
  Jorrit Schaap authored 9 years ago
  
  4bb68ac2
- Task #8291: optimized filesInTree method. added totalFileSizeInTree method · bd839eec
  Jorrit Schaap authored 9 years ago
  
  bd839eec
- Task #8291: added rootDirectoriesForSite select method · d51c989c
  Jorrit Schaap authored 9 years ago
  
  d51c989c
- Task #8291: created several index in tables for faster select queries · 53962691
  Jorrit Schaap authored 9 years ago
  
  53962691
Oct 15, 2015
- Task #8291: Use store module to save results and queues persistent. Removed... · 5c67ac87
  Jorrit Schaap authored 9 years ago
  
  Task #8291: Use store module to save results and queues persistent. Removed reporting. We'll have to use store + reporting for that as well
  5c67ac87
- Task #8291: fix: creation_date for file_info. query... · 78ed5398
  Jorrit Schaap authored 9 years ago
  
  Task #8291: fix: creation_date for file_info. query leastRecentlyVisitedDirectory with before_timestamp.
  78ed5398
- Task #8291: added method to count the number of directories not visited since a timestamp · 0da9ca85
  Jorrit Schaap authored 9 years ago
  
  0da9ca85
- Task #8291: added method to get info for one direcory by id · c6a5880a
  Jorrit Schaap authored 9 years ago
  
  c6a5880a