Jan 26

I don’t know why but the SQLColumnSchema class of the SQLite API does not return the DEFAULT value of a field, neither its UNIQUE attribute. This kind of information is needed when you have to explore the schema of your AIR database. Here is my solution.

Continue reading »

not goodquite goodgoodvery goodexcellent (No Ratings Yet)
Loading ... Loading ...

Written by Arnaud
Tags: , ,

Share/Save/Bookmark


Jan 03

The SQLite API that is provided by AIR has a very interesting and powerful feature: the loadSchema() method that returns the whole structure of a SQLite database as a SQLSchemaResult class.

The structure of the SQLSchemaResult can be illustrated by the following schema.Structure of the SQLSchemaResult class

This class is composed by 4 arrays: tables containing SQLTableSchema classes, views containing SQLViewSchemas, triggers for SQTriggerSchema and indices for SQLIndicesSchema.

SQLTableSchema and SQLViewSchema contain an array of SQLColumnSchema classes. Each SQLColumnSchema represents the fields in the tables (or views) of the database. This last class has properties as names, allowNull, primaryKey, dataType… that describes the field in the SQLite database.

As I am working on an AIR application that needs to analyze the structure of SQLite databases, I decided to convert the SQLSchemaResult to XML and then play with it. I think that it is really easier to perform the task that the application has to execute (the easiest way being the use of the HierarchicalData class but…).

Continue reading »

not goodquite goodgoodvery goodexcellent (1 votes, average: 5 out of 5)
Loading ... Loading ...

Written by Arnaud
Tags: ,

Share/Save/Bookmark


Jan 02

I would like to wish a happy, beautiful and successful year 2009 to every visitors, subscribers and people who tried by components.

Have fun with Flex, CMMI and Agile :D !


not goodquite goodgoodvery goodexcellent (No Ratings Yet)
Loading ... Loading ...

Written by Arnaud

Share/Save/Bookmark