| #/usr/bin/python3 | |
| from datetime import datetime | |
| import sys | |
| """ | |
| Pass the amount you've spent from the command line like this: | |
| $ python3 money-left.py 2000 |
| var _ = require('underscore'); | |
| function bootyService(booty) { | |
| return function() { | |
| if (booty.hadMeLike()) { | |
| throw new BootyError('Damn'); | |
| } | |
| func myMethod (myThing myType) (retVal string, val int) { | |
| val = 0 | |
| retVal = "Farhan" | |
| } | |
| func main() { |
| """ | |
| Set this to the current project you're working on. | |
| """ | |
| SOURCE = 'MLSListings_new' | |
| if SOURCE == 'GEPAR': | |
| PROJECT_ROOT = 'C:\\Users\\cmcfarland\\Dropbox\\Homesnap\\Projects\\GEPAR\\' | |
| sqlfile = PROJECT_ROOT + 'insert_template.sql' |
| def row_processor(row): | |
| if row['lookupColumn'] == 1: | |
| # add all 3 columns | |
| value = row['colA'] + row['colB'] + row['colC'] | |
| return value | |
| elif row['lookupColumn'] == 2: | |
| # add just 2 specific columns referenced by name | |
| value = row['colA'] + row['colB'] | |
| return value |
Here is some pdb debugger output from the surrounding code that leads to the IndexError. I put a debug statement in the grabMetadata() method of MLS_Data, and then stepped into the constructor of the table_instance class.
>>> ================================ RESTART ================================
>>>
What is the prefix for this MLS?XXX
couldnt find saved resource; looking elsewhere.
connecting
| def test_parse_activestatus(self): | |
| self.results = fetch_main_briefs() | |
| f = lambda x: x['brief_name'] == 'AAAA' | |
| aaaa = filter(f, self.results).pop() | |
| returned_status = parse_activestatus(aaaa['activestatus']) | |
| self.assertTrue(returned_status, msg="Should parse activestatus code to True.") |
| def fetch_main_briefs(): | |
| """Fetch list of dict result set from alchemy database""" | |
| q = session.query(BriefTable.briefid, | |
| BriefTable.brief_name, | |
| BriefTable.activestatus) | |
| q = q.filter(BriefTable.parentid == None) # todo abstract this out into a clauses list to prevent duplication | |
| q = q.filter(or_(BriefTable.briefName_alias == '', BriefTable.briefName_alias == None)) | |
| result_set = [result.__dict__ for result in q.all()] | |
| return result_set |
| class Query: | |
| def __init__(self, params={}): | |
| # make sure params is a dict | |
| if isinstance(params, unicode): | |
| self.params = dict(params) | |
| self.params = params | |
| # QUESTION assign defaults elsewhere? | |
| self.ids = params['ids'] if 'ids' in params else None | |
| self.dimensions = params['dimensions'] if 'dimensions' in params else None |
| # cd to a directory with a csv file in it. Any old csv file will do. | |
| # run ipython and type these things at the interactive prompt, line by line: | |
| >>> import pandas as pd | |
| >>> data = pd.read_csv('some_csv.csv') # other arguments to read_csv are available to change the separator char, for example | |
| >>> data | |
| >>> data.keys # access the keys property of the DataFrame object |