Skip to content

Instantly share code, notes, and snippets.

View joaopedroaa's full-sized avatar

João Pedro joaopedroaa

View GitHub Profile
@joaopedroaa
joaopedroaa / layout.kbd.json
Created March 21, 2021 02:11
Untitled Keyboard Layout
[
[
"Esc",
{
"x": 1
},
"F1",
"F2",
"F3",
"F4",
@joaopedroaa
joaopedroaa / moviedone.py
Created March 3, 2021 13:53
Simple script to move file to folder named "Done"
from os import listdir
from os.path import isfile, join
import shutil
mypathtodo = "./"
mypathdone = "./Done/"
mytype = "mkv"
onlyfiles_todo = sorted([file for file in listdir(mypathtodo) if isfile(join(mypathtodo, file)) and file[file.find(".", -4) + 1:] == mytype])
onlyfiles_done = sorted([file for file in listdir(mypathdone) if isfile(join(mypathdone, file)) and file[file.find(".", -4) + 1:] == mytype])
curl 'http://192.168.15.1/form2WiFiBasic.cgi' \
-H 'Connection: keep-alive' \
-H 'Cache-Control: max-age=0' \
-H 'Origin: http://192.168.15.1' \
-H 'Upgrade-Insecure-Requests: 1' \
-H 'DNT: 1' \
-H 'Content-Type: application/x-www-form-urlencoded' \
-H 'User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.183 Safari/537.36' \
-H 'Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9' \
-H 'Referer: http://192.168.15.1/settings-wireless-network.html' \
unbindall
//-----------PdR---Ultima-atualizacao---2020/11/16-------------
// C:\Users\joaop\AppData\Local\Temp
// C:\Windows\Temp
// C:\Windows\Prefetch
// C:\Windows\SoftwareDistribution\Download
//---Comandos---
CREATE TABLE INSTRUTORES (ID INT UNSIGNED PRIMARY KEY AUTO_INCREMENT, NOME VARCHAR(50) NOT NULL, EMAIL VARCHAR(50) NOT NULL, VALOR_HORA INTEGER UNSIGNED NULL, CERTIFICADOS VARCHAR(255) NULL);
CREATE TABLE CURSOS ( ID INT UNSIGNED PRIMARY KEY AUTO_INCREMENT NOT NULL , NOME VARCHAR(50) NOT NULL, REQUISITO VARCHAR(255) NULL, CARGA_HORARIA SMALLINT UNSIGNED NULL, PRECO DECIMAL(6,2) UNSIGNED NULL);
CREATE TABLE ALUNOS( ID INT UNSIGNED PRIMARY KEY AUTO_INCREMENT NOT NULL , CPF CHAR(11) NOT NULL, NOME VARCHAR(50) NOT NULL, EMAIL VARCHAR (50) NOT NULL, FONE CHAR(14) NOT NULL, DATA_NASCIMENTO DATE NULL, POLO VARCHAR(50) NOT NULL); /*ALTER TABLE ALUNOS ADD TURMAS_ID INT NULL; --ALTER TABLE ALUNOS ADD INDEX TURMAS_FKINDEX1(TURMAS_ID); --ALTER TABLE ALUNOS ADD CONSTRAINT TURMAS_ID REFERENCES TURMAS(ID) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE ALUNOS ADD CONSTRAINT FK_TURMAS FOREIGN KEY(TURMAS_ID) REFERENCES TURMAS (ID) ON DELETE NO ACTION ON UPDATE NO ACTION; /*ALTER TABLE ALUNOS ADD POLO VARCHAR(50) NOT NU
@joaopedroaa
joaopedroaa / archlinux.md
Last active March 9, 2021 22:27
Instalando Arch Linux

Arch Linux Install (GPT / UEFI)

Installation Guide

Check the internet

ip link
#
wifi-menu

Keybase proof

I hereby claim:

  • I am joaopedroaats on github.
  • I am joaopedroaats (https://keybase.io/joaopedroaats) on keybase.
  • I have a public key whose fingerprint is F117 6599 5074 FA30 957E C18D 8BB3 4838 5EB4 8008

To claim this, I am signing this object:

@joaopedroaa
joaopedroaa / cloudSettings
Last active August 16, 2020 21:49
Visual Studio Code Settings
{"lastUpload":"2020-08-16T21:45:09.340Z","extensionVersion":"v3.4.3"}
@joaopedroaa
joaopedroaa / auto create database for Ruby on Rails
Last active October 15, 2019 15:03
config/database.yml - automatic created files for Ruby on Rails
rails new mysql --database=mysql
rails new postgresql --database=postgresql
rails new sqlite3 --database=sqlite3
rails new oracle --database=oracle
rails new frontbase --database=frontbase
rails new ibm_db --database=ibm_db
rails new sqlserver --database=sqlserver
rails new jdbcmysql --database=jdbcmysql
rails new jdbcsqlite3 --database=jdbcsqlite3
rails new jdbcpostgresql --database=jdbcpostgresql