service/module/HomeNews.js

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

class HomeNews extends DBModule {

  get table() {
    return 'home_news'
  }

  get primary() {
    return 'id'
  }

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

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

module.exports = exports = HomeNews;