Method RenderOrderBy

core/internal/dialect/sqlite.go:147–207

(ctx Context, sel *qcode.Select)

func (d *SQLiteDialect) RenderOrderBy(ctx Context, sel *qcode.Select) {
	if len(sel.OrderBy) == 0 {
		return
	}
	ctx.WriteString(` ORDER BY `)

	for i, ob := range sel.OrderBy {
		if i != 0 {
			ctx.WriteString(`, `)
		}
		if ob.KeyVar != "" && ob.Key != "" {
			ctx.WriteString(` CASE WHEN `)
			ctx.AddParam(Param{Name: ob.KeyVar, Type: "text"})
			ctx.WriteString(` = `)
			ctx.WriteString(fmt.Sprintf("'%s'", strings.ReplaceAll(ob.Key, "'", "''")))
			ctx.WriteString(` THEN `)
		}
		
		if ob.Var != "" {
			ctx.ColWithTable("_gj_ob_"+ob.Col.Name, "ord")
		} else if ob.Alias != "" {
			ctx.Quote(ob.Alias)
		} else if sel.Rel.Type == sdata.RelEmbedded {
			// Embedded JSON relationships in SQLite are rendered from json_each
			// rows, so order by expressions must read from __sr_<id>.value.
			ctx.WriteString(`json_extract(`)
			ctx.Quote(fmt.Sprintf("__sr_%d", sel.ID))
			ctx.WriteString(`."value", '$."`)
			ctx.WriteString(ob.Col.Name)
			ctx.WriteString(`"')`)
		} else {
			if ob.IsFunc {
				ctx.WriteString(strings.ToUpper(ob.Func.Name))
				ctx.WriteString(`(`)
			}
			ctx.ColWithTable(ob.Col.Table, ob.Col.Name)
			if ob.IsFunc {
				ctx.WriteString(`)`)
			}
		}

		if ob.KeyVar != "" && ob.Key != "" {
			ctx.WriteString(` END `)
		}

		switch ob.Order {
		case qcode.OrderAsc:
			ctx.WriteString(` ASC`)
		case qcode.OrderDesc:
			ctx.WriteString(` DESC`)
		case qcode.OrderAscNullsFirst:
			ctx.WriteString(` ASC NULLS FIRST`)
		case qcode.OrderDescNullsFirst:
			ctx.WriteString(` DESC NULLS FIRST`)
		case qcode.OrderAscNullsLast:
			ctx.WriteString(` ASC NULLS LAST`)
		case qcode.OrderDescNullsLast:
			ctx.WriteString(` DESC NULLS LAST`)