service/module/Media.js

const DBModule = require('./DBModule');

class Media extends DBModule {

  get table() {
    return 'media'
  }

  get primary() {
    return 'id'
  }

  get fields() {
    return [
      'id', 'cover', 'text', 'zip', 'hide', 'language', 'type', 'sort'
    ]
  }

  query() {
    return super.query({
      sql: 'select * from media order by sort asc, id asc'
    })
  }
}

module.exports = exports = Media;