SmartCode

What's Changed

• 添加并行构建功能，添加依赖任务配置 by @XiaoHeitu in https://github.com/dotnetcore/SmartCode/pull/66

Full Changelog: https://github.com/dotnetcore/SmartCode/compare/v2.3.7...v2.4.0-preview.0

What's Changed

• Unable to read comments for table by @xiangxiren in https://github.com/dotnetcore/SmartCode/pull/52
• 修改oracle语法 。 by @gmij in https://github.com/dotnetcore/SmartCode/pull/57
• 修复Oracle模板中的其它Bug by @gmij in https://github.com/dotnetcore/SmartCode/pull/58
• 移除Input重定向，解决win7下PowerShell 无法Exit 的问题。 by @XiaoHeitu in https://github.com/dotnetcore/SmartCode/pull/59
• Fix 不一至的行尾 by @XiaoHeitu in https://github.com/dotnetcore/SmartCode/pull/65

New Contributors

• @xiangxiren made their first contribution in https://github.com/dotnetcore/SmartCode/pull/52
• @gmij made their first contribution in https://github.com/dotnetcore/SmartCode/pull/57

Full Changelog: https://github.com/dotnetcore/SmartCode/compare/v2.2.85...v2.3.7

1. optimize Java-SpringBoot-MyBatis template
2. Optimize table field sorting for MySql-Gen
3. fix etl template errors, add geometry and geography mapping. ->> thx @beginor

1. add mediumint to DbTypeMap
2. update SmartSql version for support PropertyChangedTrack
3. add ITableSource for Gen
4. update SmartSql version for support new features (https://github.com/dotnetcore/SmartSql/releases)
5. add CryptoTypeHandler
6. 修复 ORACLE 数据库查询列IsNullable属性反了的问题 ,thx @XiaoHeitu
7. optimize Output
8. add support Java-SpringBoot-MyBatis template

1. add db to TypeScript map (thx @beginor )
2. add basic TypeScript template (thx @beginor )
3. add ToSingular and ToPlural method. (thx @beginor )
4. optimize GetEntity template params
5. refactor ConfigBuilder
6. fix #37

1. fix #29
2. add support global default NamingConverter
3. fix #30

# Please install dotnet-format first!
# dotnet tool install -g dotnet-format
  CodeFormat:
    Type: Process
    Parameters:
      FileName: powershell
      WorkingDirectory: '{{Project.Output.Path}}'
      Args: dotnet-format

4. add support global default TableFilter -> fix #32

TableFilter:
  IgnoreNoPKTable: true
  IgnoreView: true

• add NoneTokenizer

1. add Mysql DB-Type-Map
2. update to SmartSql-v4
3. add git-ignore template
4. fix ETL load Json bug
5. add 'double'&'mediumtext' TypeMap for MySql=>CSharp
6. add ExtractDictionaryDataSource
7. fix ProjectBuilder bug
8. add support pull git template
9. add support Absolute Path Template
10. fix PKColumn.Name not equal to "Id" bug. Ref #28

1. add support Docker
   

  BuildDocker:
    Type: Process
    Parameters: 
      FileName: powershell
      WorkingDirectory: '{{Project.Output.Path}}'
      Args: docker build -t {{Project.Parameters.DockerImage}}:v1.0.0 .

  RunDocker:
    Type: Process
    Parameters: 
      FileName: powershell
      WorkingDirectory: '{{Project.Output.Path}}'
      Args: docker run --name {{Project.Parameters.DockerImage}} --rm -d -p 8008:80 {{Project.Parameters.DockerImage}}:v1.0.0 .

1. refactor ProcessBuildTask

  Publish:
    Type: Process
    Parameters: 
      FileName: powershell
      WorkingDirectory: '{{Project.Output.Path}}'
      Args: dotnet publish -c Release -o '{{Project.Output.Path}}\publish'

  Run:
    Type: Process
    Parameters: 
      FileName: powershell
      WorkingDirectory: '{{Project.Output.Path}}\publish'
      CreateNoWindow: false
      RedirectStandardOutput: false
      RedirectStandardError: false
      WaitForExit: false
      WriteLines: ['dotnet {{Project.Module}}.API.dll']

  RunChrome:
    Type: Process
    Parameters: 
      FileName: C:\Program Files (x86)\Google\Chrome\Application\chrome.exe
      CreateNoWindow: false
      Args: http://localhost:5000/swagger

2. change word Paramters -> Parameters (Broken change)
3. change sln directory structure
4. update Template to SmartSql-v4

• add SmartCode.ETL.LoadToES
• add SmartCode.ETL.LoadToES support ES_ID_Mapping
• fix CamelCaseConverter not work ,Thx https://github.com/Smart-Kit/SmartCode/pull/23

1. optimize SmartCode.ETL.LoadTask by using DbSession
2. optimize the template directory structure
3. optimize IETLRepository -> IETLTaskRepository
4. add Java-Template
5. add SmartCode-Spring-Boot.yml
6. update SqlMap-Partials template
7. add SmartCode.ETL.LoadToES(ElasticSearch)
8. update dependent lib version

1. add support SmartCode.ETL.SQLite （ETL任务持久层新增支持SQLite，免去DB服务端安装！）

ETLRepository: SQLite

1. support for SqlServer paging syntax By [Offset Fetch]
2. fix #19
3. fix #16
4. add ETL-DOC

• https://github.com/Ahoo-Wang/SmartCode/blob/master/doc/SmartCode.ETL.md
• https://github.com/Ahoo-Wang/SmartCode/blob/master/doc/SmartCode.ETL-EN.md

1. add support ETLExtract.MaxModifyTime
2. add support Generator.Oracle ,thx https://github.com/Ahoo-Wang/SmartCode/pull/15
3. fix SqlServer.IsPrimaryKey bug

1. fix Ignore system tables by is_ms_shipped
2. add SqlServerToPGBuild
3. add SqlServer to PostgreSql DataTypeMap
4. add DelimiterConverter
5. add SmartCode.ETL.PostgreSql
6. SmartCode-Gen-ETL

## SqlServer 迁移到 PG 构建配置生成器模板
Module: SqlServer2PG
Author: Ahoo Wang
DataSource:
  Name: DbTable
  Paramters:
    DbName: SqlServerDB
    DbProvider: SqlServer
    ConnectionString: Data Source=localhost;database=SqlServerDB;uid=SmartSql;pwd=SmartSql
Language: PostgreSql
TemplateEngine: Razor
Paramters:
  ExtractMode: QueryTime
  ModifyTime: ModifyTime
  ExtractConnectionString: Data Source=localhost;database=SqlServerDB;uid=SmartSql;pwd=SmartSql
  LoadDbProvider: PostgreSql
  LoadConnectionString: Server=localhost;Port=5432;User Id=report;Password=SmartSql;
Output: 
  Type: File
  Path: 'E:\ETL\SmartCode.ETL.Starter'

# 构建任务
Build:

  ClearDir:
    Type: Clear
    Paramters:
      Dirs: '.'
# 生成迁移SQL
  DbToPGSql:
    Type: Single
    Module: SmartCode
    Template: Sql/DbToPGSql.cshtml
    Output: 
      Path: '.'
      Name: 'Sql'
      Extension: '.sql'
    NamingConverter:
      Table:
        Tokenizer: 
          Type: Default
          Paramters: 
            IgnorePrefix: 'T_'
            Delimiter: '_'
            UppercaseSplit: true
        Converter:
          Type: Delimiter
          Paramters: 
            Delimiter: '_'
            Mode: AllLower
            Prefix: t_

      Column:
        Tokenizer: 
          Type: Default
          Paramters: 
            Delimiter: '_'
            UppercaseSplit: true
        Converter:
          Type: Delimiter
          Paramters: 
            Delimiter: '_'
            Mode: AllLower
# 生成 SmartCode.ETL 数据迁移构建配置
  ToPGBuild:
    Type: Table
    Module: SmartCode
    Template: ETL/ToPGBuild.cshtml
    Output: 
      Path: '.'
      Name: '{{Items.CurrentTable.Name}}'
      Extension: '.yml'
    NamingConverter:
      Table:
        Tokenizer: 
          Type: Default
          Paramters: 
            IgnorePrefix: 'T_'
            Delimiter: '_'
            UppercaseSplit: true
        Converter:
          Type: Delimiter
          Paramters: 
            Delimiter: '_'
            Mode: AllLower
            Prefix: t_
      Column:
        Tokenizer: 
          Type: Default
          Paramters: 
            Delimiter: '_'
            UppercaseSplit: true
        Converter:
          Type: Delimiter
          Paramters: 
            Delimiter: '_'
            Mode: AllLower

1. add SmartCode.ETL
2. add SmartCode.ETL.PostgreSql

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: 
      

1. add ProcessBuildTask
2. support SQLite
3. fix 中文表名输出文件名乱码
4. add Output.Mode:Incre/Full,default Incre
5. u SmartSql version to templates
6. optimize log output

1. add 仅需配置好数据链接，直接构建整个解决方案，运行API项目进行Swagger调试！！！

1. add just needs to configure the ConnectionString, directly build the whole solution, run the API project for Swagger debugging!!!

1. remove RazorLight TemplateEngine !!!