Skip to content

Instantly share code, notes, and snippets.

View shivam-tripathi's full-sized avatar
💫
Call it magic, Call it code

Shivam Tripathi shivam-tripathi

💫
Call it magic, Call it code
80 followers · 27 following
  • Bangalore, India
View GitHub Profile
@shivam-tripathi
shivam-tripathi / google.user.js
Created March 16, 2018 19:30
// ==UserScript==
// @name New Userscript
// @namespace http://tampermonkey.net/
// @version 0.1
// @description try to take over the world!
// @author You
// @match https://www.google.co.in/
// @require https://fb.me/react-0.13.0.js
// @grant none
// ==/UserScript==
@shivam-tripathi
shivam-tripathi / edition_dump_sample.json
Created March 24, 2018 18:41
{
"subtitle": "creating a butterfly haven in your garden",
"subject_place": [
"North America"
],
"covers": [
810390
],
"lc_classifications": [
"QL544.6 .E47 1997"
@shivam-tripathi
shivam-tripathi / works_dump_sample.json
Last active March 24, 2018 18:49
{
"title": "A la recherche de l'\u00e2me de mon p\u00e8re",
"created": {
"type": "\/type\/datetime",
"value": "2009-12-11T01:57:29.804644"
},
"covers": [
3143247
],
"last_modified": {
@shivam-tripathi
shivam-tripathi / authors_dump_sample.json
Created March 24, 2018 18:52
{
"name": "Jürgen Siemund",
"personal_name": "Jürgen Siemund",
"last_modified": {
"type": "/type/datetime",
"value": "2008-08-20T20:07:43.066631"
},
"key": "/authors/OL1017592A",
"type": {
"key": "/type/author"
@shivam-tripathi
shivam-tripathi / all_books.xml
Last active March 24, 2018 19:08
<record>
<leader>00720cam a2200229 a 4500</leader>
<controlfield tag="001"> 00000004 </controlfield>
<controlfield tag="003">DLC</controlfield>
<controlfield tag="005">20130531080354.0</controlfield>
<controlfield tag="008">040819s1899 ohu 000 0 eng </controlfield>
<datafield tag="010" ind1=" " ind2=" ">
<subfield code="a"> 00000004 </subfield>
</datafield>
<datafield tag="035" ind1=" " ind2=" ">
@shivam-tripathi
shivam-tripathi / GSoC-BB(remaining).md
Last active March 25, 2018 05:33

Timeline:

Community Bonding (April 24 – May 13)

In this period I aim to familiarize myself more with metabrainz community and it's projects. I will talk with the bookbrainz users and metabrainz community members and know what all they would like to see improved or additionally implemented in my gsoc project. Additionally, I will write some documentation and FAQs for the project and edit entries in BookBrainz and MusicBrainz data. I will discuss with the mentor and confirm the implementation details, based on which I will make relevant changes to the proposed plan, adding, removing or improving as required.

Phase 1 (May 14 – June 11)

@shivam-tripathi
shivam-tripathi / gist:94863c7f70347aec92d7e9e1cacc1e99
Created March 31, 2018 20:29
AchievementType model
✓ should return a JSON object with correct keys when saved (54ms)
AchievementUnlock model
✓ should return a JSON object with correct keys when saved
Alias model
✓ should return a JSON object with correct keys when saved
AliasSet model
@shivam-tripathi
shivam-tripathi / up.sql
Last active May 3, 2018 14:00
BEGIN;
CREATE EXTENSION pg_trgm;
CREATE EXTENSION unaccent;
CREATE EXTENSION btree_gin;
-- Column to cache tokenized alias names
ALTER TABLE bookbrainz.alias
ADD COLUMN IF NOT EXISTS tokens TSVECTOR;
@shivam-tripathi
shivam-tripathi / down.sql
Last active May 3, 2018 14:01
BEGIN;
DROP VIEW IF EXISTS bookbrainz.untokenized_names;
DROP MATERIALIZED VIEW IF EXISTS bookbrainz.search_mv;
DROP MATERIALIZED VIEW IF EXISTS bookbrainz.search_words_mv;
DROP VIEW IF EXISTS bookbrainz.master_entities;
DROP TRIGGER IF EXISTS alias_token_update on bookbrainz.alias;
DROP TRIGGER IF EXISTS mv_publisher_update ON bookbrainz.publisher_header;
@shivam-tripathi
shivam-tripathi / test.ipynb
Last active April 17, 2018 07:57
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.