extern DIRRES *director;
-static POOLMEM *substitute_prompts(UAContext *ua,
+static POOLMEM *substitute_prompts(UAContext *ua,
POOLMEM *query, char **prompt, int nprompt);
/*
char *prompt[9];
int nprompt = 0;;
char *query_file = director->query_file;
-
+
if (!open_db(ua)) {
goto bail_out;
}
len = strlen(line);
if (line[0] == '*') { /* prompt */
if (nprompt >= 9) {
- bsendmsg(ua, _("Too many prompts in query, max is 9.\n"));
+ bsendmsg(ua, _("Too many prompts in query, max is 9.\n"));
} else {
- line[len++] = ' ';
+ line[len++] = ' ';
line[len] = 0;
prompt[nprompt++] = bstrdup(line+1);
continue;
}
- }
+ }
if (*query != 0) {
- pm_strcat(query, " ");
+ pm_strcat(query, " ");
}
pm_strcat(query, line);
if (line[len-1] != ';') {
line[len-1] = 0; /* zap ; */
if (query[0] != 0) {
query = substitute_prompts(ua, query, prompt, nprompt);
- Dmsg1(100, "Query2=%s\n", query);
- if (query[0] == '!') {
+ Dmsg1(100, "Query2=%s\n", query);
+ if (query[0] == '!') {
db_list_sql_query(ua->jcr, ua->db, query+1, prtit, ua, 0, VERT_LIST);
} else if (!db_list_sql_query(ua->jcr, ua->db, query, prtit, ua, 1, HORZ_LIST)) {
- bsendmsg(ua, "%s\n", query);
+ bsendmsg(ua, "%s\n", query);
}
query[0] = 0;
}
if (query[0] != 0) {
query = substitute_prompts(ua, query, prompt, nprompt);
Dmsg1(100, "Query2=%s\n", query);
- if (query[0] == '!') {
+ if (query[0] == '!') {
db_list_sql_query(ua->jcr, ua->db, query+1, prtit, ua, 0, VERT_LIST);
} else if (!db_list_sql_query(ua->jcr, ua->db, query, prtit, ua, 1, HORZ_LIST)) {
- bsendmsg(ua, "%s\n", query);
+ bsendmsg(ua, "%s\n", query);
}
}
return 1;
}
-static POOLMEM *substitute_prompts(UAContext *ua,
+static POOLMEM *substitute_prompts(UAContext *ua,
POOLMEM *query, char **prompt, int nprompt)
{
char *p, *q, *o;
}
p++;
switch (*p) {
- case '1':
- case '2':
- case '3':
- case '4':
- case '5':
- case '6':
- case '7':
- case '8':
- case '9':
- n = (int)(*p) - (int)'1';
+ case '1':
+ case '2':
+ case '3':
+ case '4':
+ case '5':
+ case '6':
+ case '7':
+ case '8':
+ case '9':
+ n = (int)(*p) - (int)'1';
if (prompt[n]) {
if (!subst[n]) {
if (!get_cmd(ua, prompt[n])) {
*o++ = *p++;
}
} else {
- bsendmsg(ua, _("Warning prompt %d missing.\n"), n+1);
+ bsendmsg(ua, _("Warning prompt %d missing.\n"), n+1);
}
q += 2;
break;
- case '%':
- *o++ = '%';
+ case '%':
+ *o++ = '%';
q += 2;
break;
default:
- *o++ = '%';
+ *o++ = '%';
q++;
break;
}
}
*query = 0;
- bsendmsg(ua, _("Entering SQL query mode.\n\
-Terminate each query with a semicolon.\n\
-Terminate query mode with a blank line.\n"));
+ bsendmsg(ua, _("Entering SQL query mode.\n"
+"Terminate each query with a semicolon.\n"
+"Terminate query mode with a blank line.\n"));
msg = "Enter SQL query: ";
while (get_cmd(ua, msg)) {
len = strlen(ua->cmd);
}
query = check_pool_memory_size(query, len + 1);
if (*query != 0) {
- strcat(query, " ");
+ strcat(query, " ");
}
strcat(query, ua->cmd);
if (ua->cmd[len-1] == ';') {
/* Submit query */
db_list_sql_query(ua->jcr, ua->db, query, prtit, ua, 1, HORZ_LIST);
*query = 0; /* start new query */
- msg = _("Enter SQL query: ");
+ msg = _("Enter SQL query: ");
} else {
- msg = _("Add to SQL query: ");
+ msg = _("Add to SQL query: ");
}
}
free_pool_memory(query);
bsendmsg(ua, _("End query mode.\n"));
- return 1;
+ return 1;
}