Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
adpande opened this issue Feb 11, 2024 · 3 comments
Closed
Labels

Comments

@adpande
Copy link

adpande commented Feb 11, 2024

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/[email protected]/boilingcore/output.go:300
github.com/volatiletech/sqlboiler/v4/boilingcore.writeFile
        /home/abhishek/go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/boilingcore/output.go:240
github.com/volatiletech/sqlboiler/v4/boilingcore.executeTemplates
        /home/abhishek/go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/boilingcore/output.go:161
github.com/volatiletech/sqlboiler/v4/boilingcore.generateOutput
        /home/abhishek/go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/boilingcore/output.go:63
github.com/volatiletech/sqlboiler/v4/boilingcore.(*State).Run
        /home/abhishek/go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/boilingcore/boilingcore.go:198
main.run
        /home/abhishek/go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/main.go:270
github.com/spf13/cobra.(*Command).execute
        /home/abhishek/go/pkg/mod/github.com/spf13/[email protected]/command.go:872
github.com/spf13/cobra.(*Command).ExecuteC
        /home/abhishek/go/pkg/mod/github.com/spf13/[email protected]/command.go:990
github.com/spf13/cobra.(*Command).Execute
        /home/abhishek/go/pkg/mod/github.com/spf13/[email protected]/command.go:918
main.main
        /home/abhishek/go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/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/[email protected]/boilingcore/boilingcore.go:199
main.run
        /home/abhishek/go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/main.go:270
github.com/spf13/cobra.(*Command).execute
        /home/abhishek/go/pkg/mod/github.com/spf13/[email protected]/command.go:872
github.com/spf13/cobra.(*Command).ExecuteC
        /home/abhishek/go/pkg/mod/github.com/spf13/[email protected]/command.go:990
github.com/spf13/cobra.(*Command).Execute
        /home/abhishek/go/pkg/mod/github.com/spf13/[email protected]/command.go:918
main.main
        /home/abhishek/go/pkg/mod/github.com/volatiletech/sqlboiler/[email protected]/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?

@adpande adpande changed the title after specifying tag-ignore , sqlboiler is failing to generate the code After specifying tag-ignore , sqlboiler is failing to generate the code Feb 11, 2024
@090809
Copy link
Contributor

090809 commented Feb 12, 2024

@adpande @stephenafamo it fixed in
#1344
But it's need to be released

@stephenafamo
Copy link
Collaborator

Released in v4.16.2

@adpande
Copy link
Author

adpande commented Feb 13, 2024

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants