Skip to content

Instantly share code, notes, and snippets.

View oksbwn's full-sized avatar
🎯
Focusing

Bikash Narayan Panda oksbwn

🎯
Focusing
57 followers · 3 following
View GitHub Profile
@oksbwn
oksbwn / openhab_tasmota_pow.md
Created July 30, 2023 17:43
Sonoff POW Elite, with TASMOTA firmware, data ingestion to OPENHAB

The Things File:

Thing mqtt:topic:localMosquitto:SonoffPowElite_32D  "Sonoff Power Elite Main" (mqtt:broker:localMosquitto)  {
    Channels:
        Type number : power "Power" [ stateTopic="home/sonoff/106/pow3/tele/SENSOR", transformationPattern="JSONPATH:$.ENERGY.Power"]
        Type number : apower "Apparent Power" [ stateTopic="home/sonoff/106/pow3/tele/SENSOR", transformationPattern="JSONPATH:$.ENERGY.ApparentPower"]
        Type number : rpower "Reactive Power" [ stateTopic="home/sonoff/106/pow3/tele/SENSOR", transformationPattern="JSONPATH:$.ENERGY.ReactivePower"]
        Type number : pfactor "power Factor" [ stateTopic="home/sonoff/106/pow3/tele/SENSOR", transformationPattern="JSONPATH:$.ENERGY.Factor"]
        Type number : voltage "Voltage" [ stateTopic="home/sonoff/106/pow3/tele/SENSOR", transformationPattern="JSONPATH:$.ENERGY.Voltage"]
@oksbwn
oksbwn / sqlite_commands.md
Last active March 7, 2023 16:43
SQLite queries used in tutorial
  • Start REPL console. Use .quit anytime to exit.
$ sqlite3 test_db.db
  • List Tables
.tables
  • Create a Table
@oksbwn
oksbwn / OLEDDIsplayTest.ino
Last active December 27, 2020 15:42
TTGo ESP32 Test Codes
#include <U8x8lib.h>
//OLED Declaration
U8X8_SSD1306_128X64_NONAME_SW_I2C u8x8(/* clock=*/ 15, /* data=*/ 4, /* reset=*/ 16);
void setup() {
//setup the display
u8x8.begin();
u8x8.setFont(u8x8_font_pxplusibmcgathin_r);
@oksbwn
oksbwn / global_conf.json
Last active May 7, 2020 04:52
RAk831 TTN Gateway Config INDIA (JSON Files)
{
"SX1301_conf": {
"lorawan_public": true,
"clksrc": 1,
"clksrc_desc": "radio_1 provides clock to concentrator for most devices except MultiTech. For MultiTech set to 0.",
"antenna_gain": 0,
"antenna_gain_desc": "antenna gain, in dBi",
"radio_0": {
"enable": true,
"type": "SX1257",
@oksbwn
oksbwn / mqtt_client.py
Created April 28, 2020 07:46
import paho.mqtt.client as mqtt
import time
# The callback for when the client receives a CONNACK response from the server.
def on_connect(client, userdata, flags, rc):
print("Connected with result code "+str(rc))
client.subscribe("home/test/in")
def on_message(client, userdata, msg):
@oksbwn
oksbwn / Automated Project Stucture_git.bat
Created April 3, 2020 06:52
@echo off
set /p project="Enter ID: "
echo Project name is %project%
cd C://Workspace
mkdir "%project%"
cd "%project%"
mkdir Blog Circuit Code Edits Raw Thumbnails Upload
mkdir Code\Lib Raw\Images Raw\Videos Raw\Unused Raw\B_Rolls Raw\Screen_Capture
cd Code
@oksbwn
oksbwn / Snapper.java
Created April 1, 2020 13:18
import java.awt.Color;
import java.awt.Dimension;
import java.awt.MouseInfo;
import java.awt.Point;
import java.awt.Rectangle;
import java.awt.Robot;
import java.awt.Toolkit;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.awt.image.BufferedImage;
@oksbwn
oksbwn / R30X_LPC2148.c
Last active April 1, 2020 09:06
#include "Serial.h"
#include "Utility.h"
#include "LCD4.h"
unsigned char Message[16] = { 0XEF, 0X01, 0XFF, 0XFF, 0XFF, 0XFF, 0X01, 0X00, 0X07, 0X13, 0X00, 0X00, 0X00, 0X00, 0X00, 0X1B };
unsigned char ack[12] = { 0X00, 0X00, 0X00, 0X00, 0X00, 0X00, 0X00, 0X00, 0X00, 0X00, 0X00, 0X00, };
unsigned char gim[12] = { 0XEF, 0X01, 0XFF, 0XFF, 0XFF, 0XFF, 0X01, 0X00, 0X03, 0X01, 0X00, 0X05 };
unsigned char uim[12] = { 0XEF, 0X01, 0XFF, 0XFF, 0XFF, 0XFF, 0X01, 0X00, 0X03, 0X0A, 0X00, 0X0E };
@oksbwn
oksbwn / backup.sh
Created March 28, 2020 21:15
A shell to script to backup openhab, nodred and influxDB
#!/bin/sh
currentDate=`date +%m-%d-%Y-%H:%M`
#backing up NodeRED
cd ~/.node-red
sudo cp flows_*.json /srv/openhab2-conf/.nodered/
sudo cp flows_*_cred.json /srv/openhab2-conf/.nodered/
sudo cp settings.js /srv/openhab2-conf/.nodered/
sudo cp package.json /srv/openhab2-conf/.nodered/
sudo cp .config.json /srv/openhab2-conf/.nodered/
sudo cp lib -R /srv/openhab2-conf/.nodered/
@oksbwn
oksbwn / Backup_Flow.json
Created March 28, 2020 20:05
Node-RED flow to run backup script
[{"id":"840f46f8.ce38c8","type":"tab","label":"backup Server","disabled":false,"info":""},{"id":"c987f084.d5b","type":"exec","z":"840f46f8.ce38c8","command":"echo om | sudo -S /srv/openhab2-conf/.backup/acript.sh","addpay":false,"append":"","useSpawn":"false","timer":"","oldrc":false,"name":"","x":549,"y":122,"wires":[["ba0dab80.458cd8","eb80b45a.926ae8"],[],["3b3ad18f.f6967e"]]},{"id":"ca29d8b7.3ca738","type":"inject","z":"840f46f8.ce38c8","name":"","topic":"","payload":"","payloadType":"date","repeat":"36000","crontab":"","once":false,"onceDelay":0.1,"x":137,"y":53.5,"wires":[["c987f084.d5b","f8c7a781.0a2b88"]]},{"id":"d2d4af1e.f8a2d","type":"openhab2-in","z":"840f46f8.ce38c8","name":"","controller":"e3ae80.b3c1018","itemname":"runBackupOutputStatus","x":119.5,"y":101,"wires":[["544e5475.653dec"],[]]},{"id":"b9749575.d04238","type":"openhab2-out","z":"840f46f8.ce38c8","name":"","controller":"e3ae80.b3c1018","itemname":"runBackupOutputExitVal","topic":"ItemUpdate","payload":"","x":1110.5,"y":164,"wires":[["c