void test3()
{
DBMysqlConnectionPool pool("mysql://*****:*****@localhost:3306/test");
if (!pool.init())
return;
DBConnection* conn = pool.get(DBCS_PREPARING);
if (!conn)
return;
DBObject14 a;
if (!conn->prepare("select *,unix_timestamp(t) from test", a))
{
while (!conn->next())
{
//printf("a.m.size(): %lu\n", a.m.size());
//printf("a.n.rsize(): %d\n", a.n.rsize());
printf("%lu,%d,%d,%d,%d,%d,%d,%lld,%lld,%f,%f,%f,%s,%s(%d)\n", a.tt,a.c,a.d,a.e,a.f,a.g,a.h,a.i,a.j,a.k,a.kk,a.l,&a.m[0],a.n.rbuf(),a.n.rsize());
}
}
printf("---------------------------------\n");
#if 1
conn->finish();
DBObject14 b;
if (!conn->prepare("select *,unix_timestamp(t) from test", b))
{
while (!conn->next())
{
printf("%lu,%d,%d,%d,%d,%d,%d,%lld,%lld,%f,%f,%f,%s,%s(%d)\n", b.tt,b.c,b.d,b.e,b.f,b.g,b.h,b.i,b.j,b.k,b.kk,b.l,&b.m[0],b.n.rbuf(),b.n.rsize());
}
}
#endif
conn->finish();
pool.put(conn);
}
void test2()
{
DBMysqlConnectionPool pool("mysql://*****:*****@localhost:3306/test");
//DBMysqlConnectionPool pool("mysql://*****:*****@172.16.5.1:3306/test");
if (!pool.init())
return;
DBConnection* conn = pool.get(DBCS_PREPARING);
if (!conn)
return;
DBObject a;
//conn->prepare("select * from one", a);
conn->prepare("select * from one", a);
while (!conn->next())
{
printf("%d\n", a.c);
}
printf("---------------------------------\n");
pool.put(conn);
}