[Dbmail-dev] Replacing snprintf for queries

[Aaron Stone]

How does this grab folks? It's sort of a homegrown printf just for our
queries, with the following replacements:

%s -- string, gets escaped automatically
%d -- integer
%l -- u64_t
%u -- unsigned integer

%T -- table prefix
%D -- to_date function
%C -- to_char function


void testdbstring(void)
{
        char *goquery;
        char *query = "SELECT * FROM %Ttable WHERE "
                " string = '%s' AND int = %d "
                " AND u64_t = %l AND unsigned = %u "
                " AND to_date = %D and to_char = %C ";
        char *string = "string";
        int integer = -12345;
        unsigned unint = 12345;
        u64_t bigint = 1222333444;

        dbstring(&goquery, query, string, integer, bigint, unint);

        printf("%s\n", goquery);
}


The query string is allocated, strings escaped, parameters replaced:

    SELECT * FROM dbmail_table WHERE
      string = 'string' AND int = -12345
      AND u64_t = 1222333444ND unsigned = 12345
      AND to_date =  TO_DATE( foo )  and to_char =  TO_CHAR( foo )


Aaron

--