{"action":"opened","issue":{"url":"https://api.github.com/repos/qcode-software/qcode-tcl/issues/340","repository_url":"https://api.github.com/repos/qcode-software/qcode-tcl","labels_url":"https://api.github.com/repos/qcode-software/qcode-tcl/issues/340/labels{/name}","comments_url":"https://api.github.com/repos/qcode-software/qcode-tcl/issues/340/comments","events_url":"https://api.github.com/repos/qcode-software/qcode-tcl/issues/340/events","html_url":"https://github.com/qcode-software/qcode-tcl/issues/340","id":136121167,"number":340,"title":"Add DB introspection procedures to check unique constraints/indexes","user":{"login":"nicky-johnstone","id":8330836,"avatar_url":"https://avatars.githubusercontent.com/u/8330836?v=3","gravatar_id":"","url":"https://api.github.com/users/nicky-johnstone","html_url":"https://github.com/nicky-johnstone","followers_url":"https://api.github.com/users/nicky-johnstone/followers","following_url":"https://api.github.com/users/nicky-johnstone/following{/other_user}","gists_url":"https://api.github.com/users/nicky-johnstone/gists{/gist_id}","starred_url":"https://api.github.com/users/nicky-johnstone/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nicky-johnstone/subscriptions","organizations_url":"https://api.github.com/users/nicky-johnstone/orgs","repos_url":"https://api.github.com/users/nicky-johnstone/repos","events_url":"https://api.github.com/users/nicky-johnstone/events{/privacy}","received_events_url":"https://api.github.com/users/nicky-johnstone/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/qcode-software/qcode-tcl/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-02-24T16:58:29Z","updated_at":"2016-02-24T16:58:29Z","closed_at":null,"body":"At the moment we have DB introspection for checking types, domains, enums, and check constraints however we don't have any introspection for unique constraints and indexes.\r\n\r\nAdding introspection for unique constraints and indexes will help reduce manual validation code required as `qc::validate2model` could then be updated to check unique constraints and indexes.\r\n\r\n**Acceptance Criteria:** DB introspection procedures have been added to get and evaluate unique constraints and indexes. `qc::validate2model` has been updated to use the new introspection procedures."}}