Skip to content

Instantly share code, notes, and snippets.

View lucassch's full-sized avatar

Lucas Schmoeller da Silva lucassch

View GitHub Profile
@lucassch
lucassch / test_migrations_53_54_55_56_57.sh
Last active August 29, 2015 13:56
Run portabilis/ieducar migrations 53,54,55,56,57
echo -e "\n** Rodando migração 53_cria_campo_observacao_matricula.sql"
~/.pgvm/environments/8.2.23/bin/psql -d ieducar -p 5433 -c "ALTER TABLE pmieducar.matricula ADD COLUMN observacao character varying(300);
UPDATE pmieducar.matricula set observacao = 'Não Informado' where aprovado= 6;"
echo -e "\n** Rodando migração 54_retira_obrigatoriedade_de_campos_hora_em_escola_serie.sql"
~/.pgvm/environments/8.2.23/bin/psql -d ieducar -p 5433 -c "
ALTER TABLE pmieducar.escola_serie ALTER COLUMN hora_inicial drop not null;
ALTER TABLE pmieducar.escola_serie ALTER COLUMN hora_final drop not null;

How to install PhantomJS on Ubuntu

Version: 1.9.7

Platform: x86_64

First, install or update to the latest system software.

sudo apt-get update
@lucassch
lucassch / consulta apontamento hipper
Created January 27, 2015 12:59
consulta apontamento hipper
SELECT H6_PRODUTO, SUM(H6_QTDPROD) QTD_PROD , 0 AS QTD_PERDA,
(CASE
WHEN H6_PRODUTO LIKE 'PIM%' THEN 'MACHARIA'
WHEN H6_PRODUTO LIKE 'PIC%' THEN 'MOLDAGEM'
WHEN H6_PRODUTO LIKE 'PIU%' THEN 'USINAGEM'
WHEN H6_PRODUTO LIKE 'PIH%' THEN 'FUNDICAO' END) DEPTO,
H6_DATAINI DT_PROD,
H6_OPERADO USUARIO,
H6_RECURSO RECURSO,
H1_DESCRI,
@lucassch
lucassch / User\Preferences.sublime-settings
Created March 30, 2015 20:57
User\Preferences.sublime-settings
{
"bold_folder_labels": true,
"color_scheme": "Packages/RailsCasts Colour Scheme/RailsCastsColorScheme.tmTheme",
"detect_indentation": false,
"draw_indent_guides": true,
"draw_white_space": "selection",
"highlight_line": true,
"highlight_modified_tabs": true,
"ignored_packages":
[
@lucassch
lucassch / atualiza_migracoes_portabilis.sh
Last active August 29, 2015 14:23
atualiza_migracoes_portabilis
echo -e "\n** Rodando migração mytdt/1_adiciona_campo_secao_em_area_conhecimento.sql"
~/.pgvm/environments/8.2.23/bin/psql -d ieducar -p 5433 -c "
ALTER TABLE modules.area_conhecimento ADD COLUMN secao character varying(50);"
echo -e "\n** Rodando migração 53_cria_campo_observacao_matricula.sql"
~/.pgvm/environments/8.2.23/bin/psql -d ieducar -p 5433 -c "ALTER TABLE pmieducar.matricula ADD COLUMN observacao character varying(300);
UPDATE pmieducar.matricula set observacao = 'Não Informado' where aprovado= 6;"
@lucassch
lucassch / sublime_utils.py
Created October 31, 2018 12:13
Comandos utils no sublime
# Imprime full path de todos arquivos abertos no sublime
print("\n".join([view.file_name() for view in sublime.active_window().views() if view and view.file_name()]));
@lucassch
lucassch / install-dependencies.sh
Created October 16, 2023 14:20
Install dependencies on linux mint for my workspace
sudo su
apt update
apt upgrade -y
apt dist-upgrade -y
mv /etc/apt/preferences.d/nosnap.pref /home/lucassch/Documents/nosnap.backup
# utils
apt install remmina sublime-text apt-transport-https ca-certificates curl software-properties-common snapd git zsh build-essential vim curl -y