diff options
| author |   Dan Timoney <dtimoney@att.com> | 2017-07-18 20:23:07 -0400 |
|---|---|---|
| committer | Dan Timoney <dtimoney@att.com> | 2017-08-01 14:46:48 -0400 |
| commit | 5363b2782d906a6c6067eb840392f959ed4dfe4b (patch) | |
| tree | b8061a4875ea11c6af51ce065c300ef2dd4746ef /sql-resource/provider/src/test/resources/save.tests | |
| parent | bbe551f0d98ca20f604c03a24c1b8e7bad27008a (diff) | |
[CCSDK-6] Populate seed code
Add seed code for sli/adaptors repository
Update code to use org.onap.ccsdk.sli.core
Change-Id: I477c7a24f2cc1fed8fb0975fe9f33733411c27f9
Signed-off-by: Dan Timoney <dtimoney@att.com>
Diffstat (limited to 'sql-resource/provider/src/test/resources/save.tests')
| -rwxr-xr-x | sql-resource/provider/src/test/resources/save.tests | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql-resource/provider/src/test/resources/save.tests b/sql-resource/provider/src/test/resources/save.tests new file mode 100755 index 000000000..e2c42217d --- /dev/null +++ b/sql-resource/provider/src/test/resources/save.tests @@ -0,0 +1,13 @@ +# order-number = 1234 +# zero = 0 +# item[0].clli = MTJNJA14 +# item[0].service = NoD +# item[0].price = 1000000 +# item[1].clli = MTJNJA14 +# item[1].service = Pizza +# item[1].price = 10 +CREATE TABLE IF NOT EXISTS SQLRESOURCE_ORDER (order_number VARCHAR(40), placed_on TIMESTAMP); +CREATE TABLE IF NOT EXISTS SQLRESOURCE_ORDER_ITEM (order_number VARCHAR(40), clli VARCHAR(40), service VARCHAR(40), price INTEGER(4)); +INSERT INTO SQLRESOURCE_ORDER VALUES ( $order-number , now()); +INSERT INTO SQLRESOURCE_ORDER_ITEM VALUES( $order-number , $item[$zero].clli , $item[0].service , $item[0].price ); +INSERT INTO SQLRESOURCE_ORDER_ITEM VALUES( $order-number , $item[1].clli , $item[1].service , $item[1].price ); |