Skip to content

Instantly share code, notes, and snippets.

View hagope's full-sized avatar

Omar Al-Jadda hagope

11 followers · 39 following
  • Sunnyvale, CA
View GitHub Profile
@hagope
hagope / QlikView_Convert_from_Unix_Timestamp.qvs
Last active August 29, 2015 14:24 — forked from ralfbecher/QlikView_Convert_from_Unix_Timestamp.qvs
// Solution 1:
Timestamp = ConvertToLocalTime(Date(MakeDate(1970, 1, 1) + (<timestamp_field> / 86400)), '<time_zone>')
// Solution 2:
Timestamp = ConvertToLocalTime(Date(25569 + (<timestamp_field> / 86400)), '<time_zone>')
// my need
ConvertToLocalTime(Date(MakeDate(1970, 1, 1) + (epoch_ts / 86400)))
@hagope
hagope / windows-power-commands.txt
Created August 3, 2015 04:36
useful command line hacks for windows command prompt and powershell
# Get hard drive info
wmic logicaldisk get
# Quicky create a system image backup
wbAdmin start backup -backupTarget:E: -include:C: -allCritical -quiet
@hagope
hagope / rename-pictures-for-dropbox.sh
Created November 20, 2015 04:52
renames jpg files using exif creation date as filename in the same format as Dropbox Camera Uploads folder YYYY-MM-DD HH.MM.SS.jpg
#!/bin/bash
# requires exif command line utility
shopt -s nocaseglob #find both *.jpg and *.JPG
for i in *.JPG; do
j=`exif -t 0x9003 "$i" | grep Value: | sed 's/Value://' | sed s/:/-/g | sed s/-/./3 | sed s/-/./3`.jpg
mv -i "$i" "$j"
done
@hagope
hagope / dash-listen-3.py
Last active November 21, 2015 20:26 — forked from courtsimas/dash-listen-3.py
listen on network for push of Amazon dash button; this version uses arp-scan instead of scapy
import subprocess
import requests
import time
import os,sys
MAGIC_FORM_URL = 'http://api.cloudstitch.io/...your_url'
def record_wake():
data = {
"Timestamp": time.strftime("%Y-%m-%d %H:%M"),
@hagope
hagope / fix_exif_dates.sh
Created January 19, 2016 17:31
There's a bug in the Android Camera that doesn't set Create Date and Date Time Original in the photo's EXIF meta data, but only when the images are NOT set to HDR+
# There's a bug in the Android Camera that doesn't set Create Date and Date Time Original in the photo's EXIF meta data, but only when the images are NOT set to HDR+
# The following is fix using exiftool (brew install exiftool) to set these fields
# Run these in the terminal in sequence
# First fix DateTimeOriginal
exiftool "-datetimeoriginal<filemodifydate" -r -if '(not $datetimeoriginal or ($datetimeoriginal eq "0000:00:00 00:00:00")) and ($filetype eq "JPEG")' *.jpg
# Then fix CreateDate
exiftool "-createdate<datetimeoriginal" -r -if '(not $createdate or ($createdate eq "0000:00:00 00:00:00")) and ($filetype eq "JPEG")' *.jpg
@hagope
hagope / temps.csv
Created May 7, 2017 02:47
timestamp temp_f
2017-04-30 13:05:01 71.375
2017-04-30 13:10:01 71.487
2017-04-30 13:15:01 71.487
2017-04-30 13:20:01 71.600
2017-04-30 13:25:01 71.600
2017-04-30 13:30:01 71.600
2017-04-30 13:35:01 71.713
2017-04-30 13:40:01 71.825
2017-04-30 13:45:01 71.825
@hagope
hagope / temp_log.txt
Last active May 8, 2017 13:36
timestamp,temp_f
2017-04-30 13:05:01,71.375
2017-04-30 13:10:01,71.487
2017-04-30 13:15:01,71.487
2017-04-30 13:20:01,71.600
2017-04-30 13:25:01,71.600
2017-04-30 13:30:01,71.600
2017-04-30 13:35:01,71.713
2017-04-30 13:40:01,71.825
2017-04-30 13:45:01,71.825
@hagope
hagope / system_test_gsheets.py
Created August 20, 2019 18:27
system test for Airflow gsheets hook, see https://github.com/apache/airflow/pull/5845
# -*- coding: utf-8 -*-
#
# Licensed to the Apache Software Foundation (ASF) under one
# or more contributor license agreements. See the NOTICE file
# distributed with this work for additional information
# regarding copyright ownership. The ASF licenses this file
# to you under the Apache License, Version 2.0 (the
# "License"); you may not use this file except in compliance
# with the License. You may obtain a copy of the License at
#
@hagope
hagope / my_configs.vim
Last active December 8, 2022 18:41
set tabstop=4
set softtabstop=4
set shiftwidth=4
set textwidth=79
set expandtab
set autoindent
set number
set fileformat=unix
set list
set listchars=tab:>-
@hagope
hagope / git_tools.sh
Last active March 21, 2022 18:16
#!/bin/bash
# install lazy git
# https://github.com/jesseduffield/lazygit#ubuntu
sudo add-apt-repository ppa:lazygit-team/release
sudo apt-get update
sudo apt-get install lazygit
# install gh cli
# https://github.com/cli/cli/blob/trunk/docs/install_linux.md