Add freezer-tempest-basic-sqlalchemy job in freezer-api

Ths test job will be as a check/gate job for freezer-api which is
used sqlacchenmy as backend.

Change-Id: Iddda7df8cda341c20f3bc840c0f739fb370f4962

.zuul.yaml

@@ -13,12 +13,16 @@
         - openstack-tox-lower-constraints
         - openstack-tox-pylint
         - freezer-tempest-basic
+        - freezer-tempest-basic-sqlalchemy:
+            voting: false
     gate:
       jobs:
         - freezer-api-ubuntu-xenial
         - openstack-tox-lower-constraints
         - openstack-tox-pylint
         - freezer-tempest-basic
+        - freezer-tempest-basic-sqlalchemy:
+            voting: false
     experimental:
       jobs:
         - freezer-api-opensuse-423
@@ -66,3 +70,36 @@
       - openstack/freezer-web-ui
       - openstack/python-freezerclient
       - openstack/freezer-tempest-plugin
+
+
+- job:
+    name: freezer-tempest-basic-sqlalchemy
+    parent: devstack-tempest
+    timeout: 7200
+    required-projects:
+      - openstack-infra/devstack-gate
+      - openstack/python-openstackclient
+      - openstack/python-freezerclient
+      - openstack/freezer
+      - openstack/freezer-tempest-plugin
+      - openstack/tempest
+    vars:
+      devstack_plugins:
+        freezer-api: https://git.openstack.org/openstack/freezer-api
+      devstack_services:
+        tls-proxy: false
+        freezer-api: true
+        tempest: true
+        s-account: false
+        s-container: false
+        s-object: false
+        s-proxy: false
+      devstack_localrc:
+        FREEZER_BACKEND: 'sqlalchemy'
+        TEMPEST_PLUGINS: '/opt/stack/freezer-tempest-plugin'
+      tempest_test_regex: '^(freezer_tempest_plugin.tests.freezer_api)'
+      tox_envlist: all
+      tox_environment:
+        PYTHONUNBUFFERED: 'true'
+      zuul_copy_output:
+        /etc/hosts: logs