wukongdontskipschool / laravel-doris
This laravel extension adds support for doris and starrocks to the query builder and eloquent.
dev-master
2025-01-15 09:30 UTC
Requires
- php: ^7.4|^8.0
- illuminate/database: *
This package is auto-updated.
Last update: 2025-06-15 10:21:10 UTC
README
让drois和starrocks直接使用查询构造器和ORM
This laravel extension adds support for doris and starrocks to the query builder and eloquent.
另外有支持cte的版本
There are also versions that support cte
Require
mysqli
PDO
Installation
composer require "wukongdontskipschool/laravel-doris":"2.0.0.2-dev"
// cte
composer require "wukongdontskipschool/laravel-doris":"dev-cte-2.0.0.2"
Use
// config/database.php
// connections inside add
'doris' => [
'driver' => 'doris',
'url' => env('DORIS_DATABASE_URL'),
'host' => env('DORIS_DB_HOST', '127.0.0.1'),
'port' => env('DORIS_DB_PORT', '9030'),
'database' => env('DORIS_DB_DATABASE', 'forge'),
'username' => env('DORIS_DB_USERNAME', 'forge'),
'password' => env('DORIS_DB_PASSWORD', ''),
'charset' => env('DB_CHARSET', 'utf8mb4'),
'collation' => env('DB_COLLATION', 'utf8mb4_unicode_ci'),
'prefix' => env('DB_PREFIX', ''),
'strict' => env('DB_STRICT_MODE', true),
'options' => [
// 连接超时时间秒 Connection timeout time Second
PDO::ATTR_TIMEOUT => 3,
// 是否数值类型转字符串 Whether numeric type is converted to string
PDO::ATTR_EMULATE_PREPARES => false
]
],
Lumen需额外注册 Lumen Additional registration required
// bootstrap/app.php
// add
$app->register(\Wukongdontskipschool\LaravelDoris\DatabaseServiceProvider::class);
备注 Remark
insert() 是不会返回id,需要自己获取
It will not return the id, you need to get your own
delete() 影响的行数始终返回0
The number of rows affected always returns 0
cursor() 不是真的游标,doris还是会一次性全部返回
It's not a real cursor. doris will still return all at once
Versions
Laravel | Package |
---|---|
11.x | unknown |
10.x | 2.0.0.x |
9.x | unknown |
8.x | 2.0.0.x |
7.x | unknown |
6.x | unknown |
5.8 | unknown |
5.5–5.7 | unknown |
升级事项 Upgrade Notes
1.x 升级到 2.x
- DB::connection('doris')->table($tableName)->get();
元素由数组升级为和mysql相对应的对象结构
The element is upgraded from an array to an object structure corresponding to mysql - 支持事务(支持的sql需要参考不同版本的doris)
Support transaction (The supported sql needs to refer to different versions of doris) - 插入二进制时转为明文字符串
Converts to plaintext string when inserting binary