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