NikolasK-source

Using Channel-IDs (that's not UUID)

SELECT
  timestamp * 0.001 as time_sec, 
  data.value as value, 
  properties.value as metric
FROM data
  LEFT JOIN properties ON (properties.entity_id = data.channel_id)
  LEFT JOIN entities ON (entities.id = data.channel_id)

NikolasK-source

#!/bin/bash
#
# Copyright (C) 2022 Nikolas Koesling <nikolas@koesling.info>.
#
# Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated
# documentation files (the "Software"), to deal in the Software without restriction, including without limitation the
# rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to
# permit persons to whom the Software is furnished to do so, subject to the following conditions:
#
# The above copyright notice and this permission notice shall be included in all copies or substantial portions of the

NikolasK-source

#pragma once

#include <random>
#include <string>
#include <ctime>

namespace RandomString {

static constexpr const char* DEFAULT_CHARSET = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz";
static std::default_random_engine random{static_cast<unsigned>(time(0))};

NikolasK-source

/*
 * Copyright (C) 2022 Nikolas Koesling <nikolas@koesling.info>.
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated
 * documentation files (the "Software"), to deal in the Software without restriction, including without limitation the
 * rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to
 * permit persons to whom the Software is furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in all copies or substantial portions of the
 * Software.

NikolasK-source

#!/bin/bash
trap "" INT TERM QUIT

flatpak run network.koesling.shm-modbus dump-shm $@

ret=$?
if [ $ret -gt 128 ]; then
    exit 0
fi
exit $ret

NikolasK-source

#!/bin/bash
trap "" INT TERM QUIT

flatpak run network.koesling.shm-modbus dump-shm $@

ret=$?
if [ $ret -gt 128 ]; then
    exit 0
fi
exit $ret

NikolasK-source

#!/usr/bin/python3

# MIT License
# 
# Copyright (c) 2023 Nikolas Koesling <nikolas@koesling.info>
# 
# Permission is hereby granted, free of charge, to any person obtaining a copy
# of this software and associated documentation files (the "Software"), to deal
# in the Software without restriction, including without limitation the rights
# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell

NikolasK-source

#!/usr/bin/python

#
# Wrapper to simplify a recursive grep with a pearl compatible regular expression
#

# MIT License
# 
# Copyright (c) 2023 Nikolas Koesling <nikolas@koesling.info>
# 

NikolasK-source

alias dshm="dump-shm"
alias mbsig="shm-modbus-signal-gen"
alias mbtcp="modbus-tcp-client-shm"
alias mbrtu="modbus-rtu-client-shm"
alias shmrnd="shared-mem-random"
alias stdin2mb="stdin-to-modbus-shm"
alias wagomb="wago-modbus-coupler-shm"
alias wshm="write-shm"

NikolasK-source

/*
 * MIT License
 *
 * Copyright (c) 2023 Nikolas Koesling <nikolas@koesling.info>
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is