Skip to content

Instantly share code, notes, and snippets.

View gautiermichelin's full-sized avatar

GautierMichelin gautiermichelin

19 followers · 19 following
View GitHub Profile
@gautiermichelin
gautiermichelin / improve_performances.sh
Last active March 13, 2025 19:32
improve_performances.sh
#!/bin/bash
update_config_param() {
local param_name="$1"
local config_file="$2"
local new_value="$3"
if [[ ! -f "$config_file" ]]; then
echo "Erreur : Le fichier $config_file n'existe pas."
return 1
@gautiermichelin
gautiermichelin / gist:b91ab4e5eba6873f85a25356cc3d7129
Created February 20, 2024 21:26
Supraheader idéesculture
<!DOCTYPE html>
<html>
<head>
<title>Supraheader idéesculture</title>
</head>
<body style="background-color: white;">
<div id="supranav" style="padding:0;margin:0;">
<style>
@gautiermichelin
gautiermichelin / mysql_ramdisk.rb
Created May 8, 2021 13:43 — forked from rjkaes/mysql_ramdisk.rb
#!/usr/bin/env ruby
shutdown = false
cnf_path = '/usr/local/etc/my_ramdisk.cnf'
ramdisk_path = '/Volumes/RAMDisk'
loop { case ARGV[0]
when 'shutdown' then ARGV.shift; shutdown = true
else break
end; }
@gautiermichelin
gautiermichelin / my.cnf
Last active November 26, 2020 10:35 — forked from zabustak/my.cnf
Optimized my.cnf configuration for MySQL/MariaSQL (on Ubuntu, CentOS etc. servers)
# Optimized my.cnf configuration for MySQL/MariaSQL
#
# by Fotis Evangelou, developer of Engintron (engintron.com)
# Edited by zabustak
# Edited by GautierMichelin, idéesculture
#
# The settings marked with a specific comment or the word "UPD" (after the value)
# should be adjusted for your system by using database diagnostics tools like:
#
# https://github.com/major/MySQLTuner-perl
@gautiermichelin
gautiermichelin / export_uis_tsv.php
Last active April 12, 2018 08:30
Export in TSV all the screens and the bundles from a CollectiveAccess installation, using a user id (useful for reports)
<?php
require_once("setup.php");
$vt_user = new ca_users(16);
$vt_list_item = new ca_list_items();
print "Table CollectiveAccess | Editeur\tEcran de saisie\tLibellé du champs ou conteneur\tIdentifiant du champs ou conteneur\tType de données\n";
function getScreens($idno) {
@gautiermichelin
gautiermichelin / index.html
Last active May 3, 2021 08:33
Maintenance page Idéesculture
<html>
<head>
<title>Id&eacute;esculture</title>
<link href="https://fonts.googleapis.com/css?family=Encode+Sans:200,400,800" rel="stylesheet">
<style>
body {
font-family: "Encode Sans", helvetica, arial, sans-serif;
font-weight:400;
margin:20px 240px;
@gautiermichelin
gautiermichelin / objects_list_items.sql
Created August 14, 2015 05:34
CollectiveAccess SQL request : used list items inside object records
SELECT ca_list_labels.list_id,
ca_list_labels.`name`,
ca_attribute_values.item_id,
ca_list_item_labels.name_singular,
group_concat(distinct ca_attributes.row_id) as objets
FROM ca_list_labels LEFT OUTER JOIN ca_lists ON ca_list_labels.list_id = ca_lists.list_id
LEFT OUTER JOIN ca_list_items ON ca_lists.list_id = ca_list_items.list_id
LEFT OUTER JOIN ca_attribute_values ON ca_list_items.item_id = ca_attribute_values.item_id
LEFT OUTER JOIN ca_list_item_labels ON ca_list_item_labels.item_id = ca_attribute_values.item_id
LEFT OUTER JOIN ca_attributes ON ca_attribute_values.attribute_id = ca_attributes.attribute_id
@gautiermichelin
gautiermichelin / md-toc.rb
Created July 7, 2015 06:53 — forked from JenniferMack/md-toc.rb
Traduction en français
#!/usr/bin/env ruby
toc = "# Sommaire\n"
newmd = ""
ARGF.each_line do |line|
newmd << line
next if !line.start_with?("#")
heading = line.gsub("#", "").strip
@gautiermichelin
gautiermichelin / detection-images-being-processed.php
Created April 16, 2015 08:47
CollectiveAccess : detection & reprocessing of media not treated by queue (either for access permission or format error)
<?php
require_once('setup.php');
require_once('app/models/ca_object_representations.php');
require_once('app/lib/core/Db.php');
$o_data = new Db();
$qr_reps = $o_data->query("
SELECT *
FROM ca_object_representations
@gautiermichelin
gautiermichelin / gist:c5634a65334248788035
Last active August 29, 2015 14:13
Avant hack base PAFI
$vs_buf .="Ajouter une nouvelle <select name='type_id' id='caAddObjectToLotForm_type_id'>
<option value='4'>&nbsp;&nbsp;&nbsp; Mesure</option>
</select> à la session";