Ejemplos de mysql_conns_init en C++ (Cpp)

Ejemplo n.º 1

Archivo: st_mysql_conn.c Proyecto: Luci4r/st_utils

int st_mysql_conn_test(void)
{

    MYSQL_Data mysql_data;
    strncpy(mysql_data.hostname,"192.168.122.1",128);
    strncpy(mysql_data.username,"v5kf",128);
    strncpy(mysql_data.password,"v5kf",128);
    strncpy(mysql_data.database,"v5kf",128);

    P_MYSQL_CONN p_conn[5];

    P_MYSQL_CONNS g_p_conns = mysql_conns_init(10, &mysql_data);
    if (!g_p_conns)
    {
        st_d_print("Failed to initate MySQL connection pool!\n");
        exit(-1);
    }

    st_d_print("Database prepared OK!\n");

    if( mysql_conns_capacity(g_p_conns) != 10)
        goto FAILED;

    p_conn[0] = mysql_get_conn(g_p_conns);
    p_conn[1] = mysql_get_conn(g_p_conns);
    p_conn[2] = mysql_get_conn(g_p_conns);
    p_conn[3] = mysql_get_conn(g_p_conns);

    if( mysql_conns_capacity(g_p_conns) != 6)
        goto FAILED;


    mysql_free_conn(g_p_conns, p_conn[2]);
    mysql_free_conn(g_p_conns, p_conn[0]);

    if( mysql_conns_capacity(g_p_conns) != 8)
        goto FAILED;

    mysql_conns_destroy(g_p_conns);
    if( mysql_conns_capacity(g_p_conns) != 0)
        goto FAILED;

    fprintf(stderr,"mysql_conn unit test PASS!\n");
    return 1;

FAILED:

    fprintf(stderr,"mysql_conn unit test FAILED!\n");
    return 0;
}

Ejemplo n.º 2

Archivo: test.cpp Proyecto: shelldonGuo/lib

int main()
{
    mysql_conns_init();

    int insert_id,affect_num;
    char sql_query[MAX_CONTENT_LEN];
    MysqlResult my_rst;
    MYSQL_ROW row;
    memset(sql_query,0,sizeof(sql_query));

    snprintf(sql_query,MAX_CONTENT_LEN, 
            "insert into rts_buf (objsign,objurl,fromurl) values (%llu,'%s','%s');", 
            12345,"http://1.jpg","http://1.html");

    int ret=mysql_conn.execUpdate(sql_query,insert_id,affect_num);
    if(SQL_FAIL == ret)
    {
        MYSQL* conn = mysql_conn.getMysql();
        printf("insert item failed! sql:[%s] msg:[%s]",sql_query,mysql_error(conn));
        return -1;
    }


    snprintf(sql_query,MAX_CONTENT_LEN, 
            "select objurl,fromurl from  rts_buf where objsign=%llu;", 
            12345);

    ret=mysql_conn.execSelect(sql_query,my_rst);
    if(SQL_FAIL == ret)
    {
        MYSQL* conn = mysql_conn.getMysql();
        printf("select item failed! sql:[%s] msg:[%s]",sql_query,mysql_error(conn));
        return -1;
    }

    if(NULL != my_rst.result() && NULL!=(row=mysql_fetch_row(my_rst.result())))
    {
        printf("objurl=%s\n",row[0]);

    }
    else{
        MYSQL* conn = mysql_conn.getMysql();
        printf("sql result error! sql:[%s] msg:[%s]",sql_query,mysql_error(conn));
        return -1;
    }

    return 0;

}