Raw sql migrations

[a0nguyen]

In some case, I prefer using Raw sql to perform migrations, for ex:

• complex schema(s),
• taking advantage of vendor specific extensions to SQL (both DDL and DML)
• richer / additional data types
• using vendor specific procedural code (i.e. PL/pgSQL anonymous blocks in PostgreSQL)
  etc

Is there a way to do raw sql migrations in emmett?

[gi0baro]

@a0nguyen you can generate an empty migration as described in the docs using the relative command

emmett migrations new -m "Some name here"

then you can use the executesql command to run whatever SQL query you prefer in the migration up and down methods, eg:

def up(self):
    # runs when migration is applied
    self.db.executesql("ALTER TABLE ...")

def down(self):
    # runs when downgraded to previous
    self.db.executesql("ALTER TABLE...")

you can also avoid to write down commands, but ensure to raise some error so it's clear migration cannot be downgraded.