TypeScript Model.findOne方法代码示例

 /**
  * Get setting.
  * @param context
  * @param key
  */
 public async getSetting (context: any, key?: string): Promise<Setting> {
   let setting = await this.settingModel.findOne({
     where: { $and: [
       {context: { $eq: this.getContextString(context) }},
       {key: { $eq: key }}
     ]}
   });
   return this.parseSetting(setting);
 }

 findByUsername (username: string, callback: (error: any, result: any) => void) {
     this.schema_model.findOne({
         where: {
             username: username
         }
     })
         .then((data) => {
             return callback(null, data);
         })
         .catch((error) => {
             return callback(error, null);
         });
 }  

 findById (idItem: number, callback: (error: any, result: any) => void) {
     this.schema_model.findOne({
         where: {
             id: idItem
         }
     })
         .then((data) => {
             return callback(null, data);
         })
         .catch((error) => {
             return callback(error, null);
         });
 }

 /**
  * Remove setting.
  * @param context
  * @param setting key or setting instance.
  */
 public async removeSetting (context: any, setting: Setting | string): Promise<any> {
   let instance: Instance<any> = await this.settingModel.findOne({
     where: { $and: [
       {context: { $eq: this.getContextString(context) }},
       {key: { $eq: (typeof setting === 'string' ? setting : (setting as Setting).key) }}
     ]}
   });
   if (instance) {
     await instance.destroy();
     return true;
   }
   return false;
 }

  /**
   * Replace setting.
   * @param context
   * @param setting
   */
  public async replaceSetting (context: any, setting: Setting): Promise<any> {
    let instance = await this.settingModel.findOne({
      where: { $and: [
        {context: { $eq: this.getContextString(context) }},
        {key: { $eq: setting.key }}
      ]}
    });
    if (! instance) throw new Error('Setting key is not yet defined in the context store! (\''+setting.key+'\')');

    instance.set(setting);

    await instance.save();
  }

  /**
   * Set setting value.
   * @param context
   * @param key
   * @param value
   */
  public async setSetting (context: any, key: string, value: any): Promise<any> {
    let setting = await this.settingModel.findOne({
      where: { $and: [
        {context: { $eq: this.getContextString(context) }},
        {key: { $eq: key }}
      ]}
    });

    if (! setting) {
      throw new Error('Setting key is not yet defined in the context store!');
    }

    setting.set('value', value);
    await setting.save();
  }

  public async boot() {
    let Map: Model<any,any> = this.app.models['Map'];

    // Get all maps on server, sync with database.
    let mapList: any[] = await this.app.serverFacade.client.gbx.query('GetMapList', [-1, 0]);

    // Clear current list first.
    this.list = {};

    // TODO: Define interfaces for the maniaplanet return values.
    for (let data of mapList) {
      let exists = await Map.findOne({where: {uid: data.UId}});
      if (! exists) {
        let map = await Map.create({
          uid: data.UId,
          name: data.Name,
          author: data.Author,
          environment: data.Environnement
        });

        // Save created database model to local list.
        this.list[data.UId] = map;

      } else {
        // Name update?
        if (exists.name !== data.Name) {
          exists.set('name', data.Name);
          let map = await exists.save();
          this.list[data.UId] = map;
        } else {
          this.list[data.UId] = exists;
        }
      }
    }

    // The sync with db is done, now check the current map and set it in the this.current
    let currentMapInfo = await this.app.serverFacade.client.gbx.query('GetCurrentMapInfo', []);
    if (currentMapInfo) {
      this.current = this.list[currentMapInfo.UId];
    }
  }