def sync_google_event(_type='Post'): page_token = None credentials_json= webnotes.conn.sql(""" select credentails from tabProfile where name ='%s'"""%(webnotes.session.user), as_list=1) service = create_service(credentials_json[0][0]) while True: events = service.events().list(calendarId='primary', pageToken=page_token).execute() for event in events['items']: eventlist=webnotes.conn.sql("select event_id from `tabEvent`", as_list=1) s= webnotes.conn.sql("select modified from `tabEvent` where event_id= %s ",(event['id']) , as_list=1) a=[] a.append(event['id']) m=[] m.append(event['updated']) if a not in eventlist: webnotes.errprint("created vent") d = Document("Event") d.event_id=event['id'] d.subject=event['summary'] d.starts_on=event['start']['dateTime'] d.ends_on=event['end']['dateTime'] d.save() webnotes.errprint(d.name) elif m > s: r=webnotes.conn.sql("update `tabEvent` set starts_on=%s, ends_on=%s,subject=%s where event_id=%s",(event['start']['dateTime'],event['end']['dateTime'],event['summary'],event['id'])) webnotes.errprint(event['id']) else: pass page_token = events.get('nextPageToken') if not page_tok: break
def sync_google_event(_type='Post'): #webnotes.errprint("google sync") page_token = None credentials_json= webnotes.conn.sql(""" select credentails from tabProfile where name ='*****@*****.**'""", as_list=1) #webnotes.errprint(credentials_json) service = create_service(credentials_json[0][0]) #ebnotes.errprint("service created") while True: events = service.events().list(calendarId='primary', pageToken=page_token).execute() #webnotes.errprint(events) for event in events['items']: #ebnotes.errprint("----google events---") #ebnotes.errprint(event) eventlist=webnotes.conn.sql("select event_id from `tabEvent`", as_list=1) #ebnotes.errprint("--eventist --") #ebnotes.errprint(eventlist) s= webnotes.conn.sql("select modified from `tabEvent` where event_id= %s ",(event['id']) , as_list=1) a=[] a.append(event['id']) m=[] m.append(event['updated']) #webnotes.errprint(a) #webnotes.errprint(m) from webnotes.model.doc import Document #webnotes.errprint("-----eventdatime----") #webnotes.errprint(event['start']) if a not in eventlist: #webnotes.errprint("good") d = Document("Event") d.event_id=event['id'] d.subject=event['summary'] d.starts_on=event['start']['dateTime'] d.ends_on=event['end']['dateTime'] d.save(new=1) #webnotes.errprint(event['summary']) elif m > s: #webnotes.errprint("elif") r=webnotes.conn.sql("update `tabEvent` set starts_on=%s, ends_on=%s,subject=%s where event_id=%s",(event['start']['dateTime'],event['end']['dateTime'],event['summary'],event['id']),debug=1) #webnotes.errprint("Event Updated...") #webnotes.errprint(event['summary']) #else: #webnotes.errprint("else") page_token = events.get('nextPageToken') if not page_token: break