Skip to content

Instantly share code, notes, and snippets.

@c0mpiler
c0mpiler / test_data.csv
Created November 29, 2018 09:25
test data csv
1 IBM 36222
1 softlayer 36222
1 RedHat 36222
2 Google 989151
2 Oracle 632
3 Facebook 987092
3 Twitter 987092
1 Tesla 34333
1 Acer 9789332
2 Deloitte 467
@c0mpiler
c0mpiler / mark_dups.vba
Created November 29, 2018 09:03
assign the same serial no, for duplicate transaction rows
Sub MarkDuplicates()
' Activate the Master Sheet
Sheets("master").Activate
' Count the number of non-empty rows in the master sheet
RowCount = Worksheets("master").Cells(Rows.Count, 1).End(xlUp).Row
ColCount = Worksheets("master").Cells(1, Columns.Count).End(xlToLeft).Column
dealAmtCol = 3
firstRow = 1
@c0mpiler
c0mpiler / copy_sheets.vba
Last active November 16, 2018 08:05
excel macro test
Sub Combine()
Dim J As Integer
Dim s As Worksheet
On Error Resume Next
Sheets(1).Select
Worksheets.Add
dt = Format(CStr(Now), "yyy_mm_dd_hh_mm")
nam = "Combined_"
new_sheet_name = nam & dt
@c0mpiler
c0mpiler / ES_partial_search_by_non_existant_genome_id.json
Created October 23, 2018 01:11
ES_partial_search_by_non_existant_genome_id.json
{
"took": 134,
"timed_out": false,
"_shards": {
"total": 60,
"successful": 60,
"skipped": 0,
"failed": 0
},
"hits": {
@c0mpiler
c0mpiler / install_python37.sh
Last active September 30, 2018 04:14
Setup python 3.7 on Ubuntu
#! /usr/bin/env bash
# Requirements
sudo apt-get install -y build-essential checkinstall libreadline-gplv2-dev libncursesw5-dev libssl-dev libsqlite3-dev tk-dev libgdbm-dev libc6-dev libbz2-dev zlib1g-dev openssl libffi-dev python3-dev python3-setuptools wget
# Prepare to build
mkdir /tmp/Python37
cd /tmp/Python37
# Pull down Python 3.7, build, and install
@c0mpiler
c0mpiler / blast_response.json
Created September 26, 2018 01:12
Blast Search service response
{
"results": [
{
"alignments": [
{
"hsps": [
{
"align_length": 68,
"bits": 135.293,
"expect": 9.08954e-31,
@c0mpiler
c0mpiler / git-merge-strategies
Created September 25, 2018 01:56
(Because I always forget) How to overwrite a master branch with a remote branch
git checkout better_branch
git merge --strategy=ours master # keep the content of this branch, but record a merge
git checkout master
git merge better_branch # fast-forward master up to the merge
----------------------
If you want your history to be a little clearer, I'd recommend adding some information to the merge commit message to make it clear what you've done. Change the second line to:
@c0mpiler
c0mpiler / pypi-release-checklist.md
Created July 13, 2018 01:18
My PyPI Release Checklist
  • Update HISTORY.rst
  • Commit the changes:
git add HISTORY.rst
git commit -m "Changelog for upcoming release 0.1.1."
  • Update version number (can also be minor or major)
bumpversion patch
@c0mpiler
c0mpiler / keycloakerror.log
Created June 22, 2018 04:20
KeyCloak Github error
04:00:36,290 ERROR [org.keycloak.broker.oidc.AbstractOAuth2IdentityProvider] (default task-163) Failed to make identity provider oauth callback: org.keycloak.broker.provider.IdentityBrokerException: Could not obtain user profile from github.
at org.keycloak.social.github.GitHubIdentityProvider.doGetFederatedIdentity(GitHubIdentityProvider.java:92)
at org.keycloak.broker.oidc.AbstractOAuth2IdentityProvider.getFederatedIdentity(AbstractOAuth2IdentityProvider.java:283)
at org.keycloak.broker.oidc.AbstractOAuth2IdentityProvider$Endpoint.authResponse(AbstractOAuth2IdentityProvider.java:407)
at sun.reflect.GeneratedMethodAccessor750.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:295)
at org.jboss.resteasy.core.ResourceMet