[PROPOSAL] lino constraint disable

[adrienaury]

Problem

As a user of lino command, I want to disable foreign key constraints on a given table or ingress-descriptor, without re-enabling immediately. I want to be able to enable disabled contraints later.

Solution

The new command lino constraint will handle listing/enabling/disabling of foreign key contraints.

List constraints on foreign key pointing to <table_name>

$ lino constraints list --table <table_name>
{"table": "ACTION", "constraint_name": "FK_ACTION_01"}

List constraints on foreign key pointing to any table in the ingress-descriptor

$ lino constraints list --i <ingress-descriptor-name>
{"table": "ACTION", "constraint_name": "FK_ACTION_01"}

• constraints are listed in the order they need to be enabled

List and disable constraints on foreign key pointing to <table_name>

$ lino constraints disable --table <table_name> > constraints.jsonl
1 constraint disabled

List and disable constraints on foreign key pointing to any table in the ingress-descriptor

$ lino constraints disable -i <ingress-descriptor-name> > constraints.jsonl
1 constraint disabled

Enable constraints previously disabled

$ lino constraints enable < constraints.jsonl
1 constraint enabled

[adrienaury]

• List and disable constraints on foreign key pointing to <table_name>
• Enable constraints previously disabled