Skip to content

Classes for generate SQL queries (select/insert/update/delete) on different platforms (MySQL, MS SQL)

License

Notifications You must be signed in to change notification settings

wh1tew0lf/SQLBuilder

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

55 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

SQLBuilder

Classes for generate SQL queries (select/insert/update/delete) on different platforms (MySQL, MS SQL)

For run tests:

./vendor/bin/phpunit

For create documentation:

Don't forget install graphViz

sudo apt-get install graphviz

Run generation of php docs

./vendor/bin/phpdoc -p -d ./src -t ./docs/

For get metrics and statistics:

  • Shows some metrics
./vendor/bin/phpmetrics --report-html=./docs/metrics.html ./src/
  • Shows table of errors, code style problems and etc
./vendor/bin/phpmd ./src/ html cleancode,codesize,controversial,design,naming,unusedcode --reportfile ./docs/project_size.html
  • Shows duplicated code
./vendor/bin/phpcpd --progress ./src/ > ./docs/phpcpd_stat.txt
  • Shows summary for code
./vendor/bin/phploc ./src/ > ./docs/phploc_stat.txt

###To Do section

  • Check MSSQLPDO class and try transfer with it.
  • Check compliance of MS SQL and MySQL data types

###Can be done, but not necessary

  • Table transfer class from MySQL to MSSQL and from MS to My
  • Transfer from CSV and from MS to MS or My to My (Do I need to do it?)
  • Make tests (0.5%)
  • Make examples (2%)

###Purposes

  1. Provide tools for automatic copy/move tables from one db/engine to another if there are no access to mysql/mysqldump
  2. If you add CSVSource/CSVDestination (or other DB support) then it can be used for import/export CSV and etc.

About

Classes for generate SQL queries (select/insert/update/delete) on different platforms (MySQL, MS SQL)

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages