Skip to content

Instantly share code, notes, and snippets.

View faogustavo's full-sized avatar

Gustavo Fão Valvassori faogustavo

65 followers · 27 following
View GitHub Profile
@faogustavo
faogustavo / database.sql
Created June 30, 2016 01:40
-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: 30-Jun-2016 às 03:39
-- Versão do servidor: 10.1.8-MariaDB
-- PHP Version: 5.6.14
SET FOREIGN_KEY_CHECKS=0;
@faogustavo
faogustavo / triggers.sql
Created June 30, 2016 01:37
DROP TRIGGER IF EXISTS `t_demissao`;
DELIMITER $$
CREATE TRIGGER t_demissao BEFORE UPDATE
ON user
FOR EACH ROW
BEGIN
IF NEW.state = 'I' THEN
SET NEW.resignation_date = NOW();
@faogustavo
faogustavo / procedures.sql
Created June 30, 2016 01:22
DROP PROCEDURE IF EXISTS `registrar_usuario` ;
DROP PROCEDURE IF EXISTS `registrar_endereco` ;
DROP PROCEDURE IF EXISTS `registrar_revenda` ;
DELIMITER $$
-- Procedure OK
CREATE PROCEDURE registrar_endereco(
IN stateName VARCHAR(64),
IN stateInitials CHAR(2),
@faogustavo
faogustavo / ObjectToJson.json
Created March 28, 2016 13:31
{
"data":[
{
"type":"all_types",
"id":"ID",
"attributes":{
"mBoolean":false,
"mChar":71,
"mDouble":15.256,
"mFloat":15.255999565124512,
@faogustavo
faogustavo / MainActivity.Java
Last active February 28, 2016 19:30
Uma forma de facilitar o uso do SearchView com a Toolbar
import android.support.v4.view.MenuItemCompat;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.support.v7.widget.Toolbar;
import android.util.Log;
import android.view.Menu;
import android.widget.Toast;
public class MainActivity extends AppCompatActivity {
@faogustavo
faogustavo / ItunesFeedDownloader.java
Last active December 19, 2015 18:17
import javax.xml.stream.XMLEventReader;
import javax.xml.stream.XMLInputFactory;
import javax.xml.stream.XMLStreamException;
import javax.xml.stream.events.Attribute;
import javax.xml.stream.events.Characters;
import javax.xml.stream.events.XMLEvent;
import java.io.*;
import java.net.HttpURLConnection;
import java.net.MalformedURLException;
import java.net.URL;