Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
executable file 160 lines (141 sloc) 5.45 KB
import argparse
import logging
import sys
import re
import time
import json
import csv
import datetime
import requests
log = logging.getLogger(__name__)
class FindBoligNuClient:
URL_base = ""
URL_login = URL_base+"logind.aspx"
URL_venteliste = URL_base+"Findbolig-nu/Min-side/ventelisteboliger/opskrivninger.aspx?"
URL_placement = URL_base+"Services/WaitlistService.asmx/GetWaitlistRank"
session = requests.Session()
def __init__(self):"Initializing the client")
response = self.session.get(self.URL_base)
if "" not in response.text:
log.error("It seems like the website is down or has changed a lot.")
def login(self, username, password):"Logging into %s using username '%s'", FindBoligNuClient.URL_login, username)
# Fetch the regular login page.
response = self.session.get(self.URL_login)
# Extract input names and values
data = dict()
content = response.text
input_fields = re.findall("<input(.*)>", content, flags=re.IGNORECASE)
for field in input_fields:
name = re.findall('.*name="([^"]*)".*', field)
value = re.findall('.*value="([^"]*)".*', field)
type = re.findall('.*type="([^"]*)".*', field)
if type[0] == "button":
continue # Skip buttons
if name:
if value:
data[name[0]] = value[0]
data[name[0]] = ""
data["ctl00$placeholdercontent_1$txt_UserName"] = username
data["ctl00$placeholdercontent_1$txt_Password"] = password
data["__EVENTTARGET"] = "ctl00$placeholdercontent_1$but_Login"
data["__EVENTARGUMENT"] = ""
response =, data=data)
if "Log af" in response.text:
# Extract users full name.
name ='<span id="fm1_lbl_userName">(.*)&nbsp;</span>', response.text)"Logged in as %s",
return True
return False
def extract_waitinglist_references(self):
result = []
response = self.session.get(self.URL_venteliste)
table_content ='<table[^>]*id="GridView_Results"[^>]*>(.*?)</table>', response.text, flags=re.IGNORECASE|re.DOTALL)
if table_content:
table_content =
rows = re.findall('<tr class="rowstyle"[^>]*>(.*?)</tr>', table_content, flags=re.IGNORECASE|re.DOTALL)
for row in rows:
#collumn = re.findall('<td[^>]*>(.*?)</td>', row, flags=re.IGNORECASE|re.DOTALL)
bid ='href="\/Ejendomspraesentation.aspx\?bid=([^"]*)"', row, flags=re.IGNORECASE|re.DOTALL)
if bid:
bid = int(
return result
def extract_waitinglist_placements(self, bids, sleep=1):
result = {}
for bid in bids:
log.debug("Requesting placement on building #%u.", bid)
data = {
'buildingId': bid
headers = {
'Content-Type': 'application/json; charset=UTF-8'
response =, data=json.dumps(data), headers=headers)
if response:
response = response.json()
if response["d"] and response["d"]["WaitPlacement"]:
result[str(bid)] = int(response["d"]["WaitPlacement"])
log.debug("It was %u.", result[str(bid)])
raise RuntimeError("Error reading a placement: Error in JSON structure.")
raise RuntimeError("Error reading a placement.")
return result
def write_data(data):
fieldnames_temp = set()
output_file = open(args.output,'r')
reader = csv.DictReader(output_file, delimiter=',')
all_data = list(reader)
# Extract the fieldnames
if reader.fieldnames:
for name in reader.fieldnames:
if name != "date":
except IOError:"There was no existing data in the datafile.")
all_data = list()
# Do a union over all elements of the list.
fieldnames = ["date"]
fieldnames_temp |= set(data.keys())
# Insert the date as the first field.
data["date"] =
# Add this datapoint as new data.
output_file = open(args.output,'wb')
writer = csv.DictWriter(output_file, delimiter=',', fieldnames=fieldnames)
if __name__ == "__main__":
parser = argparse.ArgumentParser()
parser.add_argument('-u', '--username', help='Your username on', required=True)
parser.add_argument('-p', '--password', help='Your password on', required=True)
parser.add_argument('-o', '--output', help='The output file.', required=True)
parser.add_argument('-l', '--log', help='Set the log level to debug.', default='WARNING')
args = parser.parse_args()
numeric_level = getattr(logging, args.log.upper(), None)
if not isinstance(numeric_level, int):
raise ValueError('Invalid log level: %s' % args.log)
logging.basicConfig(format='%(levelname)s\t%(message)s', level=numeric_level)
print " venteliste extractor v.0.1\n"
client = FindBoligNuClient()
success = client.login(args.username, args.password)
if not success:
log.error("Couldn't login using the credentials provided.")
# Fetch bids for all buildings on the whishlist.
venteliste_bids = client.extract_waitinglist_references()
# Iterate the list of bids and return a dict of the placements.
venteliste_placements = client.extract_waitinglist_placements(venteliste_bids, 0)
# Append to the datafile.