def build_vars(mode):
''' build vars '''
sys.path.insert(0, '/mesonet/www/apps/iemwebsite/scripts/cscap')
import util
import ConfigParser
config = ConfigParser.ConfigParser()
config.read('/mesonet/www/apps/iemwebsite/scripts/cscap/mytokens.cfg')
spr_client = util.get_spreadsheet_client(config)
feed = spr_client.get_list_feed(config.get('cscap', 'sdckey'), 'od6')
places = 3 if mode != 'soil' else 4
prefix = 'AGR' if mode != 'soil' else 'SOIL'
for entry in feed.entry:
data = entry.to_dict()
if data['key'] is None or data['key'][:places] != prefix:
continue
varorder.append( data['key'].strip() )
varlookup[ data['key'].strip() ] = data['name'].strip()
def build_vars(mode):
''' build vars '''
sys.path.insert(0, '/mesonet/www/apps/iemwebsite/scripts/cscap')
import util
import ConfigParser
config = ConfigParser.ConfigParser()
config.read('/mesonet/www/apps/iemwebsite/scripts/cscap/mytokens.cfg')
spr_client = util.get_spreadsheet_client(config)
feed = spr_client.get_list_feed(config.get('cscap', 'sdckey'), 'od6')
places = 3 if mode != 'soil' else 4
prefix = 'AGR' if mode != 'soil' else 'SOIL'
for entry in feed.entry:
data = entry.to_dict()
if data['key'] is None or data['key'][:places] != prefix:
continue
varorder.append(data['key'].strip())
varlookup[data['key'].strip()] = data['name'].strip()
import ConfigParser
import util # @UnresolvedImport
import sys
config = ConfigParser.ConfigParser()
config.read('mytokens.cfg')
spr_client = util.get_spreadsheet_client(config)
drive = util.get_driveclient()
xref_plotids = util.get_xref_plotids(spr_client, config)
xref_feed = spr_client.get_list_feed(config.get('cscap', 'xrefrot'), 'od6')
rotations = {}
for entry in xref_feed.entry:
data = entry.to_dict()
rotations[data['code']] = data
# Build xref of cropmate with variables
cropmates = {}
xref_feed = spr_client.get_list_feed(config.get('cscap', 'xrefrotvars'), 'od6')
for entry in xref_feed.entry:
data = entry.to_dict()
res = cropmates.setdefault(data['cropmate'], [])
res.append(data['variable'].lower())
res = drive.files().list(q="title contains 'Agronomic Data'").execute()
for item in res['items']:
if item['mimeType'] != 'application/vnd.google-apps.spreadsheet':
continue
