A Yeoman code generator that inspects your Stored Procedures and generates strongly typed TypeScript code for them. Currently supports only Microsoft SQL Server. You can customize the templates according to your needs. See templates for references.
See the description above :-)
yarn global add yo generator-mssql-types
# or
npm install -g yo generator-mssql-typesYou have 2 options to run the generator.
Have an .env file containing the following:
DB_CONNECTION_STRING=mssql://username:password@localhost/DATABASE_NAMEThen just run:
yo mssql-typesDB_CONNECTION_STRING=mssql://username:password@localhost/DATABASE_NAME yo mssql-typesHere's the --help output:
Usage:
yo mssql-types:app [<templatesDirectory>] [options]
Options:
-h, --help # Print the generator's options and usage
--skip-cache # Do not remember prompt answers Default: false
--skip-install # Do not automatically install dependencies Default: false
--force-install # Fail on install dependencies error Default: false
--ask-answered # Show prompts for already configured options Default: false
Arguments:
templatesDirectory Type: String Required: falseYou can specify an alternative template directory. Example:
yo mssql-types ./my-templates- Discover whether a stored procedure parameter has a default value or not. It's currently not possible without parsing the procedure definition. For more information see https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-parameters-transact-sql?view=sql-server-ver16
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent