The raw query interface

[CriztianiX]

I'm a playing with sailor, and i see that Sailor does not provide a raw interface to execute queries.

So, i've added in resty_,mysql.lua something like this:

-- Gets instance for db
-- @return table_name
function db.get_instance()
    db.instantiate()
    db.connect()
    return db
end

And now i can do:

local db = require "sailor.db"
db.get_instance().query("SELECT * from articles") 

Why this feature is not available in the framework?
Can be added with a PR?
Thanks!

[Etiene]

Hello! PRs are always welcome! 👯

But which version of Sailor are you using?
Isn't this method what you are looking for?
https://github.com/sailorproject/sailor/blob/master/src/sailor/db/resty_mysql.lua#L55

[CriztianiX]

Hey, yes!, but can not call this method directly, because depends on instialisate, connect, etc.
So, get_instance() give you a db's instance ready for work.
Take a look my example.

[Etiene]

Oh yes, of course. Hmm... yea! maybe we need a refactor over there :D

[CriztianiX]

Yes, i think so, the db layer should be re-implemented.
I can work in this, any idea? Desing? Architecture ?

[Etiene]

Which suggestions do you have in mind?

[CriztianiX]

CriztianiX@944fba4

What do you think?

[Etiene]

Added a new comment over there! ^_^