Add db:create and db:drop tasks about cli

[edorgeville]

@joost @Catchpowle @anthony-ism
Since March 10, 2016, it is possible to use emoji reactions on comments. Please use the 👍 reaction to show your interest instead of commenting "+1". This saves everyone in the thread a notification. If you want to get updates on the issue in the future, you can use the "Subscribe" button. Thank you ! 😄

[juliocanares]

@sushantdhiman I think the command sequelize db:drop must add IF EXISTS;

[sdepold]

PRs are welcome :)

[Epyon616]

Has anything been done on adding these? At present this is the only thing(s) stopping me from using sequelize in my companies project.

[itsashis4u]

sequelize db:create should have support for IF NOT EXISTS as a flag --if-not-exists

[elliotsabitov]

I also think that this feature would be very helpful.

[nicholaswagner]

Hahaha.. I also would love to see this feature. 👍

[sushantdhiman]

@Kae2312 are you just randomly commenting +1 on issues :), its already available in v3.0

[Telokis]

@itsashis4u There is an issue for this problem: #629.

@juliocanares There is an issue for this problem: #599

[sdepold]

Hi Cesar,

I agree :) In fact I actually created a ticket for that some time ago (as you have already seen).
The first step would be a PR for the sequelize core which adds the respective queries (as this is currently not implemented). I'd assume that this is fairly easy, but I'm not entirely sure. Once the core supports something like sequelize.createDatabase and sequelize.dropDatabase we can add the stuff to the CLI. This basically means, it would be necessary to add another key value pair here:

https://github.com/sequelize/cli/blob/master/lib/tasks/db.js#L81

[cesarandreu]

Oh, I completely forgot about that. I'll take a look, sounds good.

[anthonator]

Would love this. Does a ticket need to be opened at sequelize proper for adding sequielize.createDatabase and sequelize.dropDatabase?

[sdepold]

Hm, could not harm, though this ticket might be good enough already

[sladebot]

+1

[sadaf2605]

+1

[jackycute]

+1

[derrandz]

👍

[joaodiogocosta]

+1

[juniorplenty]

+1

[joost]

+1

[Catchpowle]

+1

[anthony-ism]

+1

[mmahalwy]

+1

[dorothythurston]

+1

[itsMattShull]

+1