Skip to content

Instantly share code, notes, and snippets.

View nevergone's full-sized avatar

Kurucz István nevergone

View GitHub Profile
@nevergone
nevergone / microbit - fénysorompó.py
Last active January 9, 2022 12:55
Fénysorompó készítése Micro:bit platformon
def elo_tilos_jelzes_utasitasok():
pins.digital_write_pin(DigitalPin.P0, 0)
def on_button_pressed_a():
global szabad
while foglalt:
basic.pause(100)
if szabad:
szabad = False
elo_tilos_jelzes_utasitasok()
http://example.com/foobar/http://example.com/foobar/
@nevergone
nevergone / .gitconfig
Last active July 25, 2025 12:59
git config
[core]
quotepath = false
whitespace = trailing-space,space-before-tab
autocrlf = input
[alias]
# "commit" roviditesek
ci = commit
cia = commit -a
ciam = commit --amend
cif = commit --fixup
@nevergone
nevergone / comment_child_count.sql
Last active February 17, 2023 07:23
Posts with the most one-level children comments (Drupal 8-10)
Without Subselect:
SELECT count(child.cid), parent.cid, user.uid, user.name, node_field.nid, node_field.title
FROM comment_field_data as parent
LEFT JOIN comment_field_data AS child ON parent.cid = child.pid
INNER JOIN users_field_data as user ON parent.uid=user.uid
INNER JOIN node_field_data as node_field ON parent.entity_id=node_field.nid
GROUP BY parent.cid
ORDER BY COUNT(child.cid) DESC;