| 458 | } |
| 459 | |
| 460 | int db_ctl::load_db_tbls(void) |
| 461 | { |
| 462 | const char* sql = "select id_db, id_tbl, count from tbl_db_tbl"; |
| 463 | if ((ctl_conn_->sql_select(sql)) == false) |
| 464 | { |
| 465 | logger_error("sql(%s) error", sql); |
| 466 | return -1; |
| 467 | } |
| 468 | |
| 469 | const std::vector<acl::db_row*>* rows = ctl_conn_->get_rows(); |
| 470 | if (rows == NULL) |
| 471 | { |
| 472 | logger_warn("tbl_db_tbl empty"); |
| 473 | return 0; |
| 474 | } |
| 475 | |
| 476 | unsigned int id_db, id_tbl; |
| 477 | acl_int64 count; |
| 478 | |
| 479 | size_t i; |
| 480 | for (i = 0; i < rows->size(); i++) |
| 481 | { |
| 482 | const acl::db_row* row = (*rows)[i]; |
| 483 | if ((id_db = row->field_int("id_db", -1)) == (unsigned int) -1) |
| 484 | { |
| 485 | logger_warn("id_db invalid"); |
| 486 | continue; |
| 487 | } |
| 488 | else if ((id_tbl = row->field_int("id_tbl", -1)) == |
| 489 | (unsigned int) -1) |
| 490 | { |
| 491 | logger_warn("id_tbl invalid"); |
| 492 | continue; |
| 493 | } |
| 494 | else if ((count = row->field_int64("count", -1)) == -1) |
| 495 | { |
| 496 | logger_warn("count invalid"); |
| 497 | continue; |
| 498 | } |
| 499 | add_tbl(id_db, id_tbl, count); |
| 500 | } |
| 501 | |
| 502 | ctl_conn_->free_result(); |
| 503 | return (int) i; |
| 504 | } |
| 505 | |
| 506 | int db_ctl::load_tbl_idxes(void) |
| 507 | { |
nothing calls this directly
no test coverage detected