You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
|
3 weeks ago | |
---|---|---|
.github | 3 weeks ago | |
Examples | 6 months ago | |
debian | 2 months ago | |
nbproject | 8 months ago | |
src/Ease | 2 months ago | |
tests | 6 months ago | |
.gitignore | 3 months ago | |
Makefile | 7 months ago | |
README.md | 2 months ago | |
composer.json | 2 months ago | |
php-ease-fluentpdo.svg | 10 months ago | |
phpunit.xml | 9 months ago |
README.md
SQL Support for EasePHP Framework using FluentPDO
Installation
Download https://github.com/VitexSoftware/php-ease-fluentpdo/archive/master.zip or use
Composer:
composer require vitexsoftware/ease-fluentpdo
Linux
For Debian, Ubuntu & friends please use repo:
echo "deb http://repo.vitexsoftware.cz $(lsb_release -sc) main" | sudo tee /etc/apt/sources.list.d/vitexsoftware.list
sudo wget -O /etc/apt/trusted.gpg.d/vitexsoftware.gpg http://repo.vitexsoftware.cz/keyring.gpg
sudo apt update
sudo apt install php-vitexsoftware-ease-fluentpdo
In this case please add this to your app composer.json:
"require": {
"deb/ease-fluentpdo": "*"
},
"repositories": [
{
"type": "path",
"url": "/usr/share/php/EaseSQL",
"options": {
"symlink": true
}
}
]
Framework Constants
- DB_TYPE - pgsql|mysql|sqlsrv|sqlite
- DB_HOST - localhost is default
- DB_PORT - database port
- DB_DATABASE - database schema name
- DB_USERNAME - database user login name
- DB_PASSWORD - database user password
- DB_SETUP - database setup command (executed directly after connect)
Testing
At first you need initialise create sql user & database with login and password from testing/phinx.yml and initialise testing database by phinx migrate command:
make phpunit
Or initalize another database and update .env file
composer update
cd tests
mysqladmin -u root -p create easetest
mysql -u root -p -e "GRANT ALL PRIVILEGES ON easetest.* TO easetest@localhost IDENTIFIED BY 'easetest'"
sudo -u postgres bash -c "psql -c \"CREATE USER easetest WITH PASSWORD 'easetest';\""
sudo -u postgres bash -c "psql -c \"create database easetest with owner easetest encoding='utf8' template template0;\""
make prepare
Building
Simply run make deb
Links
Homepage: https://www.vitexsoftware.cz/ease.php