module.exports = {
  ApiBaseUrl: '/api/json/1.0/',
  getIpAddres: 'http://2019.ip138.com/ic.asp',
  mysql: {
    host     : '127.0.0.1',
    user     : 'root',
    password : 'lb714500',
    database : 'Novel',
    connectionLimit : 10
  },
  TargetUrl: {
    baseUrl: 'http://www.xbiquge.la/',
    class: {
      title: 'fenlei/',
      fantasy: {
        id: '1_',
        url: 'xuanhuanxiaoshuo/'
      },
      though: {
        id: '2_',
        url: 'xiuzhenxiaoshuo/'
      },
      urban: {
        id: '3_',
        url: 'dushixiaoshuo/'
      },
      passThrough: {
        id: '4_',
        url: 'chuanyuexiaoshuo/'
      },
      game: {
        id: '5_',
        url: 'wangyouxiaoshuo/'
      },
      scienceFiction: {
        id: '6_',
        url: 'kehuanxiaoshuo/'
      },
      hotlist: {
        url: 'paihangbang/'
      }
    }
  },
  sql: {
    index: {
      selectData: 'SELECT * FROM novel_book WHERE book_key = ? AND book_page = ?',
      selectSave: 'SELECT * FROM novel_book WHERE book_key = ? AND book_page = ?  AND book_hot = ?',
      inrset: 'INSERT INTO novel_book(book_title,book_introduce,book_img,book_author,book_time,book_url,book_hot,book_page,book_key) VALUES (?,?,?,?,?,?,?,?,?)',
      delete: 'DELETE FROM novel_book WHERE book_key = ? AND book_hot = 1'
    },
    user: {
      getUserInfo: 'SELECT * FROM novel_user WHERE id = ?',
      checkUser: 'SELECT * FROM novel_user WHERE user_phone = ?',
      login: 'SELECT id,user_phone,user_ip FROM novel_user WHERE user_phone = ? AND user_pwd = ?',
      userReg: 'INSERT INTO novel_user(user_phone,user_pwd,user_ip) VALUES (?,?,?)',
      checkBook: 'SELECT * FROM novel_collection WHERE collection_user = ? AND collection_bookid = ?',
      insertBook: 'INSERT INTO novel_collection(collection_user,collection_bookid) VALUES (?,?)',
      selectBook: 'SELECT * FROM novel_collection WHERE collection_user = ?',
      deleteBook: 'DELETE FROM novel_collection WHERE collection_user = ? AND collection_bookid = ?'
    }
  },
  apiStatus: {
    status: 200,
    data: null
  }
}