db/gen/create_tables.sql

@@ -0,0 +1,151 @@
+-- Deployment
+CREATE TABLE Deployment (
+  DeploymentId SERIAL PRIMARY KEY,
+  ProviderType VARCHAR(255) NOT NULL,
+  TargetType VARCHAR(255) NOT NULL,
+  TargetName VARCHAR(255) NOT NULL,
+  FactoryCluster VARCHAR(255),
+  FactoryNodeName VARCHAR(255),
+  CPU INTEGER,
+  VCPU INTEGER,
+  Memory INTEGER,
+  Labels VARCHAR(255) [] DEFAULT '{}',
+  UNIQUE (TargetType, TargetName)
+);
+CREATE INDEX Deployment_FactoryNodeName_index ON Deployment(FactoryNodeName);
+
+-- Cluster
+CREATE TABLE FactoryCluster (
+  ClusterId SERIAL PRIMARY KEY,
+  ClusterName VARCHAR(255) NOT NULL UNIQUE,
+  ClusterDescription VARCHAR(255) NOT NULL,
+  VirtualIp VARCHAR(15) NOT NULL,
+  ZoneName VARCHAR(255) NOT NULL
+);
+
+-- Node in Cluster
+CREATE TABLE FactoryClusterNode (
+  ClusterNodeId SERIAL PRIMARY KEY,
+  ClusterId INTEGER NOT NULL,
+  ServerName VARCHAR(255) NOT NULL UNIQUE,
+  FOREIGN KEY (ClusterId) REFERENCES FactoryCluster(ClusterId)
+);
+CREATE INDEX FactoryClusterNode_ServerName_index ON FactoryClusterNode(ServerName);
+-- Site
+CREATE TABLE Site (
+  SiteId SERIAL PRIMARY KEY,
+  SiteName VARCHAR(255) NOT NULL UNIQUE,
+  SiteDescription VARCHAR(255) NOT NULL
+);
+
+-- Zone
+CREATE TABLE Zone (
+  ZoneId SERIAL PRIMARY KEY,
+  ZoneName VARCHAR(255) NOT NULL UNIQUE,
+  ZoneDescription VARCHAR(255) NOT NULL,
+  SitesName VARCHAR(255) [] NOT NULL
+);
+
+-- Server
+CREATE TABLE Server (
+  ServerId SERIAL PRIMARY KEY,
+  ServerName VARCHAR(255) NOT NULL UNIQUE,
+  ServerDescription VARCHAR(255) NOT NULL,
+  ServerServermodelName VARCHAR(255) NOT NULL,
+  ReleaseDistribution VARCHAR(255) NOT NULL,
+  SiteName VARCHAR(255) NOT NULL,
+  ZonesName VARCHAR(255) [] NOT NULL,
+  ZonesIP VARCHAR(255) [] NOT NULL
+);
+-- Source
+CREATE TABLE Source (
+  SourceId SERIAL PRIMARY KEY,
+  SourceName VARCHAR(255) NOT NULL UNIQUE,
+  SourceURL TEXT
+);
+
+-- 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)
+);
+
+-- Servermodel
+CREATE TABLE Servermodel (
+  ServermodelId SERIAL PRIMARY KEY,
+  ServermodelName VARCHAR(255) NOT NULL,
+  ServermodelDescription VARCHAR(255) NOT NULL,
+  Osname VARCHAR(255),
+  Osversion VARCHAR(255),
+  ISO VARCHAR(255),
+  ServermodelParents VARCHAR(255) [] DEFAULT '{}',
+  SourceName VARCHAR(255) NOT NULL,
+  ReleaseDistribution VARCHAR(255) NOT NULL,
+  ServermodelApplicationserviceId INTEGER NOT NULL,
+  UNIQUE (ServermodelName, SourceName, ReleaseDistribution)
+);
+CREATE INDEX ServermodelApplicationserviceId_index ON Servermodel (ServermodelApplicationserviceId);
+
+-- Applicationservice
+CREATE TABLE Applicationservice (
+  ApplicationserviceId SERIAL PRIMARY KEY,
+  ApplicationserviceName VARCHAR(255) NOT NULL,
+  ApplicationserviceDescription VARCHAR(255) NOT NULL,
+  ApplicationserviceReleaseId INTEGER NOT NULL,
+  ApplicationserviceLVIS VARCHAR(255) NOT NULL,
+  ApplicationserviceLVIP VARCHAR(255) NOT NULL,
+  ApplicationserviceLVMP VARCHAR(255) NOT NULL,
+  OS JSON,
+  UNIQUE (ApplicationserviceName, ApplicationserviceReleaseId)
+);
+
+CREATE TABLE ApplicationserviceDependency (
+  ApplicationserviceId INTEGER NOT NULL,
+  ApplicationserviceDependencyId INTEGER NOT NULL,
+  UNIQUE(ApplicationserviceId, ApplicationserviceDependencyId),
+  FOREIGN KEY (ApplicationserviceId) REFERENCES Applicationservice(ApplicationserviceId),
+  FOREIGN KEY (ApplicationserviceDependencyId) REFERENCES Applicationservice(ApplicationserviceId)
+);
+
+-- Log
+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
+);
+-- User, Role and ACL
+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)
+);

debian/compat

@@ -1 +0,0 @@
-11

debian/control

@@ -1,41 +0,0 @@
-Source: eole-risotto
-Section: admin
-Priority: optional
-Maintainer: Cadoles <contact@cadoles.com>
-Build-Depends: debhelper (>= 11)
-Standards-Version: 3.9.3 
-Homepage: https://forge.cadoles.com/Infra/risotto
-Vcs-Git: https://forge.cadoles.com/Infra/risotto
-Vcs-Browser: https://forge.cadoles.com/Infra/risotto
-
-Package: eole-risotto
-Architecture: any
-Depends: ${misc:Depends},
- eole-db,
- eole-postgresql,
- risotto-user-sql,
- risotto-setting-sql,
- risotto-provider-sql,
- risotto-infra-sql,
- risotto-message,
- risotto
-Description: configuration pour l’intégration de risotto dans EOLE
- .
- Pour toute information complémentaire, veuillez vous rendre sur le
- site du projet.
-
-Package: eole-risotto-all
-Architecture: any
-Depends: ${misc:Depends},
- eole-risotto,
- python3-risotto-user,
- python3-risotto-setting,
- python3-risotto-provider,
- python3-risotto-infra,
- cadoles-risotto-seed,
- cucchiaiata,
- eole-risotto
-Description: configuration pour l’intégration de risotto dans EOLE
- .
- Pour toute information complémentaire, veuillez vous rendre sur le
- site du projet.

debian/copyright

@@ -1,44 +0,0 @@
-Format: http://dep.debian.net/deps/dep5
-Upstream-Name: {PROJECT}
-Source: {URL}
-
-Files: *
-Copyright: YEAR {UPSTREAM} {AUTHOR} <{MAIL}>
-License: {UPSTREAM LICENSE}
-
-Files: debian/*
-Copyright: 2012 Équipe EOLE <eole@ac-dijon.fr>
-License: CeCILL-2
-
-License: {UPSTREAM LICENSE}
- {TEXT OF THE LICENSE}
-
-License: CeCILL-2
- This software is governed by the CeCILL-2 license under French law and
- abiding by the rules of distribution of free software.  You can  use,
- modify and or redistribute the software under the terms of the CeCILL-2
- license as circulated by CEA, CNRS and INRIA at the following URL
- "http://www.cecill.info";.
- .
- As a counterpart to the access to the source code and  rights to copy,
- modify and redistribute granted by the license, users are provided only
- with a limited warranty  and the software's author,  the holder of the
- economic rights,  and the successive licensors  have only  limited
- liability.
- .
- In this respect, the user's attention is drawn to the risks associated
- with loading,  using,  modifying and/or developing or reproducing the
- software by the user in light of its specific status of free software,
- that may mean  that it is complicated to manipulate,  and  that  also
- therefore means  that it is reserved for developers  and  experienced
- professionals having in-depth computer knowledge. Users are therefore
- encouraged to load and test the software's suitability as regards their
- requirements in conditions enabling the security of their systems and/or
- data to be ensured and,  more generally, to use and operate it in the
- same conditions as regards security.
- .
- The fact that you are presently reading this means that you have had
- knowledge of the CeCILL-2 license and that you accept its terms.
- .
- On Eole systems, the complete text of the CeCILL-2 License can be found
- in '/usr/share/common-licenses/CeCILL-2-en'.

debian/rules

@@ -1,11 +0,0 @@
-#!/usr/bin/make -f
-# -*- makefile -*-
-
-# Uncomment this to turn on verbose mode.
-#export DH_VERBOSE=1
-
-%:
-	dh $@
-
-override_dh_installsystemd:
-	dh_installsystemd -peole-risotto --no-enable --no-start --no-stop-on-upgrade

debian/source/format

@@ -1 +0,0 @@
-3.0 (quilt)

dicos/20_partitioning_risotto.xml

@@ -1,26 +0,0 @@
-<?xml version="1.0" encoding="utf-8"?>
-
-<creole>
-    <variables>
-        <family name='système'>
-            <!-- We need to recalculate the variables -->
-            <variable name='eole_lv_names' redefine='True' remove_check='True' />
-            <variable name='eole_lv_standard_extends' redefine='True' remove_check='True' />
-        </family>
-    </variables>
-    <constraints>
-        <!-- Default AmonEcole* logical volumes -->
-        <auto name='calc_multi_val' target='eole_lv_names'>
-            <param>root</param>
-            <param>tmp</param>
-        </auto>
-        <auto name='calc_multi_val' target='eole_lv_standard_extends'>
-            <param type='number'>100</param>
-            <param type='number'>0</param>
-        </auto>
-    </constraints>
-    <help/>
-</creole>
-<!-- vim: ts=4 sw=4 expandtab
--->
-

dicos/50_risotto.xml

@@ -34,13 +34,13 @@
                 <value>localhost</value>
             </variable>
             <variable name='risotto_messages_dir' type='filename' description='Emplacement des messages de l’API' hidden='True'>
-                <value>/usr/share/risotto-message/messages</value>
+                <value>/srv/risotto-message/messages</value>
             </variable>
             <variable name='risotto_cache_dir' type='filename' description='Emplacement du cache' hidden='True'>
-                <value>/srv/risotto/cache/risotto</value>
+                <value>/var/cache/risotto</value>
             </variable>
             <variable name='risotto_seed_dir' type='filename' description='Emplacement des descriptions de services' hidden='True'>
-                <value>/usr/share/risotto/seed</value>
+                <value>/srv/risotto/seed</value>
             </variable>
             <variable name='risotto_factory_configuration_dir' type='filename' description='Emplacement de la configuration du provider factory' hidden='True'>
                 <value>/srv/factory/</value>

postservice/01-fix-postgresql-permissions

@@ -2,8 +2,6 @@
 
 set -e
 
-systemctl start postgresql.service
-
 psql -Upostgres -c "grant all on all tables in schema public to risotto" risotto
 psql -Upostgres -c "grant all on all sequences in schema public to risotto" risotto
 psql -Upostgres -c "grant all on all functions in schema public to risotto" risotto
@@ -11,6 +9,4 @@ psql -Upostgres -c "grant all on all tables in schema public to tiramisu" tirami
 psql -Upostgres -c "grant all on all sequences in schema public to tiramisu" tiramisu
 psql -Upostgres -c "grant all on all functions in schema public to tiramisu" tiramisu
 
-systemctl stop postgresql.service
-
 exit 0

posttemplate/20-directories

@@ -1,7 +0,0 @@
-#!/bin/bash
-
-for dir in risotto_messages_dir risotto_cache_dir risotto_seed_dir; do
-    mkdir -p $(CreoleGet dir)
-done
-
-exit 0

tmpl/risotto.yml

@@ -1,23 +1,17 @@
-%from os import listdir
 %set %%dbname = %%getVar('risotto_main_dbname')
 ---
 dbuser: %%getVar('risotto_db_user')
 dbuser_options:
-  - LOGIN
+    - LOGIN
 privileges:
-  %%{dbname}.public.*: 'ALL'
-  %%{dbname}.public: 'ALL'
-  %%{dbname}: 'ALL'
+    %%{dbname}.public.*: 'ALL'
+    %%{dbname}.public: 'ALL'
+    %%{dbname}: 'ALL'
 dbhost: %%getVar('risotto_db_address')
 dbport: 5432
 dbtype: postgres
 dbname: %%dbname
 template: 'template0'
-sqlscripts:
-%for %%file in %%listdir('/usr/share/eole/db/eole-risotto/gen/')
- %if %%file.endswith('.sql')
-  - /usr/share/eole/db/eole-risotto/gen/%%file
- %end if
-%end for
+sqlscripts: ['/usr/share/eole/db/eole-risotto/gen/create_tables.sql']
 pwd_files:
-  - {'file': '/etc/risotto/risotto.conf', 'pattern': 'RISOTTO_DB_PASSWORD='}
+        - {'file': '/etc/risotto/risotto.conf', 'pattern': 'RISOTTO_DB_PASSWORD='}