How can I change the type of a property in Geddy

Question

How can I change the type of an existing property in Geddy?

I believe I need to change the type as set when defining the properties in the model file:

this.defineProperties({
  title: {type: 'string', required: true},
  description: {type: 'text'},
  status: {type: 'boolean'}
});

I also think I need to alter the table in a migration. I'm using the 'changeColumn' function as documented here http://geddyjs.org/guide#models

var StatusToBoolean = function () {
  this.up = function (next) {
    this.changeColumn("step", 'status', 'boolean', function (err, data) {
      if (err) { throw err; }
      next();
    });
  };

  this.down = function (next) {
    this.changeColumn('step', 'status', 'string', function (err, data) {
      if (err) { throw err; }
      next();
    });
  };
};

exports.StatusToBoolean = StatusToBoolean;

However, when I run this migration I get a 'SQLITE_ERROR: near "ALTER"' error:

Hindenburg:to_do Tom$ geddy jake db:migrate  --trace
Running migrations for development environment...
Running status_to_boolean (up)
jake aborted.
Error: SQLITE_ERROR: near "ALTER": syntax error
Hindenburg:to_do Tom$

This makes me think I'm doing something wrong. I tried the '--trace' option (as you can see), but that didn't give any helpful information.

I also suspect that I need to actually change some of the data in the table (so that it can map to the new datatype), but the documentation is unclear on how to do that.

Any help is appreciated. Thanks.

score 1 · Answer 1 · edited May 23 '17 at 10:31

1

Unfortunately SQLite doesn't support ALTER COLUMN (http://www.sqlite.org/lang_altertable.html). This is only a problem in the SQLite adapter, and it doesn't affect Postgres or MySQL. There are also workarounds, as described here: How do I rename a column in a SQLite database table? You could write a migration that performs these steps. Version 0.4.16 of Geddy's ORM (now on NPM) now includes a friendly error message when you try to do this with the SQLite adapter.

edited May 23 '17 at 10:31

Community

1
1

answered Jan 22 '14 at 05:50

mde

196
1
4

Indeed, that does seem to be the problem. It looks like I should I should be able to work around the issue by somehow modifying all the data in that column from the current value to 'true' or 'false' or whatever Geddy sticks in to columns that it creates as 'booleans'. – Tom Hennen Jan 22 '14 at 14:07

How can I change the type of a property in Geddy

1 Answers1