esoastor/database-manager

此软件包最新版本（v0.0.19）没有提供许可证信息。

维护者

详细信息

github.com/esoastor/database-manager

源代码

问题

安装: 67

依赖项: 1

建议者: 0

安全性: 0

星标: 0

关注者: 1

分支: 0

公开问题: 0

v0.0.19 2023-03-18 06:53 UTC

Requires

  • php: >=8.0

Requires (Dev)

Unknown License be28c69d6be59528b501fb5cf507ea665cc347ad

This package is auto-updated.

Last update: 2024-09-18 10:13:43 UTC

README

现在支持Sqlite & Mysql

    require_once __DIR__ . '/vendor/autoload.php';

    use SqliteOrm\Schema\Sqlite\SqliteConstructor;

    $constructor = new SqliteConstructor();
    $blueprint = $constructor->getBlueprintBuilder();

    $constructor->createTable('test', [
        $blueprint->id(),
        $blueprint->text('login')->length(50)->notNull(),
        $blueprint->integer('number')->notNull(),
    ]);

    $test = $constructor->getDatabase('test');

    $insertData = [
        ['name' => 'Robert', 'surename' => 'Wolders', 'age' => '57'],
        ['name' => 'Jan', 'surename' => 'Vercauteren', 'age' => '51'],
        ['name' => 'Rutger', 'surename' => 'Hauer', 'age' => '61'],
        ['name' => 'Herbert', 'surename' => 'West', 'age' => '47']
    ];
    
    foreach ($insertData as $row) {
        $this->table->insert($row)->execute();
    }

    $test->count()->execute();
    $test->count()->where('surename', '=', 'Vercauteren')->where('age', '>', '0')->execute();

    $test->select(['name', 'age'])->execute();

    $test->update(['name' => 'aaa'])->where('name', '=', 'Abaddon')->execute();

    $test->delete()->where('surename', '=', 'Vercauteren')->execute();

测试

运行docker-compose-unittest.yml，检查database_manager的日志