Re: [WebERP-developers] Postgresql

[Phil D. <we...@pa...>]

The diff is over 25,000 lines?

This is effectively a re-write and it looks like it was done against an older 
version of webERP - I am aftaid we have done too much and Danie has also done 
too much. This is just too much for a part timer :-(

Any thoughts team on how we deal with this???

Phil

On Sun, 12 Dec 2004 00:51, Danie Brink wrote:
> Hi Jake,
> Here is the link to download the postgres weberp stuff we have done so far,
> Note there is a testing postgres script in the sql directory,
> Also note that you need most of the stored procedures we created, although
> some was just for good measure.
> A lot of the SQL's has been updated as MySQL does not handle group by
> according to SQL spec and neither does the ORDER BY, it works but it does
> not enforce correctness, postgres does.
>
> The Admin and Mail scripts is not done yet and some other scripts may be
> funny.
>
> Download http://www.b2brus.co.za/downloads/pgweberp.tar.gz
>
> Kind Regards
> Danie Brink
>
> On Saturday 11 December 2004 12:55, Jake Stride wrote:
> > Do you have anything that we can start looking at yet? Even if not all
> > the files are converted we could still be testing the ones that are done.
> >
> > Thanks
> >
> > Jake
> >
> > Danie Brink wrote:
> > > Yes, it is just an HTTP testing tool, so adding fields to the
> > > databases, or even changing the underlying database altogether has no
> > > effect, however adding or changing a field on a form will require some
> > > modification of the XML.
> > >
> > > As far as lack of functionality, I am sure that if we realy require
> > > modufications, someone will probably step up to the plate if the
> > > original developer is no longer interested.
> > >
> > > Kind Regards.
> > > Danie Brink
> > >
> > > Quoting Steve Kaill <sk...@ro...>:
> > >>Converted from Rich TextCool.  What happens if fields are added in
> > >> tables or tables are added?  Is it just some minimal changes to the
> > >> xml or are Perl code changes required?  I'm thinking just a bit of
> > >> xml...
> > >>
> > >>Steve
> > >>  ----- Original Message -----
> > >>  From: Danie Brink
> > >>  To: web...@li...
> > >>  Sent: Tuesday, December 07, 2004 5:59 PM
> > >>  Subject: Re: [WebERP-developers] Postgresql
> > >>
> > >>
> > >>  Hi Steve,
> > >>
> > >>  It is not needed to understand the perl as we will be using the
> > >> utility to the extend it allows.
> > >>
> > >>
> > >>  It runs on linux
> > >>
> > >>
> > >>  I am prepared to put the xmls together as I require them soon anyway.
> > >> if we do decide to go this way I would require a lot of input from all
> > >> you guys, order of events, data that should be entered, where should
> > >> test be paused for manual processes to take over, etc..
> > >>
> > >>
> > >>  XML is simple and it uses a coniguration file containing sequential
> > >> tests specified in XML.
> > >>
> > >>
> > >>  Kind regards
> > >>
> > >>  Danie Brink.
> > >>
> > >>
> > >>  _____________Original message ____________
> > >>
> > >>  Subject: Re: [WebERP-developers] Postgresql
> > >>
> > >>  Sender: "Steve Kaill" <sk...@ro...>
> > >>
> > >>  Date: Wed, 8 Dec 2004 00:47:51 +0200
> > >>
> > >>
> > >>  I could see something like this being fantastic. We did have similar
> > >>  proprietary systems/tools at the large software company I worked at.
> > >>  However, while it has some great advantages it has some drawbacks...
> > >>
> > >>
> > >>  Advantages:
> > >>  - testers just create tests in a fairly easy way and they don't need
> > >> to understand the underlying code/architecture of WebInject in order
> > >> to use it.
> > >>
> > >>
> > >>  - would allow a good amount of automated testing in a small amount of
> > >>time.
> > >>  Some testing that otherwise never gets done.
> > >>
> > >>
> > >>  - can help with performance testing and probably many otherwise
> > >> "hidden" errors.
> > >>
> > >>
> > >>  - would ensure greater stability
> > >>
> > >>
> > >>  - nice to be able to say to people we actually go to this extent!
> > >>
> > >>
> > >>  Disadvantages
> > >>  - testers would seem to need some clear instruction on how to set up
> > >> the tests which I believe are XML based, however, probably very simple
> > >> XML.
> > >>
> > >>
> > >>  - says something about only being compiled for Windows. Need to run
> > >> on Linux or both. Maybe it can, I'm not sure...
> > >>
> > >>
> > >>  - it would require someone commit to be the pioneer and get it to the
> > >>point
> > >>  where us others can handle using.
> > >>
> > >>
> > >>  - cannot totally replace manual testing but nothing can. It would
> > >> surely
> > >>
> > >>  reduce the amount of testing and provide for better, different and
> > >> more testing.
> > >>
> > >>
> > >>  - Perl concerns me because I don't know it and not sure how many here
> > >> do if
> > >>  we should need to modify the test code. Possibly we wouldn't need to
> > >>  depending on how it is designed...
> > >>
> > >>
> > >>  Steve
> > >>
> > >>
> > >>
> > >>  ----- Original Message -----
> > >>  From: "Danie Brink" <br...@na...>
> > >>  To: <web...@li...>
> > >>  Sent: Tuesday, December 07, 2004 2:25 PM
> > >>
> > >>  Subject: Re: [WebERP-developers] Postgresql
> > >>
> > >>  > Also what about using some automation tool to test at least some of
> > >>  > the functionality like WebInject for instance.
> > >>  >
> > >>  > http://sourceforge.net/projects/webinject/
> > >>  >
> > >>  > Danie
> > >>  >
> > >>  > Quoting Steve Kaill <sk...@ro...>:
> > >>  > > Good idea. Testing procedures/list would be very handy. I believe
> > >>  > > it
> > >>
> > >>  should
> > >>
> > >>  > > be based on the base demo data. Possibly as the test procedures
> > >>  > > are
> > >>
> > >>  refined
> > >>
> > >>  > > we end up discovering that we need to add or modify some demo
> > >>  > > data appropriately...
> > >>  > >
> > >>  > > Steve
> > >>  > >
> > >>  > >
> > >>  > > ----- Original Message -----
> > >>  > > From: "Danie Brink" <br...@na...>
> > >>  > > To: <web...@li...>
> > >>  > > Sent: Tuesday, December 07, 2004 1:54 PM
> > >>  > > Subject: Re: [WebERP-developers] Postgresql
> > >>  > >
> > >>  > > > Hi Jake,
> > >>  > > >
> > >>  > > > Going Well, As of today weberp as when loged in is now fully
> > >>
> > >>  converted,
> > >>
> > >>  > > > Outstanding issues are still Z_Admin pages and Mail_PDF pages.
> > >>  > > >
> > >>  > > > Starting those tomorrow.
> > >>  > > >
> > >>  > > > We also need to go through a testing cycle now. I was wondering
> > >>  > > > if
> > >>
> > >>it
> > >>
> > >>  > > would be a
> > >>  > >
> > >>  > > > good idee to start putting together some testing procedures,
> > >>  > > > Things
> > >>
> > >>  like
> > >>
> > >>  > > load
> > >>  > >
> > >>  > > > this account set, now fill in these details, create this client
> > >>  > > > an
> > >>  > >
> > >>  > > supplier,
> > >>  > >
> > >>  > > > these items, so these purcheses, etc. It would be helpfull to
> > >>
> > >>identify
> > >>
> > >>  > > > opperational errors in future with new releases of WebERP. And
> > >>  > > > sure
> > >>
> > >>it
> > >>
> > >>  > > would
> > >>  > >
> > >>  > > > help now, but how about we do these things together ???
> > >>  > > >
> > >>  > > > I will create a DB export as soon as I am finished and then
> > >>  > > > clean it
> > >>
> > >>  up a
> > >>
> > >>  > > bit,
> > >>  > >
> > >>  > > > then I will post it all. As mentioned, I need to clean up a few
> > >>
> > >>things
> > >>  but
> > >>
> > >>  > > I
> > >>  > >
> > >>  > > > figured I might as well do that, and let all have a look.
> > >>  > > >
> > >>  > > > Kind Regards
> > >>  > > >
> > >>  > > > Danie Brink
> > >>  > > >
> > >>  > > > Quoting Jake Stride <ns...@us...>:
> > >>  > > > > I know in one of the previous threads there was mention of
> > >>  > > > > Danies
> > >>  > >
> > >>  > > postgresql
> > >>  > >
> > >>  > > > > port but I thought it would be a good idea to start a new
> > >>  > > > > thread
> > >>
> > >>to
> > >>
> > >>  > > offer m
> > >>  > >
> > >>  > > > > help and see how things are proceeding with the port.
> > >>  > > > >
> > >>  > > > > Thanks
> > >>  > > > >
> > >>  > > > >
> > >>  > > > > Jake
> > >>  > > > >
> > >>  > > > >
> > >>  > > > > -------------------------------------------------------
> > >>  > > > > SF email is sponsored by - The IT Product Guide
> > >>  > > > > Read honest & candid reviews on hundreds of IT Products from
> > >>  > > > > real
> > >>
> > >>  users.
> > >>
> > >>  > > > > Discover which products truly live up to the hype. Start
> > >>  > > > > reading
> > >>
> > >>  now.
> > >>
> > >>  > > > > http://productguide.itmanagersjournal.com/
> > >>  > > > > _______________________________________________
> > >>  > > > > Web-erp-developers mailing list
> > >>  > > > > Web...@li...
> > >>  > > > > https://lists.sourceforge.net/lists/listinfo/web-erp-develope
> > >>  > > > >rs
> > >>  > > >
> > >>  > > > -------------------------------------------------------
> > >>  > > > SF email is sponsored by - The IT Product Guide
> > >>  > > > Read honest & candid reviews on hundreds of IT Products from
> > >>  > > > real
> > >>
> > >>  users.
> > >>
> > >>  > > > Discover which products truly live up to the hype. Start
> > >>  > > > reading
> > >>
> > >>now.
> > >>
> > >>  > > > http://productguide.itmanagersjournal.com/
> > >>  > > > _______________________________________________
> > >>  > > > Web-erp-developers mailing list
> > >>  > > > Web...@li...
> > >>  > > > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> > >>  > >
> > >>  > > -------------------------------------------------------
> > >>  > > SF email is sponsored by - The IT Product Guide
> > >>  > > Read honest & candid reviews on hundreds of IT Products from real
> > >>
> > >>users.
> > >>
> > >>  > > Discover which products truly live up to the hype. Start reading
> > >>  > > now. http://productguide.itmanagersjournal.com/
> > >>  > > _______________________________________________
> > >>  > > Web-erp-developers mailing list
> > >>  > >
> > >>  > > Web...@li...
> > >>  > > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> > >>  >
> > >>  > -------------------------------------------------------
> > >>  > SF email is sponsored by - The IT Product Guide
> > >>  > Read honest & candid reviews on hundreds of IT Products from real
> > >>  > users.
> > >>  >
> > >>  > Discover which products truly live up to the hype. Start reading
> > >>  > now. http://productguide.itmanagersjournal.com/
> > >>  > _______________________________________________
> > >>  > Web-erp-developers mailing list
> > >>  > Web...@li...
> > >>  > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> > >>
> > >>  -------------------------------------------------------
> > >>  SF email is sponsored by - The IT Product Guide
> > >>  Read honest & candid reviews on hundreds of IT Products from real
> > >> users. Discover which products truly live up to the hype. Start
> > >> reading now.
> > >>
> > >>  http://productguide.itmanagersjournal.com/
> > >>  _______________________________________________
> > >>  Web-erp-developers mailing list
> > >>  Web...@li...
> > >>  https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> > >
> > > -------------------------------------------------------
> > > SF email is sponsored by - The IT Product Guide
> > > Read honest & candid reviews on hundreds of IT Products from real
> > > users. Discover which products truly live up to the hype. Start reading
> > > now. http://productguide.itmanagersjournal.com/
> > > _______________________________________________
> > > Web-erp-developers mailing list
> > > Web...@li...
> > > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products from real users.
> > Discover which products truly live up to the hype. Start reading now.
> > http://productguide.itmanagersjournal.com/
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers

-- 
Phil Daintree
webERP Project Admin