Public feed #891556

Unnamed

public text v1 · immutable
Raw Edit
·published 2008-02-04 18:52 UTC
rendered paste body
DatabaseResponse PostgreSQLConnection::ExecuteQuery(DatabaseRequest &request){
    DatabaseResponse response;
    
    
    //aducem sql-ul la forma select * from myfunc($1,$2,...$n)
    stringstream ss;
    ss<<"select * from "<<request.sql<<" (";
    
    for(uint32_t i=0;i<request.parameters.size()-1;i++){
        ss<<"$"<<(i+1)<<", ";
    }
    if(request.parameters.size()>=1){
        ss<<"$"<<request.parameters.size();
    }
    ss<<")";
    string preparedSql=ss.str();
    
    //identifici tipul de date pe care il intoarce tr.conn().prepare(...)
    returned_type preparedStmt=tr.conn().prepare(STR(preparedSql));
    
    FOR_VECTOR_ITERATOR(AMFPrimitive, request.parameters, i){
        swicth(VECTOR_VAL(i).type){
            case PT_STRING:
                preparedStmt=preparedStmp(STR(VECTOR_VAL(i)),treat_string));
                ...
        }
    }