diff options
Diffstat (limited to '')
-rwxr-xr-x | skripti/bme280_udp_logger.py | 28 | ||||
-rw-r--r-- | skripti/ž | 36 |
2 files changed, 28 insertions, 36 deletions
diff --git a/skripti/bme280_udp_logger.py b/skripti/bme280_udp_logger.py new file mode 100755 index 0000000..1debe6c --- /dev/null +++ b/skripti/bme280_udp_logger.py @@ -0,0 +1,28 @@ +#!/usr/bin/python3 +import socket +import struct +import sqlite3 +sock = socket.socket(socket.AF_INET6, socket.SOCK_DGRAM); +sock.bind(("::", 3232)) +conn = sqlite3.connect('db') +cur = conn.cursor() +cur.execute(''' +CREATE TABLE IF NOT EXISTS meritve ( + id INTEGER PRIMARY KEY AUTOINCREMENT, + temp REAL NOT NULL, + humid REAL NOT NULL, + pres REAL NOT NULL, + datetime DATETIME DEFAULT CURRENT_TIMESTAMP +) +''') +conn.commit() +while True: + data, addr = sock.recvfrom(1024) + if len(data) != 16: + print(f"Received malformed from {addr}: {data}") + continue + info = struct.unpack("ffff", data) + print(f"Received from {addr}: {info}") + cur = conn.cursor() + cur.execute('INSERT INTO meritve (temp, humid, pres) VALUES (?, ?, ?)', (info[1], info[2], info[3])) + conn.commit() diff --git a/skripti/ž b/skripti/ž deleted file mode 100644 index d18de36..0000000 --- a/skripti/ž +++ /dev/null @@ -1,36 +0,0 @@ -#!/bin/bash -# $1 naj bo icecast host kruljo.radiostudent.si -# $2 naj bo icecast http port 8000 -# $3 naj bo icecast endpoint /ehiq -# $4 naj bo končnica datotek .mp3 -# v CWD delam imenike in datoteke in sem glede tega kompatibilen z earhornom: -# Posnetek 2024/06/03/202136.mp3 se začne 2024-06-03T20:21:36 vedno UTC. -# Posnetkov ne splittam na uro. Posnetek se splitta le takrat, ko se zgodi napaka (stream crkne) -- takrat začnem pisati v novo datoteko -# požvižgam se na vsebino datotek. zame so to le bajti. v tem nisem earhornski. -host=$1 -port=$2 -endpoint=$3 -kon=$4 -mistakes=0 -set -xeuo pipefail -while : -do - filename=`date --utc +%Y/%m/%d/%H%m%S$kon` - mkdir -p `cut -d/ -f1-3 <<<$filename` - start=$SECONDS - set +e - nc $host $port <<<"GET $endpoint HTTP/1.0"$'\r\n\r' > $filename - koda=$? - set -e - echo TCP PREKINJEN! ZAČENJAM NOV POSNETEK! IZHODNA KODA nc je $koda, datum je `date` - if [ $(($SECONDS-$start)) -lt 300 ] - then - mistakes=$(($mistakes+1)) - if [ $mistakes -gt 3 ] - then - sleep $((2**($mistakes-3))) - fi - else - mistakes=0 - fi -done |