FakeDataEngine

Sometimes working with database, you need to continuously insert records in a table, e.g testing a CDC implementation, with near real data. FakeDataEngine tries to solves that problem. FakeDataEngine is inspired in voluble.

• Entirely developed using Net Core 3.1
• FakeDataEngine uses Bogus to generate fake data.
• Sql Serve and Oracle supported until now (Ask for a new one).

Running with Docker

Images are hosted at Docker Hub.

Launch container:

docker run -it --rm \
    -v ./config.yml:/opt/config.yml \
    fglaeser/fakedataengine:0.2
    

By default fakedataengine will load the config.yml from /opt/config.yml. You could set a different path with the FAKER_CONFIG_PATH environment variable.

docker run -it --rm \
    -e FAKER_CONFIG_PATH=/other_path/config.yml \
    -v ./config.yml:/other_path/config.yml \
    fglaeser/fakedataengine:0.2
    

or using a docker-compose.yml file to launch the container:

services:
  faker:
    image: fglaeser/fakedataengine:0.2
    environment:
      FAKER_CONFIG_PATH: /opt/config.yml
    volumes:
      - ./config.yml:/opt/config.yml

Then:

docker-compose up

Configuration

Let's check a config.yml, you could realize that the configuration is pretty straightforward:

connection.string: "Data Source=mssql;Initial Catalog=DemoDB;Persist Security Info=True;User ID=sa;Password=passw0rd!;"
database.provider: sqlserver # oracle
throttle.ms: 5000
tables:
  - name: Employee
    schema: dbo
    columns:
    - name: ID
      value: "{{randomizer.number(1,1000)}}"
    - name: Name
      value: "{{name.firstname(Male)}}"
    - name: Salary
      value: "{{randomizer.number(1,1000)}}"
    - name: office
      format: array
      items:
       - "ONE"
       - "TWO"
       - "ALL"
    - name: payload
      format: json
      object:
        id: "{{randomizer.number(1,1000)}}"
        name: "{{name.firstname(Female)}}"
        mode: 1

You can configure your database with the connection.string property, the database provider with database.provider (sqlserver and oracle for now) and how fast the data is generated with throttle.ms.

Tables

To configure tables you need to set the following properties:

• name: Table name.
• schema: Table schema.
• columns: Array of columns you want to include in the insert statement.

Columns

To configure a column you need to set the following properties:

• name: Column name.
• format: Default value is raw, but you can also set this value to json in order to fill the column with a valid json string or array to choose between a list of values.
• value: Here you can use a fix value or a Bogus handlebar
• object: If your column format is json, use this to define the properties of your json object.
• items: If your column format is array, use this to define an array of values. The generator will randomly pick one for each insert.

In the previous example, the column payload will be fill with a json string like the following:

{"id": "890", "name": "Anna", "mode": 1 }