The db:create command fails if the database name contains a hyphen

[aledalgrande]

What you are doing?

The config file:

{
  "development": {
     "username": "postgres",
     "password": "",
     "database": "example-development",
     "dialect": "postgres",
     "host": "localhost"
  }
}

The command:

sequelize db:create

What do you expect to happen?

The database is created.

What is actually happening?

The code at https://github.com/sequelize/cli/blob/master/src/commands/database.js#L22 should be using quotes to make this work I think.

Output, either JSON or SQL

Error: syntax error at or near "-"

Dialect: postgres
Database version: 9.6.3
Sequelize CLI version: 3.0.0-3
Sequelize version: 4.8.4

[alexbakerdev]

Hey, this is still an issue, is it ok if we re-open it? I have made a PR that has tests and should fix the issue. Which is also a big problem for connection string usage, as you cannot wrap the database name with quotes as double-quotes get encoded by url.parse to %22.

[alexbakerdev]

@sushantdhiman

[alexbakerdev]

I misread this thread, the issue has been fixed in 3.0.0.