Re: Oracle Development on 18c XE

If you want to build your own framework and it works well - go ahead. I'm supportive of test automation and test thinking. Before you do, see what's available already. utPLSQL is alive and rocking.
Want to inegrate with jenkins or other CI/CD, maven, SQLDeveloper - no problem.
Want to have code coverage with statement level coverage - got it. Need custom reports - sure can do.
Run from command line withour sql client - done.

Have issues - raise them on:
github.com/utplsql/utplsql

Cheers and Happy New Year
Jacek

On Thu, 20 Dec 2018, 16:55 <post.ethan_at_gmail.com wrote:

> I will roll my own (I hear the “don’t do its”.)
>
>
>
> I have already built one for shell and I love it. I might have gone with
> shunit2 but it didn’t look like it was being maintained at the time I built
> mine. It is now. I am very particular about things. Probably a flaw.
>
>
>
> Since I have a solid design in shell already porting to PL/SQL should not
> be too hard and I might even just extend the shell framework to call into
> the DB.
>
>
>
> *From:* Jacek Gębal <jgebal_at_gmail.com>
> *Sent:* Wednesday, December 19, 2018 5:04 PM
> *To:* post.ethan_at_gmail.com
> *Cc:* Tim Hall <tim_at_oracle-base.com>; Niall Litchfield <
> niall.litchfield_at_gmail.com>; ORACLE-L <oracle-l_at_freelists.org>
> *Subject:* Re: Oracle Development on 18c XE
>
>
>
> I heard unit testing, so side question:
>
> What do you use for unit testing? Did you try utPLSQL v3?
>
> Cheers
>
> Jacek
>
>
>
> On Wed, 19 Dec 2018, 05:09 <post.ethan_at_gmail.com wrote:
>
> This is just for development of a automation/monitoring schema in the DB.
> Performance, built in packages and so on. The issue is if the data is the
> same in the views coming back from XE that it is from EE, especially for
> things like multitenant. Can I expect roughly the same data/columns? Sounds
> like it is at least good enough to get started and I can always test in
> SE/EE later. I build unit tests so I will know pretty much right away if
> something is broken.
>
> Thanks for the feedback.
>
> -----Original Message-----
> From: Tim Hall <tim_at_oracle-base.com>
> Sent: Tuesday, December 18, 2018 10:41 AM
> To: Niall Litchfield <niall.litchfield_at_gmail.com>
> Cc: post.ethan_at_gmail.com; ORACLE-L <oracle-l_at_freelists.org>
> Subject: Re: Oracle Development on 18c XE
>
> The other concern, depending on your usage of course, is the lack of
> patches. Depending on company policy this can be a show stopper.
>
> Cheers
>
> Tim...
>
> On Tue, Dec 18, 2018 at 4:05 PM <niall.litchfield_at_gmail.com> wrote:
> >
> > The only concern I'd have is that since you get essentially all the
> > added-cost features for free you might build them into whatever
> > development you do.
> >
> > On Tue, Dec 18, 2018 at 3:07 PM <post.ethan_at_gmail.com> wrote:
> > >
> > >
> > >
> > > Anyone know of any obvious reason to not do development on 18c XE?
> This will mostly be data dict and V$ access. Are there significant
> differences in these views between this and EE? I think in the past I
> avoided the free edition of SE because of some issues but wondering if that
> might still be a thing I need to be concerned about.
> > >
> > >
> > >
> > > Thanks,
> > >
> > > Ethan
> > >
> > > https://twitter.com/poststop
> >
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > http://www.orawin.info
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l