Skip to content

Support compound primary keys #26

New issue
New issue
Closed
#27
Closed
Support compound primary keys#26
#27
Labels
enhancementNew feature or request
@simonw

Description

@simonw
simonw
opened on Jul 27, 2020

These are deliberately not supported here:

db-to-sqlite/db_to_sqlite/cli.py

Lines 71 to 78 in 045cbee

pks = inspector.get_pk_constraint(table)["constrained_columns"]
if len(pks) > 1:
raise click.ClickException(
"Multiple primary keys not currently supported"
)
pk = None
if pks:
pk = pks[0]

I think that's because sqlite-utils didn't support them - but it gained support for them in 1.5: https://sqlite-utils.readthedocs.io/en/stable/changelog.html#v1-5

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions