How to use aliases?

[fairking]

I could not find any manual how to use aliases

Would it be correct?:

type BookListItem struct {
	name string 
	cat string
}

var items []BookListItem

query := rel.
    Select("b.title as name", "c.category as cat").
    From("books as b").
    JoinOn("categories as c", "b.cat_id", "c.id")).
    Where(where.Eq("c.category", "education")).
    SortAsc("b.title")

err := repo.FindAll(ctx, &items, query)

[Fs02]

yes, that should be correct. there's no special builder for alias

you can also disable escaping when REL is not escaping the field correctly (such as when using function) by adding ^ prefix (example)

[Fs02]

can you try using AS? (From("contacts AS c").)
only case using AS is currently handled

[fairking]

Query:

var query = rel.
	Select("c.id", "c.created_at", "c.updated_at", "c.archived", "c.name", "c.description", "^MAX(n.updated_at) last_note_dated", "^AVG(n.score) avg_score").
	From("contacts AS c").
	JoinWith("LEFT JOIN", "notes AS n", "n.object_id", "c.id").
	Where(where.Eq("c.archived", false)).
	Where(where.Eq("n.archived", false)).
	Group("c.id", "c.created_at", "c.updated_at", "c.archived", "c.name", "c.description")

Result:

Instrumentation: adapter-query, SELECT "contacts" AS "c","contacts" AS "c","contacts" AS "c","contacts" AS "c","contacts" AS "c","contacts" AS "c","contacts" AS "c","contacts" AS "c" FROM "contacts" AS "c" LEFT JOIN "notes" AS "n" ON "n"."object_id"="c"."id" WHERE ("contacts" AS "c"=? AND "contacts" AS "c"=?) GROUP BY "contacts" AS "c","contacts" AS "c","contacts" AS "c","contacts" AS "c","contacts" AS "c","contacts" AS "c";, [[false false]]
Instrumentation: rel-scan-one, scanning a entity, [[]]
--- FAIL: Test_Contacts (12.41s)
    contact_service_test.go:67: 
        	Error Trace:	/tests/contact_service_test.go:67
        	Error:      	Expected nil, but got: sqlite3.Error{Code:1, ExtendedCode:1, SystemErrno:0x0, err:"near \"AS\": syntax error"}
        	Test:       	Test_Contacts
    contact_service_test.go:68: 
        	Error Trace:	/tests/contact_service_test.go:68
        	Error:      	Not equal: 
        	            	expected: 1
        	            	actual  : 0
        	Test:       	Test_Contacts
FAIL

[Fs02]

how about From("^contacts c") as temporary workaround

[fairking]

how about From("^contacts c") as temporary workaround

Still the same issue.

Sample:

var query = rel.
	Select("c.id", "c.created_at", "c.updated_at", "c.archived", "c.name", "c.description", "^MAX(n.updated_at) last_note_dated", "^AVG(n.score) avg_score").
	From("^contacts c").
	JoinWith("LEFT JOIN", "^notes n", "n.object_id", "c.id").
	Where(where.Eq("c.archived", false)).
	Where(where.Eq("n.archived", false)).
	Group("c.id", "c.created_at", "c.updated_at", "c.archived", "c.name", "c.description")

Same issue:

Instrumentation: adapter-query, SELECT "c"."id","c"."created_at","c"."updated_at","c"."archived","c"."name","c"."description",MAX(n.updated_at) last_note_dated,AVG(n.score) avg_score FROM "^contacts c" LEFT JOIN "^notes n" ON "n"."object_id"="c"."id" WHERE ("c"."archived"=? AND "n"."archived"=?) GROUP BY "c"."id","c"."created_at","c"."updated_at","c"."archived","c"."name","c"."description";, [[false false]]
    \tests\contact_service_test.go:67:
	Error Trace:    /tests/contact_service_test.go:67
	Error:          Expected nil, but got: sqlite3.Error{Code:1, ExtendedCode:1, SystemErrno:0x0, err:"no such table: ^contacts c"}
	Test:           Test_Contacts
    \tests\contact_service_test.go:68:
	Error Trace:    /tests/contact_service_test.go:68
	Error:          Not equal:
                                expected: 1
                                actual  : 0
	Test:           Test_Contact

[fairking]

Raised issue go-rel/sql#69