QPM Package /
QView (Code Generator)
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.)
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
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