Skip to content

Instantly share code, notes, and snippets.

@jbdesbas
jbdesbas / dataGroupBy.ts
Last active January 17, 2024 20:03
Javascript groupby
const dataGroupBy = (data:[], group_fields:string[], metric_field:string, method:string) => {
const agg_function:(arr:[], field:string) => number = ((arr, field) => {
switch(method){
case 'sum':
return _.sumBy(arr, field)
case 'min':
return _.minBy(arr, field)[field]
case 'max':
return _.maxBy(arr, field)[field]
@jbdesbas
jbdesbas / rebase.md
Created April 11, 2024 07:20
rebase
git checkout feature
git rebase dev
git push --force # car l'historique a changé, OK si personne ne travail sur _feature_
@jbdesbas
jbdesbas / fbfs.py
Created November 12, 2025 11:25
gbfs insert sql
#!/usr/bin/env python3
"""
Script pour générer des INSERT SQL à partir d'un flux GBFS JSON.
Usage :
python3 gbfs.py <url> <system_id> <id_meca> <id_electrical>
Exemple :
python3 gbfs.py https://media.ilevia.fr/opendata/station_status.json v_lille bike NULL | psql service=work
python3 gbfs.py https://api.cyclocity.fr/contracts/amiens/gbfs/v2/station_status.json velam mechanical electrical | psql service=work