[Emmet_]

db_parse

Introduction
Yesterday, I began development of a new system that uses SQLite, but I was going to run queries all around the clock, so formatting strings all the time wasn't too pretty looking, so I implemented this useful library that does it for you!

Tutorial: https://sampforum.blast.hk/showthread.php?tid=483457

What's the catch?
This code:

pawn Code:

new
    string[128],
    DBResult:result, 
    DB:db = db_open("Accounts.db");

format(string, sizeof(string), "SELECT * FROM `Accounts` WHERE `Username` = '%s'", PlayerName(playerid));
result = db_query(db, string);

if (db_num_rows(result) > 0)
{
    db_get_field_assoc(result, "Money", string, sizeof(string));
    PlayerInfo[playerid][pMoney] = strval(string);

    db_get_field_assoc(result, "Score", string, sizeof(string));
    PlayerInfo[playerid][pScore] = strval(string);
}
db_free_result(result);

Looks very messy, but with db_parse:

pawn Code:

new
    rows, 
    DB:db = db_open("Accounts.db");

rows = db_parse(db, "Accounts", "`Username` = '%s'", PlayerName(playerid));
if (rows)
{
    PlayerInfo[playerid][pMoney] = db_fetch_int("Money");
    PlayerInfo[playerid][pScore] = db_fetch_int("Score");
}
db_free_parse();

Looks VERY neatly organized now, doesn't it?

Functions
There are 8 functions:

pawn Code:

// Parse a database query for fetching results.
stock db_parse(DB:database, db_table[], string[] = "", ...);

// Returns the integer of the specified field name.
stock db_fetch_int(field[]);

// Returns the float value of the specified field name.
stock Float:db_fetch_float(field[]);

// Returns a boolean value for the specified field name.
stock bool:db_fetch_bool(field[]);

// Fetches the string from the specified field name.
stock db_fetch_string(field[], dest[], size = sizeof(dest));

// Get the stored result of the last executed query.
stock db_get_result(&DBResult:result);

// Free the stored result.
stock db_free_parse();

// Similar to "db_next_row" but for the stored result.
stock db_next_parse();

Download
Pastebin
Solidfiles