This adds vin related transforms to Transformalize using Vin. It is a plug-in compatible with Transformalize 0.3.3-beta.
Build the Autofac project and put it's output into Transformalize's plugins folder.
<add name='TestProcess' read-only='false'>
<entities>
<add name='TestData'>
<rows>
<add vin='11111111111111111' />
<add vin='2LMDJ6JK0FBL33226' />
<add vin='JM1BK323071624570' />
</rows>
<fields>
<add name='vin' primary-key='true' />
</fields>
<calculated-fields>
<add name='valid' type='bool' t='copy(vin).vinisvalid()' />
<add name='year' type='short' t='copy(vin).vingetmodelyear()' />
<add name='make' t='copy(vin).vingetworldmanufacturer()' />
</calculated-fields>
</add>
</entities>
</add>This produces:
vin,valid,year,make 11111111111111111,true,2001, 2LMDJ6JK0FBL33226,true,2015,Lincoln JM1BK323071624570,false,2007,Mazda
BenchmarkDotNet=v0.10.12, OS=Windows 10 Redstone 3 [1709, Fall Creators Update] (10.0.16299.125)
Intel Core i7-7700HQ CPU 2.80GHz (Kaby Lake), 1 CPU, 8 logical cores and 4 physical cores
Frequency=2742188 Hz, Resolution=364.6723 ns, Timer=TSC
[Host] : .NET Framework 4.6.2 (CLR 4.0.30319.42000), 32bit LegacyJIT-v4.7.2600.0
LegacyJitX64 : .NET Framework 4.6.2 (CLR 4.0.30319.42000), 64bit LegacyJIT/clrjit-v4.7.2600.0;compatjit-v4.7.2600.0
LegacyJitX86 : .NET Framework 4.6.2 (CLR 4.0.30319.42000), 32bit LegacyJIT-v4.7.2600.0
Jit=LegacyJit Runtime=Clr | Method | Job | Platform | Mean | Error | StdDev | Scaled | ScaledSD |
|---|---|---|---|---|---|---|---|
| '3 test rows' | LegacyJitX64 | X64 | 1.572 ms | 0.0146 ms | 0.0136 ms | 1.00 | 0.00 |
| '3 rows using transforms' | LegacyJitX64 | X64 | 2.125 ms | 0.0334 ms | 0.0313 ms | 1.35 | 0.02 |
| '3 test rows' | LegacyJitX86 | X86 | 1.488 ms | 0.0153 ms | 0.0144 ms | 1.00 | 0.00 |
| '3 rows using transforms' | LegacyJitX86 | X86 | 1.983 ms | 0.0231 ms | 0.0216 ms | 1.33 | 0.02 |