Skip to content

Instantly share code, notes, and snippets.

View TimVosch's full-sized avatar

Tim van Osch TimVosch

View GitHub Profile
@TimVosch
TimVosch / example.go
Last active July 5, 2025 14:36
Composable DB models queries
func TestBasicRelationalModel(t *testing.T) {
// Arrange test database
db, sq := setupDB(t)
sq.Insert("authors").
Values(1, "Jeff", "cool,awesome").
Values(2, "Madonna", "vocal").Exec()
sq.Insert("books").
Values(1, "Life of Jeff", 1).
Values(2, "Cooking like Jeff", 1).
Values(3, "Sing baby sing", 2).
@TimVosch
TimVosch / formatter.js
Created December 4, 2025 11:15
MFM V3 waterlevel TTN payload formatter
function version(msb, lsb) {
let v = (msb << 8) | lsb;
return {
proto: (v >> 15) & 0x01,
major: (v >> 10) & 0x1F,
minor: (v >> 5) & 0x1F,
patch: (v >> 0) & 0x1F
};
}