Batista Harahap tistaharahap

## binance-candles.py
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

## ct-events.py
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')

## dt.py
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:

## xl-iframe.html
<!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

## results.txt
$ 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

## hs.py
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'

## hs.py
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])


## create-index.sql
CREATE INDEX usernames ON `user` (user_name);

## hs.txt
$ python hs.py
{'user_name': 'tistaharahap', 'user_id': '1', 'user_email': 'tista@example.org', 'created': '2016-09-06 15:00:00'}

## hs.py
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
	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
	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')
	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:
	<!DOCTYPE html>
	<html><head>
	<noscript>
	<meta http-equiv="refresh"content="0;URL=http://ibn.adreach.co/ads-request?t=3&j=0&i=182324434&s=I03025149477501061917&a=http://www.livescore.com/"/>
	</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&j=2&callback=ibn.jsonp313&rnd=313&a=http%3A%2F%2Fwww.livescore.com%2F&i=182324434&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&adsTransactionId=D0394775012212561&orgUrl=http%3A%2F
	$ 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
	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'
	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])
	$ python hs.py
	{'user_name': 'tistaharahap', 'user_id': '1', 'user_email': 'tista@example.org', 'created': '2016-09-06 15:00:00'}
	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