Skip to content

Instantly share code, notes, and snippets.

View vanjos's full-sized avatar

Victor ... wait for it .... Anjos vanjos

View GitHub Profile
@nikhilkumarsingh
nikhilkumarsingh / google_calendar_api_integration.ipynb
Created May 10, 2019 10:01
Integrating Google Calendar API in Python Projects
View google_calendar_api_integration.ipynb
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@johndstein
johndstein / re-attributes.sql
Created February 9, 2017 20:25
Raiser's Edge Gift Attributes
View re-attributes.sql
-- Shows some helpful info about gift attributes.
-- This SQL is for SQL Server.
DECLARE @attr varchar(MAX)
SET @attr = 'Legacy Correction'
-- Overall Count
select count(*) count
from giftattributes ga
join attributetypes at on ga.attributetypesid = at.attributetypesid
@johndstein
johndstein / rea.sql
Created July 5, 2016 14:44
Raisers Edge Attributes
View rea.sql
select *
from dbo.ConstituentAttributes as ca
inner join dbo.CONSTITUENT as con on ca.PARENTID = con.id
inner join dbo.attributetypes as at on ca.attributetypesid = at.attributetypesid
inner join dbo.TABLEENTRIES as te on te.CODETABLESID = at.CODETABLESID
inner join dbo.CODETABLES as ct on ct.CODETABLESID = at.CODETABLESID
where at.recordtype = 1
and at.TYPEOFDATA > 5
-- codetables will tell you the category, (Ex. Magazine) and tableentries will tell you a specific value, (Ex, Spring 05)
@turbofart
turbofart / tsp.py
Created August 22, 2012 20:06
Applying a genetic algorithm to the travelling salesman problem
View tsp.py
#!/usr/bin/env python
"""
This Python code is based on Java code by Lee Jacobson found in an article
entitled "Applying a genetic algorithm to the travelling salesman problem"
that can be found at: http://goo.gl/cJEY1
"""
import math
import random
@tinaarnoldi
tinaarnoldi / SQL Raisers Edge Gifts to specific fund
Created July 9, 2012 16:51
SQL Raisers Edge Gifts to specific fund
View SQL Raisers Edge Gifts to specific fund
SELECT
GIFT.CONSTIT_ID, GIFT.Amount, GIFT.DTE, FUND.FUND_ID, RECORDS.FIRST_NAME, RECORDS.LAST_NAME, RECORDS.ORG_NAME, GIFT.REF
FROM
RECORDS LEFT OUTER JOIN
GIFT LEFT OUTER JOIN
FUND INNER JOIN
GiftSplit ON FUND.ID = GiftSplit.FundId ON GIFT.ID = GiftSplit.GiftId ON RECORDS.ID = GIFT.CONSTIT_ID
WHERE (FUND.FUND_ID = 'YOUR PROJECT ID OR FUND ID') AND (GIFT.DTE >= @Date)
@jasonrudolph
jasonrudolph / git-branches-by-commit-date.sh
Created February 12, 2012 20:40
List remote Git branches and the last commit date for each branch. Sort by most recent commit date.
View git-branches-by-commit-date.sh
# Credit http://stackoverflow.com/a/2514279
for branch in `git branch -r | grep -v HEAD`;do echo -e `git show --format="%ci %cr" $branch | head -n 1` \\t$branch; done | sort -r