0.18.0 - The one with limit

[justinvdm]

Character limit improvements

Before this release, the initial transform.ts config that snaplet generates for you would make use of copycat.scramble() to transform the string if the relevant column had a character limit (e.g. varchar(50)).

In this release, we now make use of copycat's new limit option when the relevant copycat API method supports the limit option. We are still adding the limit option to the rest of copycat's API, for cases where limit isn't available yet we still make use of scramble()

Subsetting improvements

Our subsetting feature now lets you to specify additional foreign keys that should be used when subsetting. This also gives you a way to tell Snaplet to also include related tables with nullable foreign keys (these are by default not included in the resulting subset).

For example, if you had a table users and a related table staff, then you could ensure that the staff table gets included with a config like this:

{
  "enabled": true,
  "initial_targets": [
    {
      "table": "public.users",
      "row_limit": 10
    }
  ],
  "keep_disconnected_tables": true,
  "foreign_keys":
  [
    {
      "table": "public.staff",
      "column": "user_id",
      "targetTable": "public.users",
      "targetColumn": "staff_id"
    }
  ]
}

Bug fixes

• The structure.ts file we generate (which includes the typescript types for transform.ts) did not generate valid typescript if for cases where there were tables or columns that did not start with a letter (for example, table names that start with numbers)