数据库任务和查询构建的一些辅助工具。

0.1.0 2022-07-26 17:09 UTC

This package is auto-updated.

Last update: 2024-09-17 15:44:17 UTC


README

()

数据库任务和查询构建的一些辅助工具。

内容

  • Parser\ObjectParser
  • ArrayUtil
  • 高亮
  • 图标
  • 选项

安装

composer require inanepain/db

用法

$qb = new SQLQueryBuilder();
$query = $qb
    ->select('users', ['name', 'email', 'password'])
    ->where('age', 18, '>')
    ->where('age', 30, '<')
    ->limit(10, 20);


echo "-- Testing MySQL query builder:\n";
echo $qb->getSQLFor(new MysqlQueryBuilder());

echo "\n\n";

echo "-- Testing PostgresSQL query builder:\n";
echo $qb->getSQLFor(new PostgresQueryBuilder());

这将为您提供

-- Testing MySQL query builder:
SELECT name, email, password FROM users WHERE age > 18 AND age < 30 LIMIT 10, 20;

-- Testing PostgresSQL query builder:
SELECT name, email, password FROM users WHERE age > 18 AND age < 30 LIMIT 10 OFFSET 20;