{
  "fields": [
    {
      "belongPrimaryKey": true,
      "fieldName": "idx",
      "fieldType": "Integer",
      "isNeedEncrypt": false,
      "notNull": true
    },
    {
      "belongPrimaryKey": false,
      "fieldName": "zodiacName",
      "fieldType": "String",
      "isNeedEncrypt": false,
      "notNull": false
    }
  ],
  "indexes": [
    {
      "indexName": "idxIndex",
      "indexList": [
        {
          "fieldName": "idx",
          "sortType": "ASC"
        }
      ]
    },
    {
      "indexName": "zodiacIndex",
      "indexList": [
        {
          "fieldName": "zodiacName",
          "sortType": "DESC"
        }
      ]
    }
  ],
  "objectTypeName": "ZodiacObject",
  "permissions": [
    {
      "rights": [
        "Read"
      ],
      "role": "World"
    },
    {
      "rights": [
        "Read",
        "Upsert"
      ],
      "role": "Authenticated"
    },
    {
      "rights": [
        "Read",
        "Upsert",
        "Delete"
      ],
      "role": "Creator"
    },
    {
      "rights": [
        "Read",
        "Upsert",
        "Delete"
      ],
      "role": "Administrator"
    }
  ]
}

{
  "cloudDBZoneName": "cloudDBZoneZodiac",
  "objectTypeName": "ZodiacObject",
  "objects": [
    {
      "idx": 0,
      "zodiacName": "猴"
    },
    {
      "idx": 1,
      "zodiacName": "雞"
    },
    {
      "idx": 2,
      "zodiacName": "狗"
    },
    {
      "idx": 3,
      "zodiacName": "豬"
    },
    {
      "idx": 4,
      "zodiacName": "鼠"
    },
    {
      "idx": 5,
      "zodiacName": "牛"
    },
    {
      "idx": 6,
      "zodiacName": "虎"
    },
    {
      "idx": 7,
      "zodiacName": "兔"
    },
    {
      "idx": 8,
      "zodiacName": "龍"
    },
    {
      "idx": 9,
      "zodiacName": "蛇"
    },
    {
      "idx": 10,
      "zodiacName": "馬"
    },
    {
      "idx": 11,
      "zodiacName": "羊"
    }
  ]
}

import agconnect from '@hw-agconnect/api-ohos';
import "@hw-agconnect/core-ohos";
import "@hw-agconnect/auth-ohos";
import '@hw-agconnect/auth-types-ohos';

import { Log } from '../common/Log';

const TAG = "[AGCConfig]";

export function getAGConnect(context) {
    try {
        agconnect.instance().init(context);
        Log.info(TAG, "xx init AGC SDK success");
        return agconnect;
    }
    catch (err) {
        Log.error(TAG, "xx initAgcSDK failed" + err);
    }
}

{
  "schemaVersion": 1,
  "permissions": [{
    "permissions": [{
      "role": "World",
      "rights": ["Read"]
    }, {
      "role": "Authenticated",
      "rights": ["Read", "Upsert"]
    }, {
      "role": "Creator",
      "rights": ["Read", "Upsert", "Delete"]
    }, {
      "role": "Administrator",
      "rights": ["Read", "Upsert", "Delete"]
    }],
    "objectTypeName": "ZodiacObject"
  }],
  "objectTypes": [{
    "indexes": [{
      "indexName": "zodiacIndex",
      "indexList": [{
        "fieldName": "zodiacName",
        "sortType": "DESC"
      }]
    }, {
      "indexName": "idxIndex",
      "indexList": [{
        "fieldName": "idx",
        "sortType": "ASC"
      }]
    }],
    "objectTypeName": "ZodiacObject",
    "fields": [{
      "isNeedEncrypt": false,
      "fieldName": "idx",
      "notNull": true,
      "isSensitive": false,
      "belongPrimaryKey": true,
      "fieldType": "Integer"
    }, {
      "isNeedEncrypt": false,
      "fieldName": "zodiacName",
      "notNull": false,
      "isSensitive": false,
      "belongPrimaryKey": false,
      "fieldType": "String"
    }]
  }]
}

/*
 * Copyright (c) Huawei Technologies Co., Ltd. 2020-2020. All rights reserved.
 * Generated by the CloudDB ObjectType compiler. DO NOT EDIT!
 */

class ZodiacObject {
    constructor() {
        this.idx = undefined;
        this.zodiacName = undefined;
    }

    setIdx(idx) {
        this.idx = idx;
    }

    getIdx() {
        return this.idx;
    }

    setZodiacName(zodiacName) {
        this.zodiacName = zodiacName;
    }

    getZodiacName() {
        return this.zodiacName;
    }
}

ZodiacObject.className = 'ZodiacObject';

export {ZodiacObject}

import * as schema from './app-schema.json';
import { ZodiacObject } from './ZodiacObject'
import { AGConnectCloudDB, CloudDBZone, CloudDBZoneQuery } from '@hw-agconnect/database-ohos';
import { AGCRoutePolicy } from '@hw-agconnect/core-ohos';
import { getAGConnect } from './AgcConfig';
export class CloudDBService {
  private static ZONE_NAME: string = "cloudDBZoneZodiac"
  private static init(context: any): Promise<CloudDBZone> {
    return new Promise((resolve, reject) => {
      // 獲取AGC連接
      getAGConnect(context);
      AGConnectCloudDB.initialize(context);

      AGConnectCloudDB.getInstance({
        context: context,
        agcRoutePolicy: AGCRoutePolicy.CHINA,
        objectTypeInfo: schema
      }).then((ret) => {
        return resolve(ret.openCloudDBZone(this.ZONE_NAME));
      }).catch((err) => {
        return reject(err);
      });
    })
  }

  public static query(context: any, year: number): Promise<ZodiacObject> {
    let idx = year%12;

    return new Promise((resolve, reject) => {
      const query = CloudDBZoneQuery.where(ZodiacObject).equalTo("idx", idx);
      this.init(context).then((ret) => {
        ret.executeQuery(query).then((ret) => {
          resolve(ret.getSnapshotObjects()[0]);
        })
      }).catch((err) => {
        reject(err);
      });
    })
  }
}

import { CloudDBService } from '../services/CloudDB';

@Entry
@Component
struct Index {
  // 存儲選擇年份
  @State year: number = 2022
  // 計算出來生肖
  @State born: string = "?"
  // 是否在計算中
  @State flag: boolean = false

  // 計算生肖
  getBorn() {
    // 標識為計算中
    this.flag = true;
    console.info('xx Page year: ' + this.year)
    // 封裝參數
    let params = {
      "year": this.year
    }
    // 調用云數據庫
    CloudDBService.query(getContext(this), this.year).then((res) => {
      console.info('xx cloud db result: ' + JSON.stringify(res));
      // 計算完成
      this.flag = false;
      // 結果賦值給生肖變量
      this.born = res.zodiacName;

    }).catch((err) => {
      // 計算完成
      this.flag = false;
      console.error('xx error: ', err && err.message);
    });
  }

  build() {
    Stack() {
      if (!this.flag) {
        Column({space: 20}) {
          Text('請選擇年份')
            .fontSize(20)
            .fontWeight(FontWeight.Bold)

          // 選擇年份
          Column() {
            Text(this.year + '')
              .fontSize(20)
              .fontWeight(FontWeight.Bold)
              .padding(10)
              .width(100)
              .border({ width: 1, radius: 8 })
          }
          .bindMenu([
            { value: '2006', action: () => {this.year = 2006; this.born = '?'} },
            { value: '2007', action: () => {this.year = 2007; this.born = '?'} },
            { value: '2008', action: () => {this.year = 2008; this.born = '?'} },
            { value: '2009', action: () => {this.year = 2009; this.born = '?'} },
            { value: '2010', action: () => {this.year = 2010; this.born = '?'} },
            { value: '2011', action: () => {this.year = 2011; this.born = '?'} },
            { value: '2012', action: () => {this.year = 2012; this.born = '?'} },
            { value: '2013', action: () => {this.year = 2013; this.born = '?'} },
            { value: '2014', action: () => {this.year = 2014; this.born = '?'} },
            { value: '2015', action: () => {this.year = 2015; this.born = '?'} },
            { value: '2016', action: () => {this.year = 2016; this.born = '?'} },
            { value: '2017', action: () => {this.year = 2017; this.born = '?'} },
            { value: '2018', action: () => {this.year = 2018; this.born = '?'} },
            { value: '2019', action: () => {this.year = 2019; this.born = '?'} },
            { value: '2020', action: () => {this.year = 2020; this.born = '?'} },
            { value: '2021', action: () => {this.year = 2021; this.born = '?'} },
            { value: '2022', action: () => {this.year = 2022; this.born = '?'} },
            { value: '2023', action: () => {this.year = 2023; this.born = '?'} },
            { value: '2024', action: () => {this.year = 2024; this.born = '?'} },
            { value: '2025', action: () => {this.year = 2025; this.born = '?'} }
          ])

          // 計算按鈕操作
          Button('計算', {type: ButtonType.Normal, stateEffect: true})
            .fontSize(18)
            .borderRadius(8)
            .width(100)
            .margin({bottom: 20})
            .onClick(() => {
              // 根據年份計算生肖
              this.getBorn()
            })

            // 顯示計算結果
            Text(`${this.year} 年生肖是  ${this.born}`)
              .fontSize(20)
              .fontWeight(FontWeight.Bold)
        }
        .width('100%')
        .height('100%')
        .padding({top: '33%'})
      } else {
        // 計算中
        LoadingProgress().color(Color.Blue)
          .backgroundColor(Color.Transparent)
      }
    }
  }
}