Lucas Schmoeller da Silva 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

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 / 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 / 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 / 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 / phantomjs_install.md

Last active August 29, 2015 14:10 — forked from julionc/00.howto_install_phantomjs.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 / 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;