solve / 数据库
数据库引擎
v2.0.19
2015-07-20 02:59 UTC
Requires
- php: >=5.3.0
- solve/datatools: *
- solve/fsservice: *
- solve/graphics: >=1.0.2
- solve/inflector: >=1.0.3
- solve/storage: >=1.0.2
- dev-master
- 2.0.x-dev
- v2.0.19
- v2.0.18
- v2.0.17
- v2.0.16
- v2.0.15
- v2.0.14
- v2.0.13
- v2.0.12
- v2.0.11
- v2.0.10
- v2.0.9
- v2.0.8
- v2.0.7
- v2.0.6
- v2.0.5
- v2.0.4
- v2.0.3
- v2.0.2
- v2.0.1
- v2.0
- v1.0.29
- v1.0.28
- v1.0.27
- 1.0.26
- v1.0.25
- v1.0.24
- v1.0.23
- v1.0.22
- v1.0.21
- v1.0.20
- v1.0.19
- v1.0.18
- v1.0.17
- v1.0.16
- v1.0.15
- v1.0.14
- v1.0.13
- v1.0.12
- v1.0.11
- v1.0.9
- v1.0.8
- v1.0.7
- v1.0.6
- v1.0.5
- v1.0.4
- v1.0.3
- v1.0.2
- v1.0.1
- v1.0.0
This package is auto-updated.
Last update: 2024-08-26 23:31:51 UTC
README
解决框架的数据库组件
已完成
QC
MysqlDBAdaptor
DBOperator
ModelOperator
ModelStructure
Model
ModelCollection
ModelRelation
SlugAbility
TranslateAbility
FilesAbility (+thumbnails)
Validation
需要实现
排序能力 时间跟踪能力 树形能力 历史能力 动态能力
分页器
示例模型结构
品牌
table: brands columns: id: type: 'int(11) unsigned' auto_increment: true title: type: varchar(255) indexes: primary: columns: - id relations: products: { } # here we have autodetect for model, for relation type and related field names
类别
table: categories columns: id: type: 'int(11) unsigned' auto_increment: true title: type: varchar(255) indexes: primary: columns: - id relations: products: { }
产品
table: products columns: id: type: 'int(11) unsigned' auto_increment: true title: type: varchar(255) id_brand: type: 'int(11) unsigned' indexes: primary: columns: - id relations: brand: { } categories: { }
简单操作
$product = Product::loadOne(1); $product->title = 'Macbook air'; $product->save(); $product = new Product(); $product->title = 'Macbook pro' $product->save(); $list = Product::loadList(QC::create()->where('id < :d', 3)); //$list->loadRelated('brand'); - optional echo $list->getFirst()->brand->id; $list->getFirst()->setRelatedBrand(1); // set related by id