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  
Comments Add Comment Add patch


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 35 + 49 = ?

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