Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

OLE has three two different application schemas for OLEFS , OLELS and OLEDOCSTORE respectively. All the three different schemas come with a baseline dataset that is required for the applications application's basic functionality. Details of individual application schemas, baseline data sets and process for adding or updating different tables in the respective schemas has been explained below;

...

OLEFS - The main db module in OLEFS can be located under ole-app/ole-db

The four different maven modules for OLEFS DB are as follows;

  1. ole-impex- This is the parent module contains information about the baseline KFSthat has sub-modules that contains baseline OLEFS/LS/Rice datasets.
    1. ole-impex-master - This module has all the table definitions (schema.xml) along with data xml files for the base OLEFS/KFS datasets. This doesn't have any Rice related tables or data. For future KFS upgrades, any KFS table changes have to be updated here.
    2. ole-impex-rice - This module strictly contains the Rice table definitions (schema.xml) along with data xml files. The schema.xml that contains all the table definitions are modified for KFS needs, and so wont match with the schema.xml of the rice bootstrap dataset. Any future rice version upgrade changes will need to be accounted here (should come from KFS as KFS had modified rice tables)
    3. ole-impex-ls - This module contains all the table definitions (schema.xml) along with data.xml files for the base OLELS (Circulation and other library functions) datasets. 
  2. ole-liquibase- This module contains information about any database changes or updates that need to be mademodule allows injecting data easily by the use of liquibase tooling. Typically all the data files should go in the ole-impex module, but anything that is more demo specific and needs to be ingested for development purposes go here.
    1. ole-liquibase-changeset - This module contains the definitions for any updates that needs to be made to the base OLE schema that contains the base KFS/Rice tables/data. The updates could include creation of new tables, populating with some data etc..
  3. ole-sql - SQL Files under the various sub-modules are auto-generatedby maven commands run under the modules in 1 & 2commands. The various commands to produce sql statements for both MySQL and Oracle are explained below.

    Warning

    The various SQL files are auto generated by the maven process on the ole-impex and ole-liquibase modules. Do not attempt to manually update these the sql files as they will be overridden anytime the build process is run on the ole-impex and ole-liquibase modules.

    1. ole-liquibase-sql - These are auto-generated sql files from the ole-liquibase-changeset module.

      Info

      By default, the jdbc url is jdbc:mysql://mysql.rice.kuali.org/LIQUIBASEBLANK but since its not on your local db, there could be some performance lag. You could have the schema/user/password created locally.

      user-LIQUIBASEBLANK
      password-LIQUIBASEBLANK
      Schema-LIQUIBASEBLANK

      No Formatcd into the

       

      No Format
      cd ole-app/ole-db/ole-liquibase/ole-liquibase-changeset
      mvn moduleclean install
      mvn clean process-resources -Psql,mysql
      mvn clean process-resources -Psql,oracle
      cd ole-app
      mvn clean install -Dproperties.resolve=false
      andDskipTests=true
      cd ole-app/olefs
      mvn clean process-resources -Psql,oracle install -Pdb -Djdbc.dba.username=root -Djdbc.dba.password=root
      mvn initialize -Pdb,oracle -Djdbc.username=OLE -Doracle.dba.url=jdbc:oracle:thin:system/manager@localhost:1521:XE
    2. ole-master-sql - These are auto-generated sql files from the ole-impex-master module.
    3. ole-rice-sql - These are auto generated sql files from the ole-impex-rice module.

      Info

      These auto-generated sql files gets executed by the maven-sql plugin on a database; weather be it MySQL or Oracle. Refer to the DB refresh process in the main Developer's guide.

      kuali-deploy.jar is a tool that helps with the generation of all the sql files etc, and so its important to know the right version of the kuali-deploy when try to extract and generate the sql files.
      No Format
      cd into ole-impex
      mvn clean process-resources -Psql,mysql -Djdbc.dba.username=[fill me] -Djdbc.dba.password=[fill me]
      Info

       

       

  4. ole-workflow - These are files that are put in place as per the KFS/OLEFS workflow definitions. These were manually created to be consumed by the OLEFS application at startup so that all the document definitions along with routing info is available to the application.

...