- Start REPL console. Use
.quit
anytime to exit.
$ sqlite3 test_db.db
- List Tables
.tables
- Create a
Table
[{"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 |
#!/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/ |
#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 }; | |
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; |
@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 |
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): |
{ | |
"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", |
#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); |
.quit
anytime to exit.$ sqlite3 test_db.db
.tables
Table
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"]