Skip to content

Instantly share code, notes, and snippets.

View yota345's full-sized avatar
🏠
Working from home

Yota Numata yota345

🏠
Working from home
View GitHub Profile
@yota345
yota345 / RxCounter.swift
Last active August 17, 2016 09:27
RxCounter.swift
// 秒数カウンターを実装。いまは実装内容を深く考えないでください。
func myInterval(interval: NSTimeInterval) -> Observable<Int> {
return Observable.create { observer in
print("Subscribed")
let queue = dispatch_get_global_queue(DISPATCH_QUEUE_PRIORITY_DEFAULT, 0)
let timer = dispatch_source_create(DISPATCH_SOURCE_TYPE_TIMER, 0, 0, queue)
var next = 0
dispatch_source_set_timer(timer, 0, UInt64(interval * Double(NSEC_PER_SEC)), 0)
Started ----
Subscribed
Subscribed
First 0
Second 0
First 1
Second 1
First 2
Second 2
First 3
@yota345
yota345 / GAE sample app.yaml
Last active March 4, 2017 19:41
GAE sample app.yaml
application: your app id
service: default
version: 1
runtime: go
api_version: go1
default_expiration: "1d"
instance_class: F1
env_variables:
MY_VAR: 'my value'
@yota345
yota345 / GAE directory tree with golang
Last active February 28, 2017 05:43
GAE directory tree with golang
.
├── readme.md
├── config.toml
└── v1
├── app
│   ├── app-engine.go
│   ├── app.go
│   ├── app.yaml
│   └── queue.yaml
├── app-standalone.go
@yota345
yota345 / sample.rule
Last active February 10, 2020 17:07
Firestore security rule
service cloud.firestore {
match /databases/{database}/documents {
function isOwn() {
return request.resource.userId == request.auth.uid;
}
function hasTimestamp() {
return request.resource.data.timestamp == request.time;
}
function isCalm() {
return request.time > resource.data.timestamp + duration.value(5, 's');
@yota345
yota345 / script
Created February 7, 2020 17:21
Sql to sum up weekly retention with Firebase Analytics
WITH start AS (
SELECT
user_pseudo_id,
EXTRACT(DATE FROM TIMESTAMP_MICROS(event_timestamp)) AS start_date
FROM
`your.database.events_*`
WHERE
_TABLE_SUFFIX BETWEEN FORMAT_DATE("%Y%m%d", DATE_SUB(DATE_TRUNC(CURRENT_DATE(), WEEK), INTERVAL 5 WEEK)) AND FORMAT_DATE("%Y%m%d", DATE_SUB(DATE_TRUNC(CURRENT_DATE(), WEEK), INTERVAL 1 DAY))
AND event_name = "your event name"
AND EXTRACT(DATE FROM TIMESTAMP_MICROS(event_timestamp)) BETWEEN DATE_SUB(DATE_TRUNC(CURRENT_DATE(), WEEK), INTERVAL 5 WEEK) AND DATE_SUB(DATE_TRUNC(CURRENT_DATE(), WEEK), INTERVAL 1 DAY)