search

atk4 / schema

Few classes built on top of Agile Data that can take care of your SQL database schema
https://agiletoolkit.org/
MIT License
4 stars 5 forks source link

Add option for INDEX/UNIQUE keys #31

Open mvorisek opened 4 years ago

mvorisek commented 4 years ago

Single and compound indexes should be supported.

mvorisek commented 4 years ago

@DarkSide666, @romaninsh Help wanted, wdyt?

DarkSide666 commented 4 years ago

That could be useful of course, but probably will not be that easy to implement because we don't define indexes (especially compound ones) anywhere in agile data. So there is no source of information for schema to work with.

mvorisek commented 4 years ago

That could be useful of course, but probably will not be that easy to implement because we don't define indexes (especially compound ones) anywhere in agile data. So there is no source of information for schema to work with.

For start it will be enought to be able to define them after the table is modelled (with setModel or manually or imported).

DarkSide666 commented 4 years ago

Yes probably.

I'm not hoping that atk/schema will be completely looseless converter from data model to DB structure and back. Especially if we want to support other DB persistences like Oracle, NoSQL etc. Each DB engine does something differently. Even multiple same engine versions have quite big differences sometimes...