0.2.0 Demo Dataset Testing

[zackkrida]

Moved to an issue: #4164

[zackkrida]

Bike Shop 🚲

[zackkrida]

Unable to delete rows from

Bike Shop -> Equipment:

Unable to delete row. ForeignKeyViolation: update or delete on table "Equipment" violates foreign key constraint "Service Requests_equipment_id_fkey" on table "Service Requests" DETAIL: Key (id)=(3) is still referenced from table "Service Requests". CONTEXT: SQL statement " WITH delete_cte AS (DELETE FROM "Bike Shop"."Equipment" WHERE (msar.format_data(id))::text IN (SELECT jsonb_array_elements_text('["3"]')) RETURNING *) SELECT count(1) FROM delete_cte " PL/pgSQL function msar.delete_records_from_table(oid,jsonb) line 13 at EXECUTE

Bike Shop -> Service Request:

Unable to delete row. ForeignKeyViolation: update or delete on table "Service Requests" violates foreign key constraint "Service Milestones_service_request_id_fkey" on table "Service Milestones" DETAIL: Key (id)=(8) is still referenced from table "Service Milestones". CONTEXT: SQL statement " WITH delete_cte AS (DELETE FROM "Bike Shop"."Service Requests" WHERE (msar.format_data(id))::text IN (SELECT jsonb_array_elements_text('["8"]')) RETURNING *) SELECT count(1) FROM delete_cte " PL/pgSQL function msar.delete_records_from_table(oid,jsonb) line 13 at EXECUTE