app_snippet.js

// add all items to collection
Alloy.Collections.Fugitive.reset([{
        "name" : "Jeff Haynie"
}, {
        "name" : "Nolan Wright"
}, {
        "name" : "Don Thorp"
}, {
        "name" : "Marshall Culpepper"
}, {
        "name" : "Blain Hamon"
}]);

// save all the items
Alloy.Collections.Fugitive.saveAll();


// get the collection object
Alloy.Collections.instance("Fugitive");


// delete all items
Alloy.Collections.Fugitive.deleteAll();

model.js

exports.definition = {

    function S4() {
        return (0 | 65536 * (1 + Math.random())).toString(16).substring(1);
    }
    
    function guid() {
        return S4() + S4() + "-" + S4() + "-" + S4() + "-" + S4() + "-" + S4() + S4() + S4();
    }

    config : {
        "columns" : {
            "name" : "TEXT",
            "captured" : "integer",
            "url" : "TEXT",
            "capturedLat" : "real",
            "capturedLong" : "real"
        },
        "defaults" : {
            "name" : "",
            "captured" : 0,
            "url" : "",
            "capturedLat" : "",
            "capturedLong" : ""
        },
        "adapter" : {
            "type" : "sql",
            "collection_name" : "fugitives"
        }
    },

    extendModel : function(Model) {
        _.extend(Model.prototype, {

        });
        // end extend

        return Model;
    },

    extendCollection : function(Collection) {
        _.extend(Collection.prototype, {

            deleteAll : function() {

                var collection = this;

                var sql = "DELETE FROM " + collection.config.adapter.collection_name;
                db = Ti.Database.open(collection.config.adapter.db_name);
                db.execute(sql);
                db.close();

                collection.trigger('sync');

            },

            saveAll : function() {
                var collection = this;

                var dbName = collection.config.adapter.db_name;
                var table = collection.config.adapter.collection_name;
                var columns = collection.config.columns;


                db = Ti.Database.open(dbName);
                db.execute("BEGIN;");
                
                collection.each(function(model) {

                    if (!model.id) {
                        model.id = guid();
                        model.attributes[model.idAttribute ] = model.id;
                    }

                    var names = [], values = [], q = [];
                    for (var k in columns) {
                        names.push(k);
                        values.push(model.get(k));
                        q.push("?");
                    }
                    var sqlInsert = "INSERT INTO " + table + " (" + names.join(",") + ") VALUES (" + q.join(",") + ");";

                    db.execute(sqlInsert, values);

                });
                
                db.execute("COMMIT;");
                db.close();

                collection.trigger('sync');
            }
        });
        // end extend

        return Collection;
    }
}