No type:json anymore?

[matukosan]

Just upgraded from 0.0.11 to 0.1.1 and having a lot breaking changes, one of them is, that I can't use
@Column({type: 'json'}) anymore, with the following error message:

Model is called "template" and has a property "presetAdvancedSettings" with the mentioned Column decorator.

Any idea why it doesn't work? o.O

[pleerock]

it must work, there are tests confirming it. Try to create a new (empty) model with json column type and check if it works

[matukosan]

hmm, interesting, created a new model and still got this error :(

I'm using MySQL 5.6.27 with InnoDB engine and UTF-8, if that makes a difference.

[mrkmg]

I found that it only works if your database natively supports it now. It no longer does any magic for you to convert from/to a json object. If you use postgre, you will see it works.

I used a getter/setter for my use case.

@Entity()
class Todo {
    @PrimaryGeneratedColumn()
    public id: number;

    @Column()
    public name: string;

    @Column("text")
    public dataJson?: string;

    public get data(): any {
        if (this.dataJson) return JSON.parse(this.dataJson);
        else return null;
    }

    public set data(data: any) {
        if (data) this.dataJson = JSON.stringify(data);
        else this.data = null;
    }

    // Only needed if you want the json to included when you stringify 
    // the whole object.
    // e.g request.json(obj)
    public toJSON() {
        return {
            id: this.id,
            name: this.name,
            data: this.data
        };
    }
}

You may want to use a library for your json parsing, or wrap it in a try/catch as it can throw a fatal error.

[matukosan]

Thanks for the hint. Seems like MySQL 5.7 supports JSON as datatype, will try to update!

[pleerock]

@mrkmg you are right, thanks

[pleerock]

I guess this can be closed.