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; }
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; }