zrnik/mksql

MkSQL is a tool for keeping your tables up to date with PHP code. You can use it in your project or as a database preparation in your integration tests.

v0.10.0 2023-02-12 12:19 UTC

Requires

• php: >=8.0
• ext-pdo: *
• jetbrains/phpstorm-attributes: ^1.0
• nette/utils: ^3.0
• zrnik/enum: ^1

Requires (Dev)

• brick/date-time: ^0.3
• nette/neon: ^3
• phpstan/phpstan: ^1.8
• phpstan/phpstan-phpunit: ^1.3.4
• phpunit/phpunit: ^9
• tracy/tracy: ^2
• zrnik/phpunit-exceptions: ^0.0.5

MIT

• Štěpán Zrník

• sql
• mysql
• sqlite
• table
• create

README

Do not use this!

Use doctrine instead!

What is it?

So, I just found out that the thing I created is usually called an ORM and DBAL.

MkSQL is a tool for keeping your tables up to date with PHP code. It aims for a simple use cases, so it cannot handle very complex stuff. Explore the docs to see what is possible.

This package simply allows you to define entities, that represent your database tables, and automatically creates them for you.

You can also skip the ORM part and use Updater class to create your database without any entities, instead of creating them with Adminer (or PHPMyAdmin).

Documentation index is in docs/index.md file.

Requirements

This package requires you to run it with PHP 8+, as it uses the new stuff this version delivers. Mainly attributes and promoted constructor properties.

{
    "PHP": ">= 8",
    "ext-pdo": "*",

    "nette/utils": "^3.0",
    "zrnik/enum": "^1",
    
    "ext-iconv": "*",
    "ext-intl": "*"
}

Installation

composer require zrnik/mksql

Read more at Installation and Configuration page.

Supported Drivers:

• ✅ MySQL
• ✅ SQLite 3

This package contains a Tracy panel

Add this to your bootstrap file:

Tracy\Debugger::getBar()->addPanel(new \Zrnik\MkSQL\Tracy\Panel());

Or, if you are using Nette Framework, register it in your configuration file:

tracy: 
    bar: 
        - Zrnik\MkSQL\Tracy\Panel