Skip to content

Instantly share code, notes, and snippets.

View davelooi's full-sized avatar

Looi David davelooi

4 followers · 3 following
View GitHub Profile
@davelooi
davelooi / mongodb-query
Created May 16, 2023 07:04
[{
$match:
{
_id: {
$gte: ObjectId('6459e25142d1fa00071e3b72')
}
}
}]
@davelooi
davelooi / docker DBs
Last active August 30, 2022 02:52
# Start a new mysql 5.7 DB at host port 3306
docker run --name=mysql57 -e MYSQL_ROOT_PASSWORD=password -p 3306:3306 -d mysql/mysql-server:5.7
# Connect to docker container
docker exec -it mysql57 mysql -p
# Create superuser
create user looi@'%' identified by 'password';
grant all on *.* to looi@'%';
flush privileges;
# Start a new mysql 5.7 DB at host port 3307
@davelooi
davelooi / keybase
Created September 10, 2019 23:37
### Keybase proof
I hereby claim:
* I am davelooi on github.
* I am davidlooi (https://keybase.io/davidlooi) on keybase.
* I have a public key whose fingerprint is 1E92 D6E2 97BA C062 CEEB 97C1 A8F9 DF38 5BF9 81A8
To claim this, I am signing this object:
@davelooi
davelooi / coverage_merger.rb
Created March 28, 2019 02:55
Merging simplecov resultsets
# frozen_string_literal: true
module CoverageMerger
def self.merge(directories:)
require 'json'
require 'simplecov'
# Simplecov generates a report on exit by default
# We are doing this manually with merged resultsets
SimpleCov.at_exit {}
@davelooi
davelooi / user.rb
Created November 5, 2018 02:48
## somewhere.rb
bunch_of_user_entities = UserRepository.new.fetch_all_active_users.map do |user_record|
UserEntity.new(user_record.id, user_record.email, user_record.name, user_record.age)
end
## user_entity.rb
class UserEntity < Struct.new(:id, :email, :name, :age)
def to_s
@davelooi
davelooi / chart.html
Created September 15, 2018 21:23
chart.js example
<html>
<head>
<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.7.2/Chart.min.js"></script>
</head>
<body>
<canvas id="myChart"></canvas>
</body>
@davelooi
davelooi / lala.rb
Created March 13, 2018 03:43
public gist
puts "Ryan Gosling"
@davelooi
davelooi / joins.sql
Created February 4, 2018 10:52
begin;
create table users (id integer, name text);
create table segments (id integer, name text);
create table user_segment (user_id integer, segment_id integer);
insert into users (id, name) values (1, 'david');
insert into users (id, name) values (2, 'davido');
insert into users (id, name) values (3, 'looi');
insert into users (id, name) values (4, 'oliver');
@davelooi
davelooi / dice.html
Created April 16, 2017 14:45
Dice rolling in JS
<html>
<head>
<script>
function numberOfDice() {
return document.getElementById("numberOfDice").value;
}
function handleDiceChange() {
document.getElementById('rangeValLabel').innerHTML = numberOfDice();
}
function rollDice() {
@davelooi
davelooi / david_bot.rb
Created February 3, 2015 13:17
dave's RTanque
class DavidBot < RTanque::Bot::Brain
NAME = 'david_bot'
include RTanque::Bot::BrainHelper
def tick!
## main logic goes here
# use self.sensors to detect things
# See http://rubydoc.info/github/awilliams/RTanque/master/RTanque/Bot/Sensors