Array support

[samnguyen-outreach]

Hello, I'm interested in adding array support, but I wanted to check whether such a feature would be welcome or not before putting in the effort.

Looking through the repo, I only saw this comment mentioning array support #53 (comment).

Jet currently doesn't have support for arrays.
Until it gets support..

I was thinking of starting around here to figure out if I could generate proper Go types based on the database type:

jet/generator/template/model_template.go

Lines 234 to 244 in 38b6caf

	func getType(columnMetadata metadata.Column) Type {
	userDefinedType := getUserDefinedType(columnMetadata)
	if userDefinedType != "" {
	if columnMetadata.IsNullable {
	return Type{Name: "*" + userDefinedType}
	}
	return Type{Name: userDefinedType}
	}
	return NewType(getGoType(columnMetadata))

[samnguyen-outreach]

I got a small think going, being able to generate slice types into the model: #179

However, now I'm trying to get it scanning with qrm, and running into this error

jet: can't append string to []int slice: converting driver.Value type string ("{1,2}") to a int64: invalid syntax

I see it getting into this code path and erroring out:

jet/qrm/utill.go

Lines 232 to 238 in a45442b

	case reflect.Int, reflect.Int8, reflect.Int16, reflect.Int32, reflect.Int64:
	var integer sql.NullInt64
	err := integer.Scan(sourceInterface)
	if err != nil {
	return err
	}

[samnguyen-outreach]

Response from go-jet here: #179 (comment)