root/as3/ChartData/samples/SQLCharts.as

import flash.events.*;
import flash.filesystem.*;
import mx.events.*;
import flash.data.SQLConnection;
import mx.collections.ArrayCollection;
import org.libspark.utils.SqlUtil;
import org.libspark.snippets.controls.SQLDataGrid;
import org.libspark.snippets.controls.ChartData.FusionCharts.SingleChartData;

private var connection:SQLConnection = null;
private var htmlFile:File = null;
private var dataFile:File = null;
private var dgSQLResult:SQLDataGrid = new SQLDataGrid();

private var chartType:String = "Column2D";

private function onSQLChange(event:KeyboardEvent):void {
    if (event.keyCode == Keyboard.ENTER) {
        executeSQL(tSQL.text);
    }
}

private function executeSQL(sql:String): void {
    trace("executeSQL", sql);
    dgSQLResult.executeQuery(sql);
    if (dgSQLResult.dataProvider != null)
        updateChart();
}

private function updateChart():void {
    trace("updateChart");
    var chartData:SingleChartData = new SingleChartData();
    chartData.graphAttribute.decimalPrecision = "0";
    chartData.graphAttribute.formatNumberScale = "0";
    for each (var val:* in dgSQLResult.dataProvider)
        chartData.addSetElement(val);
    chartData.createHtmlFile(htmlFile, chartType, 600, 350, dataFile.nativePath);
    chartData.createDataFile(dataFile);
    html.location = "file:///" + htmlFile.nativePath;
}

/*
 * Initialize application
 */
private var prefFile:String = "preference.xml";
private var prefList:ArrayCollection = new ArrayCollection();

private function init():void {
    dgSQLResult.x = 10; dgSQLResult.y = 406; dgSQLResult.width = 620; dgSQLResult.height = 164;
    addChild(dgSQLResult);
    htmlFile = File.applicationStorageDirectory.resolvePath("tempChart.html");
    dataFile = File.applicationStorageDirectory.resolvePath("tempData.xml");
    tSQL.addEventListener(KeyboardEvent.KEY_UP, onSQLChange);
    createMenus();
}

/*
 * Create application menus
 */
private var rootMenu:NativeMenu = null;
private var adminMenu:NativeMenuItem = null;
private var openDatabaseMenuItem:NativeMenuItem = null;
private var closeDatabaseMenuItem:NativeMenuItem = null;
private var chartMenu:NativeMenuItem = null;
private var column2dMenuItem:NativeMenuItem = null;
private var column3dMenuItem:NativeMenuItem = null;
private var pie2dMenuItem:NativeMenuItem = null;
private var pie3dMenuItem:NativeMenuItem = null;
private var line2dMenuItem:NativeMenuItem = null;
private var bar2dMenuItem:NativeMenuItem = null;
private var area2dMenuItem:NativeMenuItem = null;
private var doughnut2dMenuItem:NativeMenuItem = null;
private function createMenus():void {
      if (NativeApplication.supportsMenu) {
          rootMenu = NativeApplication.nativeApplication.menu;
      } else if (NativeWindow.supportsMenu) {
          rootMenu = new NativeMenu();
          stage.nativeWindow.menu = rootMenu;
      }
      if (rootMenu != null) {
          adminMenu = new NativeMenuItem("Admin");
          var adminSubMenu:NativeMenu = new NativeMenu();
          openDatabaseMenuItem = new NativeMenuItem("Open Database");
          openDatabaseMenuItem.addEventListener(Event.SELECT, OpenDatabase);
          adminSubMenu.addItem(openDatabaseMenuItem);
          closeDatabaseMenuItem = new NativeMenuItem("Close Database");
          closeDatabaseMenuItem.enabled = false;
          closeDatabaseMenuItem.addEventListener(Event.SELECT, CloseDatabase);
          adminSubMenu.addItem(closeDatabaseMenuItem);
          adminMenu.submenu = adminSubMenu;
          rootMenu.addItem(adminMenu);
          
          chartMenu = new NativeMenuItem("Charts");
          var chartSubMenu:NativeMenu = new NativeMenu();
          column2dMenuItem = new NativeMenuItem("Column2D");
          column2dMenuItem.addEventListener(Event.SELECT, Column2D);
          column2dMenuItem.checked = true;
          chartSubMenu.addItem(column2dMenuItem);
          column3dMenuItem = new NativeMenuItem("Column3D");
          column3dMenuItem.addEventListener(Event.SELECT, Column3D);
          chartSubMenu.addItem(column3dMenuItem);
          pie2dMenuItem = new NativeMenuItem("Pie2D");
          pie2dMenuItem.addEventListener(Event.SELECT, Pie2D);
          chartSubMenu.addItem(pie2dMenuItem);
          pie3dMenuItem = new NativeMenuItem("Pie3D");
          pie3dMenuItem.addEventListener(Event.SELECT, Pie3D);
          chartSubMenu.addItem(pie3dMenuItem);
          line2dMenuItem = new NativeMenuItem("Line2D");
          line2dMenuItem.addEventListener(Event.SELECT, Line2D);
          chartSubMenu.addItem(line2dMenuItem);
          bar2dMenuItem = new NativeMenuItem("Bar2D");
          bar2dMenuItem.addEventListener(Event.SELECT, Bar2D);
          chartSubMenu.addItem(bar2dMenuItem);
          area2dMenuItem = new NativeMenuItem("Area2D");
          area2dMenuItem.addEventListener(Event.SELECT, Area2D);
          chartSubMenu.addItem(area2dMenuItem);
          doughnut2dMenuItem = new NativeMenuItem("Doughnut2D");
          doughnut2dMenuItem.addEventListener(Event.SELECT, Doughnut2D);
          chartSubMenu.addItem(doughnut2dMenuItem);
          chartMenu.submenu = chartSubMenu;
          rootMenu.addItem(chartMenu);
     } else {
          trace("rootMenu is null");
     }
}

/*
 * Menu Event Handlers
 */
private function OpenDatabase(event:Event):void {
    var file:File = new File();
    var filter:FileFilter = new FileFilter("DB File", "*.db");
    file.browseForOpen("Open Database file (*.db)", [filter]);
    file.addEventListener(Event.SELECT, dbFileSelected);
}

private function dbFileSelected(event:Event):void {
    title = "SQLite & Charts - " + event.target.nativePath;
    connectionOpen(File(event.target), SQLMode.READ);
}

private function connectionOpen(file:File, mode:String):void {
    if (connection != null) {
        if (connection.connected) {
            try {
                connection.close();
            } catch (error:Error) {
                trace("Failed:", error.message);
            }
        }
    }

    connection = new SQLConnection();
    try {
        connection.open(file, mode);
        dgSQLResult.sqlConnection = connection;
        openDatabaseMenuItem.enabled = false;
        closeDatabaseMenuItem.enabled = true;
    } catch (error:Error) {
        trace("Failed:", error.message);
    }
}

private function CloseDatabase(event:Event):void {
    connectionClose();
    openDatabaseMenuItem.enabled = true;
    closeDatabaseMenuItem.enabled = false;
    callLater(updateTitle);
}

private function connectionClose():void {
    if (connection != null)
        if(connection.connected)
            connection.close();
}

private function updateTitle():void {
    title = "SQLite & Charts";
}

private function clearCheck():void {
    column2dMenuItem.checked = false;
    column3dMenuItem.checked = false;
    pie2dMenuItem.checked = false;
    pie3dMenuItem.checked = false;
    line2dMenuItem.checked = false;
    bar2dMenuItem.checked = false;
    area2dMenuItem.checked = false;
    doughnut2dMenuItem.checked = false;
}

private function Column2D(event:Event):void {
    trace("Column2D");
    clearCheck();
    column2dMenuItem.checked = true;
    chartType = "Column2D";
    if (dgSQLResult.dataProvider != null)
        updateChart();
}

private function Column3D(event:Event):void {
    trace("Column3D");
    clearCheck();
    column3dMenuItem.checked = true;
    chartType = "Column3D";
    if (dgSQLResult.dataProvider != null)
        updateChart();
}

private function Pie2D(event:Event):void {
    trace("Pie2D");
    clearCheck();
    pie2dMenuItem.checked = true;
    chartType = "Pie2D";
    if (dgSQLResult.dataProvider != null)
        updateChart();
}

private function Pie3D(event:Event):void {
    trace("Pie3D");
    clearCheck();
    pie3dMenuItem.checked = true;
    chartType = "Pie3D";
    if (dgSQLResult.dataProvider != null)
        updateChart();
}

private function Line2D(event:Event):void {
    trace("Line2D");
    clearCheck();
    line2dMenuItem.checked = true;
    chartType = "Line";
    if (dgSQLResult.dataProvider != null)
        updateChart();
}

private function Bar2D(event:Event):void {
    trace("Bar2D");
    clearCheck();
    bar2dMenuItem.checked = true;
    chartType = "Bar2D";
    if (dgSQLResult.dataProvider != null)
        updateChart();
}

private function Area2D(event:Event):void {
    trace("Area2D");
    clearCheck();
    area2dMenuItem.checked = true;
    chartType = "Area2D";
    if (dgSQLResult.dataProvider != null)
        updateChart();
}

private function Doughnut2D(event:Event):void {
    trace("Doughnut2D");
    clearCheck();
    doughnut2dMenuItem.checked = true;
    chartType = "Doughnut2D";
    if (dgSQLResult.dataProvider != null)
        updateChart();
}