alan-turing-institute / alan-turing-institute/sqlsynthgen

Handle primary keys that aren't auto-populated

Open
#38 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
12
Forks
4
PR merge metrics
No merged PRs in 30d

Description

We currently presume that PKs can be ignored and will be auto-populated by the DB. Although this often works, there are plenty of cases (see, for example, the OMOP domain.domain_id column, which is a VARCHAR) where we need to specify one.

We may need to inspect each PK column to work out whether it will be auto populated and, if not, choose a *unique* random value for it.

Contributor guide

Open the contributing guide

Research direction

Start by tracing how primary-key columns are currently handled during synthetic data generation. Use the OMOP domain.domain_id VARCHAR example to examine the distinction between auto-populated and explicitly required keys. Done means non-auto-populated primary keys receive unique values while keys populated by the database continue to work.

Written by the indexing model from the issue text.

Assessment

Tech stack
python, sql
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.