VeighNa框架的MySQL数据库接口
说明
基于peewee开发的MySQL数据库接口。
使用
全局配置
在VeighNa中使用MySQL时，需要在全局配置中填写以下字段信息：
| 名称 | 含义 | 必填 | 举例 |
|---|---|---|---|
| database.name | 名称 | 是 | mysql |
| database.host | 地址 | 是 | localhost |
| database.port | 端口 | 是 | 3306 |
| database.database | 实例 | 是 | vnpy |
| database.user | 用户名 | 是 | root |
| database.password | 密码 | 是 | 123456 |
创建实例（Schema）
VeighNa不会主动为MySQL数据库创建实例，所以使用前请确保database.database字段中填写的的数据库实例已经创建了。
若实例尚未创建，可以使用【MySQL Workbench】客户端的【new_schema】进行操作。
字符串大小写敏感支持
由于peewee的建表功能限制，默认情况下在保存合约代码的【symbol】字段时，无法区分字符串大小写。如果影响使用，可按照以下方式手动修改MySQL数据表来解决：
# 用MySQL命令行工具连接数据库
# 选择数据实例
use vnpy;
# 修改四张表symbol字段的BINARY属性
ALTER TABLE `dbbaroverview` MODIFY COLUMN `symbol` VARCHAR(45) BINARY;
ALTER TABLE `dbtickoverview` MODIFY COLUMN `symbol` VARCHAR(45) BINARY;
ALTER TABLE `dbbardata` MODIFY COLUMN `symbol` VARCHAR(45) BINARY;
ALTER TABLE `dbtickdata` MODIFY COLUMN `symbol` VARCHAR(45) BINARY;
1 maintainer
Release files for vnpy_mysql 1.1.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| vnpy_mysql-1.1.1.tar.gz | 7.4 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| vnpy_mysql-1.1.1-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 14.6 kB
Release files / vnpy_mysql-1.1.1.tar.gz
| Download URL | vnpy_mysql-1.1.1.tar.gz |
|---|---|
| Size | 7.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
9b000563f52d3ce7070c17c3387493fa6876e9db600098d53a8f451c094212aa
|
|
BLAKE2b-256 checksum How to use checksums |
23645837f51ce41ef29c36bed0b30c53be83c18fb6ceb8d3f3e18ece7c53b6f7
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.6.11
|
Release files / vnpy_mysql-1.1.1-py3-none-any.whl
| Download URL | vnpy_mysql-1.1.1-py3-none-any.whl |
|---|---|
| Size | 7.2 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
3332043d39aabcff39e036ed240a917af1c0b9e0f4e3728b263b2df9ed18455b
|
|
BLAKE2b-256 checksum How to use checksums |
891b015ae71d31b93538ec6cd156ee5a9561eb654bcdda83d18d79596576fc40
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.6.11
|
