CHANGELOG.md

Changelog

v1.49.3 (2021-02-04)

• Use RunE #292 (k1LoW)
• Fix errors handling #291 (k1LoW)

v1.49.2 (2021-02-01)

• Add --rm-dist option to remove files in docPath before generating documents #285 (k1LoW)
• Fix dsn url (tbls diff output) #284 (k1LoW)

v1.49.1 (2021-02-01)

• Fix tbls diff (no args) #283 (k1LoW)

v1.49.0 (2021-02-01)

• Separate datasource/datasource.go #282 (k1LoW)
• Fix tbls diff output #281 (k1LoW)
• tbls diff support for diff checking between dsn and dsn #280 (k1LoW)

v1.48.1 (2021-01-21)

• [PostgreSQL]Fix version parse #279 (k1LoW)

v1.48.0 (2021-01-16)

• Add hide_auto_increment option to hide the entire AUTO_INCREMENT clause #277 (k1LoW)
• Support MariaDB #276 (k1LoW)

v1.47.0 (2020-12-31)

• Fix MySQL extra definition #272 (k1LoW)
• [BREAKING][PostgreSQL]Support Extra Definition (Generated column) #271 (k1LoW)
• Organize testdata #270 (k1LoW)
• xlsx format support extra definition #269 (k1LoW)
• [BREAKING][MySQL]Support Extra Definition (AUTO_INCREMENT / Generated column etc) #268 (k1LoW)

v1.46.0 (2020-12-11)

• Support Snowflake #267 (kanata2)

v1.45.2 (2020-11-26)

• Fix external sub-command logic #265 (k1LoW)

v1.45.1 (2020-11-23)

• Fix detectVirtualRelations: default strategy #264 (k1LoW)

v1.45.0 (2020-11-10)

• Add flag that it should deltect relations #260 (syarig)
• [BigQuery] Sort labels #263 (k1LoW)
• Add baseUrl flag for links #261 (wubin1989)

v1.44.0 (2020-11-05)

• Bump up go version #262 (k1LoW)
• Support personalized templates #258 (folago)

v1.43.1 (2020-08-13)

• Remove array_remove() for supporting PostgreSQL 9.2 #253 (k1LoW)
• Fix raws.Close() position #252 (k1LoW)

v1.43.0 (2020-08-07)

• Add allOrNothing: lint option #250 (k1LoW)

v1.42.0 (2020-08-03)

• [BREAKING] Remove --add option #249 (k1LoW)
• Add --when option #248 (k1LoW)
• [BREAKING] Move tbls out -t cacoo to tbls cacoo csv (tbls-cacoo) #247 (k1LoW)

v1.40.0 (2020-07-09)

• [BREAKING] Change default ER diagram format to 'svg' #244 (k1LoW)
• Add er.font option for png/jpg ER diagram #243 (k1LoW)

v1.39.0 (2020-06-15)

• [BREAKING][MySQL]Redact AUTO_INCREMENT value of table option by default #241 (k1LoW)

v1.38.3 (2020-05-13)

• Fix MSSQL comments trimmed to 30 chars #238 (paulKabira)

v1.38.2 (2020-05-11)

• [BREAKING]Set path of temporary generated schema.json (instead of JSON string) to TBLS_SCHEMA #236 (k1LoW)

v1.38.1 (2020-05-10)

• Fix Dockerfile.hub.docker.com #235 (k1LoW)

v1.38.0 (2020-05-10)

• Support MSSQL Description for Table/Columns. #234 (paulKabira)

v1.37.5 (2020-05-09)

• make config.DefaultDocPath and config.DefaultConfigFilePaths public #233 (k1LoW)
• fix typo #231 (dojineko)

v1.37.4 (2020-05-07)

• Pass env TBLS_CONFIG_PATH to subcommands #230 (k1LoW)

v1.37.3 (2020-05-05)

• Support completion of external subcommands (Bash) #229 (k1LoW)
• Fix basename issue and simplify code #228 (syohex)
• Support completion of external subcommands (Zsh) #227 (k1LoW)

v1.37.2 (2020-05-01)

• Remove relations of excluded tables #226 (k1LoW)

v1.37.1 (2020-04-30)

• Fix FilterTables #225 (k1LoW)
• Fix usage #224 (k1LoW)

v1.37.0 (2020-04-28)

• Add tbls coverage #222 (k1LoW)
• Add lint rule for comments ( index, constraint, trigger ) #221 (k1LoW)
• [PostgreSQL]Support comments ( index, constraint, trigger ) #220 (k1LoW)
• Support more comments ( index, constraint, trigger ) #219 (k1LoW)

v1.36.1 (2020-04-25)

• Add ",omitempty" to config.Config #218 (k1LoW)
• Correct test for varchar arrays #217 (mjpieters)

v1.36.0 (2020-04-25)

• [PostgreSQL]Fix the logic of extracting table/column name from definition of FK #215 (k1LoW)
• Postgres: support materialized views #214 (mjpieters)

v1.35.0 (2020-04-22)

• [BREAKING]Fix tbls diff output #207 (k1LoW)
• Add datasource.NewBigqueryClient #206 (k1LoW)

v1.34.1 (2020-04-21)

• Add datasource.AnalyzeJSONString for external subcommand #205 (k1LoW)

v1.34.0 (2020-04-21)

• Support external subcommand like git-* #204 (k1LoW)
• Fix typo #203 (k1LoW)

v1.33.0 (2020-04-19)

• Add output format (CSV for Cacoo's Database Schema Importer) #202 (k1LoW)

v1.32.2 (2020-04-17)

• Fix lint labelStyleBigQuery #201 (k1LoW)

v1.32.1 (2020-04-17)

• [BREAKING]Fix excludedTables: -> excludeTables: #200 (k1LoW)

v1.32.0 (2020-04-17)

• Add lint rule labelStyleBigQuery #199 (k1LoW)
• Fix Config.MaskedDSN output #198 (k1LoW)

v1.31.2 (2020-04-14)

• fix (MSSQLDriver) : Set size of nvarchar/varchar/varbinary columns. Filter sysname columns from list. #197 (jafin)

v1.31.1 (2020-04-14)

• Fixed an error in Graphviz when the parent table of Relation is an exclude target. #196 (yoskhdia)

v1.31.0 (2020-04-07)

• Add labels: and comments.labels: #195 (k1LoW)
• [BigQuery]Add labels section #194 (k1LoW)

v1.30.0 (2020-04-06)

• Fix #188 'near "." Syntax Error' #193 (BoringDude)
• [BREAKING]Add schema description #192 (k1LoW)

v1.29.3 (2020-04-05)

• Fix os.OpenFile mode and permission #191 (k1LoW)
• Set dict for BigQuery #190 (k1LoW)
• Add testing platform ( GitBash on Windows ) #189 (k1LoW)
• Support https:// http:// #187 (k1LoW)
• Add default config file name tbls.yml #186 (k1LoW)

v1.29.2 (2020-03-17)

• Fix syntax error (
  ->
  ) in dot file #185 (k1LoW)

v1.29.1 (2020-03-15)

• [PostgreSQL]Detect full table name using search_path and information_schema #184 (k1LoW)

v1.29.0 (2020-03-14)

• Set dict for DynamoDB #183 (k1LoW)
• Add dict: for replacement title/table header of database document #182 (k1LoW)
• Add name: for specifing database name of document #180 (k1LoW)
• Fix schema.Driver.Meta #179 (k1LoW)

v1.28.2 (2020-03-09)

• Support table name omitting current_schema #178 (k1LoW)

v1.28.1 (2020-03-08)

• Use goccy/go-yaml for loading config, too #177 (k1LoW)

v1.28.0 (2020-03-07)

• Fix zsh completion #176 (k1LoW)
• [BREAKING][PostgreSQL][Amazon Redshift]Show public. schema #175 (k1LoW)
• Support Amazon DynamoDB #174 (k1LoW)
• Filter target tables using include: and exclude: / include: and exclude: support wildcard #172 (k1LoW)

v1.27.0 (2020-02-24)

• Add config.ER.distance #171 (k1LoW)
• Fix: tbls out -t config does not set default values #170 (k1LoW)
• Add output format (PNG, SVG, JPG) #169 (k1LoW)
• Use github.com/goccy/go-graphviz instead of dot command #167 (k1LoW)
• Bump up goccy/go-yaml version to v1.3.2 and remove workaround #168 (k1LoW)
• Change default shell to /bin/sh #166 (kkznch)

v1.26.0 (2020-02-20)

• [BREAKING] Normalize relations: of tbls output #165 (k1LoW)
• Rename schema.Relation.IsAdditional -> schema.Relation.Virtual #164 (k1LoW)
• Add YAML output format #163 (k1LoW)

v1.25.1 (2020-02-17)

• [MySQL]Fix constraints/indexes detection bug #162 (k1LoW)
• Fix: Empty array is output as null #161 (k1LoW)

v1.25.0 (2020-02-06)

• lint exclude: lintExclude: support wildcard (*) #160 (k1LoW)

v1.24.1 (2020-01-16)

• [PostgreSQL]Fix parsing double-quoted table/column name in definition of Foreign Key #154 (k1LoW)
• Update README.md #151 (ednawig)
• Dockerfile use latest version of tbls #150 (k1LoW)

v1.24.0 (2020-01-11)

• Add tbls completion #149 (k1LoW)

v1.23.0 (2019-12-11)

• Show table names when lint error unrelated table exists #148 (k1LoW)

v1.22.1 (2019-11-21)

• Fix: panic: assignment to entry in nil map #147 (k1LoW)

v1.22.0 (2019-11-20)

• Add .tbls.yml (tbls config file) output format #146 (k1LoW)

v1.21.1 (2019-11-11)

• Fix: requireForeignKeyIndex check only FOREIGN_KEY. #145 (k1LoW)

v1.21.0 (2019-11-11)

• Add lintExclude for exclude tables from lint. #144 (k1LoW)

v1.20.0 (2019-11-02)

• lint rule requireColumnComment excludes table_name.column_name as well as column_name #143 (k1LoW)
• Add lint rule requireForeignKeyIndex #142 (k1LoW)
• Use GitHub Actions #141 (k1LoW)
• Remove MATCH SIMPLE from my.sql #140 (k1LoW)

v1.19.0 (2019-09-06)

• Add lint rule duplicateRelations #139 (k1LoW)

v1.18.2 (2019-09-06)

• Remove duplicate relation links #138 (k1LoW)
• add error handling #137 (toshi0607)
• add Dockerfile #136 (peccu)
• Add gosec #135 (k1LoW)

v1.18.1 (2019-08-15)

• Fix duplicate output when multiple schemas have the same named table #134 (oohira)
• Support span:// for Cloud Spanner scheme #133 (k1LoW)

v1.18.0 (2019-08-13)

• Support Cloud Spanner #132 (k1LoW)
• Fix .travis.yml condition #131 (k1LoW)
• fix typo for readme #130 (kojirock5260)

v1.17.2 (2019-07-15)

• Fix .goreleaser build hooks #129 (k1LoW)

v1.17.1 (2019-07-08)

• Fix panic when hyphen-table #126 (k1LoW)
• Update gobuffalo/packr to v2 #124 (k1LoW)

v1.17.0 (2019-06-12)

• Refactor out/* packages #123 (k1LoW)
• Add er.comment for add comment to ER diagram #122 (k1LoW)

v1.16.1 (2019-06-11)

• Fix loading ER diagram format from .tbls.yml #120 (k1LoW)

v1.16.0 (2019-06-04)

• Support for Microsoft SQL Server #118 (k1LoW)

v1.15.4 (2019-05-28)

• Postgres driver support new schema.Constraint schema.Index #116 (k1LoW)

v1.15.3 (2019-05-27)

• Redshift can not analyze indexes #115 (k1LoW)
• Fixed a typo in "repository" #112 (AntonNguyen)

v1.15.2 (2019-05-27)

• Redshift can not analyze constraints #114 (k1LoW)
• Revert Postgres driver parsing logic schema.Constaint/schema.Index #113 (k1LoW)

v1.15.0 (2019-05-26)

• Fix PlantUML output format #109 (k1LoW)
• Fix schema.Index #108 (k1LoW)
• Fix schema.Constraint #107 (k1LoW)
• Add PlantUML output format #106 (k1LoW)

v1.14.0 (2019-05-15)

• Support Amazon Redshift #105 (k1LoW)

v1.13.3 (2019-05-13)

• Fix config.RequireColumns is not config.Rule #104 (k1LoW)

v1.13.2 (2019-05-12)

• Truncate xlsx worksheet name for MS Excel #102 (k1LoW)

v1.13.1 (2019-05-12)

• Fix BigQuery dataset schema name #101 (k1LoW)

v1.13.0 (2019-05-12)

• Fix dot file format #100 (k1LoW)
• Fix command options #99 (k1LoW)
• Support BigQuery #98 (k1LoW)
• Refactor drivers #97 (k1LoW)

v1.12.0 (2019-05-11)

• Add exclude for excluding tables from the document #96 (k1LoW)
• Add lint rule requireColumns #95 (k1LoW)

v1.11.1 (2019-04-25)

• Fix loading args when tbls out #91 (k1LoW)

v1.11.0 (2019-04-25)

• Add --out option to set output file path. #90 (k1LoW)
• Add xlsx output format #89 (k1LoW)

v1.10.1 (2019-03-16)

• Fix .goreleaser.yml for CGO_ENABLED=1 #88 (k1LoW)

v1.10.0 (2019-03-13)

• Update document #83 (k1LoW)
• Update tbls lint detect message #87 (k1LoW)
• Update tbls lint detect message #87 (k1LoW)
• Add a temporary installation script for CI #86 (k1LoW)
• Add a temporary installation script for CI #86 (k1LoW)
• Change tbls diff output to unified format #85 (k1LoW)
• Change tbls diff output to unified format #85 (k1LoW)
• Fix config.Config internal #84 (k1LoW)
• Fix config.Config internal #84 (k1LoW)

v1.9.0 (2019-03-09)

• Use goreleaser #82 (k1LoW)
• mkdir when document directory does not exists #81 (k1LoW)
• Set default doc path dbdoc #80 e2ec6ed (k1LoW)
• Add md to tbls out format #79 (k1LoW)

v1.8.3 (2019-02-25)

• Add requireColumnComment.excludedTables #78 (k1LoW)

v1.8.2 (2019-02-25)

• Fix lint rules #77 (k1LoW)

v1.8.1 (2019-02-25)

• Fix dataPath to docPath #76 (k1LoW)

v1.8.0 (2019-02-23)

• Add tbls lint #75 (k1LoW)

v1.7.1 (2018-12-08)

• Fix the bug that foreign key constraints are not listed in the document and ER diagram in the case of primary key and foreign key #74 (k1LoW)

v1.7.0 (2018-11-29)

• Support default config file .tbls.yml #73 (k1LoW)

v1.6.0 (2018-11-24)

• [DEPRACATED] --add option is deprecated. Use --config #72 (k1LoW)
• Add --config option #71 (k1LoW)
• Load Environment Values #70 (k1LoW)
• Rename some code #69 (k1LoW)
• Add tbls driver information to JSON #68 (k1LoW)
• Support json:// #67 (k1LoW)
• [BREAKING] Change tbls dot to tbls out / Support JSON format #66 (k1LoW)

v1.5.1 (2018-11-20)

• Fix error messages #65 (k1LoW)

v1.5.0 (2018-11-18)

• [BREAKING] Fix md output ( fix newline ) #64 (k1LoW)
• [BREAKING] Add newline at end of file #63 (k1LoW)
• [BREAKING] Change tbls diff exit code #62 (k1LoW)
• mv test/ to testdata/ #61 (k1LoW)
• Fix tbls dot ( use packr ) #60 (k1LoW)
• Use Codecov #59 (k1LoW)

v1.4.1 (2018-11-14)

• Use gobuffalo/packr #58 (k1LoW)
• Remove unused modules in go.mod #57 (linyows)

v1.4.0 (2018-11-13)

• Support Go 1.11.x #56 (k1LoW)
• Fix PostgreSQL constraints sort rule. #55 (k1LoW)

v1.3.0 (2018-09-06)

• Add --er-format option #54 (k1LoW)

v1.2.1 (2018-08-09)

• Fix relation rendering of multi-columns foreign key #53 (k1LoW)

v1.2.0 (2018-08-08)

• Support SQLite FTS3/FTS4 Virtual Table #52 (k1LoW)
• Fix SQLite relation support #51 (k1LoW)

v1.1.1 (2018-08-06)

• Support SQLite CHECK constraints #50 (k1LoW)

v1.1.0 (2018-08-05)

• Support SQLite #49 (k1LoW)

v1.0.1 (2018-07-28)

• Add Triggers to Schema.Sort() #47 (k1LoW)

v1.0.0 (2018-07-28)

• Don't show item when length 0 #46 (k1LoW)
• Support analyze TRIGGER #45 (k1LoW)
• Change option --no-viz to --without-er #44 (k1LoW)

v0.10.2 (2018-07-26)

• Fix MySQL constraints / indexes query #42 (k1LoW)
• Add exec dot STDOUT to error message #41 (k1LoW)
• Add UNKNOWN CONSTRAINT ( This is constraint information that "tbls" still can not support ) #40 (k1LoW)

v0.10.1 (2018-07-22)

• Fix error handling #39 (k1LoW)

v0.10.0 (2018-07-22)

• Show errors with stack when DEBUG=1 #38 (k1LoW)
• Add --adjust-table option for adjust column width of table #37 (k1LoW)

v0.9.3 (2018-07-13)

• Support CR \r and CRLF \r\n #35 (k1LoW)

v0.9.2 (2018-07-09)

• Support multi-line comment #34 (k1LoW)
• Fix too many open files #33 (k1LoW)
• Add test for many tables #31 (k1LoW)

v0.9.1 (2018-06-30)

• Support PostgreSQL non-default schema #30 (k1LoW)

v0.9.0 (2018-06-29)

• Work with Amazon Redshift #29 (watarukura)

v0.8.2 (2018-06-06)

• Fix output dot bug #25 (k1LoW)

v0.8.1 (2018-06-06)

• Fix table template #24 (k1LoW)

v0.8.0 (2018-06-05)

• Add schema.Table.Def for show table/view definition #22 (k1LoW)
• call dot command with temporary file , graph name in dot file must be quoted #23 (kenichiro-kimura)

v0.7.0 (2018-06-02)

• --add option support additional comments #21 (k1LoW)

v0.6.2 (2018-05-31)

• Add ORDER BY to sort columns, constraints #20 (k1LoW)

v0.6.1 (2018-05-30)

• Escape tmpl value because dot file use #19 (k1LoW)
• Change style of additional relation edges / can set relation def #18 (k1LoW)

v0.6.0 (2018-05-30)

• Use Graphviz dot to generate ER diagram .png #17 (k1LoW)
• tbls dot generate dot to STDOUT #15 (k1LoW)

v0.5.1 (2018-05-29)

• Support Camelize table name like "CamelizeTable" #16 (k1LoW)

v0.5.0 (2018-05-28)

• Support CHECK constraints #14 (k1LoW)
• Support view table #13 (k1LoW)
• Add tbls dot command #12 (k1LoW)

v0.4.0 (2018-05-26)

• Add --add option for add extra data (relations) to schema #11 (k1LoW)
• Support MySQL 8 #10 (k1LoW)
• Add db.Ping() for test connection #9 (k1LoW)

v0.3.0 (2018-05-24)

• MySQL driver support #8 (k1LoW)

v0.2.2 (2018-05-24)

• Fix typo ;; #7 (k1LoW)

v0.2.1 (2018-05-22)

• Fix query for tables #6 (k1LoW)

v0.2.0 (2018-05-21)

• Add --sort option for CI easily #5 (k1LoW)
• Add go-assets #4 (k1LoW)

v0.1.2 (2018-05-21)

• Fix defer *.Close() #3 (k1LoW)
• Use path/filepath #2 (k1LoW)

v0.1.1 (2018-05-21)

• Add driver interface #1 (k1LoW)

v0.1.0 (2018-05-20)