/Transformalize.Provider.MySql

a mysql provider for transformalize

Primary LanguageC#MIT LicenseMIT

Overview

This is a MySql provider for Transformalize using MySqlConnector for .NET(https://mysqlconnector.net). This plug-in ships with the Transformalize CLI.

Write Usage

<add name='TestProcess' mode='init'>
  <connections>
    <add name='input' provider='bogus' seed='1' />
    <add name='output' provider='mysql' database='junk' user='*' password='*' />
  </connections>
  <entities>
    <add name='Contact' size='1000'>
      <fields>
        <add name='Identity' type='int' primary-key='true' />
        <add name='FirstName' />
        <add name='LastName' />
        <add name='Stars' type='byte' min='1' max='5' />
        <add name='Reviewers' type='int' min='0' max='500' />
      </fields>
    </add>
  </entities>
</add>

This writes 1000 rows of bogus data to a MySql / MariaDb database.

Read Usage

<add name='TestProcess' >
  <connections>
    <add name='input' provider='mysql' database='junk' user='*' password='*' />
  </connections>
  <entities>
    <add name='Contact' page='1' size='10'>
      <order>
        <add field='Identity' />
      </order>
      <fields>
        <add name='Identity' type='int' />
        <add name='FirstName' />
        <add name='LastName' />
        <add name='Stars' type='byte' />
        <add name='Reviewers' type='int' />
      </fields>
    </add>
  </entities>
</add>

This reads 10 rows of bogus data from a MySql database:

Identity,FirstName,LastName,Stars,Reviewers
1,Justin,Konopelski,3,153
2,Eula,Schinner,2,41
3,Tanya,Shanahan,4,412
4,Emilio,Hand,4,469
5,Rachel,Abshire,3,341
6,Doyle,Beatty,4,458
7,Delbert,Durgan,2,174
8,Harold,Blanda,4,125
9,Willie,Heaney,5,342
10,Sophie,Hand,2,176

Notes

  • Tested with MariaDb 10.2
  • You have to provider user and password