Nadine Rhinogradentia
Rhinogradentia
/ drone-cleanup.php
Created
November 28, 2022 10:52
— forked from MorrisJobke/drone-cleanup.php
Script to cleanup drone builds after a given retention period
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /* | |
| Script that cleans up old builds of all repos of a drone server. | |
| Dependencies: | |
| $ # having PHP and composer installed | |
| $ composer require "guzzlehttp/guzzle=^6.3" |
Rhinogradentia
/ remove_old_builds.sql
Created
November 23, 2022 08:31
— forked from david-zw-liu/remove_old_builds.sql
Keep 1000 builds per repos for DroneCI (sqlite3 version >= 3.25 required)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Thank @sbengo to figure out foreign_keys constraints is defaults to false in sqlite | |
| -- Enable to delete logs by cascading delete | |
| PRAGMA foreign_keys = ON; | |
| WITH n_build_ids_per_repo as ( | |
| SELECT build_id | |
| FROM ( | |
| SELECT | |
| build_id, | |
| build_repo_id, |
Rhinogradentia
/ gist:a6d8302f1f5a82a01b06ee260e55305d
Created
September 27, 2022 12:33
— forked from Rafe/gist:3102414
AWK cheatsheet
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| HANDY ONE-LINE SCRIPTS FOR AWK 30 April 2008 | |
| Compiled by Eric Pement - eric [at] pement.org version 0.27 | |
| Latest version of this file (in English) is usually at: | |
| http://www.pement.org/awk/awk1line.txt | |
| This file will also be available in other languages: | |
| Chinese - http://ximix.org/translation/awk1line_zh-CN.txt | |
| USAGE: |