{"action":"created","issue":{"url":"https://api.github.com/repos/Seddryck/NBi/issues/106","labels_url":"https://api.github.com/repos/Seddryck/NBi/issues/106/labels{/name}","comments_url":"https://api.github.com/repos/Seddryck/NBi/issues/106/comments","events_url":"https://api.github.com/repos/Seddryck/NBi/issues/106/events","html_url":"https://github.com/Seddryck/NBi/issues/106","id":101612205,"number":106,"title":"Test names of DBs/Tables/Views/Functions/SPs/Columns with RegEx","user":{"login":"FuegoArtificial","id":13558754,"avatar_url":"https://avatars.githubusercontent.com/u/13558754?v=3","gravatar_id":"","url":"https://api.github.com/users/FuegoArtificial","html_url":"https://github.com/FuegoArtificial","followers_url":"https://api.github.com/users/FuegoArtificial/followers","following_url":"https://api.github.com/users/FuegoArtificial/following{/other_user}","gists_url":"https://api.github.com/users/FuegoArtificial/gists{/gist_id}","starred_url":"https://api.github.com/users/FuegoArtificial/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/FuegoArtificial/subscriptions","organizations_url":"https://api.github.com/users/FuegoArtificial/orgs","repos_url":"https://api.github.com/users/FuegoArtificial/repos","events_url":"https://api.github.com/users/FuegoArtificial/events{/privacy}","received_events_url":"https://api.github.com/users/FuegoArtificial/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Seddryck/NBi/labels/feature-request","name":"feature-request","color":"006b75"},{"url":"https://api.github.com/repos/Seddryck/NBi/labels/up-for-grabs","name":"up-for-grabs","color":"d4c5f9"}],"state":"open","locked":false,"assignee":{"login":"Seddryck","id":5455045,"avatar_url":"https://avatars.githubusercontent.com/u/5455045?v=3","gravatar_id":"","url":"https://api.github.com/users/Seddryck","html_url":"https://github.com/Seddryck","followers_url":"https://api.github.com/users/Seddryck/followers","following_url":"https://api.github.com/users/Seddryck/following{/other_user}","gists_url":"https://api.github.com/users/Seddryck/gists{/gist_id}","starred_url":"https://api.github.com/users/Seddryck/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Seddryck/subscriptions","organizations_url":"https://api.github.com/users/Seddryck/orgs","repos_url":"https://api.github.com/users/Seddryck/repos","events_url":"https://api.github.com/users/Seddryck/events{/privacy}","received_events_url":"https://api.github.com/users/Seddryck/received_events","type":"User","site_admin":false},"milestone":null,"comments":13,"created_at":"2015-08-18T09:26:34Z","updated_at":"2015-10-27T17:34:39Z","closed_at":null,"body":"Hi Seddryck,\r\n\r\nI would like to ask for a feature:\r\nTesting of name patterns of DBs/tables/views/functions/stored procedures/columns with regular expressions.\r\nOne approach could be to enable the \"matchpattern\"-tag to assert it against a structure. However, there might be more viable approaches.\r\n\r\nBest regards,\r\nTilo\r\n\r\nP.S. It's useful to easily enforce naming conventions throughout a project."},"comment":{"url":"https://api.github.com/repos/Seddryck/NBi/issues/comments/151580635","html_url":"https://github.com/Seddryck/NBi/issues/106#issuecomment-151580635","issue_url":"https://api.github.com/repos/Seddryck/NBi/issues/106","id":151580635,"user":{"login":"Seddryck","id":5455045,"avatar_url":"https://avatars.githubusercontent.com/u/5455045?v=3","gravatar_id":"","url":"https://api.github.com/users/Seddryck","html_url":"https://github.com/Seddryck","followers_url":"https://api.github.com/users/Seddryck/followers","following_url":"https://api.github.com/users/Seddryck/following{/other_user}","gists_url":"https://api.github.com/users/Seddryck/gists{/gist_id}","starred_url":"https://api.github.com/users/Seddryck/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Seddryck/subscriptions","organizations_url":"https://api.github.com/users/Seddryck/orgs","repos_url":"https://api.github.com/users/Seddryck/repos","events_url":"https://api.github.com/users/Seddryck/events{/privacy}","received_events_url":"https://api.github.com/users/Seddryck/received_events","type":"User","site_admin":false},"created_at":"2015-10-27T17:34:39Z","updated_at":"2015-10-27T17:34:39Z","body":"No, I just think that having to know about information_schema.tables is complex. I mean it's not something that a guy graduated from university will know. \n\n\n\n> On 27 Oct 2015, at 13:36, FuegoArtificial <notifications@github.com> wrote:\n> \n> I might missunderstand, what do you mean with complex? For me it's very easy to write the test compared to all other kinds of tests.\n> \n> Just as a sample:\n> \n>   <test name=\"mein Test\">\n>     <category>meine Kategorie</category>\n>     <system-under-test>\n>       <execution>\n>         <query connectionString=\"Data Source=DEVELOPMENT;Initial Catalog=NBI;Integrated Security=SSPI\">SELECT TABLE_NAME FROM information_schema.tables</query>\n>       </execution>\n>     </system-under-test>\n>     <assert>\n>       <matchPattern>\n>         <regex>Query[A-Za-z0-9_]</regex>\n>       </matchPattern>\n>     </assert>\n>   </test>\n> Do I understand something wrong?\n> \n> —\n> Reply to this email directly or view it on GitHub.\n> \n"}}