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
