def upload_main(argv):
if len(argv) != 2:
return __doc__
path = argv[1]
sheet = load_sheet(path)
try:
collection = hyou.login(json_path=CREDENTIAL_PATH)
except Exception:
return ('Your credential is missing, expired or invalid.'
'Please authenticate again by --authenticate.')
title = os.path.basename(path).decode('utf-8')
spreadsheet = collection.create_spreadsheet(title,
rows=len(sheet),
cols=len(sheet[0]))
with spreadsheet[0] as worksheet:
for srow, trow in zip(sheet, worksheet):
for i, value in enumerate(srow):
trow[i] = value
print spreadsheet.url
def upload(self, results):
collection = hyou.login(self._credential_path)
spreadsheet = collection[self._sheet_id]
sorted_results = sorted(results.values(),
key=lambda page: page['page_id'])
#self._upload_allocator_sizes(sorted_results, spreadsheet)
#self._upload_partitions(sorted_results, spreadsheet)
self._upload_partitions_allocated_sizes(sorted_results, spreadsheet)
#self._upload_partition_buffer_details(sorted_results, spreadsheet)
self._upload_partition_fast_malloc_details(sorted_results, spreadsheet)
def upload(self, results):
collection = hyou.login(self._credential_path)
spreadsheet = collection[self._sheet_id]
sorted_results = sorted(results.values(),
key=lambda page: page['page_id'])
#self._upload_allocator_sizes(sorted_results, spreadsheet)
#self._upload_partitions(sorted_results, spreadsheet)
self._upload_partitions_allocated_sizes(sorted_results, spreadsheet)
#self._upload_partition_buffer_details(sorted_results, spreadsheet)
self._upload_partition_fast_malloc_details(sorted_results, spreadsheet)
def main():
json_path = os.path.join(os.path.dirname(__file__), 'creds',
'unittest-sheets.json')
collection = hyou.login(json_path)
spreadsheet = collection['1hxNAHH-DUWgFcC603mFARGYOeKUwiRq56VsHOJSA5Z0']
print('Running tests with %s ...' % spreadsheet.url)
worksheet_title = 'sheet%08d' % random.randrange(100000000)
worksheet = spreadsheet.add_worksheet(worksheet_title, rows=20, cols=10)
print('Created %s' % worksheet_title)
try:
print('Testing...')
assert worksheet.title == worksheet_title
assert worksheet.rows == 20
assert worksheet.cols == 10
worksheet.rows = 15
assert worksheet.rows == 15
view = worksheet.view(start_row=2, end_row=4, start_col=3, end_col=6)
assert len(view) == 2
assert len(view[0]) == 3
view[0][0] = 'a'
view[0][1:] = ['b', 'c']
view[-1][:] = ['d', 'e', 'f']
view.commit()
assert view[1][1] == 'e'
worksheet.refresh()
assert worksheet[3][4] == 'e'
finally:
spreadsheet.delete_worksheet(worksheet_title)
print('Removed %s' % worksheet_title)
print('PASSED!')
def upload_main(argv):
if len(argv) != 2:
return __doc__
path = argv[1]
sheet = load_sheet(path)
try:
collection = hyou.login(json_path=CREDENTIAL_PATH)
except Exception:
return ('Your credential is missing, expired or invalid.'
'Please authenticate again by --authenticate.')
title = os.path.basename(path).decode('utf-8')
spreadsheet = collection.create_spreadsheet(
title, rows=len(sheet), cols=len(sheet[0]))
with spreadsheet[0] as worksheet:
for srow, trow in zip(sheet, worksheet):
for i, value in enumerate(srow):
trow[i] = value
print spreadsheet.url
def upload_main(argv):
if len(argv) != 3:
return __doc__
path, title = argv[1:]
title = title.decode('utf-8')
sheet = load_sheet(path)
try:
collection = hyou.login(json_path=CREDENTIAL_PATH)
except Exception:
return ('Your credential is missing, expired or invalid.'
'Please authenticate again by --authenticate.')
spreadsheet = collection.create_spreadsheet(
title, rows=len(sheet), cols=len(sheet[0]))
with spreadsheet[0] as worksheet:
for srow, trow in zip(sheet, worksheet):
for i, value in enumerate(srow):
trow[i] = value
print 'https://docs.google.com/spreadsheets/d/%s/edit' % spreadsheet.key
