search

volatiletech / sqlboiler

Generate a Go ORM tailored to your database schema.
BSD 3-Clause "New" or "Revised" License
6.69k stars 540 forks source link

After specifying tag-ignore , sqlboiler is failing to generate the code #1354

Closed adpande closed 7 months ago

adpande commented 7 months ago

In the version 4.16.1 when we define tag-ignore it is failing to generate the code. I have provided all the required details of the error below.

Please note that when I use the templates from commit Id 1a6aefb, it works fine. I think, this functionality is broken in the 4.16.1 release.

What version of SQLBoiler are you using (sqlboiler --version)?

4.16.1

What is your database and version (eg. Postgresql 10)

Postgresql 14

If this happened at generation time what was the full SQLBoiler command you used to generate your models? (if not applicable leave blank)

sqlboiler psql

no-auto-timestamps = false
no-tests = true
output = "models"
pkgname = "models"
tag = ["form"]
tag-ignore = ["workspace_id"]
wipe = true

[psql]
dbname = "xyz"
host = "192.168.0.128"
pass = "password"
sslmode = "disable"
user = "app"

If this happened at runtime what code produced the issue? (if not applicable leave blank)

not happenig on runtime

What is the output of the command above with the -d flag added to it? (Provided you are comfortable sharing this, it contains a blueprint of your schema)

using driver: /home/abhishek/go/bin/sqlboiler-psql
{"config":{"driver_name":"psql","driver_config":{"add-enum-types":false,"blacklist":null,"dbname":"ss_analytics_dev","enum-null-prefix":"Null","foreign-keys":null,"host":"earth.statstream.dev","pass":"password","sslmode":"disable","user":"abhishek","whitelist":null},"pkg_name":"models","out_folder":"models","tags":["form"],"debug":true,"enum_null_prefix":"Null","no_tests":true,"wipe":true,"struct_tag_cases":{"json":"snake","yaml":"snake","toml":"snake","boil":"snake"},"struct_tag_casing":"snake","relation_tag":"-","tag_ignore":["workspace_id"],"imports":{"all":{"Standard":["\"database/sql\"","\"fmt\"","\"reflect\"","\"strconv\"","\"strings\"","\"sync\"","\"time\"","\"context\""],"ThirdParty":["\"github.com/friendsofgo/errors\"","\"github.com/volatiletech/sqlboiler/v4/boil\"","\"github.com/volatiletech/sqlboiler/v4/queries\"","\"github.com/volatiletech/sqlboiler/v4/queries/qm\"","\"github.com/volatiletech/sqlboiler/v4/queries/qmhelper\"","\"github.com/volatiletech/strmangle\""]},"test":{"Standard":["\"bytes\"","\"reflect\"","\"testing\"","\"context\""],"ThirdParty":["\"github.com/volatiletech/randomize\"","\"github.com/volatiletech/sqlboiler/v4/boil\"","\"github.com/volatiletech/sqlboiler/v4/queries\"","\"github.com/volatiletech/strmangle\""]},"singleton":{"boil_queries":{"Standard":["\"regexp\""],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/drivers\"","\"github.com/volatiletech/sqlboiler/v4/queries\"","\"github.com/volatiletech/sqlboiler/v4/queries/qm\""]},"boil_types":{"Standard":["\"strconv\""],"ThirdParty":["\"github.com/friendsofgo/errors\"","\"github.com/volatiletech/sqlboiler/v4/boil\"","\"github.com/volatiletech/strmangle\""]},"psql_upsert":{"Standard":["\"fmt\"","\"strings\""],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/drivers\"","\"github.com/volatiletech/strmangle\""]}},"test_singleton":{"boil_main_test":{"Standard":["\"database/sql\"","\"flag\"","\"fmt\"","\"math/rand\"","\"os\"","\"path/filepath\"","\"strings\"","\"testing\"","\"time\""],"ThirdParty":["\"github.com/spf13/viper\"","\"github.com/volatiletech/sqlboiler/v4/boil\""]},"boil_queries_test":{"Standard":["\"bytes\"","\"fmt\"","\"io\"","\"math/rand\"","\"regexp\""],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/boil\""]},"boil_relationship_test":{"Standard":["\"testing\""],"ThirdParty":null},"boil_suites_test":{"Standard":["\"testing\""],"ThirdParty":null},"psql_main_test":{"Standard":["\"bytes\"","\"database/sql\"","\"fmt\"","\"io\"","\"os\"","\"os/exec\"","\"regexp\"","\"strings\""],"ThirdParty":["\"github.com/friendsofgo/errors\"","\"github.com/kat-co/vala\"","_ \"github.com/lib/pq\"","\"github.com/spf13/viper\"","\"github.com/volatiletech/randomize\"","\"github.com/volatiletech/sqlboiler/v4/drivers/sqlboiler-psql/driver\""]},"psql_suites_test":{"Standard":["\"testing\""],"ThirdParty":[]}},"based_on_type":{"null.Bool":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/null/v8\""]},"null.Bytes":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/null/v8\""]},"null.Float32":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/null/v8\""]},"null.Float64":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/null/v8\""]},"null.Int":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/null/v8\""]},"null.Int16":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/null/v8\""]},"null.Int32":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/null/v8\""]},"null.Int64":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/null/v8\""]},"null.Int8":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/null/v8\""]},"null.JSON":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/null/v8\""]},"null.String":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/null/v8\""]},"null.Time":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/null/v8\""]},"null.Uint":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/null/v8\""]},"null.Uint16":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/null/v8\""]},"null.Uint32":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/null/v8\""]},"null.Uint64":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/null/v8\""]},"null.Uint8":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/null/v8\""]},"pgeo.Box":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types/pgeo\""]},"pgeo.Circle":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types/pgeo\""]},"pgeo.Line":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types/pgeo\""]},"pgeo.Lseg":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types/pgeo\""]},"pgeo.NullBox":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types/pgeo\""]},"pgeo.NullCircle":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types/pgeo\""]},"pgeo.NullLine":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types/pgeo\""]},"pgeo.NullLseg":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types/pgeo\""]},"pgeo.NullPath":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types/pgeo\""]},"pgeo.NullPoint":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types/pgeo\""]},"pgeo.NullPolygon":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types/pgeo\""]},"pgeo.Path":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types/pgeo\""]},"pgeo.Point":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types/pgeo\""]},"pgeo.Polygon":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types/pgeo\""]},"time.Time":{"Standard":["\"time\""],"ThirdParty":[]},"types.BoolArray":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types\""]},"types.Byte":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types\""]},"types.BytesArray":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types\""]},"types.Decimal":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types\""]},"types.DecimalArray":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types\""]},"types.Float64Array":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types\""]},"types.HStore":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types\""]},"types.Int64Array":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types\""]},"types.JSON":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types\""]},"types.NullDecimal":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types\""]},"types.StringArray":{"Standard":[],"ThirdParty":["\"github.com/volatiletech/sqlboiler/v4/types\""]}}},"aliases":{"tables":{"users":{"up_plural":"Users","up_singular":"User","down_plural":"users","down_singular":"user","columns":{"created_at":"CreatedAt","email":"Email","email_verified":"EmailVerified","enabled":"Enabled","id":"ID","name":"Name","sso_id":"SsoID","updated_at":"UpdatedAt"}},"workspace_dashboards":{"up_plural":"WorkspaceDashboards","up_singular":"WorkspaceDashboard","down_plural":"workspaceDashboards","down_singular":"workspaceDashboard","columns":{"created_at":"CreatedAt","dashboard_json":"DashboardJSON","default":"Default","enabled":"Enabled","id":"ID","name":"Name","tags":"Tags","updated_at":"UpdatedAt","workspace_id":"WorkspaceID"},"relationships":{"workspace_dashboards_workspaces_workspace_id_fk":{"local":"WorkspaceDashboards","foreign":"Workspace"}}},"workspace_integrations":{"up_plural":"WorkspaceIntegrations","up_singular":"WorkspaceIntegration","down_plural":"workspaceIntegrations","down_singular":"workspaceIntegration","columns":{"credentials":"Credentials","description":"Description","details":"Details","enabled":"Enabled","id":"ID","integration":"Integration","name":"Name","run_at_hours":"RunAtHours","run_every_hours":"RunEveryHours","timezone":"Timezone","workspace_id":"WorkspaceID"},"relationships":{"workspace_integrations_workspaces_id_fk":{"local":"WorkspaceIntegrations","foreign":"Workspace"}}},"workspace_users":{"up_plural":"WorkspaceUsers","up_singular":"WorkspaceUser","down_plural":"workspaceUsers","down_singular":"workspaceUser","columns":{"id":"ID","tags":"Tags","user_id":"UserID","workspace_id":"WorkspaceID"},"relationships":{"workspace_users_users_id_fk":{"local":"WorkspaceUsers","foreign":"User"},"workspace_users_workspaces_id_fk":{"local":"WorkspaceUsers","foreign":"Workspace"}}},"workspaces":{"up_plural":"Workspaces","up_singular":"Workspace","down_plural":"workspaces","down_singular":"workspace","columns":{"created_at":"CreatedAt","description":"Description","name":"Name","updated_at":"UpdatedAt","uuid":"UUID","workspace_id":"WorkspaceID"}}}},"auto_columns":{},"inflections":{"Plural":{},"PluralExact":{},"Singular":{},"SingularExact":{},"Irregular":{}},"version":"4.16.1"},"driver_config":{"add-enum-types":false,"blacklist":null,"dbname":"ss_analytics_dev","enum-null-prefix":"Null","foreign-keys":null,"host":"earth.statstream.dev","pass":"password","sslmode":"disable","user":"abhishek","whitelist":null},"schema":"public","dialect":{"lq":34,"rq":34,"use_index_placeholders":true,"use_last_insert_id":false,"use_schema":false,"use_default_keyword":true,"use_top_clause":false,"use_output_clause":false,"use_case_when_exists_clause":false,"use_auto_columns":false},"tables":[{"name":"users","schema_name":"","columns":[{"name":"id","type":"string","db_type":"character varying","default":"","comment":"","nullable":false,"unique":true,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"varchar","domain_name":null,"full_db_type":"varchar"},{"name":"sso_id","type":"string","db_type":"character varying","default":"","comment":"","nullable":false,"unique":true,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"varchar","domain_name":null,"full_db_type":"character varying(40)"},{"name":"email","type":"string","db_type":"character varying","default":"","comment":"","nullable":false,"unique":true,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"varchar","domain_name":null,"full_db_type":"character varying(250)"},{"name":"name","type":"string","db_type":"character varying","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"varchar","domain_name":null,"full_db_type":"character varying(250)"},{"name":"email_verified","type":"bool","db_type":"boolean","default":"false","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"bool","domain_name":null,"full_db_type":"bool"},{"name":"enabled","type":"bool","db_type":"boolean","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"bool","domain_name":null,"full_db_type":"bool"},{"name":"created_at","type":"time.Time","db_type":"timestamp without time zone","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"timestamp","domain_name":null,"full_db_type":"timestamp"},{"name":"updated_at","type":"time.Time","db_type":"timestamp without time zone","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"timestamp","domain_name":null,"full_db_type":"timestamp"}],"p_key":{"name":"users_pk","columns":["id"]},"f_keys":null,"is_join_table":false,"to_one_relationships":null,"to_many_relationships":[{"name":"workspace_users_users_id_fk","table":"users","column":"id","nullable":false,"unique":true,"foreign_table":"workspace_users","foreign_column":"user_id","foreign_column_nullable":false,"foreign_column_unique":false,"to_join_table":false,"join_table":"","join_local_fkey_name":"","join_local_column":"","join_local_column_nullable":false,"join_local_column_unique":false,"join_foreign_fkey_name":"","join_foreign_column":"","join_foreign_column_nullable":false,"join_foreign_column_unique":false}],"is_view":false,"view_capabilities":{"can_insert":false,"can_upsert":false}},{"name":"workspace_dashboards","schema_name":"","columns":[{"name":"id","type":"string","db_type":"character varying","default":"","comment":"","nullable":false,"unique":true,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"varchar","domain_name":null,"full_db_type":"character varying(40)"},{"name":"name","type":"string","db_type":"character varying","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"varchar","domain_name":null,"full_db_type":"character varying(250)"},{"name":"dashboard_json","type":"types.JSON","db_type":"json","default":"'{}'::json","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"json","domain_name":null,"full_db_type":"json"},{"name":"created_at","type":"time.Time","db_type":"timestamp without time zone","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"timestamp","domain_name":null,"full_db_type":"timestamp"},{"name":"updated_at","type":"time.Time","db_type":"timestamp without time zone","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"timestamp","domain_name":null,"full_db_type":"timestamp"},{"name":"enabled","type":"bool","db_type":"boolean","default":"true","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"bool","domain_name":null,"full_db_type":"bool"},{"name":"workspace_id","type":"int64","db_type":"bigint","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"int8","domain_name":null,"full_db_type":"int8"},{"name":"default","type":"bool","db_type":"boolean","default":"false","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"bool","domain_name":null,"full_db_type":"bool"},{"name":"tags","type":"types.StringArray","db_type":"ARRAYtext","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":"text","udt_name":"_text","domain_name":null,"full_db_type":"_text"}],"p_key":{"name":"workspace_dashboards_pk","columns":["id"]},"f_keys":[{"table":"workspace_dashboards","name":"workspace_dashboards_workspaces_workspace_id_fk","column":"workspace_id","nullable":false,"unique":false,"foreign_table":"workspaces","foreign_column":"workspace_id","foreign_column_nullable":false,"foreign_column_unique":true}],"is_join_table":false,"to_one_relationships":null,"to_many_relationships":null,"is_view":false,"view_capabilities":{"can_insert":false,"can_upsert":false}},{"name":"workspace_integrations","schema_name":"","columns":[{"name":"id","type":"string","db_type":"character varying","default":"","comment":"","nullable":false,"unique":true,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"varchar","domain_name":null,"full_db_type":"character varying(40)"},{"name":"name","type":"string","db_type":"character varying","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"varchar","domain_name":null,"full_db_type":"character varying(250)"},{"name":"workspace_id","type":"int64","db_type":"bigint","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"int8","domain_name":null,"full_db_type":"int8"},{"name":"integration","type":"string","db_type":"character varying","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"varchar","domain_name":null,"full_db_type":"character varying(50)"},{"name":"description","type":"string","db_type":"character varying","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"varchar","domain_name":null,"full_db_type":"character varying(250)"},{"name":"details","type":"types.JSON","db_type":"json","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"json","domain_name":null,"full_db_type":"json"},{"name":"credentials","type":"types.JSON","db_type":"json","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"json","domain_name":null,"full_db_type":"json"},{"name":"run_at_hours","type":"int","db_type":"integer","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"int4","domain_name":null,"full_db_type":"int4"},{"name":"run_every_hours","type":"int","db_type":"integer","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"int4","domain_name":null,"full_db_type":"int4"},{"name":"timezone","type":"string","db_type":"character varying","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"varchar","domain_name":null,"full_db_type":"character varying(100)"},{"name":"enabled","type":"bool","db_type":"boolean","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"bool","domain_name":null,"full_db_type":"bool"}],"p_key":{"name":"workspace_integrations_pkey","columns":["id"]},"f_keys":[{"table":"workspace_integrations","name":"workspace_integrations_workspaces_id_fk","column":"workspace_id","nullable":false,"unique":false,"foreign_table":"workspaces","foreign_column":"workspace_id","foreign_column_nullable":false,"foreign_column_unique":true}],"is_join_table":false,"to_one_relationships":null,"to_many_relationships":null,"is_view":false,"view_capabilities":{"can_insert":false,"can_upsert":false}},{"name":"workspace_users","schema_name":"","columns":[{"name":"id","type":"string","db_type":"character varying","default":"","comment":"","nullable":false,"unique":true,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"varchar","domain_name":null,"full_db_type":"character varying(40)"},{"name":"workspace_id","type":"int64","db_type":"bigint","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"int8","domain_name":null,"full_db_type":"int8"},{"name":"user_id","type":"string","db_type":"character varying","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"varchar","domain_name":null,"full_db_type":"character varying(40)"},{"name":"tags","type":"types.StringArray","db_type":"ARRAYtext","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":"text","udt_name":"_text","domain_name":null,"full_db_type":"_text"}],"p_key":{"name":"workspace_users_pk","columns":["id"]},"f_keys":[{"table":"workspace_users","name":"workspace_users_users_id_fk","column":"user_id","nullable":false,"unique":false,"foreign_table":"users","foreign_column":"id","foreign_column_nullable":false,"foreign_column_unique":true},{"table":"workspace_users","name":"workspace_users_workspaces_id_fk","column":"workspace_id","nullable":false,"unique":false,"foreign_table":"workspaces","foreign_column":"workspace_id","foreign_column_nullable":false,"foreign_column_unique":true}],"is_join_table":false,"to_one_relationships":null,"to_many_relationships":null,"is_view":false,"view_capabilities":{"can_insert":false,"can_upsert":false}},{"name":"workspaces","schema_name":"","columns":[{"name":"workspace_id","type":"int64","db_type":"bigint","default":"nextval('workspaces_id_seq'::regclass)","comment":"","nullable":false,"unique":true,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"int8","domain_name":null,"full_db_type":"int8"},{"name":"uuid","type":"string","db_type":"character varying","default":"","comment":"","nullable":false,"unique":true,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"varchar","domain_name":null,"full_db_type":"character varying(40)"},{"name":"name","type":"string","db_type":"character varying","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"varchar","domain_name":null,"full_db_type":"character varying(250)"},{"name":"created_at","type":"time.Time","db_type":"timestamp without time zone","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"timestamp","domain_name":null,"full_db_type":"timestamp"},{"name":"updated_at","type":"time.Time","db_type":"timestamp without time zone","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"timestamp","domain_name":null,"full_db_type":"timestamp"},{"name":"description","type":"string","db_type":"character varying","default":"","comment":"","nullable":false,"unique":false,"validated":false,"auto_generated":false,"arr_type":null,"udt_name":"varchar","domain_name":null,"full_db_type":"character varying(250)"}],"p_key":{"name":"workspaces_pk","columns":["workspace_id"]},"f_keys":null,"is_join_table":false,"to_one_relationships":null,"to_many_relationships":[{"name":"workspace_dashboards_workspaces_workspace_id_fk","table":"workspaces","column":"workspace_id","nullable":false,"unique":true,"foreign_table":"workspace_dashboards","foreign_column":"workspace_id","foreign_column_nullable":false,"foreign_column_unique":false,"to_join_table":false,"join_table":"","join_local_fkey_name":"","join_local_column":"","join_local_column_nullable":false,"join_local_column_unique":false,"join_foreign_fkey_name":"","join_foreign_column":"","join_foreign_column_nullable":false,"join_foreign_column_unique":false},{"name":"workspace_integrations_workspaces_id_fk","table":"workspaces","column":"workspace_id","nullable":false,"unique":true,"foreign_table":"workspace_integrations","foreign_column":"workspace_id","foreign_column_nullable":false,"foreign_column_unique":false,"to_join_table":false,"join_table":"","join_local_fkey_name":"","join_local_column":"","join_local_column_nullable":false,"join_local_column_unique":false,"join_foreign_fkey_name":"","join_foreign_column":"","join_foreign_column_nullable":false,"join_foreign_column_unique":false},{"name":"workspace_users_workspaces_id_fk","table":"workspaces","column":"workspace_id","nullable":false,"unique":true,"foreign_table":"workspace_users","foreign_column":"workspace_id","foreign_column_nullable":false,"foreign_column_unique":false,"to_join_table":false,"join_table":"","join_local_fkey_name":"","join_local_column":"","join_local_column_nullable":false,"join_local_column_unique":false,"join_foreign_fkey_name":"","join_foreign_column":"","join_foreign_column_nullable":false,"join_foreign_column_unique":false}],"is_view":false,"view_capabilities":{"can_insert":false,"can_upsert":false}}],"templates":[{"name":"main/00_struct.go.tpl","loader":"asset:main/00_struct.go.tpl"},{"name":"main/01_types.go.tpl","loader":"asset:main/01_types.go.tpl"},{"name":"main/02_hooks.go.tpl","loader":"asset:main/02_hooks.go.tpl"},{"name":"main/03_finishers.go.tpl","loader":"asset:main/03_finishers.go.tpl"},{"name":"main/04_relationship_to_one.go.tpl","loader":"asset:main/04_relationship_to_one.go.tpl"},{"name":"main/05_relationship_one_to_one.go.tpl","loader":"asset:main/05_relationship_one_to_one.go.tpl"},{"name":"main/06_relationship_to_many.go.tpl","loader":"asset:main/06_relationship_to_many.go.tpl"},{"name":"main/07_relationship_to_one_eager.go.tpl","loader":"asset:main/07_relationship_to_one_eager.go.tpl"},{"name":"main/08_relationship_one_to_one_eager.go.tpl","loader":"asset:main/08_relationship_one_to_one_eager.go.tpl"},{"name":"main/09_relationship_to_many_eager.go.tpl","loader":"asset:main/09_relationship_to_many_eager.go.tpl"},{"name":"main/10_relationship_to_one_setops.go.tpl","loader":"asset:main/10_relationship_to_one_setops.go.tpl"},{"name":"main/11_relationship_one_to_one_setops.go.tpl","loader":"asset:main/11_relationship_one_to_one_setops.go.tpl"},{"name":"main/12_relationship_to_many_setops.go.tpl","loader":"asset:main/12_relationship_to_many_setops.go.tpl"},{"name":"main/13_all.go.tpl","loader":"asset:main/13_all.go.tpl"},{"name":"main/14_find.go.tpl","loader":"asset:main/14_find.go.tpl"},{"name":"main/15_insert.go.tpl","loader":"asset:main/15_insert.go.tpl"},{"name":"main/16_update.go.tpl","loader":"asset:main/16_update.go.tpl"},{"name":"main/17_upsert.go.tpl","loader":"base64:(sha256 of content): 602261d465483952d7ad95e757ed2d8e198640013467681ede6ae722dcd589e5"},{"name":"main/18_delete.go.tpl","loader":"asset:main/18_delete.go.tpl"},{"name":"main/19_reload.go.tpl","loader":"asset:main/19_reload.go.tpl"},{"name":"main/20_exists.go.tpl","loader":"asset:main/20_exists.go.tpl"},{"name":"main/21_auto_timestamps.go.tpl","loader":"asset:main/21_auto_timestamps.go.tpl"},{"name":"main/22_ilike.go.tpl","loader":"base64:(sha256 of content): b590db21a38fc42dd892905f7b4fa0e41ab0339717a8d577c0a807374ff6abde"},{"name":"main/singleton/boil_queries.go.tpl","loader":"asset:main/singleton/boil_queries.go.tpl"},{"name":"main/singleton/boil_table_names.go.tpl","loader":"asset:main/singleton/boil_table_names.go.tpl"},{"name":"main/singleton/boil_types.go.tpl","loader":"asset:main/singleton/boil_types.go.tpl"},{"name":"main/singleton/boil_view_names.go.tpl","loader":"asset:main/singleton/boil_view_names.go.tpl"},{"name":"main/singleton/psql_upsert.go.tpl","loader":"base64:(sha256 of content): b497cd57da15f3f3b932742b9d3adfe8f345cc6ce6402d78ff74299a59494156"},{"name":"test/00_types.go.tpl","loader":"asset:test/00_types.go.tpl"},{"name":"test/all.go.tpl","loader":"asset:test/all.go.tpl"},{"name":"test/delete.go.tpl","loader":"asset:test/delete.go.tpl"},{"name":"test/exists.go.tpl","loader":"asset:test/exists.go.tpl"},{"name":"test/find.go.tpl","loader":"asset:test/find.go.tpl"},{"name":"test/finishers.go.tpl","loader":"asset:test/finishers.go.tpl"},{"name":"test/hooks.go.tpl","loader":"asset:test/hooks.go.tpl"},{"name":"test/insert.go.tpl","loader":"asset:test/insert.go.tpl"},{"name":"test/relationship_one_to_one.go.tpl","loader":"asset:test/relationship_one_to_one.go.tpl"},{"name":"test/relationship_one_to_one_setops.go.tpl","loader":"asset:test/relationship_one_to_one_setops.go.tpl"},{"name":"test/relationship_to_many.go.tpl","loader":"asset:test/relationship_to_many.go.tpl"},{"name":"test/relationship_to_many_setops.go.tpl","loader":"asset:test/relationship_to_many_setops.go.tpl"},{"name":"test/relationship_to_one.go.tpl","loader":"asset:test/relationship_to_one.go.tpl"},{"name":"test/relationship_to_one_setops.go.tpl","loader":"asset:test/relationship_to_one_setops.go.tpl"},{"name":"test/reload.go.tpl","loader":"asset:test/reload.go.tpl"},{"name":"test/select.go.tpl","loader":"asset:test/select.go.tpl"},{"name":"test/singleton/boil_main_test.go.tpl","loader":"asset:test/singleton/boil_main_test.go.tpl"},{"name":"test/singleton/boil_queries_test.go.tpl","loader":"asset:test/singleton/boil_queries_test.go.tpl"},{"name":"test/singleton/boil_relationship_test.go.tpl","loader":"asset:test/singleton/boil_relationship_test.go.tpl"},{"name":"test/singleton/boil_suites_test.go.tpl","loader":"asset:test/singleton/boil_suites_test.go.tpl"},{"name":"test/singleton/psql_main_test.go.tpl","loader":"base64:(sha256 of content): a10f31b033737bdec0142363f6661a201e39eee8201e6cd56f889278d9e05f80"},{"name":"test/singleton/psql_suites_test.go.tpl","loader":"base64:(sha256 of content): a89b312831433fa034ad26757c27224bad4cf17b2e1a89a31574c5da21f68fa7"},{"name":"test/types.go.tpl","loader":"asset:test/types.go.tpl"},{"name":"test/update.go.tpl","loader":"asset:test/update.go.tpl"},{"name":"test/upsert.go.tpl","loader":"base64:(sha256 of content): fbdedf7ee38269da51adf562f603fb1616cf5ac7975c53268a9181863b2c2258"}]}
Error: 32:77: expected ';', found Default (and 1 more errors)
failed to format template

  27    Name string`form:"name" boil:"name" json:"name" toml:"name" yaml:"name"`
  28    DashboardJSON types.JSON`form:"dashboard_json" boil:"dashboard_json" json:"dashboard_json" toml:"dashboard_json" yaml:"dashboard_json"`
  29    CreatedAt time.Time`form:"created_at" boil:"created_at" json:"created_at" toml:"created_at" yaml:"created_at"`
  30    UpdatedAt time.Time`form:"updated_at" boil:"updated_at" json:"updated_at" toml:"updated_at" yaml:"updated_at"`
  31    Enabled bool`form:"enabled" boil:"enabled" json:"enabled" toml:"enabled" yaml:"enabled"`
>>>>    WorkspaceID int64 `form:"-" boil:"workspace_id" json:"-" toml:"-" yaml:"-"`Default bool`form:"default" boil:"default" json:"default" toml:"default" yaml:"default"`
  33    Tags types.StringArray`form:"tags" boil:"tags" json:"tags" toml:"tags" yaml:"tags"`
  34 
  35    R *workspaceDashboardR `form:"-" boil:"-" json:"-" toml:"-" yaml:"-"`
  36    L workspaceDashboardL `form:"-" boil:"-" json:"-" toml:"-" yaml:"-"`
  37    }

github.com/volatiletech/sqlboiler/v4/boilingcore.formatBuffer
        /home/abhishek/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.16.1/boilingcore/output.go:300
github.com/volatiletech/sqlboiler/v4/boilingcore.writeFile
        /home/abhishek/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.16.1/boilingcore/output.go:240
github.com/volatiletech/sqlboiler/v4/boilingcore.executeTemplates
        /home/abhishek/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.16.1/boilingcore/output.go:161
github.com/volatiletech/sqlboiler/v4/boilingcore.generateOutput
        /home/abhishek/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.16.1/boilingcore/output.go:63
github.com/volatiletech/sqlboiler/v4/boilingcore.(*State).Run
        /home/abhishek/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.16.1/boilingcore/boilingcore.go:198
main.run
        /home/abhishek/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.16.1/main.go:270
github.com/spf13/cobra.(*Command).execute
        /home/abhishek/go/pkg/mod/github.com/spf13/cobra@v1.5.0/command.go:872
github.com/spf13/cobra.(*Command).ExecuteC
        /home/abhishek/go/pkg/mod/github.com/spf13/cobra@v1.5.0/command.go:990
github.com/spf13/cobra.(*Command).Execute
        /home/abhishek/go/pkg/mod/github.com/spf13/cobra@v1.5.0/command.go:918
main.main
        /home/abhishek/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.16.1/main.go:123
runtime.main
        /home/linuxbrew/.linuxbrew/Cellar/go/1.21.6/libexec/src/runtime/proc.go:267
runtime.goexit
        /home/linuxbrew/.linuxbrew/Cellar/go/1.21.6/libexec/src/runtime/asm_amd64.s:1650
unable to generate output
github.com/volatiletech/sqlboiler/v4/boilingcore.(*State).Run
        /home/abhishek/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.16.1/boilingcore/boilingcore.go:199
main.run
        /home/abhishek/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.16.1/main.go:270
github.com/spf13/cobra.(*Command).execute
        /home/abhishek/go/pkg/mod/github.com/spf13/cobra@v1.5.0/command.go:872
github.com/spf13/cobra.(*Command).ExecuteC
        /home/abhishek/go/pkg/mod/github.com/spf13/cobra@v1.5.0/command.go:990
github.com/spf13/cobra.(*Command).Execute
        /home/abhishek/go/pkg/mod/github.com/spf13/cobra@v1.5.0/command.go:918
main.main
        /home/abhishek/go/pkg/mod/github.com/volatiletech/sqlboiler/v4@v4.16.1/main.go:123
runtime.main
        /home/linuxbrew/.linuxbrew/Cellar/go/1.21.6/libexec/src/runtime/proc.go:267
runtime.goexit
        /home/linuxbrew/.linuxbrew/Cellar/go/1.21.6/libexec/src/runtime/asm_amd64.s:1650

Please provide a relevant database schema so we can replicate your issue (Provided you are comfortable sharing this)

create table public.workspace_dashboards
(
    id             varchar(40)                not null
        constraint workspace_dashboards_pk
            primary key,
    name           varchar(250)               not null,
    dashboard_json json    default '{}'::json not null,
    created_at     timestamp                  not null,
    updated_at     timestamp                  not null,
    enabled        boolean default true       not null,
    workspace_id   bigint                     not null
        constraint workspace_dashboards_workspaces_workspace_id_fk
            references public.workspaces,
    "default"      boolean default false      not null,
    tags           text[]                     not null
);

Further information. What did you do, what did you expect?

090809 commented 7 months ago

@adpande @stephenafamo it fixed in https://github.com/volatiletech/sqlboiler/pull/1344 But it's need to be released

stephenafamo commented 7 months ago

Released in v4.16.2

adpande commented 7 months ago

Upgraded and tested. It is working fine now. Thanks a lot !