slabad

import pyautogui
import time
while True:
    pyautogui.moveRel(0, 10)
    time.sleep(2)

slabad

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

--create database for testing rollback


create database if not exists dmstest;

use dmstest; 

create table people(
    id int auto_increment

slabad

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

#To display the largest folders/files including the sub-directories, run:

du -Sh | sort -rh | head -5

#du command: Estimate file space usage.
#-h : Print sizes in human-readable format (e.g., 10MB).
#-S : Do not include the size of subdirectories.
#-s : Display only a total for each argument.
#sort command : sort lines of text files.
#-r : Reverse the result of comparisons.

slabad

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, 
Genre_id int, 
Release_Year year);

Create table Genre (id int identity primary key,

slabad

 SELECT
    c.relname,
    indexname,
    c.reltuples AS num_rows,
    pg_size_pretty(pg_relation_size(quote_ident(c.relname)::text)) AS table_size,
    pg_size_pretty(pg_relation_size(quote_ident(indexrelname)::text)) AS index_size,
    CASE WHEN indisunique THEN 'Y'
       ELSE 'N'
    END AS UNIQUE,
    idx_scan AS number_of_scans,

slabad

CREATE INDEX index_notifications_gin_subscriber ON notifications USING gin ((params ->> 'subscriber') gin_trgm_ops) WHERE params -> 'subscriber':: text IS NOT NULL;

slabad

myaliases = {
    # 'grep': 'grep --color=auto --exclude-dir={.bzr,CVS,.git,.hg,.svn}',
    # one char shortcuts
    'h': 'history show all | less',
    'c': 'clear',
    #  ls shortcuts
    'l': 'ls -F',
    'la': 'ls -lAfh',
    'll': 'ls -lFh',
    'ldot': 'ls -ld .*',

slabad

pg_config --version|grep -oP "(?<=PostgreSQL ).*"