This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE billing.mytable(id integer, name text); | |
INSERT INTO billing.mytable VALUES(1, '1'); | |
INSERT INTO billing.mytable VALUES(2, '2'); | |
INSERT INTO billing.mytable VALUES(3, '3'); | |
UPDATE billing.mytable | |
SET name = Q.name | |
FROM ( | |
SELECT (value->>0)::integer AS id, (value->>1)::decimal AS name |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#include <ESP8266WiFi.h> | |
#include <TM1637Display.h> | |
#include <ESP8266HTTPClient.h> | |
#include <ESP8266WiFiMulti.h> | |
#include "DHTesp.h" | |
const char* ssid = "HUAWEI-E8372-26A6";//put your wifi ssid here | |
const char* password = "***";//put your wifi password here | |
const int CLK = D2; //Set the CLK pin connection to the display |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
cat ~/.ssh/id_rsa.pub | ssh REMOTE_USER@REMOTE_IP "mkdir -p ~/.ssh && cat >> ~/.ssh/authorized_keys" | |
// ssh-copy-id REMOTE_USER@REMOTE_IP |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from django.contrib import admin | |
from .models import User | |
admin.site.register([User]) |
OlderNewer