Php Object Generator Tutorials
  1. Introduction to POG
  2. Setting up PHP, MySQL etc.
  3. Designing your objects
  4. Generating your code
  5. Description of the generated code
  6. Edit configuration file
  7. The Setup Process
  8. Using the code: Save()
  9. Using the code: Get()
  10. Using the code: SaveNew()
  11. Using the code: GetList()
  12. Using the code: Delete()
  13. Using the code: DeleteList()
  14. Advanced: object relations
  15. Advanced: Set{Parent}()
  16. Advanced: Get{Parent}()
  17. Advanced: Add{Child}()
  18. Advanced: Get{Child}List()
  19. Advanced: Save(deep)
  20. Advanced: Delete(deep)
  21. Advanced: Add{Sibling}()
  22. Advanced: Set{Child}List()
  23. Advanced: Set{Sibling}List()
  24. Advanced: Get{Sibling}List()
  25. Advanced: DeleteList(deep)
  26. Customizing POG-generated code
  27. Customizing: Extending POG Objects
  28. Customizing: Plugins
  29. Examples
  30. Examples: User registration system
  31. Examples: User authentication
  32. Examples: Survey form
  33. Examples: Using POG with AJAX
  34. PDO: Introduction
  35. PDO: SQLite example
  36. PDO: Firebird example
  37. PDO: PostgreSQL example
  38. PDO: MySQL example
  39. PDO: ODBC example
  40. Troubleshooting
  41. Troubleshooting: Data appears encoded
  42. Troubleshooting: Can't regenerate object
  43. Troubleshooting: Can't seem to Save()
  44. Troubleshooting: Can't get object / object attributes from database
  45. Troubleshooting: Can't open zip file on Mac
  46. Troubleshooting: Setup screen is blank
  47. Videos
  48. Appendix: Creating table(s) manually
  49. Appendix: Regenerating objects
  50. Appendix: Generating objects using SOAP
  51. Case Study: Gravity GTD
  52. Case Study: Web Form Factory


Want more Php Object Generator?
Back to the Code Generator
The POG Weblog and RSS feed.
The POG Google group


The Setup Process


The setup process is a 3-step process which extends the usefulness of PHP Object Generator. It automates the actions the developer would normally do after code generation is performed. Here’s an overview of the 3 steps:

Step 1 gives instructions and explains what will happen in steup 2 and 3. Step 1 also allows you to choose from 3 options:

#Align objects with tables #Drop and recreate tables #Drop, recreate tables and initialize data

Align objects with tables
If this option is chosen, during step2, Setup will simply analyze your database and compare and align it with the objects in the /objects folder. If an object exists and there isn’t a corresponding table for it in the database, the table will be created. If there is already a table but the columns do not match the object attributes exactly, the table will be modified so that it corresponds to what’s been defined in the object. If both object and table are aligned, no further action is taken.

Drop and recreate tables
All tables that have a corresponding object in the /objects folder are dropped and recreated in step 2.

Drop, recreate tables and initialize data
Same as “Drop and recreate tables”, with 1 added functionality: After the tables are recreated, any SQL statement present in /setup/data_initialization.sql is executed. This is useful, if, for instance, your application requires some initialization data.

During Step 2, POG checks your configuration file, aligns your tables with the objects and performs unit testing on all the objects found in your /objects folder. If needed, POG Setup will create the table(s) for your object(s). If you decide later on to manually make code changes to your objects, running setup is an excellent and easy way to test if your objects still work properly. After all tests are completed, POG provides you with a set of diagnostic messages. If all tests succeeded, you will be able to proceed to step 3.

In Step 3, you’re provided with a light interface to your database objects.

Now, let’s begin the setup process. Once you’ve extracted the content of the zipped file into a file on your server, access the setup folder from within your browser as follows:

PHP code generator setup

You’ll be presented with a setup screen. This is the first of a 3-step process:

Read the instructions on the first page. When you’re done, click on the “POG ME UP” button at the bottom.

PHP code generator Pog Me Up

POG Setup will then perform unit testing and present you with some diagnostic messages. If everything went well, you should see something like this:

PHP code generator setup diagnostics

Clicking on the proceed button will push you to the 3rd step: A light interface to your database objects:

PHP code generator manage objects

This interface provides a way for you to quickly add, delete and update objects in your database. In short, it acts as a control panel at various stage of your development, where you can always come back to check on your objects.

For more information on how to use the objects in your own code, take a look at the “Using the code” series of articles. They cover the 5 CRUD methods and how to use them in your code.





POG documentation summary: