// 引入模块
// for browser
<script src="/socket.io/socket.io.js"></script>
// for nodejs
const io = require('socket.io-client')

// 建立连接
const client = io('http://127.0.0.1:7170')
client.on('connect', () => {
  // 连接成功
})

curl -X POST http://127.0.0.1:7170/createTable -d '{"ns": "tt.test", "cols": {}}'

client.emit('createTable', 'tt.test', {
  name: { len: 10, type: 'string', encoding: 'utf8'},
  uptime: { type: 'double'},
  test: { len: 20, type: 'string', encoding: 'utf8'},
  rand: { len: 20, type: 'string', encoding: 'utf8'},
  bool: { type: 'bool', default: false },
  int: { len: 2, type: 'int' }, // int len: 1-6, 1: 128, 2: 128 * 256, 3: 128 * 256 * 256
  time: { type: 'time' },
  date: { len: 20, type: 'string', encoding: 'utf8'}
}, { update: true })

http://127.0.0.1:7170/tt.test/create?name=hehe&rand=165

test.create({
  name: 'test',
  uptime: 1.23123,
  test: 'hehedada',
  rand: '371893',
  bool: true,
  int: Acan.random(0, 99),
  time: 1592188598,
  date: '2020-06-15 10:36:56'
})

http://127.0.0.1:7170/tt.test/find?name=hehe&rand[$like]=165&$limit=10&$skip=0

test.find({
  name: 'test', // 全等于查询
  test: { $like: ['hehe', 'dada'] } // like模糊查询, 支持数组传入
  rand: { $in: ['123456', '234567'] } // 数组全等于查询
}, { limit: 10, skip: 0 })

http://127.0.0.1:7170/tt.test/findOne?name=hehe&rand[$like]=165&$skip=0

test.findOne({
  name: 'test', // 全等于查询
  test: { $like: ['hehe', 'dada'] } // like模糊查询, 支持数组传入
  rand: { $in: ['123456', '234567'] } // 数组全等于查询
}, { skip: 0 })

http://127.0.0.1:7170/tt.test/count?name=hehe&rand[$like]=165

test.count({
  name: 'test', // 全等于查询
  test: { $like: ['hehe', 'dada'] } // like模糊查询, 支持数组传入
  rand: { $in: ['123456', '234567'] } // 数组全等于查询
})