Patch Mechanism to modify database

OpenEMR Development
1

bradymiller wrote on Saturday, October 15, 2011:

Hi,

Just committed a patch mechanism that will allow database modifications during patch releases. Mechanism for future patches are described here:
http://open-emr.org/wiki/index.php/Patch_Mechanism

The next patch will use this mechanism to place about 10 mysql/index keys to improve performance of the clinical decision rules related stuff. If you want to test it out now, then place(only do this if using OpenEMR 4.1.0):

http://github.com/openemr/openemr/blob/rel-410/sql/patch.sql
TO sql/patch.sql

http://github.com/openemr/openemr/blob/rel-410/sql_patch.php
TO sql_patch.php

http://github.com/openemr/openemr/blob/rel-410/library/sql_upgrade_fx.php
TO library/sql_upgrade_fx.php

After you’ve placed the above files, then go to following in your web browser:
http://your_server/sql_patch.php

Then it will install the new mysql keys/indexes (if they do not already exist)

-brady

2

yehster wrote on Saturday, October 15, 2011:

Brady,
Very cool. Just added the indexes to my system with the mechanism.
Thanks

3

cverk wrote on Saturday, October 15, 2011:

Wow, you are amazing.  I don’t seem to have to wait for the little circle things to do stuff anymore. Maybe tomorrow I can figure out how to try Yehsters allscripts thing, because that would also be really helpful.

4

bradymiller wrote on Saturday, October 15, 2011:

Hi,

All of the above stuff is now part of the second 4.1 patch, which just got released.

Also added a mechanism to track/show the patch (via the $v_realpatch variable in version.php), which is displayed in the login page. For example 4.1.0 (2) means it is 4.1.0 with the second patch installed. This was directed towards Tony feedback in the past, which I think will be helpful for us and others providing support (now can easily gather what patch, if any, is installed).

Placed related documents on the wiki:
http://open-emr.org/wiki/index.php/OpenEMR_Wiki_Home_Page#Release_Process
http://open-emr.org/wiki/index.php/Patch_Mechanism
http://open-emr.org/wiki/index.php/Steps_for_a_patch_release

-brady