Advertisement
Guest User

Untitled

a guest
Jun 28th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.89 KB | None | 0 0
  1. import gdata.docs
  2. import gdata.docs.service
  3. import gdata.spreadsheet.service
  4. import time
  5.  
  6. USERNAME = None
  7. PASSWORD = None
  8.  
  9. class_filename = 'classes.csv'
  10. field_filename = 'fields.csv'
  11. func_filename  = 'methods.csv'
  12.  
  13. def PrintFeed(feed):
  14.     if not feed.entry:
  15.         print '\n'
  16.     for entry in feed.entry:
  17.         print '%s %s %s' % (entry.title.text.encode('UTF-8'), entry.GetDocumentType(), entry.resourceId.text)
  18.        
  19. def get_from_google():
  20.  
  21.     gd_client = gdata.docs.service.DocsService(source='test-yourAppName-v1')
  22.  
  23.     gd_client.ClientLogin(USERNAME, PASSWORD)
  24.  
  25.     feed = gd_client.GetDocumentListFeed()
  26.     PrintFeed(feed)
  27.  
  28.     q = gdata.docs.service.DocumentQuery(categories=['spreadsheet'])
  29.     feed = gd_client.Query(q.ToUri())
  30.     PrintFeed(feed)
  31.  
  32.     entry = None
  33.     for i in feed.entry:
  34.         if i.resourceId.text == 'spreadsheet:0AgPl2O82XX1pdFp2SnQxZUNuVWVJeHl0eGRSdnRDNGc':
  35.             entry = i
  36.  
  37.     #entry = feed.entry[0]
  38.  
  39.     spreadsheets_client = gdata.spreadsheet.service.SpreadsheetsService()
  40.     spreadsheets_client.ClientLogin(USERNAME, PASSWORD)
  41.  
  42.     # substitute the spreadsheets token into our gd_client
  43.     docs_auth_token = gd_client.GetClientLoginToken()
  44.     gd_client.SetClientLoginToken(spreadsheets_client.GetClientLoginToken())
  45.  
  46.     print 'Downloading Classes spreadsheet to %s...' % (class_filename,)
  47.     gd_client.Export(entry, class_filename, gid=12)
  48.  
  49.     print 'Downloading Fields spreadsheet to %s...' % (field_filename,)
  50.     gd_client.Export(entry, field_filename, gid=2)
  51.  
  52.     print 'Downloading Methods spreadsheet to %s...' % (func_filename,)
  53. #    gd_client.Export(entry, func_filename, gid=1)
  54.     gd_client.Export(entry, func_filename, gid=8)
  55.  
  56.     gd_client.SetClientLoginToken(docs_auth_token) # reset the DocList auth token
  57.  
  58. def main(timer):
  59.    
  60.     while(True):
  61.         get_from_google()
  62.         time.sleep(60*timer)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement