aboutsummaryrefslogtreecommitdiffstats
path: root/intentanalysis/src/test/resources/intentdb-test-init.sql
diff options
context:
space:
mode:
authorChuanyuChen <chenchuanyu@huawei.com>2022-07-30 09:39:36 +0800
committerChuanyuChen <chenchuanyu@huawei.com>2022-08-03 10:25:50 +0800
commitc63412acfab7c50803bdd0dcf848b3a91b3f565f (patch)
tree6db3531941ba930e0ad5a91e8bf87b6ad4c48781 /intentanalysis/src/test/resources/intentdb-test-init.sql
parent0c41af52f3f453219a0240cf54ea321829a49c0e (diff)
Add unit test for intent analysis
Add unit test for intent analysis Issue-ID: USECASEUI-692 Signed-off-by: ChuanyuChen <chenchuanyu@huawei.com> Change-Id: If7c8a1ca56c1e8cc07e91729b3d2e38ddb2c855b
Diffstat (limited to 'intentanalysis/src/test/resources/intentdb-test-init.sql')
-rw-r--r--intentanalysis/src/test/resources/intentdb-test-init.sql42
1 files changed, 42 insertions, 0 deletions
diff --git a/intentanalysis/src/test/resources/intentdb-test-init.sql b/intentanalysis/src/test/resources/intentdb-test-init.sql
new file mode 100644
index 0000000..b84f8e3
--- /dev/null
+++ b/intentanalysis/src/test/resources/intentdb-test-init.sql
@@ -0,0 +1,42 @@
+/*
+ Navicat Premium Data Transfer
+
+ Source Server : 1
+ Source Server Type : PostgreSQL
+ Source Server Version : 100011
+ Source Host : localhost:5432
+ Source Catalog : exampledb
+ Source Schema : mec
+
+ Target Server Type : PostgreSQL
+ Target Server Version : 100011
+ File Encoding : 65001
+
+ Date: 30/12/2019 14:40:23
+*/
+DROP TABLE IF EXISTS intent;
+DROP TABLE IF EXISTS expectation;
+DROP TABLE IF EXISTS state;
+
+CREATE TABLE if NOT EXISTS intent(
+ intent_id varchar(255),
+ intent_name varchar(255),
+ CONSTRAINT intent_test_task_pkey PRIMARY KEY (intent_id)
+);
+
+create table if not exists expectation(
+ expectation_id varchar(255),
+ expectation_name varchar(255),
+ target_moi varchar(255),
+ intent_id varchar(255),
+ CONSTRAINT expectation_test_task_pkey PRIMARY KEY (expectation_id)
+);
+
+create table if not exists state(
+ state_id varchar(255),
+ state_name varchar(255),
+ is_satisfied boolean,
+ condition varchar(255),
+ expectation_id varchar(255),
+ CONSTRAINT state_test_task_pkey PRIMARY KEY (state_id)
+);