Jump to content
dennis

lsqlite3 dynamic update

Recommended Posts

heya all smile.png

 

 

when I want to update an value in my database it needs to be done dynamically (by the user) for example. when the value in the database = 1, the user may want to change that to 0 (when he sets the Bloom off) I can do it hard coded by using:

for test in db:nrows("UPDATE test SET bloom = 1 WHERE bloom = 0")

 

I already have an placeholder for this which is

 

local bloomval =1

 

How to do this so the value of bloomval = 1 can be set by the user ?

Regards,

Share this post


Link to post

I don't quite understand what you are asking. If i understand this is a straight forward way about it.

 

local settings = db:nrows("Select * from settings")[1]  or CreateSettings() -- singleton row
function SetSetting(field, value)
db:exec("UPDATE settings SET " .. field .. " = " value")
settings[field] = value
end

Share this post


Link to post

okay thanks :)

what I wanted to do is that I have sliders and check boxes, those will set an value.

I want that value to be returned to the code and updated in the database...

And the code fragment I showed will do that but I can not add my own value to it.

Share this post


Link to post

A good number of sql engines have a concept they call prepared statements. This allows you to define parameters and set those parameters with values. The reason you want to use these instead of building the sql string yourself is to avoid something they call sql injection. Here is an example on how to do it using Lua: http://www.nessie.de/mroth/lua-sqlite3/documentation.html#ref11 . This is the preferred method. You also get a speed boost by using prepared statements.

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...