text: /*
   * MIT License
   *
   * Copyright (c) 2017 SmartestEE Co,Ltd..
   *
   * Permission is hereby granted, free of charge, to any person obtaining a copy
   * of this software and associated documentation files (the 'Software'), to deal
   * in the Software without restriction, including without limitation the rights
   * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
   * copies of the Software, and to permit persons to whom the Software is
   * furnished to do so, subject to the following conditions:
   *
   * The above copyright notice and this permission notice shall be included in all
   * copies or substantial portions of the Software.
   *
   * THE SOFTWARE IS PROVIDED 'AS IS', WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
   * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
   * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
   * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
   * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
   * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
   * SOFTWARE.
   */
  
  /*
   * Revision History:
   *     Initial: 2017/07/29        Tang Xiaoji
   */
  
  'use strict';
  
  const {
    tables,
  } = require('../utils/mysqlKit');
  
  module.exports = app => {
    class Test extends app.Service {
      * multiQuery() {
        const client1 = app.mysql.get('db1');
        const res1 = yield client1.get(tables.user);
  
        const client2 = app.mysql.get('db2');
        const res2 = yield client2.get(tables.avatar);
  
        return {
          res: [
            res1,
            res2,
          ],
        };
      }
  
      * multiInsert() {
        const client1 = app.mysql.get('db1');
        const res1 = yield client1.insert(tables.user, {
          nickname: "ttt3",
          mobile: "15733204444",
          password: "dedeedede",
        });
        const client2 = app.mysql.get('db2');
        const res2 = yield client2.insert(tables.avatar, {
          avatar: 'dhwebdjwdewjdbewkdkwedbwejdbqkjbqkwjsbqwsjqkwbsqw',
        });
  
        return {
          res: [
            res1,
            res2,
          ],
        };
      }
  
      * knexTest() {
        const knex = require('knex')({
          client: 'mysql',
          connection: { // 指明连接参数
            host: '127.0.0.1',
            user: 'root',
            password: '123456',
            database: 'user',
          },
        });
  
        const k = knex.schema.withSchema('user').createTableIfNotExists('knex111', function(table) {
          table.increments();
          table.string('name');
          table.integer('age');
          table.timestamps();
        });
  
        const results = app.mysql.get('stds');
        console.log(results);
  
        return results;
      }
    }
    return Test;
  };
  