freeeve

I have been trying to fix my dad's washing machine for more than a week--it originally got stuck last Thursday with an error message that came on the screen and the door locked (it's a front loading washing machine).

I read up about the error, which is E01 -> F09, which means generally something like "problem in the draining process"-- could be a clog or a busted pump, or apparently even too much soap can cause it.

I managed to break the handle of this drain plug cap because I was using the metal part of the pliers to turn it, like I saw in some youtube video, and it cracked and started leaking, so I ordered a new piece for that, which came wednesday. Oops!

freeeve

#!/bin/python3

import requests

latest_json = requests.get('https://launchermeta.mojang.com/mc/game/version_manifest.json').json().get('versions')[0].get('url')
latest_server_url = requests.get(latest_json).json().get('downloads').get('server').get('url')
print(latest_server_url)

freeeve

// merge movies
LOAD CSV WITH HEADERS FROM 'http://data.neo4j.com.s3.amazonaws.com/advanced/movies/new_movies.csv' AS row
with toFloat(row.avgVote) as avgVote, toInteger(row.releaseYear) as releaseYear, split(row.genres, ":") as genres, toInteger(row.movieId) as id,
row.title as title
merge (m:Movie {id:id})
set m.title = title,m.avgVote = avgVote,m.releaseYear=releaseYear,m.genres = genres
return count(1)

// merge people
LOAD CSV WITH HEADERS FROM 'http://data.neo4j.com.s3.amazonaws.com/advanced/movies/people.csv' as row 

freeeve

Restaurant Recommendations

Here’s an updated gist.

Here are some changes.

freeeve

id,name
1,"Eve"
2,"Thomas"
3,"Ryan"

freeeve

// get an idea of schema for node properties
match (n)
with n, keys(n) as ks
limit 100000
unwind ks as k
with n, k
order by k
return distinct labels(n), collect(distinct k)

// query to get actors/directors

freeeve

license: gpl-3.0

freeeve

create constraint ON ( movie:Movie ) ASSERT movie.id IS UNIQUE;
create constraint ON ( person:Person ) ASSERT person.id IS UNIQUE;

create index ON :Movie(title);
create index ON :Person(name);

// migrate genres to nodes
match (m:Movie)
unwind m.genres as genre
merge (g:Genre {name:genre})

freeeve

create index on :Movie(movieId);

create index on :Person(personId);

load csv with headers from 'file:///people.csv' as record
merge (p:Person {personId:record.personId})
set p = record;

load csv with headers from 'file:///movies.csv' as record
merge (m:Movie {movieId:record.movieId})

freeeve

match (n)
with n, keys(n) as keys
limit 100000
unwind keys as key
with n, key
order by id(n), key
with n, collect(key) as keys
return distinct labels(n), keys, count(1)