k1LoW / tbls

tbls is a CI-Friendly tool for document a database, written in Go.
MIT License
3.32k stars 163 forks source link

An error about:invalid database scheme #560

Closed AlilyZ closed 4 months ago

AlilyZ commented 4 months ago

I followed the method in the readme, used go to download the latest version of tbls. And used the method provided in the readme to configure the yml file for connecting to MySQL. As follows:

.tbls.yml

dsn: mysql://root:root@127.0.0.1:3306/test

Then I opened cmd in the bin directory of tbls, and executed D:\bin>tbls doc -c tbls.yml -f erd. The error is as follows : invalid database scheme

Using the navicat tool can connect to mysql 127.0.0.1:3306/test How should I handle it?

k1LoW commented 4 months ago

Hi @AlilyZ

Please show me the result of each of the following commands.

$ env DEBUG=1 tbls doc mysql://root:root@127.0.0.1:3306/test
$ env DEBUG=1 tbls doc -c tbls.yml -f erd
AlilyZ commented 4 months ago

Thank you very much for your reply. The results of these two commands are as follows: D:\go\bin\bin>tbls doc mysql://root:root@127.0.0.1:3306/test dbdoc\schema.svg dbdoc\class.svg dbdoc\relative.svg dbdoc\students.svg dbdoc\README.md dbdoc\class.md dbdoc\relative.md dbdoc\students.md dbdoc\schema.json

D:\go\bin\bin>tbls doc -c tbls.yml -f erd invalid database scheme

Thank you very much for your reply. The results of these two commands are as follows: D:\go\bin\bin>tbls doc mysql://root:root@127.0.0.1:3306/test dbdoc\schema.svg dbdoc\class.svg dbdoc\relative.svg dbdoc\students.svg dbdoc\README.md dbdoc\class.md dbdoc\relative.md dbdoc\students.md dbdoc\schema.json

D:\go\bin\bin>tbls doc -c tbls.yml -f erd invalid database scheme

k1LoW commented 4 months ago

Could you run some commands as follows?

( I'm a little concerned about the syntax of the config file. )

$ tbls version
1.73.2
$ cat .tbls.yml
dsn: mysql://root:mypass@localhost:33308/testdb
$ tbls doc -c .tbls.yml
dbdoc/schema.svg
dbdoc/CamelizeTable.svg
dbdoc/comment_stars.svg
dbdoc/comments.svg
dbdoc/hyphen-table.svg
dbdoc/logs.svg
dbdoc/long_long_long_long_long_long_long_long_table_name.svg
dbdoc/post_comments.svg
dbdoc/posts.svg
dbdoc/user_options.svg
dbdoc/users.svg
dbdoc/README.md
dbdoc/CamelizeTable.md
dbdoc/comment_stars.md
dbdoc/comments.md
dbdoc/hyphen-table.md
dbdoc/logs.md
dbdoc/long_long_long_long_long_long_long_long_table_name.md
dbdoc/post_comments.md
dbdoc/posts.md
dbdoc/user_options.md
dbdoc/users.md
dbdoc/schema.json
$
AlilyZ commented 4 months ago

Could you run some commands as follows?

( I'm a little concerned about the syntax of the config file. )

$ tbls version
1.73.2
$ cat .tbls.yml
dsn: mysql://root:mypass@localhost:33308/testdb
$ tbls doc -c .tbls.yml
dbdoc/schema.svg
dbdoc/CamelizeTable.svg
dbdoc/comment_stars.svg
dbdoc/comments.svg
dbdoc/hyphen-table.svg
dbdoc/logs.svg
dbdoc/long_long_long_long_long_long_long_long_table_name.svg
dbdoc/post_comments.svg
dbdoc/posts.svg
dbdoc/user_options.svg
dbdoc/users.svg
dbdoc/README.md
dbdoc/CamelizeTable.md
dbdoc/comment_stars.md
dbdoc/comments.md
dbdoc/hyphen-table.md
dbdoc/logs.md
dbdoc/long_long_long_long_long_long_long_long_table_name.md
dbdoc/post_comments.md
dbdoc/posts.md
dbdoc/user_options.md
dbdoc/users.md
dbdoc/schema.json
$

D:\go\bin\bin>tbls doc -c tbls.yml output ER diagram files already exists

D:\go\bin\bin>tbls version 1.73.2

D:\go\bin\bin>type tbls.yml dsn: mysql://root:root@127.0.0.1:3306/test

D:\go\bin\bin>tbls doc -c tbls.yml dbdoc\schema.svg dbdoc\class.svg dbdoc\relative.svg dbdoc\students.svg dbdoc\README.md dbdoc\class.md dbdoc\relative.md dbdoc\students.md dbdoc\schema.json

AlilyZ commented 4 months ago

Could you run some commands as follows? ( I'm a little concerned about the syntax of the config file. )

$ tbls version
1.73.2
$ cat .tbls.yml
dsn: mysql://root:mypass@localhost:33308/testdb
$ tbls doc -c .tbls.yml
dbdoc/schema.svg
dbdoc/CamelizeTable.svg
dbdoc/comment_stars.svg
dbdoc/comments.svg
dbdoc/hyphen-table.svg
dbdoc/logs.svg
dbdoc/long_long_long_long_long_long_long_long_table_name.svg
dbdoc/post_comments.svg
dbdoc/posts.svg
dbdoc/user_options.svg
dbdoc/users.svg
dbdoc/README.md
dbdoc/CamelizeTable.md
dbdoc/comment_stars.md
dbdoc/comments.md
dbdoc/hyphen-table.md
dbdoc/logs.md
dbdoc/long_long_long_long_long_long_long_long_table_name.md
dbdoc/post_comments.md
dbdoc/posts.md
dbdoc/user_options.md
dbdoc/users.md
dbdoc/schema.json
$

D:\go\bin\bin>tbls doc -c tbls.yml output ER diagram files already exists

D:\go\bin\bin>tbls version 1.73.2

D:\go\bin\bin>type tbls.yml dsn: mysql://root:root@127.0.0.1:3306/test

D:\go\bin\bin>tbls doc -c tbls.yml dbdoc\schema.svg dbdoc\class.svg dbdoc\relative.svg dbdoc\students.svg dbdoc\README.md dbdoc\class.md dbdoc\relative.md dbdoc\students.md dbdoc\schema.json

20240218142320

k1LoW commented 4 months ago

@AlilyZ

Yeah, I finally understood what you were asking with your answer!

tbls doc -c tbls.yml -f erd.

In the case of this command, erd is interpreted as a DSN.

Because tbls doc is in the following order when receiving args

tbls doc [DSN] [DOC_PATH]

Pass DSN and DOC_PATH as arguments or set the path in the docPath: section of tbls.yml.

AlilyZ commented 4 months ago

@AlilyZ

Yeah, I finally understood what you were asking with your answer!

tbls doc -c tbls.yml -f erd.

In the case of this command, erd is interpreted as a DSN.

Because tbls doc is in the following order when receiving args

tbls doc [DSN] [DOC_PATH]

Pass DSN and DOC_PATH as arguments or set the path in the docPath: section of tbls.yml.

Thank you very much for helping me solve my doubts.

AlilyZ commented 4 months ago

@AlilyZ

Yeah, I finally understood what you were asking with your answer!

tbls doc -c tbls.yml -f erd.

In the case of this command, erd is interpreted as a DSN.

Because tbls doc is in the following order when receiving args

tbls doc [DSN] [DOC_PATH]

Pass DSN and DOC_PATH as arguments or set the path in the docPath: section of tbls.yml.

Thank you very much for helping me solve my doubts