Skip to content

Instantly share code, notes, and snippets.

View CheeseCake87's full-sized avatar
🐝
Oh look, a bee.

David CheeseCake87

🐝
Oh look, a bee.
  • Scotland
  • 20:06 (UTC +01:00)
View GitHub Profile
@CheeseCake87
CheeseCake87 / UtilityMixin.py
Last active January 6, 2024 09:22
UtilityMixin.py
from datetime import datetime, date
import typing as t
from sqlalchemy import (
Result,
Select,
Insert,
Update,
Delete,
select,
@CheeseCake87
CheeseCake87 / folder_structure.md
Last active November 6, 2023 14:33
Multiloader: Flask, Vite, SocketIO, Gunicorn
project_folder/
├── app/
│   ├── static/
│   │   └── ...
│   ├── templates/
│   │   └── ...
│   ├── extensions/
│   │   └── __init__.py
│ └── __init__.py
@CheeseCake87
CheeseCake87 / enum_colors.py
Last active December 6, 2023 13:12
enum_colors.py
from enum import Enum
class Colors(Enum):
BLACK = '#000000'
NIGHT = '#0C090A'
CHARCOAL = '#34282C'
OIL = '#3B3131'
DARK_GRAY = '#3A3B3C'
LIGHT_BLACK = '#454545'
@CheeseCake87
CheeseCake87 / flask_file_upload_pathlib.py
Last active October 10, 2023 06:59
Flask file upload with pathlib
import pathlib
import random
from textwrap import dedent
from flask import Flask, request, abort
from werkzeug.utils import secure_filename
def create_app():
app = Flask(__name__, static_url_path="/")
// imports here
const server_url = '127.0.0.1:5000';
export default function Client() {
const url_params = useParams();
// places dely on the amount of times a function is called, used in the form input onInput tag.
function debounce(func, timeout = 300) {
let timer;
#
# With help from : https://github.com/jonbiemond
#
# requires:
# pip install flask flask_sqlalchemy
#
# run: flask --app sqlalchemy_to_josnable_dict.py init-db
# run: flask --app sqlalchemy_to_josnable_dict.py test-data
# run: flask --app sqlalchemy_to_josnable_dict.py get-user1
# run: flask --app sqlalchemy_to_josnable_dict.py get-user2
from email.mime.application import MIMEApplication
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
from pathlib import Path
from smtplib import SMTP
from smtplib import SMTPException
from ssl import create_default_context
from typing import Optional, Union
import random
import timeit
from datetime import datetime
from datetime import timedelta
from pytz import timezone
def epoch(ltz: str = "Europe/London") -> int:
"""
@CheeseCake87
CheeseCake87 / truly.py
Created March 29, 2023 09:46
Truly Cheat sheet
value1 = True
value2 = False
if value1:
print("#1 value1 is true")
if value2:
print("#2 value2 is true")
@CheeseCake87
CheeseCake87 / postgres-cheatsheet.md
Created March 19, 2023 19:34 — forked from Kartones/postgres-cheatsheet.md
PostgreSQL command line cheatsheet

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)