vlntsolo

import logging
import random
import string
import sys
import traceback
from os import environ

import orjson
from loguru import logger

vlntsolo

# For async driver user postgresql+asyncpg
DB_URL=postgresql://<DB_USER>:<DB_USER_PASS>@/<DB_NAME>?host=/cloudsql/<INSTANCE_CONNECTION_NAME>/

# <INSTANCE_CONNECTION_NAME> has the following format <cloud_project>:<region_>:<db_instance_name> (e.g. cloudproject_demo:europe-west2:cloudrun-test-db

vlntsolo

"""
MIT License
Copyright (c) 202X Valentyn Solonechnyi
===========================================
"""

"""
Created/updated timestamp fields similar to 
Django's db models.DateTimeField(auto_now_add=True) 
and models.DateTimeField(auto_now=True)

vlntsolo

/**
Generates cipher based on AES256 algorithm with CBC mode.
Sources: [ https://stackoverflow.com/questions/59488728/aes-encrypt-in-cryptojs-decrypt-in-pycrypto ]
**/

var CryptoJS = require("crypto-js");

var originalString = "thisIsAnOriginalString";
var passPhrase = "cRfUjXn2r5u8x/A?D(G-KaPdSgVkYp3s"; // NEVER MAKE PASSWORDS OR SECRETS PUBLIC

vlntsolo

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

vlntsolo

import asyncio
import logging
from multiprocessing import Queue, Process, cpu_count
import queue
from threading import Thread
import time
import aiohttp
import aiosqlite
from bs4 import BeautifulSoup

vlntsolo

Short MySQL Cheatsheet

Command	Description
SHOW DATABASES;	List all databases
USE database;	Choose database on which next commands will be performed
SHOW TABLES;	List all tables in the database
SHOW TABLES LIKE pattern;	Show tables that match the pattern i.e. permissions%
DESCRIBE table;	Show all table column names and their types.
SELECT column FROM tabel;	Basic SELECT statement to retieve rows from selected column

vlntsolo

You'll find the talks here

---

Morgan Williams @mrgnw

The Zen of Svelte

Approaching frontend as a backend developer, Svelte feels surprisingly pythonic. Let's take a quick look at what's familiar, what's foreign, and how to explore the gap.

vlntsolo

#!/bin/bash

#Create a copy of the environment variable file.
sudo cp /opt/elasticbeanstalk/deployment/env /opt/elasticbeanstalk/deployment/custom_env_var

#Set permissions to the custom_env_var file so this file can be accessed by any user on the instance. You can restrict permissions as per your requirements.
sudo chmod 644 /opt/elasticbeanstalk/deployment/custom_env_var

#Remove duplicate files upon deployment.
sudo rm -f /opt/elasticbeanstalk/deployment/*.bak

vlntsolo