• Home
  • History
  • Annotate
Name Date Size #Lines LOC

..03-May-2022-

0001_get_restore_objectsH A D14-Sep-2021230 65

0002_cleanup_created_jobH A D14-Sep-2021128 76

0003_cleanup_running_jobH A D14-Sep-2021105 76

0004_fill_jobhistoH A D14-Sep-2021850 2221

0005_list_poolH A D14-Sep-202174 87

0006_list_jobsH A D14-Sep-2021611 1716

0007_list_jobs_longH A D14-Sep-2021915 2220

0008_list_jobs_countH A D14-Sep-2021509 1513

0009_list_jobs_lastH A D14-Sep-2021932 2624

0010_list_jobs_long_lastH A D14-Sep-20211.2 KiB3028

0011_sel_JobMediaH A D14-Sep-2021139 65

0012_drop_deltabsH A D14-Sep-202125 21

0012_drop_deltabs.mysqlH A D14-Sep-202135 21

0012_drop_deltabs.postgresqlH A D14-Sep-202135 21

0013_create_deltabsH A D14-Sep-2021199 65

0013_create_deltabs.mysqlH A D14-Sep-2021204 65

0013_create_deltabs.postgresqlH A D14-Sep-2021148 32

0014_create_delindexH A D14-Sep-202146 21

0015_uar_count_filesH A D14-Sep-202145 43

0016_uar_list_jobsH A D14-Sep-2021236 76

0017_uar_print_jobsH A D14-Sep-2021189 98

0018_uar_del_tempH A D14-Sep-202116 21

0019_uar_del_temp1H A D14-Sep-202117 21

0020_uar_last_fullH A D14-Sep-2021450 1514

0021_uar_last_full_no_poolH A D14-Sep-2021320 1211

0022_uar_fullH A D14-Sep-2021446 1211

0023_uar_difH A D14-Sep-2021633 1716

0024_uar_incH A D14-Sep-2021597 1615

0025_uar_list_jobs_by_idlistH A D14-Sep-2021279 87

0026_uar_sel_jobid_tempH A D14-Sep-202169 43

0027_uar_sel_all_temp1H A D14-Sep-202122 32

0028_uar_sel_all_tempH A D14-Sep-202121 32

0029_uar_sel_filesetH A D14-Sep-2021185 76

0030_uar_sel_filesetidH A D14-Sep-2021342 1210

0031_uar_jobid_fileindexH A D14-Sep-2021481 2220

0032_uar_jobids_fileindexH A D14-Sep-2021327 1716

0033_uar_jobid_fileindex_from_tableH A D14-Sep-202165 43

0034_select_recent_version_with_basejobH A D14-Sep-20211.3 KiB5250

0034_select_recent_version_with_basejob.postgresqlH A D14-Sep-2021982 4342

0035_select_recent_version_with_basejob_and_deltaH A D14-Sep-20211.8 KiB6967

0035_select_recent_version_with_basejob_and_delta.postgresqlH A D14-Sep-20211.1 KiB4745

0036_select_recent_versionH A D14-Sep-2021764 2928

0036_select_recent_version.postgresqlH A D14-Sep-2021426 1917

0037_create_temp_accurate_jobidsH A D14-Sep-2021494 2322

0038_create_temp_basefileH A D14-Sep-202160 21

0038_create_temp_basefile.mysqlH A D14-Sep-2021108 21

0039_create_temp_new_basefileH A D14-Sep-2021384 1514

0040_uap_upgrade_copies_oldest_jobH A D14-Sep-2021419 1715

0041_uar_fileH A D14-Sep-2021440 2120

0041_uar_file.mysqlH A D14-Sep-2021426 2019

0042_uar_create_tempH A D14-Sep-2021330 76

0042_uar_create_temp.postgresqlH A D14-Sep-2021269 65

0043_uar_create_temp1H A D14-Sep-202190 21

0043_uar_create_temp1.postgresqlH A D14-Sep-202172 21

0044_uar_jobid_fileindex_from_dirH A D14-Sep-2021324 1514

0044_uar_jobid_fileindex_from_dir.postgresqlH A D14-Sep-2021506 1817

0045_sql_media_order_most_recently_writtenH A D14-Sep-202154 21

0046_sql_get_max_connectionsH A D14-Sep-20219 21

0046_sql_get_max_connections.mysqlH A D14-Sep-202138 21

0046_sql_get_max_connections.postgresqlH A D14-Sep-202121 21

0047_bvfs_selectH A D14-Sep-2021544 2422

0047_bvfs_select.postgresqlH A D14-Sep-2021345 1514

0048_bvfs_list_filesH A D14-Sep-20211,009 4544

0048_bvfs_list_files.postgresqlH A D14-Sep-20211 KiB4847

0049_batch_lock_path_queryH A D14-Sep-20216 21

0049_batch_lock_path_query.mysqlH A D14-Sep-202153 21

0049_batch_lock_path_query.postgresqlH A D14-Sep-202151 21

0050_batch_lock_filename_queryH A D14-Sep-20216 21

0050_batch_lock_filename_query.mysqlH A D14-Sep-202161 21

0050_batch_lock_filename_query.postgresqlH A D14-Sep-202155 21

0051_batch_unlock_tables_queryH A D14-Sep-20217 21

0051_batch_unlock_tables_query.mysqlH A D14-Sep-202114 21

0052_batch_fill_path_queryH A D14-Sep-202189 76

0052_batch_fill_path_query.mysqlH A D14-Sep-2021192 1211

0052_batch_fill_path_query.postgresqlH A D14-Sep-2021199 1211

0053_batch_fill_filename_queryH A D14-Sep-202197 76

0053_batch_fill_filename_query.mysqlH A D14-Sep-2021200 1211

0053_batch_fill_filename_query.postgresqlH A D14-Sep-2021207 1211

0054_match_queryH A D14-Sep-202126 21

0054_match_query.mysqlH A D14-Sep-202128 21

0054_match_query.postgresqlH A D14-Sep-202123 21

0055_match_query2H A D14-Sep-202129 21

0055_match_query2.mysqlH A D14-Sep-202131 21

0055_match_query2.postgresqlH A D14-Sep-202126 21

0056_insert_counter_valuesH A D14-Sep-2021112 32

0056_insert_counter_values.mysqlH A D14-Sep-2021130 32

0057_select_counter_valuesH A D14-Sep-202191 43

0057_select_counter_values.mysqlH A D14-Sep-2021109 43

0058_update_counter_valuesH A D14-Sep-2021114 43

0058_update_counter_values.mysqlH A D14-Sep-2021141 43

0059_get_quota_jobbytesH A D14-Sep-2021103 65

0059_get_quota_jobbytes.postgresqlH A D14-Sep-2021113 65

0060_get_quota_jobbytes_nofailedH A D14-Sep-2021141 76

0060_get_quota_jobbytes_nofailed.postgresqlH A D14-Sep-2021151 76

0061_uar_sel_jobid_copiesH A D14-Sep-2021114 65

0062_get_jobstatus_detailsH A D14-Sep-2021590 2119

0063_bvfs_versions_6H A D14-Sep-2021736 2726

0064_bvfs_lsdirs_4H A D14-Sep-2021454 2221

0065_bvfs_clear_cache_0H A D14-Sep-2021206 108

0065_bvfs_clear_cache_0.sqliteH A D14-Sep-2021235 1110

0066_bvfs_update_path_visibility_3H A D14-Sep-2021306 1211

0066_bvfs_update_path_visibility_3.sqliteH A D14-Sep-2021254 76

0067_list_volumes_count_0H A D14-Sep-202158 21

0068_list_volumes_by_name_count_1H A D14-Sep-202179 43

0069_list_volumes_by_poolid_count_1H A D14-Sep-202179 43

0070_list_joblog_2H A D14-Sep-202171 54

0071_list_joblog_count_1H A D14-Sep-202153 43

0072_get_orphaned_paths_0H A D14-Sep-2021323 1312

0073_get_bad_paths_0H A D14-Sep-2021107 76

0074_bvfs_ls_special_dirs_3H A D14-Sep-2021722 3128

0074_bvfs_ls_special_dirs_3.postgresqlH A D14-Sep-2021800 3229

0075_bvfs_ls_sub_dirs_5H A D14-Sep-20211.9 KiB6160

0075_bvfs_ls_sub_dirs_5.postgresqlH A D14-Sep-20212 KiB6463

0076_list_volumes_select_0H A D14-Sep-2021212 65

0077_list_volumes_select_long_0H A D14-Sep-20211.4 KiB4746

0078_bvfs_lock_pathhierarchy_0H A D14-Sep-20216 21

0078_bvfs_lock_pathhierarchy_0.mysqlH A D14-Sep-202144 21

0078_bvfs_lock_pathhierarchy_0.postgresqlH A D14-Sep-202160 21

0079_bvfs_unlock_tables_0H A D14-Sep-20217 21

0079_bvfs_unlock_tables_0.mysqlH A D14-Sep-202114 21

READMEH A D14-Sep-2021537 1611

check_queriesH A D14-Sep-2021284 1812

create_queryfiles.shH A D14-Sep-20212.8 KiB10860

duplicate_queriesH A D14-Sep-2021632 4223

README

1This directory contains individual sql queries,
2
3These queries are translated into .inc files into
4../ by the following scripts:
5
6create_queryfiles.sh
7
8The .inc files only need to be updated when the queries
9are altered or new ones are added.
10
11NOTE:
12  * Naming: Number_Description_NumberOfArguments
13  * As % are used for replace variables, % in SQL LIKE statements must be escaped (% => %%).
14  * each query must consist of a single SQL statement,
15    as more statement, separated by columns (";") need special result handling for MySQL.
16