Sign inSign up

obpt123/sql-translate

By obpt123

•Updated over 4 years ago

a tools for convert sql statement

Image
0

1.0K

obpt123/sql-translate repository overview

⁠Sql.Translate

sql.translate is a docker tools for translate sql from one to another, it's a docker wrapper for the org.jooq.

You can see more details usage in Jooq⁠.

⁠How to use
  • Convert To mysql
docker run obpt123/sql-translate -T mysql -s "select top 1 name, newid() as randomId from [dbo].[table1]"

the result for the mysql will be:

select name, uuid() as randomid from `dbo`.`table1` limit 1;
  • Convert to postgres
docker run obpt123/sql-translate:0.0.1 -T postgres -s "select top 1 name, newid() as randomId from [dbo].[table1]"

the result for the postgres will be:

select name, gen_random_uuid() as randomid from "dbo"."table1" fetch next 1 rows only;

Tag summary

Content type

Image

Digest

Size

121.1 MB

Last updated

over 4 years ago

docker pull obpt123/sql-translate