Rework buildbot: Move towards independent builds

[perso/Immae/Config/Nix.git] / modules / private / websites / nicecoop / gestion-compte.nix

{ lib, pkgs, config, ... }:
let
  secrets = config.myEnv.websites.nicecoop.gestion-compte;
  varDir = "/var/lib/nicecoop_gestion-compte/var";
  parametersPath = "/var/lib/buildbot/outputs/nicecoop/gestion/production/parameters.yml";
  app = pkgs.callPackage ./gestion-compte {
    inherit varDir;
    secretsPath = parametersPath;
  };
  cfg = config.myServices.websites.nicecoop.gestion-compte;
in {
  options.myServices.websites.nicecoop.gestion-compte.enable = lib.mkEnableOption "enable nicecoop's gestion-compte website";

  config = lib.mkIf cfg.enable {
    services.phpfpm.pools.nicecoop_gestion-compte = {
      user = config.services.httpd.Prod.user;
      group = config.services.httpd.Prod.group;
      settings = {
        "listen.owner" = config.services.httpd.Prod.user;
        "listen.group" = config.services.httpd.Prod.group;
        "php_admin_value[open_basedir]" = builtins.concatStringsSep ":" [
          app
          varDir
          parametersPath
          "/tmp"
        ];
        "php_admin_value[upload_max_filesize]" = "20M";
        "php_admin_value[post_max_size]" = "20M";
        "php_admin_value[session.save_path]" = "${varDir}/phpSessions";
        "pm" = "dynamic";
        "pm.max_children" = "20";
        "pm.start_servers" = "2";
        "pm.min_spare_servers" = "1";
        "pm.max_spare_servers" = "3";
      };
    };
    system.extraSystemBuilderCmds = let
      tarball = pkgs.runCommand "production.tar.gz" {} ''
        tar -P --transform="s@${app}@production_app@" -czf $out ${app}
      '';
    in ''
      mkdir -p $out/nicecoop/gestion
      ln -s ${tarball} $out/nicecoop/gestion/production.tar.gz
    '';
    systemd.services.phpfpm-nicecoop_gestion-compte = {
      after = lib.mkAfter ["mysql.service"];
      wants = ["mysql.service"];
      preStart = lib.mkAfter ''
        /run/wrappers/bin/sudo chown wwwrun:wwwrun ${parametersPath}
        watchFilesChanged() {
          [ ! -f "${varDir}"/watchedFiles ] \
            || ! sha512sum -c --status ${varDir}/watchedFiles
        }
        appDirChanged() {
          [ ! -f "${varDir}/currentWebappDir" -o \
            "${app}" != "$(cat ${varDir}/currentWebappDir 2>/dev/null)" ]
        }
        updateWatchFiles() {
          sha512sum ${parametersPath} > ${varDir}/watchedFiles
        }

        if watchFilesChanged || appDirChanged; then
          pushd ${app} > /dev/null
          /run/wrappers/bin/sudo -u wwwrun ./bin/console --env=prod cache:clear
          /run/wrappers/bin/sudo -u wwwrun ./bin/console --env=prod doctrine:database:create -n --if-not-exists
          /run/wrappers/bin/sudo -u wwwrun ./bin/console --env=prod doctrine:migrations:migrate -n
          popd > /dev/null
          echo -n "${app}" > ${varDir}/currentWebappDir
          updateWatchFiles
        fi
      '';
    };

    services.cron = {
      systemCronJobs = let
        prefix = "${config.services.httpd.Prod.user} cd ${app} && ./bin/console --env=prod";
      in [
        ''
          # generate shifts in 27 days (same weekday as yesterday)
          55 5 * * * ${prefix} app:shift:generate $(date -d "+27 days" +\%Y-\%m-\%d)

          # free pre-booked shifts
          55 5 * * * ${prefix} app:shift:free $(date -d "+21 days" +\%Y-\%m-\%d)

          # send reminder 2 days before shift
          #0 6 * * * ${prefix} app:shift:reminder $(date -d "+2 days" +\%Y-\%m-\%d)

          # execute routine for cycle_end/cycle_start, everyday
          5 6 * * * ${prefix} app:user:cycle_start

          # send alert on shifts booking (low)
          #0 10 * * * ${prefix} app:shift:send_alerts --emails creneaux@nicecoop.fr $(date -d "+2 days" +\%Y-\%m-\%d) 1

          # send a reminder mail to the user who generate the last code but did not validate the change.
          #45 21 * * * ${prefix} app:code:verify_change --last_run 24
        ''
      ];
    };

    system.activationScripts.nicecoop_gestion-compte = {
      deps = [];
      text = ''
        install -m 0700 -o wwwrun -g wwwrun -d ${varDir} ${varDir}/phpSessions ${varDir}/var
      '';
    };

    services.filesWatcher.phpfpm-nicecoop_gestion-compte = {
      restart = true;
      paths = [
        parametersPath
      ];
    };

    secrets.keys."buildbot/nicecoop/production.yml" = {
      user = "buildbot";
      group = "buildbot";
      permissions = "0400";
      text = builtins.toJSON {
        database = {
          host = secrets.mysql.host;
          port = secrets.mysql.port;
          name = secrets.mysql.database;
          user = secrets.mysql.user;
          password = secrets.mysql.password;
          version = pkgs.mariadb.mysqlVersion;
        };
        admipassword = secrets.adminpassword;
        smtp = {
          host = secrets.smtp.host;
          port = secrets.smtp.port;
          email = secrets.smtp.email;
          password = secrets.smtp.password;
        };
        secret = secrets.secret;
      };
    };

    # secrets.keys."websites/nicecoop/gestion-compte" = {
    #   user = config.services.httpd.Prod.user;
    #   group = config.services.httpd.Prod.group;
    #   permissions = "0400";
    #   text = ''
    #     # This file is auto-generated during the composer install
    #     parameters:
    #         database_host: ${secrets.mysql.host}
    #         database_port: ${secrets.mysql.port}
    #         database_name: ${secrets.mysql.database}
    #         database_user: ${secrets.mysql.user}
    #         database_password: ${secrets.mysql.password}
    #         database_version: ${pkgs.mariadb.mysqlVersion}
    #         super_admin.username: admin
    #         super_admin.initial_password: ${secrets.adminpassword}
    #         mailer_transport: smtp
    #         mailer_host: ${secrets.smtp.host}
    #         mailer_port: ${secrets.smtp.port}
    #         mailer_user: ${secrets.smtp.email}
    #         mailer_password: ${secrets.smtp.password}
    #         mailer_encryption: tls
    #         transactional_mailer_user: ${secrets.smtp.email}
    #         transactional_mailer_user_name: 'espace membre'
    #         emails.base_domain: tools.immae.eu
    #         emails.contact:
    #             from_name: 'Contact Nicecoop'
    #             address: ${secrets.smtp.email}
    #         emails.member:
    #             from_name: 'Membres Nicecoop'
    #             address: ${secrets.smtp.email}
    #         emails.shift:
    #             from_name: 'Créneaux Nicecoop'
    #             address: ${secrets.smtp.email}
    #         emails.formation:
    #             from_name: 'Formation Nicecoop'
    #             address: ${secrets.smtp.email}
    #         emails.admin:
    #             from_name: 'Admin Nicecoop'
    #             address: ${secrets.smtp.email}
    #         emails.noreply:
    #             from_name: 'Ne pas répondre'
    #             address: ${secrets.smtp.email}
    #         emails.sendable:
    #             - '%emails.contact%'
    #             - '%emails.member%'
    #             - '%emails.shift%'
    #             - '%emails.formation%'
    #             - '%emails.admin%'
    #             - '%emails.noreply%'
    #         shift_mailer_user: null
    #         secret: ${secrets.secret}
    #         router.request_context.host: membre.nicecoop.fr
    #         router.request_context.scheme: https
    #         router.request_context.base_url: null
    #         site_name: 'Espace membre @ Nicecoop'
    #         project_name: 'Nicecoop'
    #         project_url: 'https://membre.nicecoop.fr/'
    #         project_url_display: membre.nicecoop.fr
    #         main_color: null
    #         local_currency_name: 'monnaie locale'
    #         place_local_ip_address: '127.0.0.1,192.168.0.x'
    #         wiki_keys_url: null
    #         registration_duration: '1 year'
    #         registration_every_civil_year: false
    #         helloasso_registration_campaign_url: 'https://www.helloasso.com/associations/my-local-coop/adhesions/re-adhesion'
    #         helloasso_campaign_id: null
    #         helloasso_api_key: null
    #         helloasso_api_password: null
    #         helloasso_api_base_url: 'https://api.helloasso.com/v3/'
    #         due_duration_by_cycle: 180
    #         min_shift_duration: 90
    #         cycle_duration: '28 days'
    #         maximum_nb_of_beneficiaries_in_membership: 2
    #         new_users_start_as_beginner: true
    #         allow_extra_shifts: true
    #         max_time_in_advance_to_book_extra_shifts: '3 days'
    #         display_gauge: true
    #         use_fly_and_fixed: false
    #         time_after_which_members_are_late_with_shifts: -9
    #         reserve_new_shift_to_prior_shifter: true
    #         forbid_shift_overlap_time: 30
    #         display_name_shifters: false
    #         use_card_reader_to_validate_shifts: false
    #         max_time_at_end_of_shift: 0
    #         swipe_card_logging: true
    #         display_swipe_cards_settings: true
    #         logging.mattermost.enabled: false
    #         logging.mattermost.level: critical
    #         logging.mattermost.url: 'http://mattermost.yourcoop.local'
    #         logging.mattermost.channel: null
    #         logging.swiftmailer.enabled: false
    #         logging.swiftmailer.level: critical
    #         logging.swiftmailer.recipient: null
    #         code_generation_enabled: true
    #         display_freeze_account: true
    #         display_keys_shop: true
    #     services:
    #       swiftmailer.mailer.default.transport:
    #           class:     Swift_SendmailTransport
    #           arguments: ['/run/wrappers/bin/sendmail -bs']
    #   '';
    # };

    services.websites.env.production.vhostConfs.nicecoop_gestion-compte = {
      certName     = "nicecoop";
      certMainHost = "membre.nicecoop.fr";
      hosts        = ["membre.nicecoop.fr"];
      root         = app.webRoot;
      extraConfig  = [
        ''
        <FilesMatch "\.php$">
          SetHandler "proxy:unix:${config.services.phpfpm.pools.nicecoop_gestion-compte.socket}|fcgi://localhost"
        </FilesMatch>

        <Directory ${app.webRoot}>
          Options Indexes FollowSymLinks MultiViews Includes
          AllowOverride All
          Require all granted
        </Directory>
        ''
      ];
    };
  };
}