tag:blogger.com,1999:blog-7849367040589270673.post1819527993134150165..comments2024-03-21T22:50:39.997-07:00Comments on Obsessed with Oracle PL/SQL: Checklist Driven Development: TDD on the cheap - VERY cheapSteven Feuersteinhttp://www.blogger.com/profile/18405765731886460622noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-7849367040589270673.post-76282979823110535892017-03-03T07:57:21.624-08:002017-03-03T07:57:21.624-08:00Stefan, I seem to have somehow lost your email and...Stefan, I seem to have somehow lost your email and would like to get in touch. Could you please follow up with me at steven dot feuerstein at oracle dot com?Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-24982088916921716002017-02-15T09:18:47.492-08:002017-02-15T09:18:47.492-08:00Stefan, thanks for the live tutorial you gave me. ...Stefan, thanks for the live tutorial you gave me. <br /><br />Your Excel based approach makes it a lot easier for both end users and developers to be involved in the Unit Testing process!<br /><br />Thanks again!Yisroel Lazersonhttps://www.blogger.com/profile/13667344876843703089noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-76215343705244140592016-12-19T23:32:07.926-08:002016-12-19T23:32:07.926-08:00Stefan, hello.
Let me invite you to the next chap...Stefan, hello.<br /><br />Let me invite you to the next chapter of utPLSQL. Currently the community works hard on brand new version3 of the framework and we will greatly appreciate your opinion about what's already done and what should be improved.<br /><br />https://github.com/utPLSQL/utPLSQL/tree/version3Anonymoushttps://www.blogger.com/profile/15720914158443012639noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-34031939480991104482016-09-30T13:22:11.474-07:002016-09-30T13:22:11.474-07:00I'll do my very best. :-) Lets meet.I'll do my very best. :-) Lets meet.Stefan Poschenriederhttps://www.xing.com/profile/Stefan_Poschenriedernoreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-64946767133142475152016-09-26T11:47:55.348-07:002016-09-26T11:47:55.348-07:00"What i am most proud of is, that i really ev..."What i am most proud of is, that i really evangelized a team to change their way of coding. The resulting quality of the unit-tests was so good, that they changed their transition process and the testers in many cases only do unit-test reviews."<br /><br />Nice work, Stefan. That is not easy to do. I am very impressed. Perhaps you could work your magic on me, too? :-)Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-64392230347142985602016-09-18T12:02:55.104-07:002016-09-18T12:02:55.104-07:00Hi Steven,
wow thats pretty cool. Steven Feuerste...Hi Steven,<br /><br />wow thats pretty cool. Steven Feuerstein wants a live-demonstration.<br />For sure, i will give. <br />I would need a little bit time to prepare an adapted demonstration. Maybe in octobre/november?<br /><br />This tool makes developer`s life so easy. (especially pl/sql-developers life, but even i used it in the past with informatica and talend as well, and that poor ones need it even more)<br /><br />What i am most proud of is, that i really evangelized a team to change their way of coding. The resulting quality of the unit-tests was so good, that they changed their transition process and the testers in many cases only do unit-test reviews.<br /><br />If someone else is interested please contact me via email: stefan dot poschenrieder at gmx dot de.<br /><br />Regards,<br />StefanStefan Poschenriederhttps://www.xing.com/profile/Stefan_Poschenriedernoreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-3289311914866413252016-09-13T07:28:17.729-07:002016-09-13T07:28:17.729-07:00Stefan, think about it and let me know (either her...Stefan, think about it and let me know (either here or via email: steven dot feuerstein at oracle dot com). I would be happy to host you for a conversation and demonstration.Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-38114122723396005192016-09-13T07:05:22.049-07:002016-09-13T07:05:22.049-07:00Maybe i could do the same life demo just via webex...Maybe i could do the same life demo just via webex or something similar.. hm. thinking about.<br />Stefan Poschenriederhttps://www.xing.com/profile/Stefan_Poschenriedernoreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-68882250751700032822016-08-27T23:48:53.027-07:002016-08-27T23:48:53.027-07:00Well done Stefan, Really impressed. Can you give u...Well done Stefan, Really impressed. Can you give us a demo on how you do all this, may be through video or a blog ?Fahdhttps://www.blogger.com/profile/07830276367604018761noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-2914778617791745662016-06-06T03:34:57.475-07:002016-06-06T03:34:57.475-07:00Stefan, thanks for sharing your experience. Excel!...Stefan, thanks for sharing your experience. Excel! Who would have thought? This is a very exciting note, it's so great to see utPLSQL going strong. Are you involved in the project itself (just moved to Github). I wonder if there are any Excel-related resources (integration with utPLSQL) you could share via the project so others might take advantage of all the great infrastructure you have built.Steven Feuersteinhttps://www.blogger.com/profile/18405765731886460622noreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-59979421195888400882016-06-04T12:41:29.961-07:002016-06-04T12:41:29.961-07:00Hi Steven,
first let me thank you for programming...Hi Steven,<br /><br />first let me thank you for programming utplsql.<br />I use it now for over 7 years. And from the beginning i was trying to optimize the way how to define unit-tests.<br />I was really kind of shocked, as i read, that you dont unit-test when you code. Really, i dont believe.<br />I can not live without unit-tests. This is the first thing i do when starting to code.<br /><br />The most important thing: To define a unit-test, it must be very easy. The Developer needs to LOVE unit-testing.<br />In the "best case", the developer does the unit-test together with the business specialists.<br />And what is the tool everybody understands, especially "business-people": Its Excel.<br />Excel is the natural-born-unit-testing-tool for plsql. Believe me.<br />You can sit together with everybody and discussing the scenarios (or send per email). You even can get a business-approval.<br />I did some excel-macros in the last years to make life as easy as possible. <br />import table-structures, import testdata, validate testdata format, generate utplsql, execute it, show result in html...<br />I dont know the other tools (Code-Tester...), but i guess<br />they do the same, but: is the tool as easy and powerful as Excel?<br />We are using many features of Excel when defining tests. Formatting, Colours, formulas, comments... what you want.<br />Because with high-complex ETL jobs it is so important to have it good documented.<br /> <br />And at the end we only press button "test" inside excel, and we see if everything works.<br />In the background a utplsql-package is generated, and executed.<br /><br />In my life-demos, i do pair-developing with people from the audience,<br />(i define unit test, audience is programming against them, 3 cycles of going red and green), and in a result<br />we put the generated utplsql package into svn and hudson for continuous integration. waiting one minute, and then<br />getting automated email that tests are succesful now. <br /><br />We are a SCRUM-Team of 10 DWH-developers. It is so awesome seeing how this team is performing.<br />We have now problems to get enough work from business(!!) (and we are able to refactor whatever we want without pain), <br />and we are running and supporting our DWH-Software now in 3 countries.<br /><br />We are running 100.000 Unit-tests every 20 minutes. <br /><br />regards,<br />StefanStefan Poschenriederhttps://www.xing.com/profile/Stefan_Poschenrieder?sc_o=mxb_pnoreply@blogger.comtag:blogger.com,1999:blog-7849367040589270673.post-61041904979339584492015-10-09T04:55:30.872-07:002015-10-09T04:55:30.872-07:00Hi Stephen.
Even with ChLDD, you still need/should...Hi Stephen.<br />Even with ChLDD, you still need/should do some check before you tick the box - DOES.<br />How will you do that? I bet as simple as possible!<br /><br />Why not then use the "as simple as possible" check as a unit test?<br />The benefit would be that at least you leave something to go back to and verify that "stuff" is still working as it was supposed to be.<br />The Software is no linger build to last, it is build to change, and test are to make the change safe.<br /><br />There is the catch that I also fall in very often - rushing into implementation prior to writing a test case.However, there is always a question of what really the program should be doing.<br />The Unit Tests are to document the requirements in an executable form, so that the next time someone comes to change the code, looking at tests, he/she knows what the code is currently doing.<br />This is of the particular value when dealing with large and or complex systems.<br /><br />Ian Cooper made a great talk about "TDD - where did it all go wrong".<br /><br />What are your thoughts on what he is saying in the interview? <br />https://www.youtube.com/watch?v=HNjlJpuA5kQ<br /><br />Here is the full presentation from the conference: https://vimeo.com/68375232<br /><br />Anonymoushttps://www.blogger.com/profile/08849136351731818825noreply@blogger.com