im.doctor/src/server/repository/mysql/topic.repo.js

/**
 * 会话议题库。
 *
 * author: Sand
 * since: 12/21/2016
 */
"use strict";

let ImDb = require('./db/im.db');

class TopicsRepo {
    constructor(){}

    /**
     * 查找议题.
     *
     * @param topicId
     * @param handler
     */
    static findOne(topicId, handler){
        let sql = "select id, session_id, name, create_time, end_by, end_time," +
            " start_message_id, end_message_id, description, status from topics where id = ?";

        ImDb.execQuery({
            sql: sql,
            args: [topicId],
            handler: handler
        });
    }

    /**
     * 获取会话中的议题。
     *
     * @param sessionId
     * @param handler
     */
    static findAllBySessionId(sessionId, handler){
        let sql = "select id, session_id, name, create_time, end_by, end_time," +
            " start_message_id, end_message_id, description, status from topics where session_id = ?";

        ImDb.execQuery({
            sql: sql,
            args: [sessionId],
            handler: handler
        });
    }
}

module.exports = TopicsRepo;