Skip to content

Instantly share code, notes, and snippets.

@slabad
slabad / katlegohw.sql
Last active October 26, 2021 12:44
katlegohw
1. Create tables to hold data for your movie collection.
Create table Movies (id int identity primary key,
Title varchar (100),
Director varchar (100),
Runtime smallint, --Consider naming this runtime_minutes (this makes it clear as to the units)
Genre_id int,
Release_Year year);
@slabad
slabad / mysql_test_trans.sql
Last active June 28, 2022 13:07
mysql test trans #mysql
--create database for testing rollback
create database if not exists dmstest;
use dmstest;
create table people(
id int auto_increment
@slabad
slabad / get_rds_tags.py
Last active February 3, 2024 20:45
get_rds_tags
from itertools import chain
import boto3
rds = boto3.client('rds')
tagging = boto3.client('resourcegroupstaggingapi')
# Build a mapping of instance ARNs to details
paginator = rds.get_paginator('describe_db_instances')
instances = {
@slabad
slabad / mousemover.py
Created September 7, 2022 12:32
mouse mover
import pyautogui
import time
while True:
pyautogui.moveRel(0, 10)
time.sleep(2)