| 339 | |
| 340 | |
| 341 | db_res_t *sql_avp_load(struct db_url *url, str *uuid, str *username,str *domain, |
| 342 | char *attr, const str *table, struct db_scheme *scheme) |
| 343 | { |
| 344 | static db_key_t keys_ret[3]; |
| 345 | unsigned int nr_keys_cmp; |
| 346 | unsigned int nr_keys_ret; |
| 347 | db_res_t *res = NULL; |
| 348 | |
| 349 | /* prepare DB query */ |
| 350 | nr_keys_cmp = prepare_selection( uuid, username, domain, attr, scheme); |
| 351 | |
| 352 | /* set table */ |
| 353 | if (set_table( url, scheme?&scheme->table:table ,"load")!=0) |
| 354 | return 0; |
| 355 | |
| 356 | /* return keys */ |
| 357 | if (scheme==0) |
| 358 | { |
| 359 | keys_ret[0] = db_columns[2]; /*value*/ |
| 360 | keys_ret[1] = db_columns[1]; /*attribute*/ |
| 361 | keys_ret[2] = db_columns[3]; /*type*/ |
| 362 | nr_keys_ret = 3; |
| 363 | } else { |
| 364 | /* value */ |
| 365 | keys_ret[0] = scheme->value_col.s?&scheme->value_col:db_columns[2]; |
| 366 | nr_keys_ret = 1; |
| 367 | } |
| 368 | |
| 369 | /* do the DB query */ |
| 370 | if ( url->dbf.query( url->hdl, keys_cmp, 0/*op*/, vals_cmp, keys_ret, |
| 371 | nr_keys_cmp, nr_keys_ret, 0/*order*/, &res) < 0) |
| 372 | return 0; |
| 373 | |
| 374 | return res; |
| 375 | } |
| 376 | |
| 377 | |
| 378 | void db_close_query(struct db_url *url, db_res_t *res ) |
no test coverage detected