SQL Support for EasePHP Framework using FluentPDO
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.
Vítězslav Dvořák 85308f59f0 SQL Logger fixed 2 months ago
.github Create FUNDING.yml 2 years ago
Examples release v1.1 10 months ago
debian support for Ubuntu Jammy build added to Jenkinsfile 2 months ago
nbproject v1.0 release 1 year ago
src/Ease SQL Logger fixed 2 months ago
tests Sqlite updated 10 months ago
.gitignore mysql persistence 10 months ago
README.md Master merged into main 2 years ago
composer.json release v1.1 10 months ago
php-ease-fluentpdo.png Logo updated 1 year ago
php-ease-fluentpdo.svg use fresh packages 1 year ago
php-vitexsoftware-ease-fluentpdo-doc.svg Do not dev-depend on php-dotenv 12 months ago
phpunit.xml release v1.1 10 months ago

README.md

SQL Support for EasePHP Framework using FluentPDO

Project logo

Latest Stable Version Total Downloads Latest Unstable Version License Monthly Downloads Daily Downloads

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

GitHub: https://github.com/VitexSoftware/php-ease-fluentpdo