In [1]:
# automatically reload imports when their files have changed

%load_ext autoreload
%autoreload 2017-07-11-170223.term

In [2]:
import sys

#adds folder to the search path for 'import'
sys.path.append('../python-files')

In [3]:
import db

tree = db.getpasses('allpasses.db', gs='KB9JHU')
print(len(tree))

# '%' character in SQL means 'any 0 or more characters'
# lazy way instead of using the exact full string
tree = db.getpasses('allpasses.db', gs='KB9JHU', sat='%AO-7%')
print(len(tree))


96441
3246

In [0]: