0.30.0

Add documentation to model schema

v0.29.5

The CLI did not honour the -w flag which drops and recreates the data base schema, so if the -w flag was not used, the schema would still be dropped.

Correct observation of the -w flag enables the user to build the database first, and can create their own data structures, then Crudio can augment the existing structure by adding required tables and generated data.

The only issue is, if the -w flag is not used, and Crudio has already been executed, the second execution will fail due to duplicate keys in the data, but this is now expected behaviour.

enhanced date function

Fixed a bug in historical date calculations (years_ago_xx) and added new functions:

• years_ahead_xx
• months_ahead_xx

These generators assist with creating future dates which can be used for reminders, alerts, expiry dates etc.

null and decimal value handling

A number of recent merges have addressed important bugs, and the purpose of this release is to prompt an update on progress on features and bug fixes in all of the recent changes. A new YouTube series will be provided before Christmas 2022.

• Streams - this is a new feature to facilitate building of structured generated data that can be applied to scenarios like IoT devices.

• 0 values in columns would translate to NULL violating not null constraints on database columns.

• The 'decimal' data type in the Crudio datamodel translates to "double precision" in postgres.

• new preset generators for "years_ago_XX" and "months_ago_XX", e.g. years_ago_5 or months_ago_9, help to create historical data. The point being it is easy to also understand the purpose of the generators without convoluted date math.

• test cases have been improved and somewhat simplified for Hasura/Postgres combination and MongoDB.

Streaming data

In this release we add the ability to create streamed data, i.e. something that looks like it have come from an Internet of Things device, or a health monitor, such as blood pressure or heart rate.

Documentation will follow soon, but a fully functioning example of temperature, humidity and windspeed are included in the demonstration model.

Fix default database target in CLI

The -t option had an invalid default value. This now defaults to p for Postgres.

Fixed fast start and GQL queries

• In this release we have fixed the fast start process, which means you can once again create an entire demo data setup with one click
• Added the ```mermaid tag to the entity relationship diagram so your data model is instantly viewable as a functioning markdown document
• Fixed the GraphQL queries after improving the naming scheme of entities in Hasura

In-memory MongoDB

In this release we demonstrate use of Crudio with in-memory MongoDB.

Perfect for serverless / dockerless unit tests!

MongoDB Loader

In this version we introduce the capability to load data into a MongoDB database thanks to the power of Mongoose.

In one to many relationships, the one end has the object id of the many end. The many end has an empty array, as it is assumed that Population will be used in Mongoose.

Many to Many keys are not yet supported, but will be soon.

v0.11.0 Beta Release Update

Generators can now have string values or JSON values.

JSON values such as { datetime: ... } create a foundation for generators which take JSON arguments, which can be a more complex but structured syntax. For example, when generating data that has a temporal base, such as temperature or light level, which is time of day, dependent, the JSON will facilitate this type of generator specification.

datetime is the only example of usage at the moment.

More complex examples for IoT should appear in the next release.