ivanrosolen

# Fix numeric keypad
# 0 . Enter
bindkey -s "^[Op" "0"
bindkey -s "^[On" "."
bindkey -s "^[OM" "^M"
# 1 2 3
bindkey -s "^[Oq" "1"
bindkey -s "^[Or" "2"
bindkey -s "^[Os" "3"

ivanrosolen

<?php

// tem que ser separado por , e não por ;
$csvArray = array_map('str_getcsv', file('Arquivo.csv'));

// poderia rolar assim, mas não :(
//$csvArray = array_map(['str_getcsv', ';'], file('Arquivo.csv'));

// anonymous
$csvArray = array_map( function ($val) {

ivanrosolen

React Pokedex

Pages

• Initial
• List all
• Search by number/name
• Show infos on click

components

• Search

ivanrosolen

<?php

// Create bot 
// https://core.telegram.org/bots#6-botfather
//
//
// Get Channel ID - https://api.telegram.org/bot$api_token/getUpdates
// chat": { "id": -123456,

// Telegram

ivanrosolen

<?php

$regex = "/(?'group1'[0-9]+)_(?'group2'.+)_(?'group3'[0-9A-Z]+).(?'ext'.+)$/";

$files = [
    '01_lero_1X.pdf',
    '02_lerolero_13.pdf',
    '03_1k_KK.pdf'
];

ivanrosolen

-- All Databases and Tables
SELECT
    table_schema AS `Database`,
    table_name AS `Table`,
    round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`
FROM
    information_schema.TABLES
ORDER BY
    (data_length + index_length)
    DESC;

ivanrosolen

git archive --remote=[email protected]:XXX/XXX.git HEAD:path/ FILE.sql | tar -x

ivanrosolen

const http = require('http');
const cluster = require('cluster');

if (cluster.isMaster) {
    
    console.info('Starting...');

    console.info('Worker master started');
    
    const numCpus = require('os').cpus().length;

ivanrosolen

mysqldump -h host_ip -u user -ppassword database_name  > database_dump.sql

mysqldump -h host_ip -u user -ppassword database_name table_name > table_dump.sql

mysqldump -h host_ip -u user -ppassword database_name table_name --where="date_created='2019-04-19'" > rows_dump.sql

Big table, use nohup command &

If user is not root, you may add --lock-tables=false

ivanrosolen

tail -n +2 file.sql > newfile.sql