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)    
Subscription  
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes. If this is not your bug, you can add a comment by following this link. If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
2006-09-07 13:35 UTC
Package:
Bug Type:
Summary:
From: joeboe at gmail dot com
New email:
PHP Version: Package Version: OS:

 

 [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.