developer2346

Nice Job! But seems if I remove `sql:"primary_key"` tag, it does not work correctly. Same happens when I don't `SELECT` the `ID` column

Is there any way to use Jet without its query builder? I just need it for QRM

I have the following `SQL` schema: ``` CREATE TABLE `user` ( `username` VARCHAR(20) NOT NULL , `first_name` text NOT NULL , `last_name` text NOT NULL , `password` text NOT NULL...

The issue is permissions. They are not mapped. I also tried something like `SELECT article_edit as user.permissions.editArticle` ...

Also how to use `ORDER_BY` for dynamic conditions? the order is user input and user can pass empty order. Also how zero-values are handled for `WHERE` clauses? As the value...

I am trying to use `LIKE` operator with `RawStatement`: ``` if q != "" { has = `article.title LIKE ` + "'%" + "$s" + `%'` args["$s"] = q }...

Just to ensure let me ask something I am using `RawStatement` and `RawArgs` then `stmt.QueryContext`. Is it sql-injection safe? I mean does `RawArgs`, escape the injections? an example of what...

Hi How can I insert columns dynamically? I tried: ``` cols := []jet.Column{} com := model.Comment{} if comment.HTMLContent != "" { cols = append(cols, Comment.ContentHTML) com.ContentHTML = comment.HTMLContent } if...

Sorry to ask so many questions. I am struggling with another problem I need to add order clause dynamically. this is what I have tried: ``` for _, v :=...

It didn't work, Here is my query built with Jet: ``` SELECT a.`article.id` AS "article.id", a.`article.uid` AS "article.uid", a.`article.title` AS "article.title", a.`article.admin_id` AS "article.admin_id", a.`article.category_id` AS "article.category_id", a.`article.section_id` AS "article.section_id",...