Data types for Array of integers, strings and objects are omitted during the model creation

[kumarordway]

Data types for Array of integers, strings and objects are omitted during the model creation

If the column has the array of integers as the data type it is omitted in the column type.

expected behavior:
The type should be defined for array of integers, or any types of arrays.

[spinlud]

Hi there!
What do you mean by "Array of integers, strings and objects are omitted during the model creation"?

Could you provide an example?

cheers🍺

[kumarordway]

In postgress, type of column can be an array of strings or array integers etc. via json objects. For these columns the datatype is missed example here

 @Column({
    field: 'source_id',
    allowNull: true,
    defaultValue: Sequelize.literal("'{}'::integer[]"),
  })
    sourceId?: any;

See that this is missing type in column definition. this needs to be fixed with

@Column({
    field: 'xxx',
    allowNull: true,
    defaultValue: Sequelize.literal("'{}'::integer[]"),
    type: DataType.ARRAY(DataType.INTEGER),
  })
  sourceId?: any;

column definition in postgres information_schema for this column looks like this

 columns_default = "'{}'::integer[]"
 is_nullable = "YES"
 data_type="ARRAY"

[superkartoffel]

I have the same issue. The table that causes it looks like this: (It has been generated by EFCore btw)

CREATE TABLE IF NOT EXISTS Licenses
(
    "LegalEntityId" uuid NOT NULL,
    "Applications" text[] COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT "PK_Licenses" PRIMARY KEY ("LegalEntityId")
)

This is the code that stg generates:

export interface LicensesAttributes {
    legalEntityId: string;
    applications?: any;
}

@Table({ tableName: "Licenses", timestamps: false })
export class Licenses extends Model<LicensesAttributes, LicensesAttributes> implements LicensesAttributes {
    @Column({ field: "LegalEntityId", primaryKey: true, type: DataType.UUID })
    LegalEntityId!: string;
    @Column({ field: "Applications", allowNull: true })
    applications?: any;
}

The missing type causes error
Error: Specified type of property 'applications' cannot be automatically resolved to a sequelize data type. Please define the data type manually unless I modify the generated code.