Skip to content

Instantly share code, notes, and snippets.

View ajace's full-sized avatar

Ace Atienza ajace

  • Cainkade
  • New York, NY
View GitHub Profile
@ajace
ajace / SSMA
Created June 21, 2017 20:54
SSMA migration from MySql to SQL Server
SSMA
General Solutions for migration
1. Update Mysql DB
2. SSMA > Table > Refresh from DB
3. SSMA > Table > Convert Schema
4. SSMA > SQL Server Table > Synchronize with Database
5. SSMA > MySQL Table > Migrate Data
6. Apply previous MySQL logic in MSSQL equivalent (most should be possible) in separate query
@ajace
ajace / strings.xml
Created January 23, 2017 20:36
Use CDATA along with string formatting for hyperlinks (Android)
<string name="link"> <![CDATA[<a href="%1$s"><u>%2$s</u></a>]]> </string>
function addOrdinalSuffix(number) {
return number+(['st','nd','rd'][( number +'').match(/1?\d\b/)-1]||'th');
}
@ajace
ajace / jquery-ui-date-validation.js
Last active August 29, 2015 14:21
jquery-ui-date-validation
function(dateText) {
try {
// US format
$.datepicker.parseDate('mm/dd/yy', dateText);
} catch (e) {
alert(e);
// alert user
};
}
@ajace
ajace / tweet
Created October 14, 2014 16:27
Twitter Tweet Popup
<script>
function tweetIt(event) {
window.twttr=window.twttr||{};
var D=550,A=450,C=screen.height,B=screen.width,H=Math.round((B/2)-(D/2)),G=0,F=document,E;
if(C>A){G=Math.round((C/2)-(A/2))}
var fullLink = 'http://twitter.com/share?url=' + encodeURIComponent(document.URL) + '&text=' + encodeURIComponent(document.title);
window.twttr.shareWin=window.open(fullLink,'','left='+H+',top='+G+',width='+D+',height='+A+',personalbar=0,toolbar=0,scrollbars=1,resizable=1');
E=F.createElement('script');
E.src='https://platform.twitter.com/widgets.js';
F.getElementsByTagName('head')[0].appendChild(E);
@ajace
ajace / pinterest
Created October 14, 2014 14:34
Custom Pinterest Button with auto url and auto media
<!-- credit: http://www.brandaiddesignco.com/insights/add-a-custom-pinterest-pin-it-button-to-your-website/ -->
<a href='javascript:void((function()%7Bvar%20e=document.createElement(&apos;script&apos;);e.setAttribute(&apos;type&apos;,&apos;text/javascript&apos;);e.setAttribute(&apos;charset&apos;,&apos;UTF-8&apos;);e.setAttribute(&apos;src&apos;,&apos;http://assets.pinterest.com/js/pinmarklet.js?r=&apos;+Math.random()*99999999);document.body.appendChild(e)%7D)());'><img src='http://www.brandaiddesignco.com/insights/PinIt.png'/></a>
@ajace
ajace / getQueryVariable.js
Created February 21, 2014 16:55
from CSS-Tricks. grab a query value in the uri
function getQueryVariable(variable)
{
var query = window.location.search.substring(1);
var vars = query.split("&");
for (var i=0;i<vars.length;i++) {
var pair = vars[i].split("=");
if(pair[0] == variable){return pair[1];}
}
return(false);
}
@ajace
ajace / $.ajax.form.submit.js
Created January 15, 2014 19:22
ajax form submittal using jquery; useful inside of iframes since .submit() doesn't work
var url = location.origin;
var form = $('').serialize();
$.ajax({
url: url,
type: 'post',
dataType: 'json',
data: form,
}).done(function(data){
console.log("success");
@ajace
ajace / array_keys_i.php
Created December 18, 2013 20:42
PHP: array keys search for insensitive input
function array_keys_i($array, $str){
$results = array();
foreach($array as $key => $value) {
if(stristr($str,$value)) {
$results[] = $key;
}
}
if(empty($results)) {
@ajace
ajace / initial_setup.sh
Last active December 26, 2015 17:49
Ubuntu 14.10 web development setup
#!/bin/sh
# chmod +x initial_setup.sh
# sudo ./initial_setup.sh
sudo apt-get install -y \
curl \
vim \
git \
alacarte \