示例#1
0
 def add_timestamped_entry(self, worksheet_name):
     feed, worksheet_key = self.get_feed_for_worksheet(worksheet_name)
     main_entry = feed.entry[0]
     new_entry = ListEntry()
     new_entry.from_dict(main_entry.to_dict())
     new_entry.set_value('timestamp', format_date_for_gdata(datetime.datetime.utcnow()))
     self.spr_client.add_list_entry(new_entry, self.spreadsheet_key, worksheet_key)
示例#2
0
    def add_row(self, spreadsheet_key=None, worksheet_id=None, values={}):
        spreadsheet_key = spreadsheet_key or self.default_spreadsheet_key
        if spreadsheet_key is None:
            raise Exception('spreadsheet_key is not given')

        worksheet_id = worksheet_id or self.default_worksheet_id
        if worksheet_id is None:
            raise Exception('sheet_id is not given')

        if len(values) == 0:
            return

        list_entry = ListEntry()
        list_entry.from_dict(
            {key: _convert(value)
             for key, value in values.iteritems()})

        self.client.add_list_entry(list_entry, spreadsheet_key, worksheet_id)
示例#3
0
    def update_sheet(self, lpdata):
        feed, sheet_key = self.get_feed_for_worksheet('Raw data')
        seen_bugs = set()
        for row in feed.entry:
            d = row.to_dict()
            bug_id = d['id']

            seen_bugs.add(bug_id)
            if bug_id in lpdata and lpdata[bug_id] != d:
                print 'difference!'
                print 'row.to_dict: %r' % (d,)
                print 'lpdata[bug_id]: %r' % (lpdata[bug_id],)
                for key in lpdata[bug_id]:
                    row.set_value(key, lpdata[bug_id][key])
                self.spr_client.update(row)
        missing_bugs = set(lpdata.keys()) - seen_bugs
        for bug_id in missing_bugs:
            print 'Adding new bug: %s' % (bug_id,)
            row = ListEntry()
            for key in lpdata[bug_id]:
                row.set_value(key, lpdata[bug_id][key])
            self.spr_client.add_list_entry(row, self.spreadsheet_key, sheet_key)
示例#4
0
文件: sheets.py 项目: CTCL/EA-Tools
def writeRow(rowDict, client, sheetKey, sheetID='od6'):
    fixedRow = convertRow(rowDict)
    listEntry = ListEntry()
    listEntry.from_dict(fixedRow)
    client.add_list_entry(listEntry, sheetKey, sheetID)