Skip to content

Instantly share code, notes, and snippets.

View crabcrabcam's full-sized avatar

MxCraven crabcrabcam

View GitHub Profile
@crabcrabcam
crabcrabcam / palindromes.sh
Created November 16, 2016 13:44
Here you go Morgan :)
#!/bin/bash
rm -r sortedPalindromes.txt
rm -r sortedNotPalindromes.txt
cat palindromes.txt | while read line
do
if [[ $(rev <<< $line) == "$line" ]]; then
echo $line >> sortedPalindromes.txt
else
@crabcrabcam
crabcrabcam / scriptManager.sh
Created November 16, 2016 15:38
Master of all files
#!/bin/bash
echo "Where woudl you like to search from?"
read startDir
i=0
n=0
for file in ls -adR -1 *.sh $startDir
do
firstLine=$(head -n 1 $file)
@crabcrabcam
crabcrabcam / bookbinder.sh
Created November 16, 2016 15:56
Bookbinder script
#!/bin/bash
touch chapter{1..5}.txt;
for file in chapter{1..5}.txt
do
echo "This is some text is $file" >> $file
done
echo "Filled chapters"
@crabcrabcam
crabcrabcam / py.py
Last active November 17, 2016 14:43
Quick Py imported test
import tkinter as tk
tk.Tk()
print("This should show a new TK window")
@crabcrabcam
crabcrabcam / organisations.swift
Created November 21, 2016 10:32
Organisation getter
extension GitKit {
public class func getMyOrganisations() -> Observable<[Organisation]> {
guard let organisationsURL = GitKit.currentUser.value?.organizationsUrl else { return [] }
return Alamofire.request(.GET, (organisationsURL))
.rx_responseJSON()
.map { response, json in
guard let array = json as? [[String:AnyObject]] else { return [] }
@crabcrabcam
crabcrabcam / Get Regions.sqlwhateverthing
Created December 13, 2016 10:00
Gets regions by ID and all that
-- Define the database to use
USE ExSQL7
-- Gets all the parts I want and joins them together and links them.
SELECT Region.RegionID, Territories.TerritoryID, Region.RegionDescription, Territories.TerritoryDescription FROM Region
INNER JOIN Territories
ON Territories.RegionID = Region.RegionID
ORDER BY RegionDescription, TerritoryDescription
@crabcrabcam
crabcrabcam / Subquery.sql
Created December 13, 2016 15:38
Subquery inc. Freight
SELECT Customers.CustomerID, Customers.CompanyName, Orders.Freight FROM Customers
INNER JOIN Orders
ON Customers.CustomerID = Orders.CustomerID
WHERE Customers.CustomerID IN
(SELECT CustomerID FROM Orders WHERE Freight > 500)
@crabcrabcam
crabcrabcam / createtable.SQL
Created December 14, 2016 10:39
Create table, name goes blue
CREATE TABLE mythicalBeasts
(
Name NVARCHAR(30),
Century TinyInt,
Details NVARCHAR(255)
)
@crabcrabcam
crabcrabcam / Orders.sql
Created December 14, 2016 14:40
Average orders. Not grouping
SELECT Orders.OrderID, Orders.CustomerID, Customers.CompanyName, COUNT(Orders.CustomerID) AS 'OrderCount' FROM Orders
INNER JOIN Customers
ON Customers.CustomerID = Orders.CustomerID
GROUP BY Orders.OrderID, Orders.CustomerID, Customers.CompanyName, Customers.CustomerID
using System.Collections;
using System.Collections.Generic;
using System;
using System.IO;
using System.Threading;
using UnityEngine;
using UnityEngine.UI;
using UnityEditor;