marcoamorales

#!/bin/python2

'''
This script sends a notification every 45 minutes to remind you to switch
between standing and sitting.
'''

from gi.repository import Notify
from time import sleep

marcoamorales

Keybase proof

I hereby claim:

• I am marcoamorales on github.
• I am marcoamorales (https://keybase.io/marcoamorales) on keybase.
• I have a public key whose fingerprint is 8E01 9F2B F768 F534 EBFB 0E4B A3B9 C0AD 26D6 79E4

To claim this, I am signing this object:

marcoamorales

#!/bin/bash
packages=(package-query yaourt)
if [[ $(pacman -Qs base-devel) == "" ]]; then
  pacman -S base-devel
fi
cd /tmp;
for pkg in "${packages[@]}"
do
  mkdir $pkg
  cd $pkg

marcoamorales

'''
Nexus Notification Script

This script searches for the specific button in the Google Play store that appears
when the phone is in stock and you are able to buy it. It will send you an email
as a notification.

written by: Marco A Morales
http://www.marcoamorales.com
'''

marcoamorales

#!/bin/sh
start_time=`date +%s`
route="/home/marco/files/Edison-Zaragoza/*.xml"
total_count="ls -1 $route| wc -l"
counter=0

for file in $route; do
	echo There are $((total_count - counter)) remaining files to load into the DB.
	let counter+=1
	query="\g LOAD XML LOCAL INFILE '$file' INTO TABLE vcx.cdr_collection ROWS IDENTIFIED BY '<cdr>' (b3, b9, e6, f0);"

marcoamorales

#!/bin/sh

# route="/home/marco/files/*"
route="/media/USB-JGP/*"

for file in $route; do
	query="\g LOAD XML LOCAL INFILE '$file' INTO TABLE vcx.cdr_collection ROWS IDENTIFIED BY '<cdr>';"

	echo "Executing the following query"
	echo $file