summaryrefslogtreecommitdiffstats
path: root/intentanalysis/src/test/resources/intentdb-test-init.sql
diff options
context:
space:
mode:
authorKeguang He <hekeguang@chinamobile.com>2022-08-08 01:55:57 +0000
committerGerrit Code Review <gerrit@onap.org>2022-08-08 01:55:57 +0000
commitbedfcff8f80b0adc6df7bc051b82458fef4446f0 (patch)
tree9a4f436ae1d87911b5669f6aa109fa3242d8c203 /intentanalysis/src/test/resources/intentdb-test-init.sql
parent40d95f90d0740982a8a22e2ae318b4a8236ea3ba (diff)
parentc63412acfab7c50803bdd0dcf848b3a91b3f565f (diff)
Merge "Add unit test for intent analysis"
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)
+);