Skip to content

Instantly share code, notes, and snippets.

View tistaharahap's full-sized avatar

Batista Harahap tistaharahap

80 followers · 26 following
View GitHub Profile
@tistaharahap
tistaharahap / binance-candles.py
Created March 25, 2024 04:35
Modeling example
class Candle(BaseCutsModel):
open_time: int
open: Decimal
high: Decimal
low: Decimal
close: Decimal
volume: Decimal
close_time: int
quote_asset_volume: Decimal
number_of_trades: int
@tistaharahap
tistaharahap / ct-events.py
Created January 8, 2021 14:47
from os import environ
from typing import Optional, Dict
from datetime import datetime, timedelta
import requests
API_URL = 'https://api.clevertap.com'
API_EVENTS_URI = '/1/events.json'
MAX_BATCH_SIZE = 5000
PROJECT_ID = environ.get('PROJECT_ID')
PASSCODE = environ.get('PASSCODE')
@tistaharahap
tistaharahap / dt.py
Last active August 9, 2019 08:06
from datetime import datetime
import csv
import pandas as pd
import matplotlib.pyplot as plt
fn = './redfin_2019-08-08-20-18-37.csv'
fn_mapped = './redfin_2019-08-08-20-18-37-mapped.csv'
df = []
with open(fn) as f:
@tistaharahap
tistaharahap / xl-iframe.html
Created May 14, 2017 15:22
XL Iframe
<!DOCTYPE html>
<html><head>
<noscript>
&lt;meta http-equiv="refresh"content="0;URL=http://ibn.adreach.co/ads-request?t=3&amp;j=0&amp;i=182324434&amp;s=I03025149477501061917&amp;a=http://www.livescore.com/"/&gt;
</noscript>
<link href="http://ibn.adreach.co:8004/COMMON/css/ibn_20150915.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="http://ibn.adreach.co/ads-request?t=3&amp;j=2&amp;callback=ibn.jsonp313&amp;rnd=313&amp;a=http%3A%2F%2Fwww.livescore.com%2F&amp;i=182324434&amp;s=I03025149477501061917"></script><style type="text/css">
:root #content > #center > .dose > .dosesingle,
:root #content > #right > .dose > .dosesingle
{ display: none !important; }</style><meta name="viewport" content="width=device-width, initial-scale=1"><meta name="apple-mobile-web-app-capable" content="no"><title>LiveScore Soccer : Live Soccer Scores by LiveScore.com</title><script type="text/javascript" src="http://ibn.adreach.co/ads-reset?j=2&amp;adsTransactionId=D0394775012212561&amp;orgUrl=http%3A%2F
@tistaharahap
tistaharahap / results.txt
Created September 13, 2016 10:43
$ python hs.py
**/ Benchmarking Handlersocket - START /**
Elapsed time: 9.35 seconds
Speed : 10693.14 queries/second
**/ Benchmarking Handlersocket - END /**
**/ Benchmarking MySQL - START /**
Elapsed time: 12.11 seconds
@tistaharahap
tistaharahap / hs.py
Created September 13, 2016 10:41
from pyhs import Manager
import MySQLdb
import time
def run_handlersocket(maximum):
hs = Manager() # Assuming that Handlersocket is available at 127.0.0.1
print '**/ Benchmarking Handlersocket - START /**\n'
@tistaharahap
tistaharahap / hs.py
Last active September 13, 2016 10:40
from pyhs import Manager
def main():
hs = Manager() # Assuming that Handlersocket is available at 127.0.0.1
user = hs.find('fun', 'user', '>=', ['user_id', 'user_name', 'user_email', 'created'], ['tistaharahap'], 'usernames', 1)
print dict(user[0])
@tistaharahap
tistaharahap / create-index.sql
Created September 6, 2016 08:52
CREATE INDEX usernames ON `user` (user_name);
@tistaharahap
tistaharahap / hs.txt
Created September 6, 2016 08:46
$ python hs.py
{'user_name': 'tistaharahap', 'user_id': '1', 'user_email': '[email protected]', 'created': '2016-09-06 15:00:00'}
@tistaharahap
tistaharahap / hs.py
Created September 6, 2016 08:46
from pyhs import Manager
def get_user_by_id(hs, user_id):
pass
def main():
hs = Manager() # Assuming that Handlersocket is available at 127.0.0.1