Skip to content

Instantly share code, notes, and snippets.

Lucas Schmoeller da Silva lucassch

Block or report user

Report or block lucassch

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@lucassch
lucassch / sublime_utils.py
Created Oct 31, 2018
Comandos utils no sublime
View sublime_utils.py
# 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 / atualiza_migracoes_portabilis.sh
Last active Aug 29, 2015
atualiza_migracoes_portabilis
View atualiza_migracoes_portabilis.sh
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 / User\Preferences.sublime-settings
Created Mar 30, 2015
User\Preferences.sublime-settings
View 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 / consulta apontamento hipper
Created Jan 27, 2015
consulta apontamento hipper
View 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,
View phantomjs_install.md

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 / test_migrations_53_54_55_56_57.sh
Last active Aug 29, 2015
Run portabilis/ieducar migrations 53,54,55,56,57
View test_migrations_53_54_55_56_57.sh
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;
You can’t perform that action at this time.