fljdin

OPTIONS=role:Ra
OPTIONS=race:random,gender:random,align:random
OPTIONS=disclose:yi -a -v -g -c +o

OPTIONS=lit_corridor,hitpointbar
OPTIONS=!autopickup,!legacy

OPTIONS=guicolor,color
OPTIONS=windowtype:curses
OPTIONS=windowcolors:menu white/black message green/yellow status white/blue text #ffffff/#000000

fljdin

# -*- mode: ruby -*-
# vi: set ft=ruby :
Vagrant.configure("2") do |config|
  config.vm.box = "centos/7"
  config.vm.hostname = "centos7"

  config.vm.provider "libvirt" do |libvirt|
    libvirt.memory="1512"
    libvirt.cpus=2
    libvirt.disk_driver :cache => "none"

fljdin

# -*- mode: ruby -*-
# vi: set ft=ruby :
Vagrant.configure("2") do |config|
  config.vm.box = "rockylinux/8"
  config.vm.hostname = "rocky8"

  config.vm.provider "libvirt" do |libvirt|
    libvirt.memory = 512
    libvirt.cpus = 2
    libvirt.machine_virtual_size = 40

fljdin

#/bin/bash

# encrypted USB stick by uuid
UUID=a20ec820-de7d-40ec-ac29-4595a10c38e7
PASS=xxxxxxxx
EXCLUDE=$HOME/.config/borg/exclude.list

# helpers
info() { notify-send "$*"; }
trap 'echo $( date ) Backup interrupted >&2; disk_unmount; exit 2' INT TERM

fljdin

DROP TABLE IF EXISTS staff;
CREATE TABLE staff (
  id int PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
  name varchar(50),
  start date NOT NULL,
  finish date,
  period daterange GENERATED ALWAYS AS (daterange(start, finish, '[]')) STORED,
  CHECK (start < finish OR finish IS NULL)
);

fljdin

-- Type month_day
DROP TYPE IF EXISTS month_day CASCADE;
CREATE TYPE month_day AS (month int, day int);

-- Function easter_date(date)
CREATE OR REPLACE FUNCTION easter_date(year int)
  RETURNS date LANGUAGE plpgsql
AS $$
DECLARE
  g integer := year % 19;

fljdin

SELECT i.indrelid::regclass AS "Table", i.indexrelid::regclass AS "Index",
       pg_size_pretty(pg_relation_size(i.indexrelid)) AS "Taille de l'index"
  FROM pg_index i JOIN (
  SELECT indrelid, indclass, indkey, indexprs, indpred
    FROM pg_index GROUP BY indrelid, indclass, indkey, indexprs, indpred
  HAVING COUNT (*) > 1
) g ON i.indrelid = g.indrelid AND i.indclass = g.indclass AND i.indkey = g.indkey 
    AND COALESCE(i.indexprs::text,'x') = COALESCE(g.indexprs::text,'x') 
    AND COALESCE(i.indpred::text,'x') = COALESCE(g.indpred::text,'x')
ORDER BY pg_relation_size(i.indexrelid) DESC, i.indexrelid::regclass;

fljdin

#ifndef __testing_h__
#define __testing_h__

#include <stdio.h>

#define ANSI_GREEN "\033[0;32m"
#define ANSI_RED "\033[0;31m"
#define ANSI_RESET "\033[0m"

#define log_passed(M,...) fprintf(stderr,\

fljdin

#!/bin/bash

echo -n "Starting backup... Are you sure ? y/(n) " ; read response
test ${response:-n} != "y" && exit 1

dotfiles=$(dirname $0)/dotfiles.txt
destination=$(dirname $0)/home

# create dotfiles archives or append new files to it
tar -czf $HOME/dotfiles.tar.gz -C $HOME --files-from=$dotfiles

fljdin

SELECT schemaname, relname, pg_size_pretty(pg_relation_size(relname::regclass)) relsize, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze
  FROM pg_stat_user_tables 
 WHERE greatest(last_autoanalyze,last_analyze) < now()-interval '5d' 
   AND pg_relation_size(relname::regclass) > 10e6;