SmartCode.CLI 2.0.2

There is a newer version of this package available.
See the version list below for details.
dotnet tool install --global SmartCode.CLI --version 2.0.2
This package contains a .NET tool you can call from the shell/command line.
dotnet new tool-manifest # if you are setting up this repo
dotnet tool install --local SmartCode.CLI --version 2.0.2
This package contains a .NET tool you can call from the shell/command line.
#tool dotnet:?package=SmartCode.CLI&version=2.0.2
nuke :add-package SmartCode.CLI --version 2.0.2

SmartCode

SmartCode = IDataSource → IBuildTask → IOutput ⇒ Build Everything

Introduction

SmartCode

SmartCode.Db (Code generator)

Demo

SmartCode

Getting Started

  1. Install from .NET Core Global Tool
dotnet tool install --global SmartCode.CLI
  1. edit build configuration file (default: SmartCode.yml)
  2. the command line executes the SmartCode command.
    • SmartCode
    • wait for prompt to enter the configuration file path (optional: SmartCode.yml file in the default program root directory)
    • carriage return execution command
  3. wait for the end of the task execution.
  4. View output directory results

Building configuration files

Module: SmartSql.Starter
Author: Ahoo Wang
DataSource:
  Name: Db
  Paramters:
    DbName: SmartSqlStarterDB
    DbProvider: SqlServer
    ConnectionString: Data Source=.;Initial Catalog=SmartSqlStarterDB;Integrated Security=True
Language: CSharp
TemplateEngine: Razor 
Output: 
  Type: File
  Path: 'E://SmartSql-Starter'

Build:
  ClearDir:
    Type: Clear
    Paramters:
      Dirs: '.'
  Solution:
    Type: Project
    Template: Sln.cshtml
    Output:
      Path: '.'
      Name: '{{Project.Module}}'
      Extension: '.sln'
  SmartSqlConfig:
    Type: Project
    Template: SqlMapConfig.cshtml
    Output:
      Path: '{{Project.Module}}.API'
      Name: 'SmartSqlMapConfig'
      Extension: '.xml'
  Entity_Project:
    Type: Project
    Template: Proj.cshtml
    Output:
      Path: '{{Project.Module}}.Entity'
      Name: '{{Project.Module}}.Entity'
      Extension: '.csproj'
  Entity:
    Type: Table
    Module: Entity
    Template: Entity.cshtml
    Output:
      Path: '{{Project.Module}}.{{Build.Module}}'
      Extension: '.cs'
    NamingConverter:
      Table:
        Tokenizer:
          Type: Default
          Paramters:
            IgnorePrefix: 'T_'
            Delimiter: '_'
        Converter:
          Type: Default
          Paramters: { }
      View:
        Tokenizer:
          Type: Default
          Paramters:
            IgnorePrefix: 'V_'
            Delimiter: '_'
        Converter:
          Type: Pascal
      Column:
        Tokenizer:
          Type: Default
          Paramters: 
            Delimiter: '_'
        Converter:
          Type: Pascal
  Repository_Project:
    Type: Project
    Template: Proj-Repository.cshtml
    Output:
      Path: '{{Project.Module}}.Repository'
      Name: '{{Project.Module}}.Repository'
      Extension: '.csproj'
  Repository:
    Type: Table
    Module: Repository
    Template: Repository.cshtml
    Output:
      Path: '{{Project.Module}}.{{Build.Module}}'
      Name: 'I{{OutputName}}Repository'
      Extension: .cs
    NamingConverter:
      Table:
        Tokenizer:
          Type: Default
          Paramters:
            IgnorePrefix: 'T_'
            Delimiter: '_'
        Converter:
          Type: Default
      View:
        Tokenizer:
          Type: Default
          Paramters: 
            IgnorePrefix: 'V_'
            Delimiter: '_'
        Converter:
          Type: Default

  SqlMap:
    Type: Table
    Template: SqlMap-SqlServer.cshtml
    Output:
      Path: '{{Project.Module}}.API/Maps'
      Extension: .xml
    IgnoreTables: null
    NamingConverter:
      Table:
        Tokenizer:
          Type: Default
          Paramters: 
            IgnorePrefix: 'T_'
            Delimiter: '_'
        Converter:
          Type: Default
      View:
        Tokenizer:
          Type: Default
          Paramters: 
            IgnorePrefix: 'V_'
            Delimiter: '_'
        Converter:
          Type: Default
      Column:
        Tokenizer:
          Type: Default
          Paramters: 
            IgnorePrefix: 'T_'
            Delimiter: '_'
        Converter:
          Type: Default
Parameter Name Description
Module Root Module Name
Author Author
DataSource Data Source
Language Language: CSharp/Java/....
TemplateEngine Template Engine: Currently Built: Razor/Handlebars
Output Output
Build Task Build
DataSource Data Source, Name: Db

Property Name: Db, using the DbSource plugin as a data source

DbSource.Paramters accepts the following three parameters:

Parameter Name Description
DbName Database Name
DbProvider Data Drivers: MySql, MariaDB, PostgreSql, SqlServer, Oracle, SQLite
ConnectionString Connection String
Build Task Build
Parameter Name Description
Type Build type, Clear: used to clean up the directory s / file s, Project: used to build a single file, such as: solution file / project file, Table: used to build a data table-based file, such as: Entity , Repository file
Module Building Module Name
TemplateEngine Template Engine, optional, default to root module engine
Template Template File
Output Output
IncludeTables Include table name s
IgnoreTables Ignore table name s
NamingConverter Named Converter
Paramters Custom Build Parameters
NamingConverter Name Conversion
Attribute Description
Type Table/View/Column
Tokenizer Word Segmenter
Converter Converter: Camel/Pascal/None
NamingConverter.Tokenizer Word Segmenter
Attribute Description
Type Default
Paramters.IgnorePrefix Ignore prefix characters
Paramters.Delimiter Separator

How to contribute a template

In order to allow more people to participate in the construction of SmartCode templates, there are the following template specifications:

  1. The template author creates a new directory in src/SmartCode.Generator/RazorTemplates and names it in the author's English name.
  2. Place the template in the author directory
  3. The README.md file must be included in the author directory to illustrate the purpose of the template and how it is used.
  4. Submit PR

SmartCode.ETL(Extract-Transform-Load)

ETL Building configuration files

Author: Ahoo Wang
DataSource:
  Name: Extract
  Paramters:
    DbProvider: SqlServer
    ConnectionString: Data Source=.;Initial Catalog=SmartSqlDB;Integrated Security=True
    Query: SELECT [Id],[UserName],[Pwd],[Status],[LastLoginTime],[CreationTime],[Deleted] FROM [T_User] Where Id>@LastMaxId And CreationTime>@LastQueryTime
    PKColumn: Id

Paramters:
  ETLCode: SmartCode.ETL.Test
  ETLRepository: PG
  
Build:

  Transform:
    Type: Transform
    Paramters:
      Script: Load2PostgreSql.cshtml

  Load2PostgreSql: 
    Type: Load
    Paramters:
      DbProvider: PostgreSql
      ConnectionString: Server=localhost;Port=5432;User Id=postgres;Password=SmartSql; Database=smartsql_db;
      Table: t_user
      ColumnMapping: [{Column: UserName,Mapping: user_name}
      ,{Column: Pwd,Mapping: pwd}
      ,{Column: Status,Mapping: status}
      ,{Column: LastLoginTime,Mapping: lastlogintime}
      ,{Column: CreationTime,Mapping: creationtime}
      ,{Column: Deleted,Mapping: deleted}]
      PreCommand: 
      PostCommand: 
Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
.NET Core netcoreapp2.1 is compatible.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

Version Downloads Last updated
3.0.1 2,092 6/16/2022
3.0.0 1,568 3/3/2022
2.4.0-preview.1 134 6/15/2022
2.4.0-preview.0 156 5/7/2022
2.3.7 1,541 3/3/2022
2.3.6 2,264 6/10/2020
2.3.5 1,691 4/29/2020
2.3.4 1,691 3/27/2020
2.3.3 1,381 3/27/2020
2.3.2 1,573 3/11/2020
2.3.1 1,696 3/11/2020
2.3.0 1,586 3/11/2020
2.2.95 1,609 2/17/2020
2.2.94 1,462 2/14/2020
2.2.93 1,569 2/14/2020
2.2.92 1,609 11/18/2019
2.2.90 1,669 11/12/2019
2.2.88 1,718 10/30/2019
2.2.86 1,527 10/23/2019
2.2.85 1,628 10/22/2019
2.2.84 1,459 10/22/2019
2.2.83 1,701 10/22/2019
2.2.82 1,607 10/21/2019
2.2.81 1,511 10/21/2019
2.2.80 1,363 10/21/2019
2.2.70 1,675 8/21/2019
2.2.68 1,664 8/5/2019
2.2.66 1,601 7/29/2019
2.2.65 1,644 7/22/2019
2.2.62 1,483 7/19/2019
2.2.60 1,763 7/19/2019
2.2.58 1,721 7/10/2019
2.2.57 1,722 7/8/2019
2.2.56 1,523 6/28/2019
2.2.55 1,640 6/11/2019
2.2.53 1,640 6/10/2019
2.2.52 1,759 6/4/2019
2.2.50 1,630 6/3/2019
2.2.48 1,658 5/23/2019
2.2.46 1,546 5/23/2019
2.2.45 2,511 5/7/2019
2.2.44 1,729 5/6/2019
2.2.42 1,964 4/30/2019
2.2.40 1,776 4/30/2019
2.2.38 1,936 4/30/2019
2.2.36 1,439 4/29/2019
2.2.30 1,634 4/26/2019
2.2.25 1,717 4/26/2019
2.2.22 1,583 4/25/2019
2.2.20 1,648 4/24/2019
2.2.10 1,685 4/23/2019
2.2.8 1,680 4/23/2019
2.2.2 1,703 4/18/2019
2.2.0 1,423 4/16/2019
2.1.10 1,426 4/16/2019
2.1.9 1,735 4/11/2019
2.1.8 1,552 4/10/2019
2.1.6 1,395 4/10/2019
2.1.5 1,874 4/1/2019
2.1.3 1,599 3/29/2019
2.1.2 1,446 3/25/2019
2.1.1 1,704 3/22/2019
2.1.0 1,639 3/22/2019
2.0.5 1,794 2/27/2019
2.0.4 1,970 12/17/2018
2.0.2 1,786 12/14/2018
2.0.0 102,478 12/14/2018
1.18.2 114,743 11/22/2018
1.18.1 15,100 11/16/2018
1.16.20 12,352 11/16/2018
1.16.19 12,007 11/16/2018
1.16.18 6,524 11/14/2018
1.16.16 3,262 11/7/2018
1.16.15 1,847 11/4/2018
1.16.13 8,655 11/4/2018
1.16.12 3,880 11/1/2018
1.16.6 10,095 10/31/2018
1.16.2 10,697 10/31/2018
1.16.1 46,266 10/31/2018
1.16.0 1,883 10/30/2018
1.12.0 1,766 10/30/2018
1.9.0 2,017 10/27/2018
1.8.1 2,434 10/26/2018
1.8.0 2,556 10/25/2018
1.7.6 2,848 10/24/2018
1.7.5 2,755 10/24/2018
1.7.2 3,026 10/22/2018
1.7.1 2,522 10/21/2018
1.6.9 2,000 10/20/2018
1.6.8.1 2,507 10/20/2018
1.6.8 2,728 10/20/2018
1.6.2 1,917 10/19/2018
1.5.0 1,997 10/18/2018
1.4.6 2,019 10/18/2018
1.3.9 2,052 10/17/2018
1.3.8 2,121 10/17/2018
1.3.6 1,897 10/15/2018
1.3.4 2,200 10/11/2018
1.3.0 1,868 10/9/2018
1.2.0 1,846 10/8/2018
1.1.0 2,210 10/7/2018
1.0.0 2,028 10/7/2018

add SmartCode.ETL.LoadToES