[Serusers] mysql API

[.:: Francesco la Torre ::.]

Hi all,
is there any reference to new *db* API ?

In developer's guide, ch 8 there are old api.

Reading ser code, in particular auth_db module, some functions seems to
use valid database api.

I need only to do a query but it's hard to build correctly a query and
execute this, referencing only to some _similar_ code in some module.

What I need, and hope to be usefull for anybody, is a
template/guide/tutorial/documentation/dummy_example for a correct query
execution.


There is a snippet of the code :

 471 static int db_example(char* db_url){
 472     str result;
 473     db_cmd_t *query = NULL;
 474     db_res_t *result_t;
 475     db_rec_t *row;
 476 
 477     str id_column;
 478     str value_column;
 479     str table;
 480     str id;
 481 
 482     table.s = "value_att";
 483     table.len  = 10;
 484     id_column.s = "id_value";
 485     id_column.len = 9;
 486     value_column.s = "value";
 487     value_column.len = 5;
 488     int len;
 489 
 490     module_db_handle = db_ctx("module_db");
 491     if (!module_db_handle) goto err;
 492     if (db_add_db(module_db_handle, db_url) < 0) goto err;
 493     if (db_connect(module_db_handle) < 0)
 494         goto err;
 495     else
 496         LOG(L_INFO,"DB connected.\n");
 497 
 498     /* Setup query */
 499 
 500     db_fld_t match_with[] = {
 501         { .name = id_column.s, .type = DB_INT },
 502         { .name = NULL }
 503     };
 504     db_fld_t *result_cols = NULL;
 505 
 506 
 507     len = sizeof(*result_cols);
 508     result_cols = pkg_malloc(len);
 509     if (!result_cols) {
 510         ERR("can't allocate pkg mem\n");
 511         return -1;
 512     }
 513     memset(result_cols, 0, len);
 514 
 515     result_cols->name = value_column.s;
 516     result_cols->type = DB_STR;
 517 
 518     query =  db_cmd(DB_GET, module_db_handle, table.s, result_cols,
match_with, NULL);
 519 
 520     id.s="2";
 521     id.len=2;
 522     query->match[0].v.lstr = id;

 if (db_exec(&result_t, query) < 0 ) {
 525                  ERR("Error while querying database\n");
 526                  return -1;
 527      }
 528 
 529     if (result_t) row = db_first(result_t);
 530     else row=NULL;
 531 
 532     while (row) {
 533         if (IS_NULL((row)->fld[0]) || IS_NULL((row)->fld[1])) {
 534             
 535         } else {
 536             if ((row)->fld[1].v.int4 & DB_DISABLED) {
 537             } else {
 538                 if ((row)->fld[1].v.int4 & DB_LOAD_SER) {
 539                     break;
 540                 }
 541             }
 542         }
 543         row = db_next(result_t);
 544     }
 545 
 546     if (!row) {
 547         DBG("Value not found\n");
 548         return 1;
 549     }               
 550 
 551     result.s = (row)->fld[0].v.cstr;
 552     result.len = strlen(result.s);
 553    
 554 
 555     return 0;
 556 
 557 
 558 
 559 
 560 err:
 561 
 562     if (module_db_handle) {
 563         module_db_handle = NULL;
 564         db_ctx_free(module_db_handle);
 565     }
 566 
 567     LOG(L_ERR,"Error while initializing database layer\n");
 568     return -1;
 569 
 570 }    

I really hope to solve this problem because I don't want to use my sql
library when ser has his own database support.

Thanks in advance to anybody,
Francesco la Torre

_______________________________________________
Serdev mailing list
Serdev at lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serdev