Diego Selzlein diego-aslz
🏠
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /home/web/uems/current |
diego-aslz
/ Gemfile
Created
June 7, 2019 00:19
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| source 'https://rubygems.org' | |
| gem 'rspec' |
diego-aslz
/ translate_subs.rb
Last active
December 20, 2022 18:57
Extract and translate MKV subtitles
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/env ruby | |
| # Ruby script to extract and translate subtitles from MKV files from English to Portuguese (but you can customize this) | |
| # | |
| # Dependencies: | |
| # | |
| # 1. `gem install srt` | |
| # 2. `brew install translate-shell mkvtoolnix` | |
| # | |
| # Usage: |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE OR REPLACE PROCEDURE track_record ( | |
| p_record_id IN NUMBER, | |
| p_record_type IN VARCHAR2, | |
| p_is_deleted IN BOOLEAN DEFAULT FALSE | |
| ) | |
| IS | |
| BEGIN | |
| IF p_is_deleted THEN | |
| UPDATE record_trackings | |
| SET record_deleted_at = SYSTIMESTAMP |
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 6.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| "secao","divisao","grupo","classe","subclasse","denominacao" | |
| "AGRICULTURA, PECUÁRIA, PRODUÇÃO FLORESTAL, PESCA E AQUICULTURA","AGRICULTURA, PECUÁRIA E SERVIÇOS RELACIONADOS","PRODUÇÃO DE LAVOURAS TEMPORÁRIAS","CULTIVO DE CEREAIS","0111301","CULTIVO DE ARROZ" | |
| "AGRICULTURA, PECUÁRIA, PRODUÇÃO FLORESTAL, PESCA E AQUICULTURA","AGRICULTURA, PECUÁRIA E SERVIÇOS RELACIONADOS","PRODUÇÃO DE LAVOURAS TEMPORÁRIAS","CULTIVO DE CEREAIS","0111302","CULTIVO DE MILHO" | |
| "AGRICULTURA, PECUÁRIA, PRODUÇÃO FLORESTAL, PESCA E AQUICULTURA","AGRICULTURA, PECUÁRIA E SERVIÇOS RELACIONADOS","PRODUÇÃO DE LAVOURAS TEMPORÁRIAS","CULTIVO DE CEREAIS","0111303","CULTIVO DE TRIGO" | |
| "AGRICULTURA, PECUÁRIA, PRODUÇÃO FLORESTAL, PESCA E AQUICULTURA","AGRICULTURA, PECUÁRIA E SERVIÇOS RELACIONADOS","PRODUÇÃO DE LAVOURAS TEMPORÁRIAS","CULTIVO DE CEREAIS","0111399","CULTIVO DE OUTROS CEREAIS NÃO ESPECIFICADOS ANTERIORMENTE" | |
| "AGRICULTURA, PECUÁRIA, PRODUÇÃO FLORESTAL, PESCA E AQUICULTURA","AGRICULTURA, PECUÁRIA E SERVIÇOS RELACIONADOS","PRODUÇÃO DE LAVO |
OlderNewer