phpGroupWare Setup
Prev |  | Next

# Developer Tools

## sqltoarray.php

### Displays the current schema_proc array defining an application's tables.

This web application reads the current table status live from the database. It then parses this information into a hopefully correct table definition array for schema_proc. Upon visiting this app, you are shown a list of currently installed applications with defined tables. You may then select one app or all apps, and then submit the form. From this form you may then download a tables_current file, suitable for commission to cvs. Please do check the format to make sure the definitions are correct.

## schematoy.php

### Runs the full cycle of upgrades, including optional test_data.

This app is not beautiful, may bomb on you, and will definitely drop your application's tables. The display is similar to the user/admin tool, applications.php. You are shown a list of apps with tables. Select one app, and enter a target version. Upon submission of the form:

- All application tables are dropped.

- tables_baseline.inc.php is loaded.

- test_data.inc.php is loaded

- tables_update.inc.php is loaded.

- a full application upgrade test begins.

This will give a LOT of debugging output. Depending on your database, the process may take quite awhile. This tool should be considered as a destructive test of the full upgrade cycle. If the upgrade process is successful, you can then check the loaded test_data to see that it is still in place as expected after all the table modifications, etc. If not, it should be clear where the error has occurred. Look for the usual INVALID SQL warnings, among others.

## tools subdirectory

### some utilities for sql file conversion, etc.

In the tools directory under setup3, there should be at least a couple of hopefully handy perl or shell scripts. These are for running on the commandline only, and might apply to converting SQL files into lang files, etc. They are not expected to be perfect, but might offer some assistance or ideas for additional utilities. Use these at your own risk or benefit.

Prev | Home | Next
Application setup files |  | The install/upgrade process