Skip to content

Instantly share code, notes, and snippets.

View shelomentsevd's full-sized avatar
🧶
<- my code

Dmitrii Shelomentsev shelomentsevd

🧶
<- my code
View GitHub Profile
@shelomentsevd
shelomentsevd / query.sql
Created December 10, 2024 16:48
PostgreSQL, select all tables which has foreign keys to specific collumn in the specific table
SELECT
tc.constraint_name,
tc.table_schema,
tc.table_name,
kcu.column_name
FROM
information_schema.table_constraints tc
JOIN information_schema.key_column_usage kcu
ON tc.constraint_name = kcu.constraint_name
AND tc.table_schema = kcu.table_schema
@shelomentsevd
shelomentsevd / main.go
Created February 21, 2022 11:29
Merge two sorted slices
package main
import "fmt"
func insert(num int, pos int, dst []int) []int {
if len(dst) == 0 {
dst = append(dst, num)
return dst
}
@shelomentsevd
shelomentsevd / words-xml-counter.go
Created December 2, 2019 20:28
считает слова по регулярке в XML
package main
// Работает не совсем правильно, над поправить
import (
"bufio"
"flag"
"fmt"
"os"
"regexp"
package main
// JSON filter
// Stdin: json objects separated by new line
// Stdout: valid json objects
// Use case: I had a service with logs in json format.
// But due unknown reason sometimes one or two lines in logs corrupted.
// I needed an utility which filters valid json from invalid json.
// Example: cat my-service-logs.json | json_validator | cat > processed-logs.json
import (
package main
import (
"log"
"fmt"
"os"
"github.com/shelomentsevd/mtproto"
"time"
)
@shelomentsevd
shelomentsevd / file.go
Created November 28, 2017 15:47
Go Fuckup #1 appending to slice
package main
import "fmt"
type Box struct {
ID string
}
type BoxContainter struct {
box Box
package main
import (
"sync/atomic"
"fmt"
)
type Increment struct {
count uint32
}
type Store struct {
mutex sync.RWMutex
data map[string]int
}
func (s * Store) Read(key string) int, error {
// ...
defer s.mutex.RUnlock()
s.mutex.RLock()
// ...
package main
import (
"os"
"os/signal"
"syscall"
"fmt"
"time"
"reflect"
"mtproto"
import os
from os import listdir
from os.path import dirname, realpath, isfile, isdir, isabs, join
def get_filenames(path):
if isabs(path):
dir_path = path
else:
dir_path = join( dirname(realpath(__file__)), path )