httpd-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Gruno <rum...@cord.dk>
Subject Re: [Discuss] mod_lua and database connectivity
Date Tue, 08 Jan 2013 10:43:44 GMT
On 01/06/2013 07:21 PM, Daniel Gruno wrote:
> On 01/06/2013 04:23 PM, Stefan Fritsch wrote:
>> On Sun, 6 Jan 2013, Daniel Gruno wrote:
> -- Regular prepared statement creation:
> local prepped, err = db:prepare("SELECT * FROM `tbl` WHERE `id` = %s")
> if not err then
>     local result, err = prepped("foobar") -- insert foobar as id
>     ...
> end
> 
> -- Fetch from DBDPrepareSQL:
> local prepped, err = db:prepared("someTag")
> if not err then
>     local result, err = prepped("foobar") -- insert foobar as id
>     ...
> end
> 

One last change before I commit the code; prepared statements now have
two functions identical to the database object; select and query. These
were formerly known as query and run in the db object, but I have
renamed them to comply with the naming conventions of apr_dbd, thus
'query' is for running a command and fetching the no. of rows affected,
and 'select' is for...selecting :)

So, prepared statements are now run as follows:

-- select stuff
local prepared, err = db:prepare("SELECT * FROM `tbl` WHERE `age` > %u")
if not err then
    local result, err = prepared:select(1234)
    ....
end

-- run stuff
local prepared, err = db:prepare("DELETE FROM `tbl` WHERE `age` > %u")
if not err then
    local result, err = prepared:query(1234)
    ....
end

With regards,
Daniel.

Mime
View raw message