Skip to content

Instantly share code, notes, and snippets.

View ericcgu's full-sized avatar
🌍

Eric Gu (@ericguuu) ericcgu

🌍
  • New York, NY
View GitHub Profile
func filterContentForSearchText(searchString: String, scope: String = "All") {
// Filter the array using the filter method
self.filteredLocationNames = self.locationNames.filter({( stateName: String) -> Bool in
let stringMatch = stateName.lowercaseString.rangeOfString(searchString.lowercaseString)
return stringMatch != nil
})
}
@ericcgu
ericcgu / gist:091b1b55da042d1fe6e2
Created January 21, 2015 03:32
SQL Swift Raw Query
// let table = db["STOCKS_CORN_LOCATION"];
//
//
// var query = "SELECT LOCATION, \"2011301_ON\", \"2011301_OFF\", \"2011301_TOTAL\" FROM STOCKS_CORN_LOCATION"
// let statement = db.prepare(query)
// while ((statement.next()) != nil){
// let row = statement.row![0]!
// var dataFieldImport = DataFieldObject(fieldOne: statement.row![0]! as String,
// fieldTwo: statement.row![1]! as String,
// fieldThree: statement.row![2]! as String,
@ericcgu
ericcgu / gist:c1507162b97c4534f0c7
Created January 23, 2015 05:26
String Range Extension
extension String {
subscript (i: Int) -> Character {
return self[advance(self.startIndex, i)]
}
subscript (i: Int) -> String {
return String(self[i] as Character)
}
@ericcgu
ericcgu / gist:9b8398ed6e0b96cee9c6
Last active August 29, 2015 14:14
Weighted Average Spread
USE [clo1]
GO
/****** Object: StoredProcedure [dbo].[spGet_CQT_WAS_AssetContribution] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/* =============================================
-- Description: CQT_WAS_AssetContribution
<script type="text/javascript">
<!--
if (screen.width <= 800) {
window.location = "http://m.domain.com";
}
//-->
</script>
@ericcgu
ericcgu / gist:c96c93795b94645c4b6a
Created February 17, 2015 20:33
Win Condition
func checkWinCondition (column: Int, row: Int){
let alert = UIAlertView()
alert.title = "Four In a Row! Game Over!"
alert.addButtonWithTitle("OK")
for row in 0..<gameBoard.rows {
for column in 0..<gameBoard.columns {
//horizontal
if(isLinearMatch(column: column, row: row, stepX: 1, stepY: 0)){
//
// JPUsersTableViewController.swift
// BaseballCardSocialNetwork
//
// Created by Eric Gu on 2/19/15.
// Copyright (c) 2015 Eric Gu. All rights reserved.
//
import UIKit
@ericcgu
ericcgu / gist:4f50d9bc33f239f0ae55
Last active August 29, 2015 14:15
ParseUI Hack
override func tableView(tableView: UITableView!, cellForRowAtIndexPath indexPath: NSIndexPath!, object: PFObject!) -> JPUserTableViewCell! {
let cell = tableView.dequeueReusableCellWithIdentifier("Cell", forIndexPath: indexPath) as JPUserTableViewCell
cell.imageView.hidden = true
(cell.viewWithTag(1) as PFImageView).image = kProfileDefaultProfileImage
dispatch_async(dispatch_get_main_queue(),{
//cell.textLabel?.text = object["username"] as? String
if let profileImageData = object["profileImage"] as? PFFile {
println(profileImageData)
cell.imageView.file = profileImageData
@ericcgu
ericcgu / gist:3f816db1e5b1f977c77f
Last active August 29, 2015 14:15
Parse Image Upload
let pickedImage:UIImage = "SOME IMAGE"
let scaledImage = scaleImageWith(pickedImage)
let imageData = UIImagePNGRepresentation(scaledImage)
let imageFile:PFFile = PFFile(data: imageData)
PFUser.currentUser().setObject(imageFile, forKey: "imageFieldName")
@ericcgu
ericcgu / gist:ccefc6300292cfbf6c4d
Created February 27, 2015 15:47
Vacation Accrual
USE [HRData]
GO
/****** Object: StoredProcedure [dbo].[usp_Calculate_PTOAccrual] Script Date: 02/27/2015 10:46:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[usp_Calculate_PTOAccrual] (
@UserID INT = NULL