Symfony+Doctrine:为布尔字段的默认值正确的 YAML 语法

Symfony+Doctrine: Correct YAML syntax for default value of boolean field(Symfony+Doctrine:为布尔字段的默认值正确的 YAML 语法)
本文介绍了Symfony+Doctrine:为布尔字段的默认值正确的 YAML 语法的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在为我的 Symfony 应用程序处理架构,我需要将两个布尔字段的默认值设置为 false.但是,通过我尝试的所有方法,当生成 sql 时,它带有 default 关键字,但后面没有默认值.

I am working on the schema for my Symfony app, and I need to set the default value of two boolean fields to false. However, with all the ways I've tried to do it, when the sql gets generated, it comes out with the default keyword, but no default value after it.

我最后一次尝试是:

negotiable: 
    type: bool
    default: "false"
complete: 
    type: bool
    default: "false"

但我也尝试过 default: false, default: 'false', default: 0 因为 false 只是 0 的别名在 MySQL 中,default: '0'

but I have also tried default: false, default: 'false', default: 0 since false is just an alias for 0 in MySQL, and default: '0'

查询失败:

CREATE TABLE dormcode_project (id BIGINT AUTO_INCREMENT, client_id BIGINT, title VARCHAR(255), briefdesc LONGTEXT, spec LONGTEXT, coder_id BIGINT, paytype VARCHAR(30), negotiable bool DEFAULT , complete bool DEFAULT , created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, INDEX coder_id_idx (coder_id), INDEX client_id_idx (client_id), PRIMARY KEY(id)) ENGINE = INNODB

注意 negotiable bool DEFAULT , complete bool DEFAULT ,

我一直在使用的文件是 /config/doctrine/schema.yml 文件.我对 symfony/doctrine 有点陌生.我认为这是正确的,但我想我可能是错的.我在每次尝试插入 sql 之间执行 symfony cc 以确保它没有缓存架构.但它几乎似乎没有使用我一直在更改的文件......

The file I've been playing with is the /config/doctrine/schema.yml file. I'm kind of new to symfony/doctrine. I think this is the right one, but I guess I could be wrong. I do symfony cc between each attempt to insert the sql to make sure that it didn't cache the schema. But it almost seems like its not using the file I've been changing...

推荐答案

Boolean 是 TINYINT 的同义词.请改用 integer(1) 并将默认值设置为 0/1.

Boolean is a synonym for TINYINT. Use integer(1) instead and set your default to 0/1.

来源:

http://dev.mysql.com/doc/refman/5.5/en/numeric-type-overview.html

http://www.symfony-project.org/学说/1_2/en/04-Schema-Files

这篇关于Symfony+Doctrine:为布尔字段的默认值正确的 YAML 语法的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!

相关文档推荐

Hibernate reactive No Vert.x context active in aws rds(AWS RDS中的休眠反应性非Vert.x上下文处于活动状态)
Bulk insert with mysql2 and NodeJs throws 500(使用mysql2和NodeJS的大容量插入抛出500)
Flask + PyMySQL giving error no attribute #39;settimeout#39;(FlASK+PyMySQL给出错误,没有属性#39;setTimeout#39;)
auto_increment column for a group of rows?(一组行的AUTO_INCREMENT列?)
Sort by ID DESC(按ID代码排序)
SQL/MySQL: split a quantity value into multiple rows by date(SQL/MySQL:按日期将数量值拆分为多行)