Error: unable to generate test output: failed to format template

[gshilin]

When running

sqlboiler -o gmodels_old -p gmodels --no-hooks postgres

I'm getting the following error. I'm unable to find this code in any of generated files, so I have no idea where to look...

Error: unable to generate test output: failed to format template

 339 		t.Fatal(err)
 340 	}
 341 
 342 	randomize.Struct(seed, &b, catalogDescriptionDBTypes, false, catalogDescriptionColumnsWithDefault...)
 343 	randomize.Struct(seed, &c, catalogDescriptionDBTypes, false, catalogDescriptionColumnsWithDefault...)
>>>> 	a.Code3.Valid = trueb.LangID.Valid = true
 345 	c.LangID.Valid = true
 346 	b.LangID.String = a.Code3.String
 347 	c.LangID.String = a.Code3.String
 348 	if err = b.Insert(tx); err != nil {
 349 		t.Fatal(err)

: 344:37: expected '==', found '=' (and 2 more errors)

[aarondl]

Hi @gshilin, I've pushed what I think is a fix for your issue to the dev branch. Can you verify that it solves your issue and I'll push it to master.

[gshilin]

1. schema -- attached 2. --version SQLBoiler v2.1.5 3. sqlboiler -d --no-hooks -o kmodels -p kmodels postgres -- attached

On Wed, Jan 11, 2017 at 3:50 AM, Patrick O ***@***.***> wrote: Hi. Seems like one of the new lines is being stripped erroneously so the generation is failing. This code is in one of the generated test files, but as you said, it won't actually generate due to the template error. A few things: - Can you please provide your schema so I can replicate this? - What --version are you using? - Can you run the generate command with -d and paste the output. Thanks. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <https://github.com/vattle/sqlboiler/issues/89#issuecomment-271755210>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAVnPwnj6tlbgI50wNOG_2akZ4uQR2Gyks5rRDV9gaJpZM4LfgmE> .

[{"Name":"catalogs_containers","SchemaName":"","Columns":[{"Name":"catalog_id","Type":"int","DBType":"integer","Default":"0","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"container_id","Type":"int","DBType":"integer","Default":"0","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""}],"PKey":{"Name":"catnodelessons_pkey","Columns":["catalog_id","container_id"]},"FKeys":[{"Table":"catalogs_containers","Name":"catalogs_fkey","Column":"catalog_id","Nullable":false,"Unique":false,"ForeignTable":"catalogs","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true},{"Table":"catalogs_containers","Name":"containers_fkey","Column":"container_id","Nullable":false,"Unique":false,"ForeignTable":"containers","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true}],"IsJoinTable":true,"ToOneRelationships":null,"ToManyRelationships":null},{"Name":"file_types","SchemaName":"","Columns":[{"Name":"name","Type":"string","DBType":"character varying","Default":"''::character varying","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"extlist","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"pic","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""}],"PKey":{"Name":"filetypes_pkey","Columns":["name"]},"FKeys":null,"IsJoinTable":false,"ToOneRelationships":null,"ToManyRelationships":null},{"Name":"lecturer_descriptions","SchemaName":"","Columns":[{"Name":"id","Type":"int","DBType":"integer","Default":"nextval('lecturer_descriptions_lecturerdescid_seq'::regclass)","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"lecturer_id","Type":"int","DBType":"integer","Default":"0","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"desc","Type":"string","DBType":"character","Default":"''::character(1)","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"bpchar","FullDBType":""},{"Name":"lang","Type":"string","DBType":"character","Default":"''::character(1)","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"bpchar","FullDBType":""},{"Name":"created_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"updated_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""}],"PKey":{"Name":"lecturerdesc_pkey","Columns":["id"]},"FKeys":null,"IsJoinTable":false,"ToOneRelationships":null,"ToManyRelationships":null},{"Name":"lecturers","SchemaName":"","Columns":[{"Name":"id","Type":"int","DBType":"integer","Default":"nextval('lecturers_lecturerid_seq'::regclass)","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"name","Type":"string","DBType":"character","Default":"''::character(1)","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"bpchar","FullDBType":""},{"Name":"created_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"updated_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"ordnum","Type":"int","DBType":"integer","Default":"0","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""}],"PKey":{"Name":"lecturer_pkey","Columns":["id"]},"FKeys":null,"IsJoinTable":false,"ToOneRelationships":null,"ToManyRelationships":null},{"Name":"content_types","SchemaName":"","Columns":[{"Name":"id","Type":"int","DBType":"integer","Default":"nextval('content_types_id_seq'::regclass)","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"name","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"pattern","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"secure","Type":"null.Int","DBType":"integer","Default":"0","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""}],"PKey":{"Name":"content_types_pkey","Columns":["id"]},"FKeys":null,"IsJoinTable":false,"ToOneRelationships":null,"ToManyRelationships":[{"Table":"content_types","Column":"id","Nullable":false,"Unique":true,"ForeignTable":"containers","ForeignColumn":"content_type_id","ForeignColumnNullable":true,"ForeignColumnUnique":false,"ToJoinTable":false,"JoinTable":"","JoinLocalColumn":"","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false}]},{"Name":"containers_file_assets","SchemaName":"","Columns":[{"Name":"container_id","Type":"int","DBType":"integer","Default":"0","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"file_asset_id","Type":"int","DBType":"integer","Default":"0","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""}],"PKey":{"Name":"containers_file_assets_pkey","Columns":["container_id","file_asset_id"]},"FKeys":[{"Table":"containers_file_assets","Name":"containers_fkey","Column":"container_id","Nullable":false,"Unique":false,"ForeignTable":"containers","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true},{"Table":"containers_file_assets","Name":"file_assets_fkey","Column":"file_asset_id","Nullable":false,"Unique":false,"ForeignTable":"file_assets","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true}],"IsJoinTable":true,"ToOneRelationships":null,"ToManyRelationships":null},{"Name":"roles","SchemaName":"","Columns":[{"Name":"id","Type":"int","DBType":"integer","Default":"nextval('roles_id_seq'::regclass)","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"name","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"description","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"created_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"updated_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""}],"PKey":{"Name":"roles_pkey","Columns":["id"]},"FKeys":null,"IsJoinTable":false,"ToOneRelationships":null,"ToManyRelationships":null},{"Name":"catalog_descriptions","SchemaName":"","Columns":[{"Name":"id","Type":"int","DBType":"integer","Default":"nextval('catalog_descriptions_catnodedescid_seq'::regclass)","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"catalog_id","Type":"int","DBType":"integer","Default":"0","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"name","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"lang_id","Type":"null.String","DBType":"character","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"bpchar","FullDBType":""},{"Name":"created_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"updated_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""}],"PKey":{"Name":"catnodedesc_pkey","Columns":["id"]},"FKeys":[{"Table":"catalog_descriptions","Name":"catalogs_fkey","Column":"catalog_id","Nullable":false,"Unique":false,"ForeignTable":"catalogs","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true},{"Table":"catalog_descriptions","Name":"languages_fkey","Column":"lang_id","Nullable":true,"Unique":false,"ForeignTable":"languages","ForeignColumn":"code3","ForeignColumnNullable":true,"ForeignColumnUnique":true}],"IsJoinTable":false,"ToOneRelationships":null,"ToManyRelationships":null},{"Name":"catalogs","SchemaName":"","Columns":[{"Name":"id","Type":"int","DBType":"integer","Default":"nextval('catalogs_catalognodeid_seq'::regclass)","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"name","Type":"string","DBType":"character varying","Default":"''::character varying","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"parent_id","Type":"null.Int","DBType":"integer","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"created_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"updated_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"catorder","Type":"int","DBType":"integer","Default":"999","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"secure","Type":"int","DBType":"integer","Default":"0","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"visible","Type":"null.Bool","DBType":"boolean","Default":"true","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"bool","FullDBType":""},{"Name":"open","Type":"null.Bool","DBType":"boolean","Default":"true","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"bool","FullDBType":""},{"Name":"label","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"selected_catalog","Type":"null.Int","DBType":"integer","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"user_id","Type":"null.Int","DBType":"integer","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"books_catalog","Type":"null.Bool","DBType":"boolean","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"bool","FullDBType":""}],"PKey":{"Name":"catalognode_pkey","Columns":["id"]},"FKeys":[{"Table":"catalogs","Name":"catalogs_fkey","Column":"parent_id","Nullable":true,"Unique":false,"ForeignTable":"catalogs","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true},{"Table":"catalogs","Name":"users_fkey","Column":"user_id","Nullable":true,"Unique":false,"ForeignTable":"users","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true}],"IsJoinTable":false,"ToOneRelationships":null,"ToManyRelationships":[{"Table":"catalogs","Column":"id","Nullable":false,"Unique":true,"ForeignTable":"containers","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true,"ToJoinTable":true,"JoinTable":"catalogs_containers","JoinLocalColumn":"catalog_id","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"container_id","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false},{"Table":"catalogs","Column":"id","Nullable":false,"Unique":true,"ForeignTable":"catalog_descriptions","ForeignColumn":"catalog_id","ForeignColumnNullable":false,"ForeignColumnUnique":false,"ToJoinTable":false,"JoinTable":"","JoinLocalColumn":"","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false},{"Table":"catalogs","Column":"id","Nullable":false,"Unique":true,"ForeignTable":"catalogs","ForeignColumn":"parent_id","ForeignColumnNullable":true,"ForeignColumnUnique":false,"ToJoinTable":false,"JoinTable":"","JoinLocalColumn":"","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false},{"Table":"catalogs","Column":"id","Nullable":false,"Unique":true,"ForeignTable":"container_description_patterns","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true,"ToJoinTable":true,"JoinTable":"catalogs_container_description_patterns","JoinLocalColumn":"catalog_id","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"container_description_pattern_id","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false}]},{"Name":"container_description_patterns","SchemaName":"","Columns":[{"Name":"id","Type":"int","DBType":"integer","Default":"nextval('container_description_patterns_id_seq'::regclass)","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"pattern","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"description","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"lang","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"created_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"updated_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"user_id","Type":"null.Int","DBType":"integer","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""}],"PKey":{"Name":"lessondesc_patterns_pkey","Columns":["id"]},"FKeys":null,"IsJoinTable":false,"ToOneRelationships":null,"ToManyRelationships":[{"Table":"container_description_patterns","Column":"id","Nullable":false,"Unique":true,"ForeignTable":"catalogs","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true,"ToJoinTable":true,"JoinTable":"catalogs_container_description_patterns","JoinLocalColumn":"container_description_pattern_id","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"catalog_id","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false}]},{"Name":"catalogs_container_description_patterns","SchemaName":"","Columns":[{"Name":"container_description_pattern_id","Type":"int","DBType":"integer","Default":"","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"catalog_id","Type":"int","DBType":"integer","Default":"","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""}],"PKey":{"Name":"catalog_container_description_pattern_pkey","Columns":["container_description_pattern_id","catalog_id"]},"FKeys":[{"Table":"catalogs_container_description_patterns","Name":"catalogs_fkey","Column":"catalog_id","Nullable":false,"Unique":false,"ForeignTable":"catalogs","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true},{"Table":"catalogs_container_description_patterns","Name":"container_description_patterns_fkey","Column":"container_description_pattern_id","Nullable":false,"Unique":false,"ForeignTable":"container_description_patterns","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true}],"IsJoinTable":true,"ToOneRelationships":null,"ToManyRelationships":null},{"Name":"container_descriptions","SchemaName":"","Columns":[{"Name":"id","Type":"int","DBType":"integer","Default":"nextval('container_descriptions_lessondescid_seq'::regclass)","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"container_id","Type":"int","DBType":"integer","Default":"0","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"container_desc","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"lang_id","Type":"null.String","DBType":"character","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"bpchar","FullDBType":""},{"Name":"created_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"updated_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"descr","Type":"null.String","DBType":"text","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"text","FullDBType":""}],"PKey":{"Name":"lessondesc_pkey","Columns":["id"]},"FKeys":[{"Table":"container_descriptions","Name":"languages_fkey","Column":"lang_id","Nullable":true,"Unique":false,"ForeignTable":"languages","ForeignColumn":"code3","ForeignColumnNullable":true,"ForeignColumnUnique":true},{"Table":"container_descriptions","Name":"container_descriptions_fkey","Column":"container_id","Nullable":false,"Unique":false,"ForeignTable":"containers","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true}],"IsJoinTable":false,"ToOneRelationships":null,"ToManyRelationships":null},{"Name":"labels","SchemaName":"","Columns":[{"Name":"id","Type":"int","DBType":"integer","Default":"nextval('labels_id_seq'::regclass)","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"dictionary_id","Type":"null.Int","DBType":"integer","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"suid","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"created_at","Type":"time.Time","DBType":"timestamp without time zone","Default":"","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"updated_at","Type":"time.Time","DBType":"timestamp without time zone","Default":"","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""}],"PKey":{"Name":"labels_pkey","Columns":["id"]},"FKeys":null,"IsJoinTable":false,"ToOneRelationships":null,"ToManyRelationships":[{"Table":"labels","Column":"id","Nullable":false,"Unique":true,"ForeignTable":"containers","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true,"ToJoinTable":true,"JoinTable":"containers_labels","JoinLocalColumn":"label_id","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"container_id","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false}]},{"Name":"containers_labels","SchemaName":"","Columns":[{"Name":"label_id","Type":"int","DBType":"integer","Default":"","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"container_id","Type":"int","DBType":"integer","Default":"","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""}],"PKey":{"Name":"container_label_pkey","Columns":["label_id","container_id"]},"FKeys":[{"Table":"containers_labels","Name":"containers_fkey","Column":"container_id","Nullable":false,"Unique":false,"ForeignTable":"containers","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true},{"Table":"containers_labels","Name":"labels_fkey","Column":"label_id","Nullable":false,"Unique":false,"ForeignTable":"labels","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true}],"IsJoinTable":true,"ToOneRelationships":null,"ToManyRelationships":null},{"Name":"roles_users","SchemaName":"","Columns":[{"Name":"role_id","Type":"int","DBType":"integer","Default":"","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"user_id","Type":"int","DBType":"integer","Default":"","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""}],"PKey":{"Name":"role_user_pkey","Columns":["role_id","user_id"]},"FKeys":[{"Table":"roles_users","Name":"users_fkey","Column":"user_id","Nullable":false,"Unique":false,"ForeignTable":"users","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true}],"IsJoinTable":false,"ToOneRelationships":null,"ToManyRelationships":null},{"Name":"containers","SchemaName":"","Columns":[{"Name":"id","Type":"int","DBType":"integer","Default":"nextval('containers_lessonid_seq'::regclass)","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"name","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"created_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"updated_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"filmdate","Type":"null.Time","DBType":"date","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"date","FullDBType":""},{"Name":"lang_id","Type":"null.String","DBType":"character","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"bpchar","FullDBType":""},{"Name":"lecturer_id","Type":"null.Int","DBType":"integer","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"secure","Type":"int","DBType":"integer","Default":"0","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"content_type_id","Type":"null.Int","DBType":"integer","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"marked_for_merge","Type":"null.Bool","DBType":"boolean","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"bool","FullDBType":""},{"Name":"secure_changed","Type":"null.Bool","DBType":"boolean","Default":"false","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"bool","FullDBType":""},{"Name":"auto_parsed","Type":"null.Bool","DBType":"boolean","Default":"false","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"bool","FullDBType":""},{"Name":"virtual_lesson_id","Type":"null.Int","DBType":"integer","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"playtime_secs","Type":"null.Int","DBType":"integer","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"user_id","Type":"null.Int","DBType":"integer","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"for_censorship","Type":"null.Bool","DBType":"boolean","Default":"false","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"bool","FullDBType":""},{"Name":"opened_by_censor","Type":"null.Bool","DBType":"boolean","Default":"false","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"bool","FullDBType":""},{"Name":"closed_by_censor","Type":"null.Bool","DBType":"boolean","Default":"false","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"bool","FullDBType":""},{"Name":"censor_id","Type":"null.Int","DBType":"integer","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"position","Type":"null.Int","DBType":"integer","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""}],"PKey":{"Name":"lessons_pkey","Columns":["id"]},"FKeys":[{"Table":"containers","Name":"languages_fkey","Column":"lang_id","Nullable":true,"Unique":false,"ForeignTable":"languages","ForeignColumn":"code3","ForeignColumnNullable":true,"ForeignColumnUnique":true},{"Table":"containers","Name":"content_types_fkey","Column":"content_type_id","Nullable":true,"Unique":false,"ForeignTable":"content_types","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true},{"Table":"containers","Name":"virtual_lessons_fkey","Column":"virtual_lesson_id","Nullable":true,"Unique":false,"ForeignTable":"virtual_lessons","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true}],"IsJoinTable":false,"ToOneRelationships":null,"ToManyRelationships":[{"Table":"containers","Column":"id","Nullable":false,"Unique":true,"ForeignTable":"catalogs","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true,"ToJoinTable":true,"JoinTable":"catalogs_containers","JoinLocalColumn":"container_id","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"catalog_id","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false},{"Table":"containers","Column":"id","Nullable":false,"Unique":true,"ForeignTable":"file_assets","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true,"ToJoinTable":true,"JoinTable":"containers_file_assets","JoinLocalColumn":"container_id","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"file_asset_id","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false},{"Table":"containers","Column":"id","Nullable":false,"Unique":true,"ForeignTable":"container_descriptions","ForeignColumn":"container_id","ForeignColumnNullable":false,"ForeignColumnUnique":false,"ToJoinTable":false,"JoinTable":"","JoinLocalColumn":"","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false},{"Table":"containers","Column":"id","Nullable":false,"Unique":true,"ForeignTable":"labels","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true,"ToJoinTable":true,"JoinTable":"containers_labels","JoinLocalColumn":"container_id","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"label_id","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false}]},{"Name":"file_asset_descriptions","SchemaName":"","Columns":[{"Name":"id","Type":"int","DBType":"integer","Default":"nextval('file_asset_descriptions_filedescid_seq'::regclass)","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"file_id","Type":"int","DBType":"integer","Default":"0","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"filedesc","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"lang","Type":"null.String","DBType":"character","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"bpchar","FullDBType":""},{"Name":"created_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"updated_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""}],"PKey":{"Name":"filedesc_pkey","Columns":["id"]},"FKeys":[{"Table":"file_asset_descriptions","Name":"file_asset_descriptions_fkey","Column":"file_id","Nullable":false,"Unique":false,"ForeignTable":"file_assets","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true}],"IsJoinTable":false,"ToOneRelationships":null,"ToManyRelationships":null},{"Name":"servers","SchemaName":"","Columns":[{"Name":"servername","Type":"string","DBType":"character varying","Default":"''::character varying","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"httpurl","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"created","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"updated","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"lastuser","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"path","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"id","Type":"int","DBType":"integer","Default":"nextval('servers_id_seq'::regclass)","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""}],"PKey":{"Name":"servers_pkey","Columns":["id"]},"FKeys":null,"IsJoinTable":false,"ToOneRelationships":null,"ToManyRelationships":[{"Table":"servers","Column":"servername","Nullable":false,"Unique":true,"ForeignTable":"file_assets","ForeignColumn":"servername_id","ForeignColumnNullable":true,"ForeignColumnUnique":false,"ToJoinTable":false,"JoinTable":"","JoinLocalColumn":"","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false}]},{"Name":"virtual_lessons","SchemaName":"","Columns":[{"Name":"id","Type":"int","DBType":"integer","Default":"nextval('virtual_lessons_id_seq'::regclass)","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"film_date","Type":"null.Time","DBType":"date","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"date","FullDBType":""},{"Name":"created_at","Type":"time.Time","DBType":"timestamp without time zone","Default":"","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"updated_at","Type":"time.Time","DBType":"timestamp without time zone","Default":"","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"user_id","Type":"null.Int","DBType":"integer","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""}],"PKey":{"Name":"virtual_lessons_pkey","Columns":["id"]},"FKeys":null,"IsJoinTable":false,"ToOneRelationships":null,"ToManyRelationships":[{"Table":"virtual_lessons","Column":"id","Nullable":false,"Unique":true,"ForeignTable":"containers","ForeignColumn":"virtual_lesson_id","ForeignColumnNullable":true,"ForeignColumnUnique":false,"ToJoinTable":false,"JoinTable":"","JoinLocalColumn":"","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false}]},{"Name":"languages","SchemaName":"","Columns":[{"Name":"id","Type":"int","DBType":"integer","Default":"nextval('languages_id_seq'::regclass)","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"locale","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"code3","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"language","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""}],"PKey":{"Name":"languages_pkey","Columns":["id"]},"FKeys":null,"IsJoinTable":false,"ToOneRelationships":null,"ToManyRelationships":[{"Table":"languages","Column":"code3","Nullable":true,"Unique":true,"ForeignTable":"catalog_descriptions","ForeignColumn":"lang_id","ForeignColumnNullable":true,"ForeignColumnUnique":false,"ToJoinTable":false,"JoinTable":"","JoinLocalColumn":"","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false},{"Table":"languages","Column":"code3","Nullable":true,"Unique":true,"ForeignTable":"container_descriptions","ForeignColumn":"lang_id","ForeignColumnNullable":true,"ForeignColumnUnique":false,"ToJoinTable":false,"JoinTable":"","JoinLocalColumn":"","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false},{"Table":"languages","Column":"code3","Nullable":true,"Unique":true,"ForeignTable":"containers","ForeignColumn":"lang_id","ForeignColumnNullable":true,"ForeignColumnUnique":false,"ToJoinTable":false,"JoinTable":"","JoinLocalColumn":"","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false},{"Table":"languages","Column":"code3","Nullable":true,"Unique":true,"ForeignTable":"file_assets","ForeignColumn":"lang_id","ForeignColumnNullable":true,"ForeignColumnUnique":false,"ToJoinTable":false,"JoinTable":"","JoinLocalColumn":"","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false}]},{"Name":"file_assets","SchemaName":"","Columns":[{"Name":"id","Type":"int","DBType":"integer","Default":"nextval('file_assets_fileid_seq'::regclass)","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"name","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"lang_id","Type":"null.String","DBType":"character","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"bpchar","FullDBType":""},{"Name":"asset_type","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"date","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"size","Type":"null.Int","DBType":"integer","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"servername_id","Type":"null.String","DBType":"character varying","Default":"'DEFAULT'::character varying","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"status","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"created_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"updated_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"lastuser","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"clicks","Type":"null.Int","DBType":"integer","Default":"0","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"secure","Type":"null.Int","DBType":"integer","Default":"0","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"playtime_secs","Type":"null.Int","DBType":"integer","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"user_id","Type":"null.Int","DBType":"integer","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""}],"PKey":{"Name":"files_pkey","Columns":["id"]},"FKeys":[{"Table":"file_assets","Name":"languages_fkey","Column":"lang_id","Nullable":true,"Unique":false,"ForeignTable":"languages","ForeignColumn":"code3","ForeignColumnNullable":true,"ForeignColumnUnique":true},{"Table":"file_assets","Name":"users_fkey","Column":"user_id","Nullable":true,"Unique":false,"ForeignTable":"users","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true},{"Table":"file_assets","Name":"servers_fkey","Column":"servername_id","Nullable":true,"Unique":false,"ForeignTable":"servers","ForeignColumn":"servername","ForeignColumnNullable":false,"ForeignColumnUnique":true}],"IsJoinTable":false,"ToOneRelationships":null,"ToManyRelationships":[{"Table":"file_assets","Column":"id","Nullable":false,"Unique":true,"ForeignTable":"containers","ForeignColumn":"id","ForeignColumnNullable":false,"ForeignColumnUnique":true,"ToJoinTable":true,"JoinTable":"containers_file_assets","JoinLocalColumn":"file_asset_id","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"container_id","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false},{"Table":"file_assets","Column":"id","Nullable":false,"Unique":true,"ForeignTable":"file_asset_descriptions","ForeignColumn":"file_id","ForeignColumnNullable":false,"ForeignColumnUnique":false,"ToJoinTable":false,"JoinTable":"","JoinLocalColumn":"","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false}]},{"Name":"users","SchemaName":"","Columns":[{"Name":"id","Type":"int","DBType":"integer","Default":"nextval('users_id_seq'::regclass)","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"email","Type":"string","DBType":"character varying","Default":"''::character varying","Nullable":false,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"encrypted_password","Type":"string","DBType":"character varying","Default":"''::character varying","Nullable":false,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"reset_password_token","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":true,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"remember_created_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"sign_in_count","Type":"null.Int","DBType":"integer","Default":"0","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""},{"Name":"current_sign_in_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"last_sign_in_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"current_sign_in_ip","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"last_sign_in_ip","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"created_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"updated_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"first_name","Type":"null.String","DBType":"character varying","Default":"''::character varying","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"last_name","Type":"null.String","DBType":"character varying","Default":"''::character varying","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"authentication_token","Type":"null.String","DBType":"character varying","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"varchar","FullDBType":""},{"Name":"reset_password_sent_at","Type":"null.Time","DBType":"timestamp without time zone","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"timestamp","FullDBType":""},{"Name":"department_id","Type":"null.Int","DBType":"integer","Default":"","Nullable":true,"Unique":false,"Validated":false,"ArrType":null,"UDTName":"int4","FullDBType":""}],"PKey":{"Name":"users_pkey","Columns":["id"]},"FKeys":null,"IsJoinTable":false,"ToOneRelationships":null,"ToManyRelationships":[{"Table":"users","Column":"id","Nullable":false,"Unique":true,"ForeignTable":"catalogs","ForeignColumn":"user_id","ForeignColumnNullable":true,"ForeignColumnUnique":false,"ToJoinTable":false,"JoinTable":"","JoinLocalColumn":"","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false},{"Table":"users","Column":"id","Nullable":false,"Unique":true,"ForeignTable":"roles_users","ForeignColumn":"user_id","ForeignColumnNullable":false,"ForeignColumnUnique":false,"ToJoinTable":false,"JoinTable":"","JoinLocalColumn":"","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false},{"Table":"users","Column":"id","Nullable":false,"Unique":true,"ForeignTable":"file_assets","ForeignColumn":"user_id","ForeignColumnNullable":true,"ForeignColumnUnique":false,"ToJoinTable":false,"JoinTable":"","JoinLocalColumn":"","JoinLocalColumnNullable":false,"JoinLocalColumnUnique":false,"JoinForeignColumn":"","JoinForeignColumnNullable":false,"JoinForeignColumnUnique":false}]}] Error: 344:37: expected '==', found '=' (and 3 more errors) failed to format template 339 t.Fatal(err) 340 } 341 342 randomize.Struct(seed, &b, catalogDescriptionDBTypes, false, catalogDescriptionColumnsWithDefault...) 343 randomize.Struct(seed, &c, catalogDescriptionDBTypes, false, catalogDescriptionColumnsWithDefault...)

>>> a.Code3.Valid = trueb.LangID.Valid = true

345 c.LangID.Valid = true 346 b.LangID.String = a.Code3.String 347 c.LangID.String = a.Code3.String 348 if err = b.Insert(tx); err != nil { 349 t.Fatal(err) main.formatBuffer /home/gshilin/projects/go-shidur-slides/src/github.com/vattle/sqlboiler/output.go:250 main.writeFile /home/gshilin/projects/go-shidur-slides/src/github.com/vattle/sqlboiler/output.go:199 main.executeTemplates /home/gshilin/projects/go-shidur-slides/src/github.com/vattle/sqlboiler/output.go:116 main.generateTestOutput /home/gshilin/projects/go-shidur-slides/src/github.com/vattle/sqlboiler/output.go:50 main.(*State).Run /home/gshilin/projects/go-shidur-slides/src/github.com/vattle/sqlboiler/sqlboiler.go:156 main.run /home/gshilin/projects/go-shidur-slides/src/github.com/vattle/sqlboiler/main.go:248 github.com/spf13/cobra.(*Command).execute /home/gshilin/projects/go-shidur-slides/src/github.com/spf13/cobra/command.go:632 github.com/spf13/cobra.(*Command).ExecuteC /home/gshilin/projects/go-shidur-slides/src/github.com/spf13/cobra/command.go:722 github.com/spf13/cobra.(*Command).Execute /home/gshilin/projects/go-shidur-slides/src/github.com/spf13/cobra/command.go:681 main.main /home/gshilin/projects/go-shidur-slides/src/github.com/vattle/sqlboiler/main.go:96 runtime.main /usr/local/go/src/runtime/proc.go:183 runtime.goexit /usr/local/go/src/runtime/asm_amd64.s:2086 unable to generate test output main.(*State).Run /home/gshilin/projects/go-shidur-slides/src/github.com/vattle/sqlboiler/sqlboiler.go:157 main.run /home/gshilin/projects/go-shidur-slides/src/github.com/vattle/sqlboiler/main.go:248 github.com/spf13/cobra.(*Command).execute /home/gshilin/projects/go-shidur-slides/src/github.com/spf13/cobra/command.go:632 github.com/spf13/cobra.(*Command).ExecuteC /home/gshilin/projects/go-shidur-slides/src/github.com/spf13/cobra/command.go:722 github.com/spf13/cobra.(*Command).Execute /home/gshilin/projects/go-shidur-slides/src/github.com/spf13/cobra/command.go:681 main.main /home/gshilin/projects/go-shidur-slides/src/github.com/vattle/sqlboiler/main.go:96 runtime.main /usr/local/go/src/runtime/proc.go:183 runtime.goexit /usr/local/go/src/runtime/asm_amd64.s:2086

[nullbio]

@gshilin Thanks. Does the dev branch work for you? Should be fixed in there.

To test it you can:

cd $GOPATH/src/github.com/vattle/sqlboiler
git checkout dev
go install

Then run your sqlboiler command again in your project directory.

[gshilin]

Yes, it works, 10x alot

…

On Thu, Jan 12, 2017 at 12:19 PM, Patrick O ***@***.***> wrote: @gshilin <https://github.com/gshilin> Thanks. Does the dev branch work for you? Should be fixed in there. To test it you can: cd $GOPATH/src/github.com/vattle/sqlboiler git checkout dev go install Then run your sqlboiler command again in your project directory. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <https://github.com/vattle/sqlboiler/issues/89#issuecomment-272126324>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAVnP49MJlkPw2dZbr3GXsPFd4AxjzBHks5rRf4hgaJpZM4LfgmE> .