static void usp_init_updates()
{
U_TRACE(5, "::usp_init_updates()")
psql_updates = U_NEW(UOrmSession(U_CONSTANT_TO_PARAM("hello_world")));
pstmt1 = U_NEW(UOrmStatement(*psql_updates, U_CONSTANT_TO_PARAM("SELECT randomNumber FROM World WHERE id = ?")));
pstmt2 = U_NEW(UOrmStatement(*psql_updates, U_CONSTANT_TO_PARAM("UPDATE World SET randomNumber = ? WHERE id = ?")));
if (pstmt1 == 0 ||
pstmt2 == 0)
{
U_ERROR("usp_init_updates(): we cound't connect to db, exiting...");
}
pworld_updates = U_NEW(World);
pvworld_updates = U_NEW(UVector<World*>(500));
pstmt1->use( pworld_updates->id);
pstmt1->into(pworld_updates->randomNumber);
pstmt2->use( pworld_updates->randomNumber, pworld_updates->id);
#ifndef AS_cpoll_cppsp_DO
pvalue = U_NEW(UValue(ARRAY_VALUE));
#endif
}
static void usp_init_fortunes()
{
U_TRACE(5, "::usp_init_fortunes()")
psql_fortune = U_NEW(UOrmSession(U_CONSTANT_TO_PARAM("fortune")));
pstmt_fortune = U_NEW(UOrmStatement(*psql_fortune, U_CONSTANT_TO_PARAM("SELECT id, message FROM Fortune")));
if (pstmt_fortune == 0) U_ERROR("usp_init_fortunes(): we cound't connect to db, exiting...");
pfortune = U_NEW(Fortune);
pvfortune = U_NEW(UVector<Fortune*>);
pmessage = U_NEW(U_STRING_FROM_CONSTANT("Additional fortune added at request time."));
pstmt_fortune->into(*pfortune);
}
