Regex on VS Code

Place underscore between words

Find: ([A-Za-z])( )([A-Za-z])
Replace: $1_$3

Find

Ano
Sit reg
Dcih
Apres
Espec
Cgc hosp
Org rec
Ident
Org loc
Nome pac
Logr
Numero
Compl
Tipo bairr
Cs
Cs cod

Replace 

Ano
Sit_reg
Dcih
Apres
Espec
Cgc_hosp
Org_rec
Ident
Org_loc
Nome_pac
Logr
Numero
Compl
Tipo_bairr
Cs
Cs_cod

Importing files from pg_dump

For importing files generated by pg_dump command, use the command pg_restore, like that:

$ pg_restore -Uusername -hlocalhost -c -v -Fc -ddatabase < file.pg_dump

Options:

• -U: username
• -h: host
• -c: drop database before recreating
• -v: verbose mode
• -Fc: the archive is in the custom format of pg_dump
• -d: database

For more options look on page manpage by pg_restore.

$ man pg_restore

SQL files

In case you have a sql file to import, use this command:

$ psql -Uusername -hlocalhost -v -ddatabase < file.sql

That's all!

VS Code - Switch between edit and terminal

1. Open Keyboard Shortcuts [Ctrl + K, Ctrl + S]
2. Search for Focus Terminal

3. Set your shortcut, in my case I used Ctrl+'

Check the editor shortcut searching for Focus First Editor, default Ctrl + 1

Importing CSV files to SQLite3 database

Today we will learn how to import n CSV files to a SQLite3 database. Yes, I wrote SQLite3, not SQLite, because the import command just has inside SQLite version 3.

First of all, you need install the SQLite3.

$ sudo apt-get install sqlite3

Now, execute the SQLite3.

$ sqlite3

This is the current version installed in my machine.

$ sqlite3
SQLite version 3.8.7.1 2014-10-29 13:59:56
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>

Set the csv mode.

sqlite> .mode csv

Here I define the separator used in my CSV files.

sqlite> .separator ';'

Now I start importing the files.

sqlite> .import /home/lucio/desenv/file1.csv table1

sqlite> .import /home/lucio/desenv/file2.csv table2

sqlite> .import /home/lucio/desenv/file3.csv table3

Ok, I only imported 3 files, but you can import as many as you want.

You can check the tables created.

sqlite> .table
table1     table2     table3

Now, I save the tables in a sqlite file.

sqlite> .backup main my_database.db

And finish! I hope I was helpful.

Handling pdf files in linux, using command line

Some times I need to merge or split files in pdf, and a great tool for this is PDFtk. I, generally, prefer use the command line, it's just my preference, so, follow the tips:

Installing

$ sudo apt-get install pdftk

Merging separate files in one

$ pdftk file1.pdf file2.pdf output final_file.pdf

Splitting files

$ pdftk A=fileA.pdf cat A1 output page1.pdf

or, if you want the pages 1 to 3 and the 5:

$ pdftk A=fileA.pdf cat A1-3 A5 output final_file.pdf

or yet, the pages you want are in different files, see:

$ pdftk A=fileA.pdf B=fileB.pdf cat A1-3 A5 B4-5 B7 output final_file.pdf

 I took the pages 1, 2, 3 and 5 of fileA, and pages 4, 5 and 7 of fileB.

Graphical Interface

Now, if you dont't like command line, and want using a graphical tool, you need to know the PDF Chain.

Installing

$ sudo apt-get install pdfchain

That's all, folks!

Some commands of pip - python package manager

In case you have the two python version installed in your system, using pip when you using python2.x and pip3 when using python3.

Installing

Using python 2.x:

$ sudo apt-get install python-pip

or, if you want to use python3:

$ sudo apt-get install python3-pip

Updating

pip

$ sudo pip install --upgrade pip

pip3

$ sudo pip3 install --upgrade pip

You can also use the above command to upgrade the pip packages, see:

$ pip install --upgrade package_name

Installing packages

pip

$ sudo pip install package_name

pip3

$ sudo pip3 install package_name

If you want install an especific package version, use the command like this example:

$ sudo pip install googlemaps==3.0.2

In case you already have this package installed, just upgrade it:

$ sudo pip install --upgrade googlemaps

Listing all of installed packages

pip:

$ sudo pip freeze

pip3

$ sudo pip3 freeze

Checking the pip version

pip

$ sudo pip --version

pip3

$ sudo pip3 --version

That's all folks!

DPKG RETURNED AN ERROR CODE (1)

Recentemente tive problemas com warsaw quando que não obitve sucesso na instalação do pacote de segurança da Caixa Econômica Federal, em meu Linux Mint.

Contudo, a instalação do .deb bloqueou apt, retornando sempre o mesmo erro, de que teve problemas com o warsaw e o dpkg retornava erro. Nada adiantava, quando que após algumas pesquisas resolvi o problema.

Remova os pacotes com o nome warsaw do /var/lib/dpkg/info/

$ sudo rm  /var/lib/dpkg/info/warsaw.*

Pronto, agora:

$ sudo apt-get clean

$ sudo apt-get autoremove

"Failed to fetch http://dl.google.com/linux/earth/deb/dists/stable/Release"

I have received this warning every time I upgrade my Linux Mint Debian Editian 2 (LMDE 2). Today I decided to solve this problem. After some research I found a possible solution. I'm still testing, but I'll share it this way to fix the problem:

First step, execute this command:

$ sudo sed -i -e 's/deb http/deb [arch=amd64] http/' "/etc/apt/sources.list.d/google-earth-pro.list"

So, execute this one:

$ sudo sed -i -e 's/deb http/deb [arch=amd64] http/' "/etc/cron.daily/google-earth-pro"

And then:

$ sudo apt-get update ; sudo apt-get check

As I commented, I'm still testing if this configuration will be reset, but with this I can upgrade the sources. In case I have news I will tell you.

Tks!

Access to Bitbucket stopped to work via http and git

Yesterday I changed my Vivo Fibra plan to 100 Mb, so the company had to change the router. Everything was working fine until I needed to do a git pull, from my bitbucket repository. After tireless searches I found the solution. I still don't know if it has other solution, but this one worked to me. 

I just put it in the file /etc/hosts the line:

104.192.143.2 bitbucket.org

Now, try again to git pull or access bitbucket.org via browser. 

I hope this tip has helped you.

;)

Infinite loop in npm install

To solve this error, run:

$ sudo npm -g --unsafe-perm install node-sass

Laravel - error on migrate

PHP 5.6
Mysql 5.5
Laravel 5.4


I had this error while executing: php artisan migrate

Syntax error or access violation: 1071 Specified key was too long; max key l ength is 767 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))

I solved by changing the file config/database.php:

'charset' => 'utf8mb4' by 'charset' => 'utf8'

'collation' => 'utf8mb4_unicode_ci' by 'collation' => 'utf8_unicode_ci'

Drop the created tables by laravel, and execute php artisan migrate again.