Skip to content

Instantly share code, notes, and snippets.

View weeksdev's full-sized avatar
🏠
Working from home

Andrew Weeks weeksdev

🏠
Working from home
View GitHub Profile
//requires signal-js, crossroads, and hasher to work
crossroads.addRoute('order/{id}', function(id){
console.log(id);
});
function parseHash(newHash, oldHash) {
crossroads.parse(newHash);
}
hasher.initialized.add(parseHash); //parse initial hash
@weeksdev
weeksdev / jsononpagetocsv.js
Created June 24, 2015 14:42
jsononpagetocsv
var displaynames = [];
var data = JSON.parse(document.body.getElementsByTagName('pre')[0].innerHTML).data;
data.forEach(function(item){
if('displayname' in item.Properties && item.Properties.displayname != null && item.Properties.displayname.length> 0){
var displayname = item.Properties.displayname[0];
displaynames.push([displayname]);
}
});
var csvContent = '';
function exportToCsv(filename, rows) {
@weeksdev
weeksdev / GitCommands.md
Created June 19, 2015 13:49
GitCommands

tell you some files changes

git status

now revert back to the head with the changes that weren't commited

git checkout path/to/file.txt

run git status again and make sure there is nothing left

@weeksdev
weeksdev / index.html
Last active August 29, 2015 14:22
testing bl.ocks.org
<html>
<head>
</head>
<body>
<h1>This is a test page</h1>
</body>
</html>
@weeksdev
weeksdev / NetezzaGenerateExternal
Last active March 13, 2017 21:00
Netezza Generate External Command
CREATE EXTERNAL TABLE 'path/to/flat/file.dat'
USING ( delim ',' datestyle 'YMD' datedelim '-' REMOTESOURCE 'ODBC' requireQuotes true quotedvalue 'yes' LOGDIR 'path/to/log/directory/' nullvalue '') AS
SELECT *
FROM MonkeyPants
--determine which queries are running
SELECT *
FROM sys.dm_exec_requests requests
WHERE requests.session_id > 50
ORDER BY total_elapsed_time DESC
SELECT requests.session_id,
requests.status,
requests.command,
requests.statement_start_offset,
@weeksdev
weeksdev / parsing_helps.cs
Last active August 29, 2015 14:12
Parsing
public class SubstringResponse {
public string Value { get; set; }
public int loc1 { get; set; }
public int loc2 { get; set; }
}
public static SubstringResponse Substring(this string source, string startPos, string endPos) {
return Substring(source, new List<string>() { startPos }, endPos);
}
public static SubstringResponse Substring(this string source, List<string> startPos, string endPos) {
@weeksdev
weeksdev / codemirror-extjs.js
Last active August 3, 2022 00:10
CodeMirror ExtJs
{
fieldLabel: 'Code Instance',
itemId: 'parentFld',
border: 1,
html: '<textarea></textarea>',
/* Overriding getValue function of the field to pull value from the codemirror text area*/
getValue: function (value) {
return this.getCodeMirror().getValue();
},
/*Overriding setValue function of the field to put the value in the code mirror window*/
@weeksdev
weeksdev / bulkcopy.cs
Created May 29, 2014 19:04
SqlBulkCopy
var copy = new System.Data.SqlClient.SqlBulkCopy(connectionString);
System.Data.SqlClient.SqlCommand command = new System.Data.SqlClient.SqlCommand("select * from someTable",connection);
var reader = command.ExecuteReader();
copy.DestinationTableName = "destinationTable";
copy.WriteToServer(reader);
copy.Close();
connection.Close();
@weeksdev
weeksdev / regexparse.bas
Created May 29, 2014 13:45
RegEx Parse
Sub RegExParse()
Dim RE As Object, REMatches As Object
Dim pattern As String
Set RE = CreateObject("vbscript.regexp")
pattern = "\[(.*?)\] \["
With RE
.MultiLine = False
.Global = False