We've updated the DAO-Ext AIR tool for generating DAO and ActionScript Value Objects. We've just fixed some small bugs and added the auto-update. We're working on some documentation too.
If you want to join the project and contribute this is the right time ;) Feel free to contact us.
DAO-Ext is an Adobe
AIR tool that allows developers to automatically generate ActionScript
Data Access Objects (DAO) and Value Objects starting from a local
SQLite database. The project is totally free and open source.
For this first release the tool allows developers to:
- Select a local SQLite database and load a SQLite schema
- Generate for each table an ActionScript VO and an ActionScript DAO
- All the DAO objects are generated as singleton classes and use the ActionScript Value Object as itemClass of the row of the table
- The ActionScript Value Objects are Bindlable object
- Export all the AS VO and DAO of the tables in a click
- Show/hide a log window Choose the folder to store the generated classes
The DAO-Ext tool has beend released by Comtaste as an open source project. You can easily download the AIR file and install on your desktop (cross platform) and start using it to auto-generate ActionScript Value objects and Data Access Object (DAO) classes.






















Thanks for that. :)
Posted by: Jeffrey Gilbert | March 24, 2009 at 04:59 PM
I also found it handy to pass an object to the VO when creating it rather than setting each value manually. It allowed me to quickly turn SQL results into VO's
ex:
public function QuestionsVO(defaults:Object = null) {
if(defaults != null){
if(defaults.id != null) { this.id = defaults.id; }
if(defaults.question != null) { this.question = defaults.question; }
if(defaults.categoryID != null) { this.categoryID = defaults.categoryID; }
if(defaults.a != null && defaults.a != '') { this.a = defaults.a; answerLength +=1; }
if(defaults.b != null && defaults.b != '') { this.b = defaults.b; answerLength +=1; }
if(defaults.c != null && defaults.c != '') { this.c = defaults.c; answerLength +=1; }
if(defaults.d != null && defaults.d != '') { this.d = defaults.d; answerLength +=1; }
if(defaults.e != null && defaults.e != '') { this.e = defaults.e; answerLength +=1; }
if(defaults.answer != null) { this.answer = defaults.answer; }
if(defaults.explanation != null) { this.explanation = defaults.explanation; }
if(defaults.reference != null) { this.reference = defaults.reference; }
if(defaults.points != null) { this.points = defaults.points; }
}
}
Posted by: Jeffrey Gilbert | March 24, 2009 at 05:02 PM
What a facinating article. I’m looking for a marketing expert to help with a project, could you help? Please come visit my site mutual fund when you got time.
Posted by: investment advisor | July 27, 2009 at 09:34 AM