FilesExpand file tree

 master

/

sqlbuilder.lua

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

74 lines (63 loc) · 1.66 KB

 master

/

sqlbuilder.lua

Copy path

Top

File metadata and controls

• Code
• Blame

74 lines (63 loc) · 1.66 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

local sqlbuilder = {}

sqlbuilder._VERSION = "sql-builder 0.1"

sqlbuilder.select = function(what, tbl)

local ret = {}

local options = ""

local prefix = "WHERE"

local limit

local query = string.format("SELECT %s FROM `%s`", escape.sql(what), escape.sql(tbl))

local function generate_op(op)

local op = op

return function(key, value)

if type(value) == "string" then

value = string.format([["%s"]], escape.sql(value))

else

value = escape.sql(tostring(value))

end

key = escape.sql(tostring(key))

query = string.format("%s %s %s %s %s", query, prefix, key, op, value)

prefix = "AND"

return ret

end

end

ret.more_than = generate_op(">")

ret.less_than = generate_op("<")

ret.equals = generate_op("=")

ret.less_than_or_equal = generate_op("<=")

ret.more_than_or_equal = generate_op(">=")

ret.limit = function(number)

limit = number

return ret

end

ret.get = function()

if limit ~= nil then query = string.format("%s LIMIT %d", query, limit) end

return query

end

return ret

end

return sqlbuilder

--[[

-- concept:

local user = req:params().user

local pass = hash_password(req:params().pass)

sqlbuilder.fromtable({

SELECT = "*",

FROM = "tbl",

WHERE = {

{

{"user", "=", user}

"AND",

{"pass", "=", pass}

},

"OR",

{

{"user", "=", user},

"AND",

{"pass", "=", ""} -- idk, just to show the thingy

}

},

LIMIT = 1

})

-- yields:

-- SELECT * FROM `tbl` WHERE (user="Kobra" AND pass="a94...f2e") OR (user="Kobra" AND pass="") LIMIT 1

]]