add v1.servermodel.create message

README.md

@@ -20,8 +20,8 @@ docker run -d --add-host reload.example.com:127.0.0.1 -p 80:80 coudot/lemonldap-
 
 Démarrer un serveur postgresql de test
 ```
-podman pull docker.io/library/postgres:11-alpine
+docker run -dt -p 5432:5432 --name postgres postgres:11-alpine
-podman run -dt -p 5432:5432 postgres:11-alpine
+docker exec -ti postgres bash
 
 psql -U postgres -h localhost -c "CREATE ROLE risotto WITH LOGIN PASSWORD 'risotto';"
 psql -U postgres -h localhost -c "CREATE DATABASE risotto;"
@@ -44,6 +44,9 @@ su - postgres
 psql -U postgres risotto
 drop table log; drop table userrole; drop table release; drop table source; drop table server; drop table servermodel; drop table applicationservice; drop table roleuri;  drop table risottouser; drop table uri;
 
+psql -U postgres tiramisu
+drop table value; drop table property; drop table permissive; drop table information; drop table session;
+
 # Import EOLE
 ./script/cucchiaiata source.create -n eole -u http://localhost
 ./script/cucchiaiata source.release.create -s eole -n 2.7.1.1 -d last
@@ -70,3 +73,8 @@ S=xxxxxxxxxxxxxxxxxxxxxx
 # Create a new user and set role 'server_rw' for this server
 ./script/cucchiaiata user.create -l gnunux -n gnunux -s gnunux
 ./script/cucchiaiata user.role.create -u gnunux -n 'server_rw' -a 'Server.ServerName' -v test
+
+# Heritage
+./script/cucchiaiata servermodel.create -n aca -d Aca -p eolebase -s eole -r last
+./script/cucchiaiata session.servermodel.start -s aca
+./script/cucchiaiata session.servermodel.configure -s $S --creole.reseau.unbound_domain_name test.cadoles.com

docker/Dockerfile

@@ -0,0 +1,29 @@
+FROM python:3.7
+
+# Requirements
+ARG TIRAMISU_REPO_URL=https://framagit.org/tiramisu/tiramisu.git
+ARG RISOTTO_REPO_URL=https://forge.cadoles.com/Infra/risotto.git
+ARG ROUGAIL_REPO_URL=https://forge.cadoles.com/Infra/rougail.git
+
+RUN apt-get update && apt-get install -y \
+    vim \
+    curl \
+    git \
+    jq \
+    && apt-get clean
+
+RUN git clone --branch develop ${TIRAMISU_REPO_URL} /srv/src/tiramisu
+RUN git clone --branch docker ${RISOTTO_REPO_URL} /srv/src/risotto
+RUN git clone --branch master ${ROUGAIL_REPO_URL} /srv/src/rougail
+
+RUN ln -s /srv/src/tiramisu/tiramisu /usr/local/lib/python3.7
+RUN ln -s /srv/src/rougail/src/rougail /usr/local/lib/python3.7
+RUN ln -s /srv/src/risotto/src/risotto /usr/local/lib/python3.7
+
+RUN pip install Cheetah3
+RUN cd /srv/src/risotto && pip install -r requirements.txt
+
+# Installation
+RUN cp -r /srv/src/risotto/messages/ /usr/local/lib/
+RUN mkdir -p /var/cache/risotto/servermodel
+RUN mkdir -p /var/cache/risotto/database

docker/README.md

@@ -0,0 +1,14 @@
+Docker
+```
+cd docker
+docker build -t cadoles/risotto .
+docker run -t -d --name risotto cadoles/risotto
+docker exec -ti risotto bash
+
+```
+
+Docker-Compose
+```
+cd docker
+docker-compose up
+```

docker/docker-compose.yaml

@@ -0,0 +1,31 @@
+version: '2.2'
+services:
+  risotto:
+    build:
+      context: ../
+      dockerfile: docker/Dockerfile
+    volumes:
+      - ../.:/srv/src/risotto
+    ports:
+      - "8080:8080"
+    depends_on:
+      - postgres
+    links:
+      - postgres
+    #command: tail -F /var/log
+    command: python -u /srv/src/risotto/script/server.py
+    restart: on-failure
+    environment:
+        RISOTTO_DSN: ${RISOTTO_DSN:-postgres://risotto:risotto@postgres:5432/risotto}
+        RISOTTO_TIRAMISU_DSN: ${RISOTTO_TIRAMISU_DSN:-postgres://risotto:risotto@postgres:5432/tiramisu}
+  postgres:
+    image: postgres:11-alpine
+    environment:
+      POSTGRES_USER: ${POSTGRES_USER:-postgres}
+      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD:-postgres}
+      PGDATA: /data/postgres
+    volumes:
+      - ./postgres-init/:/docker-entrypoint-initdb.d/
+    ports:
+      - "5432:5432"
+    restart: unless-stopped

docker/postgres-init/10-postgres.init.sh

@@ -0,0 +1,103 @@
+#!/bin/bash
+set -e
+
+psql --username "$POSTGRES_USER" <<-EOSQL
+    CREATE ROLE risotto WITH LOGIN PASSWORD 'risotto';
+    CREATE DATABASE risotto;
+    GRANT ALL ON DATABASE risotto TO risotto;
+    \c risotto
+    CREATE EXTENSION hstore;
+EOSQL
+
+psql --username "risotto" --password "risotto" <<-EOSQL
+    -- Création de la table Source
+    CREATE TABLE Source (
+    SourceId SERIAL PRIMARY KEY,
+    SourceName VARCHAR(255) NOT NULL UNIQUE,
+    SourceURL TEXT
+    );
+
+    -- Création de la table Release
+    CREATE TABLE Release (
+    ReleaseId SERIAL PRIMARY KEY,
+    ReleaseName VARCHAR(255) NOT NULL,
+    ReleaseSourceId INTEGER NOT NULL,
+    ReleaseDistribution VARCHAR(20) CONSTRAINT releasedistribution_choice CHECK (ReleaseDistribution IN ('last', 'n-1', 'n-2')),
+    UNIQUE (ReleaseName, ReleaseSourceId),
+    UNIQUE (ReleaseDistribution, ReleaseSourceId),
+    FOREIGN KEY (ReleaseSourceId) REFERENCES Source(SourceId)
+    );
+
+
+    -- Création de la table Servermodel
+    CREATE TABLE Servermodel (
+    ServermodelId SERIAL PRIMARY KEY,
+    ServermodelName VARCHAR(255) NOT NULL,
+    ServermodelDescription VARCHAR(255) NOT NULL,
+    ServermodelParentsId INTEGER [] DEFAULT '{}',
+    ServermodelReleaseId INTEGER NOT NULL,
+    ServermodelApplicationServiceId INTEGER NOT NULL,
+    ServermodelUsers hstore,
+    UNIQUE (ServermodelName, ServermodelReleaseId)
+    );
+
+    -- Création de la table ApplicationService
+    CREATE TABLE ApplicationService (
+    ApplicationServiceId SERIAL PRIMARY KEY,
+    ApplicationServiceName VARCHAR(255) NOT NULL,
+    ApplicationServiceDescription VARCHAR(255) NOT NULL,
+    ApplicationServiceReleaseId INTEGER NOT NULL,
+    ApplicationServiceDependencies JSON,
+    UNIQUE (ApplicationServiceName, ApplicationServiceReleaseId)
+    );
+
+    -- Server table creation
+    CREATE TABLE Server (
+    ServerId SERIAL PRIMARY KEY,
+    ServerName VARCHAR(255) NOT NULL UNIQUE,
+    ServerDescription VARCHAR(255) NOT NULL,
+    ServerServermodelId INTEGER NOT NULL
+    );
+
+    -- User, Role and ACL table creation
+
+    CREATE TABLE RisottoUser (
+    UserId SERIAL PRIMARY KEY,
+    UserLogin VARCHAR(100) NOT NULL UNIQUE,
+    UserName VARCHAR(100) NOT NULL,
+    UserSurname VARCHAR(100) NOT NULL
+    );
+
+    CREATE TABLE UserRole (
+    RoleId SERIAL PRIMARY KEY,
+    RoleUserId INTEGER NOT NULL,
+    RoleName VARCHAR(255) NOT NULL,
+    RoleAttribute VARCHAR(255),
+    RoleAttributeValue VARCHAR(255),
+    FOREIGN KEY (RoleUserId) REFERENCES RisottoUser(UserId)
+    );
+
+    CREATE TABLE URI (
+    URIId SERIAL PRIMARY KEY,
+    URIName VARCHAR(255) NOT NULL UNIQUE
+    );
+
+    CREATE TABLE RoleURI (
+    RoleName VARCHAR(255) NOT NULL,
+    URIId INTEGER NOT NULL,
+    FOREIGN KEY (URIId) REFERENCES URI(URIId),
+    PRIMARY KEY (RoleName, URIId)
+    );
+
+    -- Log table creation
+
+    CREATE TABLE log(
+    Msg VARCHAR(255) NOT NULL,
+    Level VARCHAR(10) NOT NULL,
+    Path VARCHAR(255),
+    Username VARCHAR(100) NOT NULL,
+    Data JSON,
+    Date timestamp DEFAULT current_timestamp
+    );
+
+EOSQL

messages/v1/messages/session.servermodel.start.yml

@@ -11,16 +11,6 @@ parameters:
     ref: Servermodel.ServermodelName
     shortarg: s
     description: Nom du serveurmodel.
-  source_name:
-    type: String
-    shortarg: n
-    description: Nom de la source.
-    ref: Source.SourceName
-  release_distribution:
-    type: String
-    shortarg: r
-    description: Nom de la distribution.
-    ref: Source.ReleaseDistribution
 
 response:
   type: Session

messages/v1/types/servermodel.yml

@@ -23,8 +23,13 @@ properties:
     type: number
     ref: Servermodel.SubreleaseId
     description: Version du modèle de serveur.
+  servermodel_applicationservice_id:
+    type: number
+    ref: Applicationservice.ApplicationserviceId
+    description: Identifiant de l'application service local.
 required:
   - servermodel_id
   - servermodel_name
   - servermodel_description
   - release_id
+  - servermodel_applicationservice_id

requirements.txt

@@ -0,0 +1,7 @@
+asyncpg==0.20.1
+lxml==4.4.2
+requests==2.22.0
+aiohttp==3.6.2
+pytest==5.3.3
+PyYAML==5.3
+tiramisu==3.0rc15

script/database_manager.py

@@ -96,8 +96,8 @@ CREATE TABLE log(
 """
 
 async def main():
-    db_conf = get_config().get('database')
+    db_conf = get_config()['database']['dsn']
-    pool = await asyncpg.create_pool(database=db_conf.get('dbname'), user=db_conf.get('user'))
+    pool = await asyncpg.create_pool(db_conf)
     async with pool.acquire() as connection:
         async with connection.transaction():
             returns = await connection.execute(VERSION_INIT)
@@ -106,3 +106,4 @@ if __name__ == '__main__':
     loop = asyncio.get_event_loop()
     loop.run_until_complete(main())
     # asyncio.run(main())
+

script/server.py

@@ -1,6 +1,7 @@
 from asyncio import get_event_loop
 from risotto import get_app
 
+
 if __name__ == '__main__':
     loop = get_event_loop()
     loop.run_until_complete(get_app(loop))
@@ -8,5 +9,3 @@ if __name__ == '__main__':
         loop.run_forever()
     except KeyboardInterrupt:
         pass
-
-

src/risotto/config.py

@@ -1,22 +1,20 @@
 MESSAGE_ROOT_PATH = 'messages'
-DATABASE_DIR = 'database'
 INTERNAL_USER = 'internal'
 CONFIGURATION_DIR = 'configurations'
 TEMPLATE_DIR = 'templates'
 TMP_DIR = 'tmp'
 ROUGAIL_DTD_PATH = '../rougail/data/creole.dtd'
 DEFAULT_USER = 'Anonymous'
+DEFAULT_DSN = 'postgres:///risotto?host=/var/run/postgresql/&user=risotto'
+DEFAULT_TIRAMISU_DSN = 'postgres:///tiramisu?host=/var/run/postgresql/&user=tiramisu'
 
-import os
+from os import environ
 from pathlib import PurePosixPath
 CURRENT_PATH = PurePosixPath(__file__)
 
 def get_config():
-    return {'database': {'host': 'localhost',
+    return {'database': {'dsn': environ.get('RISOTTO_DSN', DEFAULT_DSN),
-                         'port': 5432,
+                         'tiramisu_dsn': environ.get('RISOTTO_TIRAMISU_DSN', DEFAULT_TIRAMISU_DSN),
-                         'dbname': 'risotto',
-                         'user': 'risotto',
-                         'password': 'risotto',
                          },
             'http_server': {'port': 8080,
                             #'default_user': "gnunux"},
@@ -28,5 +26,8 @@ def get_config():
                        'rougail_dtd_path': '../rougail/data/creole.dtd',
                        'admin_user': DEFAULT_USER},
             'source': {'root_path': '/srv/seed'},
-            'cache': {'root_path': '/var/cache/risotto'}
+            'cache': {'root_path': '/var/cache/risotto'},
+            'servermodel': {'internal_source': 'internal',
+                            'internal_distribution': 'last'},
             }
+

src/risotto/dispatcher.py

@@ -38,8 +38,7 @@ class CallDispatcher:
             raise Exception('hu?')
         else:
             for ret in returns:
-                config = await Config(response,
+                async with await Config(response, display_name=lambda self, dyn_name: self.impl_getname()) as config:
-                                      display_name=lambda self, dyn_name: self.impl_getname())
                     await config.property.read_write()
                     try:
                         for key, value in ret.items():
@@ -88,6 +87,7 @@ class CallDispatcher:
                                      kwargs,
                                      function_objs)
         else:
+            try:
                 async with self.pool.acquire() as connection:
                     await connection.set_type_codec(
                         'json',
@@ -103,6 +103,23 @@ class CallDispatcher:
                                                  check_role,
                                                  kwargs,
                                                  function_objs)
+            except CallError as err:
+                raise err
+            except Exception as err:
+                # if there is a problem with arguments, just send an error and do nothing
+                if get_config()['global']['debug']:
+                    print_exc()
+                async with self.pool.acquire() as connection:
+                    await connection.set_type_codec(
+                        'json',
+                        encoder=dumps,
+                        decoder=loads,
+                        schema='pg_catalog'
+                    )
+                    risotto_context.connection = connection
+                    async with connection.transaction():
+                        await log.error_msg(risotto_context, kwargs, err)
+                raise err
 
 
 class PublishDispatcher:
@@ -127,6 +144,7 @@ class PublishDispatcher:
                                      kwargs,
                                      function_objs)
         else:
+            try:
                 async with self.pool.acquire() as connection:
                     await connection.set_type_codec(
                         'json',
@@ -142,6 +160,23 @@ class PublishDispatcher:
                                                  check_role,
                                                  kwargs,
                                                  function_objs)
+            except CallError as err:
+                raise err
+            except Exception as err:
+                # if there is a problem with arguments, just send an error and do nothing
+                if get_config()['global']['debug']:
+                    print_exc()
+                async with self.pool.acquire() as connection:
+                    await connection.set_type_codec(
+                        'json',
+                        encoder=dumps,
+                        decoder=loads,
+                        schema='pg_catalog'
+                    )
+                    risotto_context.connection = connection
+                    async with connection.transaction():
+                        await log.error_msg(risotto_context, kwargs, err)
+                raise err
 
 
 class Dispatcher(register.RegisterDispatcher, CallDispatcher, PublishDispatcher):
@@ -182,7 +217,7 @@ class Dispatcher(register.RegisterDispatcher, CallDispatcher, PublishDispatcher)
         """ create a new Config et set values to it
         """
         # create a new config
-        config = await Config(self.option)
+        async with await Config(self.option) as config:
             await config.property.read_write()
             # set message's option
             await config.option('message').value.set(risotto_context.message)
@@ -268,19 +303,10 @@ class Dispatcher(register.RegisterDispatcher, CallDispatcher, PublishDispatcher)
                      function_objs: List) -> Optional[Dict]:
         await self.check_message_type(risotto_context,
                                       kwargs)
-        try:
         config_arguments = await self.load_kwargs_to_config(risotto_context,
                                                             f'{version}.{message}',
                                                             kwargs,
                                                             check_role)
-        except Exception as err:
-            # if there is a problem with arguments, just send an error and do nothing
-            if get_config()['global']['debug']:
-                print_exc()
-            await log.error_msg(risotto_context, kwargs, err)
-            if risotto_context.type == 'rpc':
-                raise err
-            return
         # config is ok, so send the message
         for function_obj in function_objs:
             function = function_obj['function']
@@ -306,13 +332,13 @@ class Dispatcher(register.RegisterDispatcher, CallDispatcher, PublishDispatcher)
                     raise err
                 continue
             except Exception as err:
+                if risotto_context.type == 'rpc':
+                    raise err
                 if get_config().get('global').get('debug'):
                     print_exc()
                 await log.error_msg(risotto_context,
                                     kwargs,
                                     err)
-                if risotto_context.type == 'rpc':
-                    raise CallError(str(err))
                 continue
             else:
                 if risotto_context.type == 'rpc':

src/risotto/http.py

@@ -1,7 +1,7 @@
 from aiohttp.web import Application, Response, get, post, HTTPBadRequest, HTTPInternalServerError, HTTPNotFound
 from json import dumps
 from traceback import print_exc
-from tiramisu import Config
+from tiramisu import Config, default_storage
 
 
 from .dispatcher import dispatcher
@@ -102,7 +102,7 @@ async def api(request, risotto_context):
                 WHERE RoleURI.URIId = URI.URIId
                 '''
                 uris = [uri['uriname'] for uri in await connection.fetch(sql)]
-        config = await Config(get_messages(load_shortarg=True, uris=uris)[1])
+        async with await Config(get_messages(load_shortarg=True, uris=uris)[1]) as config:
             await config.property.read_write()
             tiramisu = await config.option.dict(remotable='none')
     return tiramisu
@@ -119,6 +119,7 @@ async def get_app(loop):
     load_services()
     app = Application(loop=loop)
     routes = []
+    default_storage.engine('dictionary')
     await dispatcher.load()
     for version, messages in dispatcher.messages.items():
         print()

src/risotto/register.py

@@ -59,7 +59,7 @@ class RegisterDispatcher:
         """
         async def get_message_args():
             # load config
-            config = await Config(self.option)
+            async with await Config(self.option) as config:
                 await config.property.read_write()
                 # set message to the uri name
                 await config.option('message').value.set(message)
@@ -101,7 +101,7 @@ class RegisterDispatcher:
         """
         async def get_message_args():
             # load config
-            config = await Config(self.option)
+            async with await Config(self.option) as config:
                 await config.property.read_write()
                 # set message to the message name
                 await config.option('message').value.set(message)
@@ -247,8 +247,8 @@ class RegisterDispatcher:
 
     async def load(self):
         # valid function's arguments
-        db_conf = get_config().get('database')
+        db_conf = get_config()['database']['dsn']
-        self.pool = await asyncpg.create_pool(database=db_conf.get('dbname'), user=db_conf.get('user'))
+        self.pool = await asyncpg.create_pool(db_conf)
         async with self.pool.acquire() as connection:
             async with connection.transaction():
                 for version, messages in self.messages.items():
@@ -271,3 +271,4 @@ class RegisterDispatcher:
                                                                   module_name)
                         await self.insert_message(connection,
                                                   f'{version}.{message}')
+

src/risotto/services/config/config.py

@@ -10,7 +10,7 @@ from rougail import load as rougail_load
 
 from ...controller import Controller
 from ...register import register
-from ...config import DATABASE_DIR, ROUGAIL_DTD_PATH, get_config
+from ...config import ROUGAIL_DTD_PATH, get_config
 from ...context import Context
 from ...utils import _
 from ...error import CallError, RegistrationError
@@ -23,11 +23,12 @@ class Risotto(Controller):
                  test) -> None:
         global conf_storage
         self.cache_root_path = join(get_config().get('cache').get('root_path'), 'servermodel')
-        for dirname in [self.cache_root_path, DATABASE_DIR]:
+        if not isdir(self.cache_root_path):
-            if not isdir(dirname):
+            raise RegistrationError(_(f'unable to find the cache dir "{self.cache_root_path}"'))
-                raise RegistrationError(_(f'unable to find the cache dir "{dirname}"'))
         if not test:
-            self.save_storage = Storage(engine='sqlite3', dir_database=DATABASE_DIR)
+            db_conf = get_config()['database']['tiramisu_dsn']
+            self.save_storage = Storage(engine='postgres')
+            self.save_storage.setting(dsn=db_conf)
         self.servermodel = {}
         self.server = {}
         super().__init__(test)
@@ -115,12 +116,10 @@ class Risotto(Controller):
         # build servermodel metaconfig (v_xxx.m_v_xxx)
         metaconfig = await MetaConfig([],
                                       optiondescription=optiondescription,
-                                      persistent=True,
                                       session_id=session_id,
                                       storage=self.save_storage)
         mixconfig = await MixConfig(children=[],
                                     optiondescription=optiondescription,
-                                    persistent=True,
                                     session_id='m_' + session_id,
                                     storage=self.save_storage)
         await metaconfig.config.add(mixconfig)
@@ -248,8 +247,7 @@ class Risotto(Controller):
         """ build server's config
         """
         config = await metaconfig.config.new(session_id,
-                                             storage=self.save_storage,
+                                             storage=self.save_storage)
-                                             persistent=True)
         await config.information.set('server_id', server_id)
         await config.information.set('server_name', server_name)
         await config.owner.set(server_name)

src/risotto/services/servermodel/servermodel.py

@@ -5,7 +5,6 @@ from yaml import load, SafeLoader
 from traceback import print_exc
 from typing import Dict, List, Optional
 from rougail import CreoleObjSpace
-from rougail.config import dtdfilename
 from ...controller import Controller
 from ...register import register
 from ...utils import _
@@ -18,8 +17,10 @@ from ...logger import log
 class Risotto(Controller):
     def __init__(self,
                  test: bool) -> None:
-        self.source_root_path = get_config().get('source').get('root_path')
+        self.source_root_path = get_config()['source']['root_path']
-        self.cache_root_path = join(get_config().get('cache').get('root_path'), 'servermodel')
+        self.cache_root_path = join(get_config()['cache']['root_path'], 'servermodel')
+        self.internal_source_name = get_config()['servermodel']['internal_source']
+        self.internal_distribution_name = get_config()['servermodel']['internal_distribution']
         if not isdir(self.cache_root_path):
             makedirs(join(self.cache_root_path))
 
@@ -27,13 +28,13 @@ class Risotto(Controller):
                       risotto_context: Context) -> None:
         internal_source = await self.call('v1.source.create',
                                           risotto_context,
-                                          source_name='internal',
+                                          source_name=self.internal_source_name,
                                           source_url='none')
         internal_release = await self.call('v1.source.release.create',
                                            risotto_context,
-                                           source_name='internal',
+                                           source_name=self.internal_source_name,
                                            release_name='none',
-                                           release_distribution='last')
+                                           release_distribution=self.internal_distribution_name)
         self.internal_release_id = internal_release['release_id']
 
     async def servermodel_gen_funcs(self,
@@ -68,7 +69,7 @@ class Risotto(Controller):
         as_names_str = '", "'.join(as_names)
         await log.info(risotto_context,
                        _(f'gen funcs for "{servermodel_name}" with application services "{as_names_str}"'))
-        eolobj = CreoleObjSpace(dtdfilename)
+        #eolobj = CreoleObjSpace(get_config()['global']['rougail_dtd_path'])
 
     async def servermodel_gen_schema(self,
                                      servermodel_name: str,
@@ -106,7 +107,7 @@ class Risotto(Controller):
                         continue
                     as_names.add(applicationservice_name)
                     extras.append((namespace, [extra_dir]))
-        eolobj = CreoleObjSpace(dtdfilename)
+        eolobj = CreoleObjSpace(get_config()['global']['rougail_dtd_path'])
         as_names_str = '", "'.join(as_names)
         await log.info(risotto_context,
                        _(f'gen schema for "{servermodel_name}" with application services "{as_names_str}"'))
@@ -159,16 +160,20 @@ class Risotto(Controller):
                                   risotto_context: Context,
                                   servermodel_name: str,
                                   servermodel_description: str,
-                                  servermodel_parents_id: List[int],
+                                  servermodel_parents: List[Dict],
                                   dependencies: List[int],
                                   release_id: int,
                                   release_cache: Dict=None) -> Dict:
-        servermodel_update = """INSERT INTO Servermodel(ServermodelName, ServermodelDescription, ServermodelParentsId, ServermodelReleaseId, ServermodelApplicationServiceId)
+        servermodel_insert = """INSERT INTO Servermodel(ServermodelName, ServermodelDescription, ServermodelParentsId, ServermodelReleaseId, ServermodelApplicationServiceId)
         VALUES ($1,$2,$3,$4,$5)
         RETURNING ServermodelId
         """
         as_name = f"local_{servermodel_name}"
         as_description = f'local application service for {servermodel_name}'
+        servermodel_parents_id = []
+        for servermodel_parent in servermodel_parents:
+            servermodel_parents_id.append(servermodel_parent['servermodel_id'])
+            dependencies.append(servermodel_parent['servermodel_applicationservice_id'])
         applicationservice = await self.call('v1.applicationservice.create',
                                              risotto_context,
                                              applicationservice_name=as_name,
@@ -176,7 +181,7 @@ class Risotto(Controller):
                                              applicationservice_dependencies=dependencies,
                                              release_id=self.internal_release_id)
         applicationservice_id = applicationservice['applicationservice_id']
-        servermodel_id = await risotto_context.connection.fetchval(servermodel_update,
+        servermodel_id = await risotto_context.connection.fetchval(servermodel_insert,
                                                                    servermodel_name,
                                                                    servermodel_description,
                                                                    servermodel_parents_id,
@@ -192,7 +197,7 @@ class Risotto(Controller):
         # build cache to have all release informations
         if release_cache is None:
             release_cache = {}
-        for applicationservice_id, applicationservice_infos in dependencies.items():
+        for applicationservice_infos in dependencies.values():
             applicationservice_name, as_release_id = applicationservice_infos
             if as_release_id not in release_cache:
                 release_cache[as_release_id] = await self.call('v1.source.release.get_by_id',
@@ -217,11 +222,9 @@ class Risotto(Controller):
         sm_dict = {'servermodel_name': servermodel_name,
                    'servermodel_description': servermodel_description,
                    'servermodel_parents_id': servermodel_parents_id,
+                   'servermodel_applicationservice_id': applicationservice_id,
                    'release_id': release_id,
                    'servermodel_id': servermodel_id}
-        await self.publish('v1.servermodel.created',
-                           risotto_context,
-                           **sm_dict)
         return sm_dict
 
     def parse_parents(self,
@@ -236,15 +239,6 @@ class Risotto(Controller):
             self.parse_parents(servermodels, servermodels[parent], parents)
         return parents
 
-    async def get_servermodel_id_by_name(self,
-                                         risotto_context: Context,
-                                         servermodel_name: str,
-                                         release_id: int):
-        sql = 'SELECT ServermodelId as servermodel_id FROM Servermodel WHERE ServermodelName = $1 AND ServermodelReleaseId = $2',
-        return await risotto_context.connection.fetchval(sql,
-                                                         servermodel_name,
-                                                         release_id)['servermodel_id']
-
     @register('v1.servermodel.dataset.updated')
     async def servermodel_update(self,
                                  risotto_context: Context,
@@ -285,14 +279,13 @@ class Risotto(Controller):
                 parents = self.parse_parents(servermodels,
                                              servermodel)
                 parents.reverse()
-                servermodelparent_id = []
+                servermodel_parent = []
                 for new_servermodel in parents:
                     if not servermodels[new_servermodel]['done']:
                         servermodel_description = servermodels[new_servermodel]
                         parent = servermodel_description['parent']
-                        if not servermodelparent_id and parent is not None:
+                        if not servermodel_parent and parent is not None:
-                            # parent is a str, so get ID
+                            servermodel_parent = [await self._servermodel_describe(risotto_context,
-                            servermodelparent_id = [await self.get_servermodel_id_by_name(risotto_context,
                                                                                    parent,
                                                                                    release_id)]
                         # link application service with this servermodel
@@ -309,16 +302,18 @@ class Risotto(Controller):
                             servermodel_ob = await self._servermodel_create(risotto_context,
                                                                             sm_name,
                                                                             sm_description,
-                                                                            servermodelparent_id,
+                                                                            servermodel_parent,
                                                                             dependencies,
                                                                             release_id,
                                                                             release_cache)
-                            servermodel_id = servermodel_ob['servermodel_id']
+                            await self.publish('v1.servermodel.created',
+                                               risotto_context,
+                                               **servermodel_ob)
                         except Exception as err:
                             if get_config().get('global').get('debug'):
                                 print_exc()
                             raise ExecutionError(_(f"Error while injecting servermodel {sm_name} in database: {err}"))
-                        servermodelparent_id = [servermodel_id]
+                        servermodel_parent = [servermodel_ob]
                         servermodel_description['done'] = True
         return {'retcode': 0, 'returns': _('Servermodels successfully loaded')}
 
@@ -327,7 +322,7 @@ class Risotto(Controller):
                                risotto_context: Context,
                                source_id: int):
         sql = '''
-        SELECT ServermodelId as servermodel_id, ServermodelName as servermodel_name, ServermodelDescription as servermodel_description, ServermodelParentsId as servermodel_parents_id, ServermodelReleaseId as release_id
+        SELECT ServermodelId as servermodel_id, ServermodelName as servermodel_name, ServermodelDescription as servermodel_description, ServermodelParentsId as servermodel_parents_id, ServermodelReleaseId as release_id, ServermodelApplicationServiceId as servermodel_applicationservice_id
         FROM Servermodel
         '''
         servermodels = await risotto_context.connection.fetch(sql)
@@ -343,24 +338,58 @@ class Risotto(Controller):
                                   risotto_context,
                                   source_name=source_name,
                                   release_distribution=release_distribution)
+        return await self._servermodel_describe(risotto_context,
+                                                servermodel_name,
+                                                release['release_id'])
+
+    async def _servermodel_describe(self,
+                                    risotto_context,
+                                    servermodel_name,
+                                    release_id):
         sql = '''
-        SELECT ServermodelId as servermodel_id, ServermodelName as servermodel_name, ServermodelDescription as servermodel_description, ServermodelParentsId as servermodel_parents_id, ServermodelReleaseId as release_id
+        SELECT ServermodelId as servermodel_id, ServermodelName as servermodel_name, ServermodelDescription as servermodel_description, ServermodelParentsId as servermodel_parents_id, ServermodelReleaseId as release_id, ServermodelApplicationServiceId as servermodel_applicationservice_id
         FROM Servermodel
         WHERE ServermodelName=$1 AND ServermodelReleaseId=$2
         '''
         servermodel = await risotto_context.connection.fetchrow(sql,
                                                                 servermodel_name,
-                                                                release['release_id'])
+                                                                release_id)
         if not servermodel:
-            raise Exception(_(f'{servermodel_id} is not a valid ID for a servermodel'))
+            raise Exception(_(f'"{servermodel_name}" is not a valid name for a servermodel in source "{source_name}" and release "{release_distribution}"'))
         return dict(servermodel)
 
+    @register('v1.servermodel.create', notification='v1.servermodel.created')
+    async def create_servermodel(self,
+                                 risotto_context: Context,
+                                 servermodel_name: str,
+                                 servermodel_description: str,
+                                 servermodel_parents_name: List[int],
+                                 servermodel_parents_source_name: str,
+                                 servermodel_parents_release_distribution: str) -> Dict:
+        release = await self.call('v1.source.release.describe',
+                                  risotto_context,
+                                  source_name=servermodel_parents_source_name,
+                                  release_distribution=servermodel_parents_release_distribution)
+        release_id = release['release_id']
+        servermodel_parents = []
+        for servermodel_parent_name in servermodel_parents_name:
+            servermodel_parents.append(await self._servermodel_describe(risotto_context,
+                                                                        servermodel_parent_name,
+                                                                        release_id))
+        return await self._servermodel_create(risotto_context,
+                                              servermodel_name,
+                                              servermodel_description,
+                                              servermodel_parents,
+                                              [],
+                                              self.internal_release_id,
+                                              {})
+
     @register('v1.servermodel.get_by_id')
     async def servermodel_get_by_id(self,
                                     risotto_context: Context,
                                     servermodel_id: int) -> Dict:
         sql = '''
-        SELECT ServermodelId as servermodel_id, ServermodelName as servermodel_name, ServermodelDescription as servermodel_description, ServermodelParentsId as servermodel_parents_id, ServermodelReleaseId as release_id
+        SELECT ServermodelId as servermodel_id, ServermodelName as servermodel_name, ServermodelDescription as servermodel_description, ServermodelParentsId as servermodel_parents_id, ServermodelReleaseId as release_id, ServermodelApplicationServiceId as servermodel_applicationservice_id
         FROM Servermodel
         WHERE ServermodelId=$1
         '''

src/risotto/services/session/session.py

@@ -12,12 +12,15 @@ from .storage import storage_server, storage_servermodel
 from ...controller import Controller
 from ...register import register
 from ...dispatcher import dispatcher
+from ...config import get_config
 
 
 class Risotto(Controller):
     def __init__(self,
                  test):
         self.modify_storage = Storage(engine='dictionary')
+        self.internal_source_name = get_config()['servermodel']['internal_source']
+        self.internal_distribution_name = get_config()['servermodel']['internal_distribution']
 
     def get_storage(self,
                     type: str):
@@ -110,17 +113,15 @@ class Risotto(Controller):
     @register('v1.session.servermodel.start')
     async def start_session_servermodel(self,
                                         risotto_context: Context,
-                                        servermodel_name: str,
+                                        servermodel_name: str) -> Dict:
-                                        source_name: str,
-                                        release_distribution: str) -> Dict:
         """ start a new config session for a server or a servermodel
         """
         config_module = dispatcher.get_service('config')
         servermodel = await self.call('v1.servermodel.describe',
                                       risotto_context,
                                       servermodel_name=servermodel_name,
-                                      source_name=source_name,
+                                      source_name=self.internal_source_name,
-                                      release_distribution=release_distribution)
+                                      release_distribution=self.internal_distribution_name)
         if not servermodel or servermodel['servermodel_id'] not in config_module.servermodel:
             raise Exception(_(f'cannot find servermodel with name {servermodel_name}'))
         id = servermodel['servermodel_id']
@@ -293,7 +294,7 @@ class Risotto(Controller):
             modif_config = session['config']
             await config.value.importation(await modif_config.value.exportation())
             await config.permissive.importation(await modif_config.permissive.exportation())
-        storage.del_session(session_id)
+        await storage.del_session(session_id)
         return self.format_session(session_id, session)
 
     @register_http('v1', '/config/server/{session_id}')

src/risotto/services/session/storage.py

@@ -103,8 +103,21 @@ class Storage(object):
             raise NotAllowedError()
         return session
 
-    def del_session(self,
+    async def del_session(self,
                           id: int):
+        config = self.sessions[id]['meta']
+        while True:
+            try:
+                children = list(await config.config.list())
+                if not children:
+                    # it's an empty metaconfig
+                    break
+                config = children[0]
+                await config.session.reset()
+            except:
+                # it's a config, so no "list" method
+                break
+        await self.sessions[id]['meta'].session.reset()
         del self.sessions[id]
 
 

src/risotto/services/template/template.py

@@ -21,17 +21,21 @@ class Risotto(Controller):
     async def template_get(self,
                            risotto_context,
                            server_name: str) -> Dict:
+        # get informations for server
         server = await self.call('v1.server.describe',
                                  risotto_context,
                                  server_name=server_name)
         server_id = server['server_id']
         servermodel_id = server['server_servermodel_id']
+        # verify if server has deployed configuration
         config_module = dispatcher.get_service('config')
         server = config_module.server[server_id]
         export = await server['server'].value.exportation()
         if not export[0]:
             raise Exception(_(f'configuration for server "{server_name}" is empty, you should deploy it first'))
-        config = meta = await server['server'].config.deepcopy(storage=self.storage)
+        # copy deployed configuration
+        async with await server['server'].config.deepcopy(storage=self.storage) as config:
+            meta = config
             while True:
                 try:
                     children = list(await config.config.list())
@@ -56,6 +60,6 @@ class Risotto(Controller):
                            templates_dir,
                            tmp_dir,
                            configurations_dir)
-
+            del meta
         return {'server_name': server_name,
                 'template_dir': configurations_dir}

src/risotto/services/uri/uri.py

@@ -12,6 +12,7 @@ class Risotto(Controller):
         for uri in ['v1.applicationservice.create',
                     'v1.applicationservice.dataset.updated',
                     'v1.server.create',
+                    'v1.servermodel.create',
                     'v1.servermodel.dataset.updated',
                     'v1.session.server.start',
                     'v1.source.create',