PHP Classes
elePHPant
Icontem

Update Environment: Update database and files from a remote server

Recommend this page to a friend!
  Info   View files Example   View files View files (12)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2016-06-09 (4 months ago) RSS 2.0 feedNot yet rated by the usersTotal: 748 All time: 4,294 This week: 579Up
Version License PHP version Categories
update-enviroment 2BSD License5.3PHP 5, Databases, Systems administration
Description Author

This class can update database and files from a remote server.

The main class can connect to a remote MySQL database using PDO and retrieve the list of tables to compare with the locale MySQL database synchronize the new tables that need to be created or the existing tables that need to be updated.

Another class can also synchronize files referenced by specific database table records as they contain data not stored in the database itself.

A list of specific tables may be intentionally excluded from the synchronization process.

Innovation Award
PHP Programming Innovation award winner
September 2012
Winner


Prize: One yearly subscription to the PHP Solutions magazine
Some database applications manage content information that can be large. Usually those application store large content in separate files and just keep a reference in the database to the data files.

In this situation, if you want to backup or synchronize the database contents you also need to transfer the data files.

This class provides a solution that can synchronize both the MySQL database data and any separate files associated to given table fields.

Manuel Lemos
Picture of Alexsandro Souza
  Performance   Level  
Name: Alexsandro Souza <contact>
Classes: 2 packages by
Country: Brazil Brazil
Innovation award
Innovation award
Nominee: 2x

Winner: 1x

Details
Update--Environment-QA
======================
Pacote que permite atualizar seu ambiente de desenvolvinmento/homologação apartir do ambiente de produção.

Esse componente atualiza seu ambiente com os dados dinâmicos do seu ambiente espelho, ou seja, apartir dos seus
dados de acesso dos bancos de dados local e espelho é possivel atualizar automaticamente seu banco local e  baixar os arquivos como
imagem, pdf e doc, inerentes aos registros do banco, de forma a manter a mesma estrutura do ambiente espelho.

Com esse componente combinado ao uso do GIT, torna muito fácil manter um ambiente de homologação fiel ao de produção

  Files folder image Files  
File Role Description
Files folder imageclass (4 files)
Files folder imagedownloaded (4 files)
Files folder imageexample (3 files)
Accessible without login Plain text file README.md Data Auxiliary data

  Files folder image Files  /  class  
File Role Description
  Plain text file DataBase.class.php Class Class source
  Plain text file Download.class.php Class Class source
  Plain text file RecordFilter.class.php Class Class source
  Plain text file UpdateDataBase.class.php Class Class source

  Files folder image Files  /  downloaded  
File Role Description
  Accessible without login Image file pendrive.gif Photo Photograph
  Accessible without login Plain text file test.pdf Data Auxiliary data
  Accessible without login Plain text file test2.pdf Data Auxiliary data
  Accessible without login Image file testeimage.png Photo Photograph

  Files folder image Files  /  example  
File Role Description
  Accessible without login Plain text file Customer.class.php Aux. Example script
  Accessible without login Plain text file index.php Example Example script
  Accessible without login Plain text file Product.class.php Aux. Example script

 Version Control Unique User Downloads Download Rankings  
 100%
Total:748
This week:0
All time:4,294
This week:579Up