#define MAX_DEL_LIST_LEN 2000000
-/* Imported variables */
-extern char *select_job;
-extern char *drop_deltabs[];
-extern char *create_deltabs[];
-extern char *insert_delcand;
-extern char *select_backup_del;
-extern char *select_verify_del;
-extern char *select_restore_del;
-extern char *select_admin_del;
-extern char *cnt_File;
-extern char *del_File;
-extern char *upd_Purged;
-extern char *cnt_DelCand;
-extern char *del_Job;
-extern char *del_MAC;
-extern char *del_JobMedia;
-extern char *cnt_JobMedia;
-extern char *sel_JobMedia;
-
-
/* In memory list of JobIds */
struct s_file_del_ctx {
JobId_t *JobId;
db_sql_query(ua->db, query, file_delete_handler, (void *)&del);
for (i=0; i < del.num_ids; i++) {
- Mmsg(query, del_File, edit_int64(del.JobId[i], ed1));
- Dmsg1(200, "Delete Files JobId=%s\n", ed1);
- db_sql_query(ua->db, query, NULL, (void *)NULL);
- /*
- * Now mark Job as having files purged. This is necessary to
- * avoid having too many Jobs to process in future prunings. If
- * we don't do this, the number of JobId's in our in memory list
- * could grow very large.
- */
- Mmsg(query, upd_Purged, edit_int64(del.JobId[i], ed1));
- db_sql_query(ua->db, query, NULL, (void *)NULL);
- Dmsg1(200, "Update Purged sql=%s\n", query);
+ purge_files_from_job(ua, del.JobId[i]);
}
edit_uint64_with_commas(del.num_ids, ed1);
bsendmsg(ua, _("Pruned Files from %s Jobs for client %s from catalog.\n"),
* Then delete the Job entry, and finally and JobMedia records.
*/
for (i=0; i < del.num_ids; i++) {
- edit_int64(del.JobId[i], ed1);
- Dmsg1(050, "Delete JobId=%s\n", ed1);
if (!del.PurgedFiles[i]) {
- Mmsg(query, del_File, ed1);
- if (!db_sql_query(ua->db, query, NULL, (void *)NULL)) {
- bsendmsg(ua, "%s", db_strerror(ua->db));
- }
- Dmsg1(050, "Del sql=%s\n", query);
- }
-
- Mmsg(query, del_Job, ed1);
- if (!db_sql_query(ua->db, query, NULL, (void *)NULL)) {
- bsendmsg(ua, "%s", db_strerror(ua->db));
- }
- Dmsg1(050, "Del sql=%s\n", query);
-
- Mmsg(query, del_JobMedia, ed1);
- if (!db_sql_query(ua->db, query, NULL, (void *)NULL)) {
- bsendmsg(ua, "%s", db_strerror(ua->db));
+ purge_files_from_job(ua, del.JobId[i]);
}
- Dmsg1(050, "Del sql=%s\n", query);
+ purge_job_from_catalog(ua, del.JobId[i]);
}
bsendmsg(ua, _("Pruned %d %s for client %s from catalog.\n"), del.num_ids,
del.num_ids==1?_("Job"):_("Jobs"), client->hdr.name);
if (jr.JobTDate >= (now - period)) {
continue;
}
- edit_int64(del.JobId[i], ed1);
- Dmsg2(200, "Delete JobId=%s Job=%s\n", ed1, jr.Job);
- Mmsg(query, del_File, ed1);
- db_sql_query(ua->db, query, NULL, (void *)NULL);
- Mmsg(query, del_Job, ed1);
- db_sql_query(ua->db, query, NULL, (void *)NULL);
- Mmsg(query, del_JobMedia, ed1);
- db_sql_query(ua->db, query, NULL, (void *)NULL);
- Mmsg(query, del_MAC, ed1);
- db_sql_query(ua->db, query, NULL, (void *)NULL);
- Dmsg1(050, "Del sql=%s\n", query);
+ purge_files_from_job(ua, del.JobId[i]);
+ purge_job_from_catalog(ua, del.JobId[i]);
del.num_del++;
}
if (del.JobId) {