Skip to content

Instantly share code, notes, and snippets.

View slavama's full-sized avatar

Slava slavama

  • Asia/Krasnoyarsk
View GitHub Profile
@slavama
slavama / bulk_update.sql
Created November 12, 2019 15:23
postgresql bulk update
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
@slavama
slavama / gist:a743ce9fafa17d7642a21ed92f6f3338
Created January 24, 2021 12:44
esp8266 weather station
#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
@slavama
slavama / copy_key.sh
Last active December 16, 2021 03:46
Copy authorized key to remote server for login without password
cat ~/.ssh/id_rsa.pub | ssh REMOTE_USER@REMOTE_IP "mkdir -p ~/.ssh && cat >> ~/.ssh/authorized_keys"
// ssh-copy-id REMOTE_USER@REMOTE_IP
@slavama
slavama / admin.py
Created March 28, 2022 07:38 — forked from herotux/admin.py
django rest api framework session auth example
from django.contrib import admin
from .models import User
admin.site.register([User])