_orderby cant support function about gendry HOT 4 CLOSED

ok,I use column alias. Though not so convenient,it works.

from gendry.

for example:
  where := map[string]interface{}{
	"_orderby":          "IFNULL(I_VALUE,0) DESC, I_ID DESC",
	"_limit":            []uint{0, 1},
}
query, args, err := builder.BuildSelect("src_table", where, []string{"I_ID,I_VALUE"})
if err != nil {
	return
}
err = db.Select(&ret, query, args...)

in this case,gendry will split the "," in function "IFNULL".

Sorry for the inconvenience. Gendry splits the comma for the sake of supporting grammar like this colA asc,colB desc. But if taking function call into consideration, it will become extremely complicated and hard to implement, we must parse it into an AST in advance, by doing so can we understand the meaning of each parts.
For sql like this, I recommend you'd better use builder.NamedQuery to write sql manually

from gendry.

One of the advantages Gendry has is that, it's non-intrusive. Which means if something gendry not support, you can write sql manually, which, in fact, won't cost you too much time . It just a tool which help you construct sql, and do nothing else.

from gendry.

One of the advantages Gendry has is that, it's non-intrusive. Which means if something gendry not support, you can write sql manually, which, in fact, won't cost you too much time . It just a tool which help you construct sql, and do nothing else.

Thanks a lot.

from gendry.