| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 0.8.6 |
| Request #8645 | Add support for Views | ||
|---|---|---|---|
| Submitted: | 2006-09-06 21:40 UTC | ||
| From: | joeboe at gmail dot com | Assigned: | |
| Status: | Open | Package: | MDB2_Schema (version 0.6.0) |
| PHP Version: | 5.1.6 | OS: | N/A |
| Roadmaps: | (Not assigned) | ||
[2006-09-06 21:40 UTC] joeboe at gmail dot com
(Joshua Kaiser)
Description:
------------
We would like to use MDB2_Schema to help manage changes on the dev db's when pushing to beta and live stages. We use views in MySQL 5, which MDB2 seems to ignore. It would be nice to see this added.
Comments
[2006-09-07 13:35 UTC] lsmith
(Lukas Smith)
Thats a pretty huge step. Igor just added support for UPDATE and DELETE. So this way we now have support for WHERE clauses in the xml syntax. However for VIEWS we would need JOIN support to really make it worthwhile.
Maybe we need to explore adding a way to write certain (parts of) queries in plain SQL.
We would also need to add support for createView(), dropView() and listViews() (maybe even view reverse engineering) in MDB2.
I think your best chance if getting this feature is to work on it yourself. Maybe you can motivate Igor to invest time into it.
Personally I would love to get Foreign Key support before getting VIEW support.