User Tools

Site Tools


configure_lure_to_create_pending_patch_files_automatically

Configure Lure to create pending patch files automatically

In order to get Lure to create versioned patch files automatically during export do the following:

  1. Open the Configuration Editor from within Lure Stage, go to the “Versioned Patches” tab and select the appropriate version control system.
    1. Currently three options are supported: Subversion, Perforce and Local.
  2. Check out the project source code using a client application of the version control system as selected in the first step.
    1. Lure will use the version control command line client programs to connect to the repository to establish various properties of source files.

During export Lure will now automatically create versioned patch files for all table changes. Consider for example a table with name COMPANY. Lure will create a versioned patch file as follows:

COMPANY.table.lsql.r34.lpatch-pending

The version of the patch file (34 in the above example) will be set equal to the SVN head revision. Lure cannot create the versioned patch file unless the table source is checked out within the project directory. Lure compares the newly exported table source code with the table source code of the checked out SVN base revision and adds the corresponding ALTER TABLE statements to the patch file.

Pending Patch Files

Note the last extension of the patch file in the above example is lpatch-pending. This indicates that the patch file is created as a pending patch file. Pending patch files will not be used during import. They need to be reviewed and approved first.

Pending patch files can be approved from within Lure Stage via the context menu. Right click on the pending patch file from within the Lure Project Explorer view and select “Approve Patch” from the popup menu. This will change the name of the file to:

COMPANY.table.lsql.r34.lpatch

The patch files is now approved and will be used in subsequent import operations.

Note that approving a pending patch file is equivalent to manually renaming the pending patch file as shown above.

Although pending patch files will be ignored during import, they will be executed (and therefore tested) in patch test mode.

Do note: Any statements created by Lure in the patch file have to be carefully reviewed and updated by the developer. Lure does not correctly recognize when a column or table name was renamed. Lure will instead interpret this as a drop (column/table) and add (column/table). Also, currently Lure can only add ALTER statements for columns. Any other table property or storage changes have to be added manually in the patch file.

configure_lure_to_create_pending_patch_files_automatically.txt · Last modified: 2013/07/30 08:07 by admin

Page Tools