Download the PHP package yonna/database without Composer
On this page you can find all versions of the php package yonna/database. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Please rate this library. Is it a good library?
Informations about the package database
Yonna DB - ORM 库
如何安装
可以通过composer安装:composer require yonna/database
可以通过git下载:git clone https://github.com/yonna-framework/database.git
Yonna demo:GOTO yonna
ORM
连贯写法,全解耦,autoload后随意使用
DB自带各种分析优化,所以不再需要 Model层进行优化,可专心编写你的service(scope)
终结方法
one() multi() page() insert() insertAll() delete() count() sum() avg() min() max()
schemas() / table() 方法会进行一次clear,所以请放在前面
局部闭包(默认)
等于 ( "a" = 1 or "b" = 1 ) and( "c" = 1 or "d" = 1 or "e" = 1 )
全局闭包
等于 (( "a" = 1 or "b" = 1 ) or "c" = 1 or "d" = 1 or "e" = 1 )
插入后可以获取 lastInsertId(在无序列表中自动获取可能会产生严重的错误)
如果你只是想获取sql而不请求数据库,请使用 fetchSql()
JSON(pgsql)
搜索例子1
搜索例子2
前端json搜索语法
{project_name,name} % #TT || (({project_name,name} % #系统 || {project_name,name} != #xxx) && {server_pre_alert_limit,value} > #1 && ({server_pre_alert_limit,value} > #0 || {server_pre_alert_limit,value} < #100000000))
All versions of database with dependencies
PHP Build Version
Package Version
Requires
php Version
~7.4
ext-redis Version *
ext-json Version *
ext-pdo Version *
ext-mongodb Version *
yonna/foundation Version ~1.0
ext-redis Version *
ext-json Version *
ext-pdo Version *
ext-mongodb Version *
yonna/foundation Version ~1.0
The package yonna/database contains the following files
Loading the files please wait ....