guihatano

# Basic key operators to query the JSON objects :

# #> : Get the JSON object at that path (if you need to do something fancy)
# -> : Get the JSON object at that path (if you don't)
# ->> : Get the JSON object at that path as text
# {obj, n} : Get the nth item in that object

# https://www.postgresql.org/docs/9.4/functions-json.html#FUNCTIONS-JSONB-OP-TABLE
# Date 
# date before today

guihatano

parse_git_branch() {
    git branch 2> /dev/null | sed -e '/^[^*]/d' -e 's/* \(.*\)/(\1)/'
}
export PS1="\e[01;32m\]\u@\h \[\e[01;34m\]\w \[\e[91m\]\$(parse_git_branch)\[\e[00m\]$ "

guihatano

(function( $ ){
  
  $.fn.dependsOn = function(element, value) {
    var elements = this;
    var hideOrShow = function() {
      var $this = $(this);
      var showEm;
      if ( $this.is('input[type="checkbox"]') ) {
        showEm = $this.is(':checked');
      } else if ($this.is('select')) {

guihatano

require 'dotenv/load'

configuration_file = File.join(File.expand_path('..', __FILE__), 'config.yml')
configuration = YAML.load(File.read(configuration_file).gsub(/\<\%.*\[\'([^\']+)\'\].*\%\>/) { ENV[$1] } )

guihatano

# Backup
docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

# Restore
cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE

guihatano

#!/bin/bash

#kendo_start 8866
#kendo_last 9079
#8814
initial_pic=8866
#last_pic=9181
last_pic=9079

url="http://www.saocarlos.sp.gov.br/images/stories/abril2019/MESDASARTESMARCIAIS/DSC_"

guihatano

require "open-uri"
require "net/http"

Error = Class.new(StandardError)

DOWNLOAD_ERRORS = [
  SocketError,
  OpenURI::HTTPError,
  RuntimeError,
  URI::InvalidURIError,

guihatano

pg_restore --verbose --clean --no-acl --no-owner -n public -h db -U loldesign -d mcr_development --port 5432 ./dbdump

On Docker

docker-compose run mcr pg_restore --verbose --clean --no-acl --no-owner -n public -h db -U loldesign -d mcr_development --port 5432 ./dbdump

With text .sql bkp

cat your_dump.sql | docker exec -i your-db-container psql -U postgres

Backup database:

guihatano

require 'json'

result = RestClient.post "https://api:key-xxxxxxxxx-xxxxxxx@api.mailgun.net/v2/domain.com/",
:from => "YourDomain <your-email@domain.com>",
:to => "to-email@email.com",
:subject => "Mailgun with attachment",
:text => "Hello, Put something here",
:multipart => true,
:attachment => File.new('path/to/file', 'rb')

guihatano

# After some research on how to divide a text with html tags my final solution is here
# this should work with strings.
# If you found a better solution, please let me know.

def divided_text(text)
  # we have the start index of </p>, so we need do +3 to get the end
  middle_index = middle_paragraph_index(text)+3
  first_text = text[0..middle_index]
  # and here we have the '>' so we need do +1
  second_text = text[middle_index+1..-1]