Abhishek Dubey dubeyji10

💭

Cogito, ergo sum

kuch bhi

dubeyji10 / threadAuthentication.py

Created May 27, 2022 12:51

threading the authentication part - auto generates access tokens by using refresh token ( modify it to 3000 seconds later )

	import threading
	import time
	import requests
	import json
	import pprint

	global accessToken
	url = "https://accounts.zoho.in/oauth/v2/token"
	payload = None

dubeyji10 / generatePayloads.py

Created May 28, 2022 10:32

generating records with a 15-10 minutes timestamp difference

	import mysql.connector
	from mysql.connector import Error
	from datetime import date, time, datetime ,timedelta
	import time


	'''

	for generating payloads - data to be inserted in APIs - with timestamps

dubeyji10 / generatePayloads_Timestamps.py

Last active May 28, 2022 13:49

generating leads within last 10 minutes

	import mysql.connector
	from mysql.connector import Error
	from datetime import date, time, datetime ,timedelta
	import time



	fileName = '2015-01-07'

	'''

dubeyji10 / python_mysql_connector.py

Created May 28, 2022 11:16

python mysql connection and extracting data from tables in the database

	from fileinput import filename
	import mysql.connector
	from mysql.connector import Error
	import json
	from datetime import date, time, datetime

	# created_at between '2011-03-17 06:42:10' and '2011-03-17 07:42:50';
	print("trying to connect to database")

	url = "https://www.zohoapis.in/crm/v2/Leads"

dubeyji10 / backup_leadsPayload.py

Last active May 30, 2022 05:32

backup - timed querying of leads

	import mysql.connector
	from mysql.connector import Error
	from datetime import date, time, datetime ,timedelta
	import time
	import logging
	import json
	import sys

	'''

dubeyji10 / testScript.py

Created May 30, 2022 07:59

auth refresh accessTokens call apis push data

	from cmath import log
	from urllib import response
	import mysql.connector
	from mysql.connector import Error
	from datetime import date, datetime ,timedelta
	import time
	import logging
	import json
	import requests
	import sys

dubeyji10 / laodAllModules.py

Created May 30, 2022 12:36

loading all modules data

	import mysql.connector
	from mysql.connector import Error

	import json
	from datetime import date, datetime ,timedelta
	import time

	# created_at between '2011-03-17 06:42:10' and '2011-03-17 07:42:50';
	print("trying to connect to database")

dubeyji10 / fetchesAllModules.py

Created May 31, 2022 05:19

fetches all moduel data in correct json Format

	from datetime import date, datetime ,timedelta
	from email.policy import default
	import sys
	import time
	import logging
	import mysql.connector
	from mysql.connector import Error
	import json
	import re

dubeyji10 / workingAllModules.py

Created May 31, 2022 09:54

working version

	from datetime import date, datetime ,timedelta
	from email.policy import default
	import sys
	import time
	import logging
	import mysql.connector
	from mysql.connector import Error
	import json
	import re
	from apiCall import pushInto

dubeyji10 / testConnection.py

Created June 1, 2022 06:20

instead of connection at top using with() since every cursor is a pointer

	from datetime import date, datetime ,timedelta
	from itertools import count
	import sys
	import time
	import logging
	import mysql.connector
	from mysql.connector import Error
	import json
	import re
	# from apiCall import pushInto