Works only with Postgres. It reads pg connection options from enviroment variables
Usage:
PGPASSWORD=1 PGUSER=1 PGDATABASE=1 PGHOST=1.1.1.1 PGPORT=5432 npx types-from-sql 'select * from table'
-f specify glob instead of query, -fn to set interface name to filename:
PGPASSWORD=1 PGUSER=1 PGDATABASE=1 PGHOST=1.1.1.1 PGPORT=5432 npx types-from-sql -f ./test/*.sql
also interface name can be set with directive @InterfaceName in comment on top of sql:
-- @InterfaceName: INotification
select * from table
redirect output to interface file with > operator:
PGPASSWORD=1 PGUSER=1 PGDATABASE=1 PGHOST=1.1.1.1 PGPORT=5432 npx types-from-sql -fn ./test/*.sql
See also sql builder with typecheck: https://github.com/xialvjun/ts-sql-plugin#readme