Schema: Add ability to drop indexes about orm HOT 19 CLOSED

@Marlysson I'm not sure. @corentinalcoy will have to comment. If hes not working on it i'll assign it to you

from orm.

@josephmancuso can I have this one?

from orm.

Yes. The API should look like this: https://orator-orm.com/docs/0.9/schema_builder.html#dropping-indexes

from orm.

I think you should add index, primary functions before to complete this issue

from orm.

for adding constraints?

from orm.

Yes

from orm.

Yes @Marlysson is working on something here #46

from orm.

I thought that he works just on foreign keys.

I am talking about this https://orator-orm.com/docs/0.9/schema_builder.html#adding-indexes

from orm.

You are right. we have primary keys already but we may need to add normal indexes first

from orm.

You are right. we have primary keys already but we may need to add normal indexes first

orm/tests/schema/mysql/test_mysql_schema.py

Line 265 in bb26afa

def can_compile_primary_key(self):

The simple MySQL request to a drop primary key is alter table table_name drop primary key
I don't get why we need to pass an argument to drop_primary

from orm.

I can add index methods

from orm.

@corentinalcoy Ok awesome you can work on this issue #76

from orm.

You are right. we have primary keys already but we may need to add normal indexes first

orm/tests/schema/mysql/test_mysql_schema.py

Line 265 in bb26afa

def can_compile_primary_key(self):

The simple MySQL request to drop primary key is alter table table_name drop primary key
I don't get why we need to pass an argument to drop_primary

@josephmancuso And this?

from orm.

hmm not sure. You can have multiple columns as a primary key though. For now I guess just build no parameters going to it and later we can add support for things like composite keys

from orm.

@josephmancuso On #46 I'll add constraints and drop index of type foreign key.

With #76 created ( talking about unique index ), how to handle the unique constraint already created? Who does this, he will make git pull before?

from orm.

All these things can really happen at the same time. We just need to make sure the format is correct

from orm.

@corentinalcoy If you aren't working in this... @josephmancuso can you assign me to this?

from orm.

I am testing...
It will be done in a few hours

from orm.

@josephmancuso
I found some 'errors' in the project.
I will show when I will turn on my computer..

from orm.