Skip to content

Instantly share code, notes, and snippets.

View cesardmn's full-sized avatar

Cesar Dimi cesardmn

View GitHub Profile
@cesardmn
cesardmn / spotify_playlist.js
Last active September 10, 2025 00:54
Extrai a descrição da playlist do Spotify.
// Script simplificado
let resultado = [];
document.querySelectorAll('div[data-testid="tracklist-row"]').forEach((el, i) => {
const musica = el.querySelector('div.standalone-ellipsis-one-line')?.innerText || 'N/A';
const artista = el.querySelector('a[href*="/artist/"]')?.innerText || 'N/A';
if (musica !== 'N/A') {
resultado.push(`${i+1}. ${musica} - ${artista}`);
}
});
console.log(resultado.join('\n'));
@cesardmn
cesardmn / message_extract.js
Created September 4, 2025 04:27
Extrai mensagens de uma conversa no whatsapp com filtro de data e texto
function extrair_mensagens(dataInicioStr, dataFimStr, filtroTexto = "") {
function parseData(str) {
const [dia, mes, ano] = str.split('/');
return new Date(`${ano}-${mes}-${dia}T00:00:00`);
}
const dataInicio = parseData(dataInicioStr);
const dataFim = parseData(dataFimStr);
dataFim.setHours(23, 59, 59, 999);
@cesardmn
cesardmn / db.json
Created April 7, 2023 19:34 — forked from devfraga/db.json
Db API - React Native insider
{
"foods": [
{
"id": "1",
"name": "Strogonoff",
"total_ingredients": "4",
"time": 40,
"cover": "https://i.imgur.com/or7Phgi.jpeg",
"video":"https://www.youtube.com/watch?v=y9yKuT1m9LI",
"ingredients": [
@cesardmn
cesardmn / vba_web_scraping.vb
Last active September 14, 2021 08:42
Consulta CPF/CNPJ no site situacao-cadastral.com
Sub web_scraping()
Dim ws As Worksheet
Dim cpf, satate As Variant
Dim nRows, activeRow As Integer
Dim rg, sdRg As Range
Dim ie As Object
Dim msgErr As Integer
Set ie = CreateObject("internetexplorer.application")
@cesardmn
cesardmn / appScript_CSV_consolidate.gs
Last active September 8, 2021 14:06
Consolidate CSV files that are inside a GoogleDrive folder
const idFolder = 'your folder id'
const sheetName = 'csv' // name of the sheet that will receive data
const separator = ";" // separator type
const ui = SpreadsheetApp.getUi()
const ss = SpreadsheetApp.getActive()
const sh = ss.getSheetByName(sheetName)
function onOpen() {
ui.createMenu('CSVS')
@cesardmn
cesardmn / global.css
Last active June 18, 2020 20:31
CSS color scheme
html [theme-name]{
/* primary */
--p1: #ffffff;
--p2: #f2f2f2;
--p3: #e2e2e2;
/* secondary */
--s1: #616161;
--s2: #424242;
--s3: #212121;
@cesardmn
cesardmn / Replace word in file.sh
Last active October 7, 2020 14:39
Replace word in file
# local
sed -i '' 's/oldword/newword/' file1.txt
#VM
sed -i 's/oldword/newword/' file1.txt
#Replace especific line
sed -i 'NumberLine's/.*/New line value/' initial_settings.sh
@cesardmn
cesardmn / Vagrantfile
Last active March 18, 2020 21:04
Vagrant for Python / Django / Pipenv
# for project already started
Vagrant.configure("2") do |config|
config.vm.box = "ubuntu/bionic64"
config.vm.network "forwarded_port", guest: 8080, host: 8080, host_ip: "127.0.0.1"
config.vm.synced_folder ".", "/vagrant"
config.vm.provider "virtualbox" do |v|
v.memory = "1024"
v.cpus = 2
end
@cesardmn
cesardmn / Vagrantfile
Last active March 19, 2020 00:58
Vagrant for Python / Django / Pipenv
# for inicial project
Vagrant.configure("2") do |config|
config.vm.box = "ubuntu/bionic64"
config.vm.network "forwarded_port", guest: 8080, host: 8080, host_ip: "127.0.0.1"
config.vm.synced_folder ".", "/vagrant"
config.vm.provider "virtualbox" do |v|
v.memory = "1024"
v.cpus = 2
end
from usuarios.models import *
from django.conf import settings
from django.utils.encoding import smart_str
from django.core.mail import EmailMessage
destinatarios = ['cesar@brbid.com']
leilao = 'APL01-18'
colunas = ['Nome', 'Telefone', 'Email']
arquivo = ";".join(colunas)