SmartCode（https://github.com/Ahoo-Wang/SmartCode）

SmartCode = IDataSource -> IBuildTask -> IOutput => Build Everything

Introduction

SmartCode.Generator (代码生成器)

Demo

Getting Started

1. Install from .NET Core Global Tool

dotnet tool install --global SmartCode.CLI

1. 编辑构建配置文件（默认：SmartCode.yml）
2. 命令行执行SmartCode命令
   • SmartCode
   • 等待提示输入配置文件路径（可选：默认程序根目录下SmartCode.yml文件）
   • 回车执行命令
3. 等待任务执行结束
4. 查看输出目录结果

构建配置文件

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

DataSource 数据源，Name:Db

属性 Name:Db,使用DbSource插件作为数据源

DbSource.Paramters 接受以下三个参数：

Build 任务构建

NamingConverter 命名转换

NamingConverter.Tokenizer 分词器

如何贡献模板

为了让更多人参与到SmartCode模板建设中来，故有以下模板规范：

1. 模板作者在 src/SmartCode.Generator/RazorTemplates 中新建目录，并以作者英文名为目录名称
2. 把模板放置到作者目录
3. 作者目录下必须包括 README.md 文件，以说明模板的用途场景以及使用方式
4. 提交PR

SmartCode.ETL(Extract-Transform-Load)

ETL 构建配置

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: