All gists

stuzer05's Avatar

stuzer05 / Docker inspect to run converter

0 likes
0 forks
1 files
Last active 1751529428
`docker inspect` template to regenerate the `docker run` command that created a container, https://gist.github.com/efrecon/8ce9c75d518b6eb863f667442d7bc679, docker inspect --format "$(curl -s https://gist.stuzer.link/stuzer05/fdfc31107ce04720a186d409498e82f2/raw/HEAD/run.tpl)" 55a319b7e124
1 docker run \
2 --name {{printf "%q" .Name}} \
3 {{- with .HostConfig}}
4 {{- if .Privileged}}
5 --privileged \
6 {{- end}}
7 {{- if .AutoRemove}}
8 --rm \
9 {{- end}}
10 {{- if .Runtime}}
stuzer05's Avatar

stuzer05 / Decode HeidiSQL export password

0 likes
0 forks
1 files
Last active 1737805613
1 function heidiDecode(hex) {
2 var str = '';
3 var shift = parseInt(hex.substr(-1));
4 hex = hex.substr(0, hex.length - 1);
5 for (var i = 0; i < hex.length; i += 2)
6 str += String.fromCharCode(parseInt(hex.substr(i, 2), 16) - shift);
7 return str;
8 }
9 document.write(heidiDecode('755A5A585C3D8141786B3C385E3A393'));
stuzer05's Avatar

stuzer05 / Oracle search source code in functions DDL

1 likes
0 forks
1 files
Last active 1731272130
1 SELECT
2 type,
3 name,
4 text
5 FROM
6 all_source
7 WHERE
8 type IN ( 'FUNCTION', 'PROCEDURE' )
9 AND UPPER(text) like UPPER('%EI_KURS_VAL%')
10 ORDER BY type, name
stuzer05's Avatar

stuzer05 / Go context.WithCancel() example

0 likes
0 forks
1 files
Last active 1718274035
1 func doWork(ctx context.Context) {
2 for {
3 select {
4 case <-ctx.Done():
5 return
6 default:
7 }
8
9 time.Sleep(1 * time.Second)
10 fmt.Println("doing work...")
stuzer05's Avatar

stuzer05 / Oracle view locked tables

0 likes
0 forks
1 files
Last active 1718092169
1 SELECT o.object_name, o.object_type, l.session_id, l.locked_mode
2 FROM v$locked_object l
3 JOIN dba_objects o ON l.object_id = o.object_id;
stuzer05's Avatar

stuzer05 / Nginx default vhost configuration

0 likes
0 forks
1 files
Last active 1717238660
1 http {
2
3 server {
4 listen 80 default_server;
5 server_name _;
6
7 return 404;
8 }
9
stuzer05's Avatar

stuzer05 / PHP show all errors

0 likes
0 forks
1 files
Last active 1714735618
1 ini_set('display_errors', 1);
2 ini_set('display_startup_errors', 1);
3 error_reporting(E_ALL);
stuzer05's Avatar

stuzer05 / PHP build tree from sql result

0 likes
0 forks
1 files
Last active 1714735592
1 function buildTree(array $elements, $parentId = 0) {
2 $branch = array();
3
4 foreach ($elements as $element) {
5 if ($element['parent_id'] == $parentId) {
6 $children = buildTree($elements, $element['id']);
7 if ($children) {
8 $element['children'] = $children;
9 }
10 $branch[] = $element;
stuzer05's Avatar

stuzer05 / PHP create in-memory zip archive

0 likes
0 forks
1 files
Last active 1714735548
1 $tmp_file = tmpfile();
2 $tmp_file_path = stream_get_meta_data($tmp_file)['uri'];
3
4 $zip = new ZipArchive;
5 $res = $zip->open($tmp_file_path, ZipArchive::CREATE);
6
7 foreach ($ptah_p7s->Signs as $i => $sign) {
8 $zip->addFromString("signature{$i}.p7s", base64_decode($sign));
9 }
stuzer05's Avatar

stuzer05 / SQL tables to Go structs

0 likes
0 forks
3 files
Last active 1714309050
1 SELECT
2 'type ' || table_name || ' struct {' || CHR(10) || fields || CHR(10) || '}' AS models
3 FROM
4 (
5 SELECT
6 table_name,
7 REPLACE(RTRIM(XMLAGG(XMLELEMENT(E, CHR(9) || column_name || CHR(9) || type_info || CHR(9) || annotation || CHR(10))).EXTRACT('//text()').GETCLOBVAL(), CHR(10)), '&quot;', '"') AS fields
8 FROM
9 (
10 SELECT
Newer Older

Powered by Opengist ⋅ Load: 118ms⋅

English