this.raw in migrations doesn't work

[nrempel]

I'm trying to use this.raw in migrations to alter existing columns since knex doesn't support this yet: knex/knex#46, knex/knex#1759

When I try to execute the following command:

this.raw('alter table users alter column company_id set not null;');

I get the following error:

error: alter table users alter column company_id set not null; - bind message supplies 1 parameters, but prepared statement "" requires 0

Turning on the debug flag shows the following:

[ { method: 'raw',
    sql: 'alter table users alter column company_id set not null;',
    bindings: [ 'function (table) {\n    self._decorateTable(table)\n    callback(table)\n  }' ],
    options: {},
    __knexQueryUid: 'f6d51eb0-59b0-453a-b77a-9eff6a2d5612' } ]

Trying to follow the docs, I tried:

this.raw('alter column company_id set not null;').table('users');

And received this error: TypeError: Cannot read property 'table' of undefined

Any help would be appreciated.

Thanks!

[elhigu]

<any-help>Do you have more complete example somewhere. Your code does not show, where this is coming from. In knex you would usually use knex.raw or knex.schema.raw... Anyways I don't know anything about adonis-lucid so this might not be helpful at all :)</any-help>

[nrempel]

Thanks @elhigu! I've looked into this a bit and it's not and issue with knex at all.

Actually, it turns out updating adonis-lucid to 3.0.9 fixes the problem.

All good!

[hendra1]

on your schema, you can try this one:
this.db.raw('your raw command')