[ALOY-1178] Models: Data not retrieved from/saved to a table altered via migration using a SQL statement
| GitHub Issue | n/a |
|---|---|
| Type | Improvement |
| Priority | Medium |
| Status | Open |
| Resolution | Unresolved |
| Affected Version/s | Alloy 1.6.0 |
| Fix Version/s | n/a |
| Components | Models |
| Labels | n/a |
| Reporter | Tim Poulsen |
| Assignee | Feon Sua Xin Miao |
| Created | 2014-10-22T18:42:31.000+0000 |
| Updated | 2015-06-08T17:39:22.000+0000 |
Description
Per http://developer.appcelerator.com/question/178611/data-is-not-saved-in-column-after-alter-table-through-alloy-migration
After applying a migration that alters a table structure, data saved to the new columns is not persisted to the SQLite database.
// from the sample app, annotated
function doClick(e) {
var m = Alloy.createModel('books');
m.fetch({id: e.row.rowid}) // rowid is the alloy_id primary key
Ti.API.info(JSON.stringify(m.toJSON()));
// {"title":"Changed","alloy_id":"d6bfe744-8e7a-9b24-c958-1e4275318276","pagecount":null}
m.save({title: 'Changed', pagecount: 200});
Ti.API.info(JSON.stringify(m.toJSON()));
// {"title":"Changed","alloy_id":"d6bfe744-8e7a-9b24-c958-1e4275318276","pagecount":200}
// but looking in the app's db, the pagecount column is still null
Alloy.Collections.books.fetch();
}
Attachments
| File | Date | Size |
|---|---|---|
| app.zip | 2014-10-22T18:42:31.000+0000 | 7221 |
| Screen Shot 2014-10-22 at 2.41.05 PM.png | 2014-10-22T18:42:31.000+0000 | 281563 |
On further investigation, this would never have worked with code as reported. The list of columns is built from the model definition. With a custom SQL command being used to alter the table, there's no way for the sync adapter to know of the existence of that new column. The way to deal with this is to use this technique for adding a new column to the table: First, create your migration file (e.g. with
alloy generate migration MODEL_NAME) Then, add code like this to that file:migration.up = function(migrator) { db.createTable({ "columns" : { "title" : "text", "pagecount": "integer" /* the new field */ }, "adapter": { "type": "sql", "collection_name": "books" } }); }; migration.down = function(db) { };