Skip to content

Instantly share code, notes, and snippets.

View valdergallo's full-sized avatar
🏠
Working from home

Valder Gallo valdergallo

🏠
Working from home
View GitHub Profile
@valdergallo
valdergallo / noSleep.vbs
Last active February 22, 2024 13:59
Script to make windows stop to sleep using VBscript
set wsc = CreateObject("WScript.Shell")
Do
'Five minutes
WScript.Sleep(5*60*1000)
wsc.SendKeys("{NUMLOCK}")
Loop
@valdergallo
valdergallo / python.js
Created September 15, 2021 11:52
Snippet for VSCode Python
{
// Place your snippets for python here. Each snippet is defined under a snippet name and has a prefix, body and
// description. The prefix is what is used to trigger the snippet and the body will be expanded and inserted. Possible variables are:
// $1, $2 for tab stops, $0 for the final cursor position, and ${1:label}, ${2:another} for placeholders. Placeholders with the
// same ids are connected.
// Example:
// "Print to console": {
// "prefix": "log",
// "body": [
// "console.log('$1');",
@valdergallo
valdergallo / get_next_date.py
Last active November 13, 2023 20:21
Calculate the next valid date
from dateutil.relativedelta import relativedelta
from datetime import datetime
WEEKLY = relativedelta(weeks=1)
BIWEEKLY = relativedelta(weeks=2)
MONTHLY = relativedelta(months=1)
YEARLY = relativedelta(years=1)
def get_next_date(
@valdergallo
valdergallo / converting_pickle.py
Created May 25, 2023 01:57
Pickle to strings
import pickle
import codecs
data = {"coisa": "novidade", "nome": "valder", "estado": "SC"}
pickled = codecs.encode(pickle.dumps(data), "base64").decode()
print(pickled)
unpickled = pickle.loads(codecs.decode(pickled.encode(), "base64"))
print(unpickled)
@valdergallo
valdergallo / using-uuid-as-pk.md
Created April 7, 2023 21:48 — forked from rponte/using-uuid-as-pk.md
Não use UUID como PK nas tabelas do seu banco de dados

Pretende usar UUID como PK em vez de Int/BigInt no seu banco de dados? Pense novamente...

TL;TD

Não use UUID como PK nas tabelas do seu banco de dados.

Um pouco mais de detalhes

@valdergallo
valdergallo / conftest.py
Last active March 27, 2023 17:34
Conftest to create Postgres Database and auto delete data after test end
import os
import pytest
from flask_sqlalchemy import SQLAlchemy
from sqlalchemy_utils.functions import create_database, database_exists, drop_database
from sqlalchemy import create_engine
from sqlalchemy.orm import scoped_session, sessionmaker
from main import app as main_app
from main.database import db as _db
@valdergallo
valdergallo / baralho.py
Last active October 26, 2022 16:54
Ex. de baralho com python do Ramalho do Curso Python sem Sotaque
from random import shuffle
class Carta(object):
def __init__(self, valor, naipe):
self.valor = valor
self.naipe = naipe
def __repr__(self):
return '<%s de %s>' % (self.valor, self.naipe)
@valdergallo
valdergallo / test_set_type_order.py
Created June 10, 2022 12:00
Validate order in set type
import pytest
basket = ["apple", "orange", "apple", "pear", "orange", "banana"]
def subtract_set_list(total_items, item_to_remove):
return set(total_items) - set(item_to_remove)
@pytest.mark.parametrize(
@valdergallo
valdergallo / download_timezones.py
Created June 1, 2022 13:07
Download Time Zone information from Wikipedia
import requests
from lxml.html import document_fromstring
from django.core.exceptions import ValidationError
from pprint import pprint
def _parse_wiki_data(content):
table = content.xpath("/html/body/div[3]/div[3]/div[5]/div[1]/table[1]").pop()
tz_name = table.xpath("//tr/td[2]/a//text()")
iana_times_utc_std = table.xpath("//tr/td[5]/a//text()")
@valdergallo
valdergallo / pandas_start.py
Created April 10, 2015 18:21
Starting with Pandas
import pandas as pd
import re
from customer_purchase_order.models import CustomerPurchaseOrderItem
from django.db import connection
from django.db.models import Q
# read file XLSX
# file_name = r"D:\zina-files\NFList.xlsx"
# xl_file = pd.ExcelFile(file_name)
# show avaliable sheets