This package adds support for table Views. It is a new package that works with the new 0.4.20 release.

It will allow you to create a view in MySQL >5 and use a datagrid or metadatagrid to show the table data. I have very simple needs for this, so I haven't gone in depth on expanding the functionality. Once the file is posted I will setup a forum thread for discussion.

Assumptions I have made:
No Create support
No Delete support
No Relationships(foreign keys)
No index support

As of right now. This first release only has MySQLi support. Adding MS SQL shouldn't be too hard. We just need to find the query that returns the MSSQL views and test it.
To download and install any of the QPM packages below, use the qpm-download command in your Qcodo installation, for example:
qcodo qpm-download socc78/qview

To upload your own update or version for this QPM package, use the qpm-upload command in your Qcodo installation, for example:
qcodo qpm-upload -p your-password your-username/qview

(Note that the "qcodo" command refers to the qcodo or qcodo.bat script in your cli directory.)
Previous|1|Next Results: Viewing items 1-1 of 1.
QPM Path for Version Version Notes Posted Reverse Sorted By
socc78/qview
built on Qcodo v0.4.20
QPM Package File Count | 63 new files | 10 changed files Jan 02 2011 11:35 PM

Comments

comments: 5 comments  |  last: a year ago


#1  |  ‹‹ Qcodo System Message ››
Sunday, January 2, 2011, 10:41 PM PST

A new version of this package was uploaded by Chris Peterson

#2  |  ‹‹ Qcodo System Message ››
Sunday, January 2, 2011, 11:00 PM PST

A new version of this package was uploaded by Chris Peterson

#3  |  Chris Peterson (Seattle, WA) United States of America Qcodo Core Contributor
Sunday, January 2, 2011, 11:04 PM PST

The first package was missing a file, i have added the file and re-tested it.  It appears to be working.

A few more notes, since I can not edit the description.  I use the default codegen.xml file so I haven't tested all the exclude tables and prefix stuff..  If there is a huge need I will see what I can do to add it.

Chris

#4  |  ‹‹ Qcodo System Message ››
Sunday, January 2, 2011, 11:31 PM PST

A new version of this package was uploaded by Chris Peterson

#5  |  ‹‹ Qcodo System Message ››
Sunday, January 2, 2011, 11:35 PM PST

A new version of this package was uploaded by Chris Peterson



Copyright © 2005 - 2012, Quasidea Development, LLC
This open-source framework for PHP is released under the terms of The MIT License.