aboutsummaryrefslogtreecommitdiffstats
path: root/functest/api/database/db.py
diff options
context:
space:
mode:
authorLinda Wang <wangwulin@huawei.com>2017-08-18 06:09:56 +0000
committerLinda Wang <wangwulin@huawei.com>2017-08-21 02:47:42 +0000
commit26efacba9304071956d16a9a50a18e8f243518bb (patch)
tree38c8cdb8c363f1f9592be904b6e805567c3be66d /functest/api/database/db.py
parent58665932c2c910cedac2a135e5b84a5ec4b5946e (diff)
Create API to run a test case
Two APIs are created here: 1. Run a test case 2. Get the result of the task id JIRA: FUNCTEST-853 Change-Id: I12950933b143b82fb6aeb186ea1b35ddd16e6097 Signed-off-by: Linda Wang <wangwulin@huawei.com>
Diffstat (limited to 'functest/api/database/db.py')
-rw-r--r--functest/api/database/db.py26
1 files changed, 26 insertions, 0 deletions
diff --git a/functest/api/database/db.py b/functest/api/database/db.py
new file mode 100644
index 00000000..ea861ddb
--- /dev/null
+++ b/functest/api/database/db.py
@@ -0,0 +1,26 @@
+#!/usr/bin/env python
+
+# Copyright (c) 2017 Huawei Technologies Co.,Ltd and others.
+#
+# All rights reserved. This program and the accompanying materials
+# are made available under the terms of the Apache License, Version 2.0
+# which accompanies this distribution, and is available at
+# http://www.apache.org/licenses/LICENSE-2.0
+
+"""
+Create database to store task results using sqlalchemy
+"""
+
+from sqlalchemy import create_engine
+from sqlalchemy.ext.declarative import declarative_base
+from sqlalchemy.orm import scoped_session, sessionmaker
+
+
+SQLITE = 'sqlite:////tmp/functest.db'
+
+ENGINE = create_engine(SQLITE, convert_unicode=True)
+DB_SESSION = scoped_session(sessionmaker(autocommit=False,
+ autoflush=False,
+ bind=ENGINE))
+BASE = declarative_base()
+BASE.query = DB_SESSION.query_property()