Auto Generated Column Support

[daniel-reed]

Add IsAutoGenerated to Column

[xserve98]

func Insert(db {{$rootPkg}}.DB, r *Row) error {
    const sqlstr = `INSERT INTO {{ $table }} (
            {{$insertCols}}
        ) VALUES (
            {{ template "values" $numNonPKs }}
        ) RETURNING id;`

    err := db.QueryRow(sqlstr, {{join  ((.Table.Columns.Names.Except .Table.PrimaryKeys.Names).Sprintf "r.%s") ", "}}).Scan( {{join  (.Table.PrimaryKeys.Names.Sprintf "&r.%s") ", "}})
    return errors.Wrap(err, "insert {{.Table.Name}}")
}

Is there a better solution? id SERIAL PRIMARY KEY

[xserve98]

// Insert inserts the row into the database.
func Insert(db models.DB, r *Row) error {
        const sqlstr = `INSERT INTO sys_user (
            username, password, salt, avatar, created_at, updated_at
        ) VALUES (
            $1, $2, $3, $4, $5, $6
        ) RETURNING id;`

    err := db.QueryRow(sqlstr, r.Username, r.Password, r.Salt, r.Avatar, r.CreatedAt,r.UpdatedAt).Scan(&r.ID)
    return errors.Wrap(err, "insert SysUser")
}