Login   Register  
PHP Classes
elePHPant
Icontem

DB Version Manager: Update database schema with commands read in files

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (9)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2011-03-28 (3 years ago) RSS 2.0 feedNot enough user ratingsTotal: 303 All time: 6,586 This week: 1,543Up
Version License PHP version Categories  
dbversionmanager 0.9BSD License5XML, PHP 5, Databases, Files and Folders
Description Author  

DBVersionManager is a free software to handle trace of database
changes which are needed during application development.
In projects which use database, there might be a problem with
moving database changes (alters, drops, inserts etc) between several environments.
(eg. there might be several developers environmets, test environment
and production environment, and each of them uses own database).
DBVersionManager tries to simplify port database changes between environments.
It can be used with any database which are supported by PDO.

DBVersionManager reads the sql commands from a given location.
Then it tries to execute this commands on selected database.
On the second hand DBVersionManager remember which files where
executed to preserve executing each command more then once.

DBVersionManager offers also a simple GUI to execute sql queries
on a given environment.
Using a GUI is recomended for correct naming convention and executing
queries in proper order.

This class can update database schema with commands read in files.

It can read files in a given directory and executes the SQL commands using PDO extension.

Picture of Przemek Berezowski
Name: Przemek Berezowski <contact>
Classes: 3 packages by
Country: Poland Poland
Age: 36
All time rank: 141138 in Poland Poland
Week rank: 536 Up14 in Poland Poland Up

  Files folder image Files  
File Role Description
Files folder imageconf (1 file)
Files folder imagelib (3 files)
Files folder imageoutput (1 file)
Accessible without login Plain text file add.php Example Adds a query to list and execute it
Accessible without login Plain text file profile.php Conf. App profile configuration
Accessible without login Plain text file readme.txt Doc. what is it and how does it work
Accessible without login Plain text file update.php Example Updates current profile database

  Files folder image Files  /  conf  
File Role Description
  Accessible without login Plain text file configure.xml Data Profiles configurations

  Files folder image Files  /  lib  
File Role Description
  Plain text file config_manager.php Class Manages configuration for profile
  Plain text file db_updater.php Class Manages database updates
  Plain text file tools.php Class Helper class

  Files folder image Files  /  output  
File Role Description
  Accessible without login Plain text file dummy.txt Data Directory for store application output

 Version Control Unique User Downloads Download Rankings  
 0%Total:303All time:6,586
 This week:0This week:1,543Up