[opencms-dev] Running Unit test cases (was: [PATCH]PostgreSQLSupport for OpenCms 6.x (CVS))
Alexander Kandzior
alex at opencms.org
Mon Dec 20 18:55:51 CET 2004
Antonio,
Regarding the "legacy tables" support - you should make sure that all other
tests work first. Legacy support for a new installation with Postgres is not
really something people will miss, it's more intended for users who have a
OpenCms 5.0 version that actually use legacy stuff and want to upgrade to
6.0. Now since there is no Postgres in 5.0 this is something not really
required.
Best Regards,
Alex.
Alexander Kandzior
Alkacon Software - The OpenCms Experts
http://www.alkacon.com
> -----Original Message-----
> From: opencms-dev-bounces at opencms.org
> [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Antonio Core
> Sent: Monday, December 20, 2004 6:10 PM
> To: The OpenCms mailing list
> Subject: RE: [opencms-dev] Running Unit test cases (was:
> [PATCH]PostgreSQLSupport for OpenCms 6.x (CVS))
>
> Alex,
>
> you can download the PostgreSQL JDBC driver from here:
>
> http://jdbc.postgresql.org/download/pg74.215.jdbc3.jar
>
> Regarding tests:
>
> You are right, I executed the
> org.opencms.xml.content.AllTests; Now, I'm executing the
> right one (org.opencms.test.AllTests). :-|
>
> For this reason, may you wait to include my patches released
> yesterday?
> I'll send you the right one asap.
>
> Running unittests with the right class, I receive this error:
>
> Testcase: testLegacyInitialization took 2.672 sec
> FAILED
> Master tables not created!
> junit.framework.AssertionFailedError: Master tables not created!
> at
> org.opencms.module.TestModuleLegacy.testLegacyInitialization(T
> estModuleLegacy.java:143)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess
> orImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth
> odAccessorImpl.java:25)
> at
> junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
> at
> junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> at junit.extensions.TestSetup.run(TestSetup.java:23)
>
>
> To resolve this problem, I created the file 'postgresql.sql'
> with specific PostgreSQL commands, but I don't know how to
> proceed to insert it into the
> "org.opencms.legacy.compatibility" module.
>
> May be, do I have to follow these steps? :
>
> - Create the 'postgresql.sql' directly inside OpenCMS
> database (using OpenCms Application);
> - Export the module changed;
> - change the source code of module in my source tree using
> the source code generated by export.
>
> Is it the right way to proceed?
> May you support me??
>
>
> Regards,
>
> Antonio
>
>
>
> On Mon, 2004-12-20 at 12:44 +0100, Alexander Kandzior wrote:
> > Antonio,
> >
> > I'll include your patch in the CVS later today or tomorrow.
> >
> > Please send me the download URL for the ProstgreSQL
> > pg74.215.jdbc3.jar, I'll then include this in the
> distribution as well.
> >
> > Regarding yout tests: Did you execute
> org.opencms.test.AllTests? The
> > output you attached was only regarding
> > org.opencms.xml.content.AllTests, so there's a lot missing.
> In fact,
> > if you did execute the right test, you must have exactly one test
> > failing, this is the "publish project scenario A", since
> this currently always fails.
> >
> > Best Regards,
> > Alex.
> >
> > Alexander Kandzior
> > Alkacon Software - The OpenCms Experts http://www.alkacon.com
> >
> >
> >
> > > -----Original Message-----
> > > From: opencms-dev-bounces at opencms.org
> > > [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Antonio Core
> > > Sent: Sunday, December 19, 2004 2:33 AM
> > > To: The OpenCms mailing list
> > > Subject: Re: [opencms-dev] Running Unit test cases (was:
> > > [PATCH] PostgreSQLSupport for OpenCms 6.x (CVS))
> > >
> > > Alex,
> > >
> > > I regret for the late response, but I had problems with my Pc...
> > >
> > > I prepared the configurations file for unit tests on PostgreSQL
> > > following your instructions.
> > > The tests have been executed without errors; please, find
> attached
> > > at this email the log file
> > > (TEST-org.opencms.xml.content.AllTests.txt).
> > >
> > > Attached at this email there is the "opencms_postgresql_02.patch"
> > > file with these changes:
> > >
> > > File changed:
> > >
> > > - opencms/build.xml
> > > the postgresql lines have been added.
> > >
> > > - opencms/test/test.properties
> > > the setup for postgresql has been added.
> > >
> > > - opencms/test/data/WEB-INF/config/opencms-vfs.xml
> > > the unittests failed because the class
> > >
> > >
> > > org.opencms.workplace.xmlwidgets.CmsXmlVfsImageWidget
> > >
> > > doesn't exist anymore in the CVS tree.
> > > Reading in the CVS log, I thought taht this class
> > > has been replaced by
> > >
> > >
> > > org.opencms.workplace.xmlwidgets.CmsXmlImageGalleryWidget
> > >
> > > For this reason, I replaced the line:
> > >
> > > <widget
> class="org.opencms.workplace.xmlwidgets.CmsXmlVfsImageWidget"
> > > alias="VfsImageWidget"/>
> > >
> > > whit that one:
> > >
> > > <widget
> > > class="org.opencms.workplace.xmlwidgets.CmsXmlImageGalleryWidget"
> > > alias="ImageWidget" />
> > >
> > > This is the same value as in the
> > >
> opencms/webapp/WEB-INF/config/opencms-vfs.xml
> > > file.
> > > I hope that it is correct.
> > >
> > >
> > > -
> opencms/webapp/setup/database/postgresql/create_db.sql
> > > - opencms/webapp/setup/database/postgresql/drop_db.sql
> > > -
> opencms/webapp/setup/database/postgresql/drop_tables.sql
> > > -
> > > opencms/webapp/setup/database/postgresql/step_4_database_setup.jsp
> > > Changed the PostgreSQL setup file, according
> > > unittests results.
> > >
> > > File Added:
> > > -
> > > opencms/test/data/WEB-INF/config.postgresql/opencms-modules.xml
> > > -
> > > opencms/test/data/WEB-INF/config.postgresql/opencms.properties
> > > Configuration files to use in unittests with
> > > PostgreSQL database
> > >
> > > Moreover, in the CVS source tree the file
> pg74.215.jdbc3.jar is not
> > > present yet...
> > >
> > > Best Regards,
> > > Antonio
> > >
> > >
> > > On Mon, 2004-12-06 at 12:36 +0100, Alexander Kandzior wrote:
> > > > Antonio,
> > > >
> > > > It took me a couple of days, but I actually "repaired" the
> > > "unittests"
> > > > target in the build.xml file. Turns out there was a library
> > > missing.
> > > >
> > > > Let's assume you are able to run "ant war" and generate the
> > > > OpenCms war file.
> > > >
> > > > Try running "ant unittests". This will run all the
> Junit tests and
> > > > write the output to a file. The location of the file is ant
> > > specific
> > > > and may depend on your setup. Also, the optional "junit" target
> > > > support for ant is required, this usually comes in a
> > > "ant-junit.jar".
> > > > Please check the ant homepage on how to configure these since.
> > > >
> > > > OpenCms configuration for unit tests:
> > > >
> > > > The unit tests run with a pre-configured database
> > > configuration. The
> > > > file "/test/test.properties" contains the main test settings.
> > > > Basically you must configure the database you want to
> test here,
> > > > as well as the local path configuration where the data
> is located.
> > > >
> > > > Each database must come with it's own set of pre-configured
> > > > "opencms.properties". In the folder "/test/data/WEB-INF"
> > > you will find
> > > > one config.xxx folder for each supported database.
> These files are
> > > > copied automatically to "/test/data/WEB-INF/config" during
> > > test setup.
> > > >
> > > > For example, mySQL is configured by default in
> > > "test.propeties" with
> > > > the "db.product=mysql" setting. So the mySQL secific
> settings are
> > > > taken form the folder "/test/data/WEB-INF/config.mysql". So in
> > > > the mySQL example, it's assumed that there is a local mysql
> > > installation, the user name is "root"
> > > > and the user has no password. All of this is located in
> > > > "opencms.properties". In case the test cases can't
> connect to the
> > > > database, you must modify these parameters.
> > > >
> > > > Best Regards,
> > > > Alex.
> > > >
> > > > Alexander Kandzior
> > > > Alkacon Software - The OpenCms Experts http://www.alkacon.com
> > > >
> > > >
> > > >
> > > > > -----Original Message-----
> > > > > From: opencms-dev-bounces at opencms.org
> > > > > [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Antonio
> > > > > Core
> > > > > Sent: Thursday, December 02, 2004 2:56 PM
> > > > > To: The OpenCms mailing list
> > > > > Subject: RE: [opencms-dev] [PATCH] PostgreSQL Support for
> > > > > OpenCms 6.x (CVS)
> > > > >
> > > > > Alex,
> > > > >
> > > > > Normally, I use jEdit as my development tool.
> > > > >
> > > > > Anyway, I've already installed Eclipse (ver 3.1M3) and I'm
> > > > > trying it. ;)
> > > > >
> > > > > May you send me more informations about how proceed
> to setup and
> > > > > perform JUnit tests with Eclipse?
> > > > >
> > > > > Best Regards,
> > > > >
> > > > > Antonio
> > > > >
> > > > >
> > > > >
> > > > > On Thu, 2004-12-02 at 10:36, Alexander Kandzior wrote:
> > > > > > Are you using Eclipse for development?
> > > > > > If so, I can yout tell how we do it, since we are
> using Eclipse.
> > > > > > If not, there's also an ant task, but this may
> > > currently be broken.
> > > > > >
> > > > > > Best Regards,
> > > > > > Alex.
> > > > > >
> > > > > > Alexander Kandzior
> > > > > > Alkacon Software - The OpenCms Experts
> http://www.alkacon.com
> > > > > >
> > > > > >
> > > > > >
> > > > > > > -----Original Message-----
> > > > > > > From: opencms-dev-bounces at opencms.org
> > > > > > > [mailto:opencms-dev-bounces at opencms.org] On Behalf Of
> > > > > > > Antonio Core
> > > > > > > Sent: Thursday, December 02, 2004 10:19 AM
> > > > > > > To: The OpenCms mailing list
> > > > > > > Subject: RE: [opencms-dev] [PATCH] PostgreSQL Support for
> > > > > > > OpenCms 6.x (CVS)
> > > > > > >
> > > > > > > Alex,
> > > > > > >
> > > > > > > No, i didn't, sorry.
> > > > > > >
> > > > > > > I think that it will be necessary too.
> > > > > > >
> > > > > > > Thank you very much if you support me with that.
> > > > > > >
> > > > > > > Best Regards,
> > > > > > >
> > > > > > > Antonio
> > > > > > >
> > > > > > >
> > > > > > > On Thu, 2004-12-02 at 09:51, Alexander Kandzior wrote:
> > > > > > > > I applied these fixes to the CVS version.
> > > > > > > >
> > > > > > > > Antonio, did you run the Junit tests for
> Postgessql? These
> > > > > > > are really
> > > > > > > > helpful since they have quite a broad range of daabase
> > > > > operation
> > > > > > > > covered already. If not I can support you in
> getting these
> > > > > > > up and running.
> > > > > > > >
> > > > > > > > Best Regards,
> > > > > > > > Alex.
> > > > > > > >
> > > > > > > > Alexander Kandzior
> > > > > > > > Alkacon Software - The OpenCms Experts
> > > http://www.alkacon.com
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > > -----Original Message-----
> > > > > > > > > From: opencms-dev-bounces at opencms.org
> > > > > > > > > [mailto:opencms-dev-bounces at opencms.org] On Behalf Of
> > > > > > > > > Antonio Core
> > > > > > > > > Sent: Wednesday, December 01, 2004 10:14 PM
> > > > > > > > > To: OpenCms
> > > > > > > > > Subject: [opencms-dev] [PATCH] PostgreSQL Support for
> > > > > > > > > OpenCms 6.x
> > > > > > > > > (CVS)
> > > > > > > > >
> > > > > > > > > Dear all,
> > > > > > > > >
> > > > > > > > > here is a patch for postgreSQL database support.
> > > > > > > > >
> > > > > > > > > The files changed:
> > > > > > > > >
> > > > > > > > >
> > > opencms/src/org/opencms/db/postgresql/CmsBackupDriver.java
> > > > > > > > > (specialized method deleteBackups of class
> > > > > > > > >
> > > opencms.src.org.opencms.db.generic.CmsBackupDriver)
> > > > > > > > >
> > > > > > > > > opencms/src/org/opencms/db/postgresql/query.properties
> > > > > > > > > (added queries:
> > > > > > > > > C_POSTGRESQL_BACKUP_DELETE_CONTENT
> > > > > > > > > C_POSTGRESQL_BACKUP_DELETE_RESOURCES
> > > > > > > > > C_POSTGRESQL_BACKUP_DELETE_STRUCTURE
> > > > > > > > > removed query:
> > > > > > > > > C_BACKUP_DELETE_RESOURCE
> > > > > > > > > )
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Having a CVS checkout of the opencms source, go into
> > > > > the opencms
> > > > > > > > > directory and launch the following command:
> > > > > > > > >
> > > > > > > > > patch -p0 < ....path.../opencms_postgresql_01.patch
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Best Regards,
> > > > > > > > >
> > > > > > > > > Antonio
> > > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > _______________________________________________
> > > > > > > > This mail is send to you from the opencms-dev
> mailing list
> > > > > > > To change
> > > > > > > > your list options, or to unsubscribe from the list,
> > > > > please visit
> > > > > > > > http://mail.opencms.org/mailman/listinfo/opencms-dev
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > _______________________________________________
> > > > > > > This mail is send to you from the opencms-dev mailing
> > > > > list To change
> > > > > > > your list options, or to unsubscribe from the list,
> > > please visit
> > > > > > > http://mail.opencms.org/mailman/listinfo/opencms-dev
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > _______________________________________________
> > > > > > This mail is send to you from the opencms-dev mailing list
> > > > > To change
> > > > > > your list options, or to unsubscribe from the list,
> > > please visit
> > > > > > http://mail.opencms.org/mailman/listinfo/opencms-dev
> > > > >
> > > > >
> > > > >
> > > > > _______________________________________________
> > > > > This mail is send to you from the opencms-dev mailing
> > > list To change
> > > > > your list options, or to unsubscribe from the list,
> please visit
> > > > > http://mail.opencms.org/mailman/listinfo/opencms-dev
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > _______________________________________________
> > > > This mail is send to you from the opencms-dev mailing list
> > > To change
> > > > your list options, or to unsubscribe from the list,
> please visit
> > > > http://mail.opencms.org/mailman/listinfo/opencms-dev
> > >
> >
> >
> >
> > _______________________________________________
> > This mail is send to you from the opencms-dev mailing list
> To change
> > your list options, or to unsubscribe from the list, please visit
> > http://mail.opencms.org/mailman/listinfo/opencms-dev
>
>
>
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list To
> change your list options, or to unsubscribe from the list,
> please visit http://mail.opencms.org/mailman/listinfo/opencms-dev
>
>
More information about the opencms-dev
mailing list