Skip to content

Instantly share code, notes, and snippets.

@m-cakir
m-cakir / script.js
Last active January 23, 2023 11:51
Google Sheets - App Script - Binance Prices
function myFunction() {
// https://api.binance.com/api/v3/ticker/price?symbols=%5B%22BTCUSDT%22,%22ETHUSDT%22%5D
const sheetStatus = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('SHEET_NAME');
const _rows = SpreadsheetApp.getActiveSheet().getDataRange().getValues()
.filter(e => e[1] === 'USDT' || e[1] === 'BUSD')
.map((e, i) => {
// 0 = Column A
@m-cakir
m-cakir / docker-compose.yml
Created October 13, 2022 11:22
cron job in docker container
version: '3.1'
services:
snscrape:
image: alpine:latest
volumes:
- ./:/usr/src/app
working_dir: /usr/src/app
entrypoint:
- ./entrypoint.sh
@m-cakir
m-cakir / cmd.sh
Last active July 6, 2022 08:11
move files to sub directories sorting/grouping by created date - unix
$ chunk_size=5;n=0; for f in `ls *.json --full-time -t -r | gawk '{print $9}'`; do d="sub$((n++ / chunk_size))"; mkdir -p "$d"; mv -- "$f" "$d/$f"; done
@m-cakir
m-cakir / account_details.js
Last active June 14, 2022 07:43
MetaMask + Puppeteer
const dappeteer = require('@chainsafe/dappeteer');
const puppeteer = require('puppeteer');
const SEED = 'hello world its me again';
const PWD = '123456Git';
const sleep = (ms) => new Promise(resolve => setTimeout(resolve, ms));
const retry = async (fn, count = 3) => {
try {
@m-cakir
m-cakir / docker-compose.yml
Created June 14, 2021 06:35
Kafka & KafDrop in Docker
version: '2'
services:
zookeeper:
image: "wurstmeister/zookeeper"
ports:
- "2181:2181"
broker:
image: "wurstmeister/kafka"
ports:
@m-cakir
m-cakir / index.js
Last active June 13, 2021 18:35
Take snapshot of TradingView chart (+Stochastic RSI) with Puppeteer
const puppeteer = require('puppeteer');
const ignoreHTTPSErrors = true;
const _sharedBrowser = puppeteer.launch({
ignoreHTTPSErrors,
headless: true,
slowMo: 250,
args: [
'--single-process',
@m-cakir
m-cakir / PropertyLogger.java
Created June 9, 2021 10:10 — forked from sandor-nemeth/PropertyLogger.java
Spring Boot - Log all configuration properties on application startup
package io.github.sandornemeth.spring;
import java.util.Arrays;
import java.util.stream.StreamSupport;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.context.event.ContextRefreshedEvent;
import org.springframework.context.event.EventListener;
import org.springframework.core.env.AbstractEnvironment;
@m-cakir
m-cakir / rds_vpc_mysql.yml
Last active December 27, 2020 13:00
AWS Cloudformation template examples
AWSTemplateFormatVersion: '2010-09-09'
Description: 'RDS example MySQL 8.0'
Parameters:
DBName:
Type: String
Description: 'The database name'
MinLength: 8
MaxLength: 64
@m-cakir
m-cakir / LogFile.udl.xml
Created October 27, 2020 11:28 — forked from mmdemirbas/LogFile.udl.xml
Custom log file syntax highlighting for Notepad++
<NotepadPlus>
<UserLang name="LogFile" ext="log">
<Settings>
<Global caseIgnored="yes" />
<TreatAsSymbol comment="no" commentLine="no" />
<Prefix words1="no" words2="no" words3="no" words4="no" />
</Settings>
<KeywordLists>
<Keywords name="Delimiters">[(0])0</Keywords>
<Keywords name="Folder+"></Keywords>
@m-cakir
m-cakir / docker-compose.yml
Last active September 20, 2020 13:20
mysql container with import.sql
version: '3.1'
services:
db:
image: mysql
restart: always
environment:
MYSQL_ROOT_PASSWORD: 123
MYSQL_DATABASE: db
ports: