def GitHub_Login_Page_State(code,
GITHUB_APP_ID,
GITHUB_APP_KEY,
GITHUB_REDIRECT_URI,
timeout=5,
verify=False):
''' Authorization Code cannot repeat '''
Access_Token_Url = Splice(scheme="https",
domain="github.com",
path="/login/oauth/access_token",
query={
"client_id": GITHUB_APP_ID,
"client_secret": GITHUB_APP_KEY,
"code": code,
"redirect_uri": GITHUB_REDIRECT_URI
}).geturl
data = requests.post(Access_Token_Url, timeout=timeout, verify=verify).text
data = Parse_Access_Token(data)
if "access_token" in data:
access_token = data.get("access_token")
User_Info_Url = Splice(scheme="https",
domain="api.github.com",
path="/user",
query={
"access_token": access_token
}).geturl
data = requests.get(User_Info_Url, timeout=timeout,
verify=verify).json()
username = "******" + data.get("login")
user_id = data.get("id")
user_github = data.get("html_url")
user_cname = data.get("name")
user_avater = data.get("avatar_url")
user_email = data.get("email")
user_extra = "blog:%s, company:%s, location:%s" % (
data.get("blog"), data.get("company"), data.get("location"))
try:
UserSQL = "INSERT INTO User (username, cname, email, avatar, time, github, extra) VALUES (%s, %s, %s, %s, %s, %s, %s)"
mysql.insert(UserSQL, username, user_cname, user_email,
user_avater, How_Much_Time(), user_github, user_extra)
OAuthSQL = "INSERT INTO OAuth (oauth_username, oauth_type, oauth_openid, oauth_access_token, oauth_expires) VALUES (%s, %s, %s, %s, %s)"
mysql.insert(OAuthSQL, username, "GitHub", user_id, access_token,
How_Much_Time())
except IntegrityError, e:
logger.debug(e, exc_info=True)
#Check if it has been registered
CheckSQL = "SELECT oauth_username FROM OAuth WHERE oauth_username=%s"
if mysql.get(CheckSQL, username):
UpdateSQL = "UPDATE OAuth SET oauth_access_token=%s, oauth_expires=%s, oauth_openid=%s WHERE oauth_username=%s"
mysql.update(UpdateSQL, access_token, How_Much_Time(), user_id,
username)
#update user profile
UpdateUserSQL = "UPDATE User SET cname=%s, avatar=%s, extra=%s WHERE username=%s"
mysql.update(UpdateUserSQL, user_cname, user_avater,
user_extra, username)
return {"username": username, "uid": user_id}
except Exception, e:
logger.error(e, exc_info=True)
return False
def uc():
if g.signin:
#return redirect("https://www.saintic.com/home/")
sql = "SELECT cname, email, avatar, motto, weibo, github, url, time, gender, extra FROM User WHERE username=%s"
data = mysql.get(sql, g.username)
return render_template("home.html", data=data)
else:
return redirect(url_for("login"))
def UserAuth_Login(username, password):
sql = " SELECT lauth_username, lauth_password FROM user_lauth WHERE lauth_username=%s"
data= mysql.get(sql, username)
logger.debug("mysql data is %s, request %s:%s" %(data, username, md5(password)))
if data and username == data.get("lauth_username") and md5(password) == data.get("lauth_password"):
logger.info("%s Sign in successfully" %username)
return True
else:
logger.info("%s Sign in failed" %username)
return False
def Weibo_Login_Page_State(code,
WEIBO_APP_ID,
WEIBO_APP_KEY,
WEIBO_REDIRECT_URI,
timeout=5,
verify=False):
''' Authorization Code cannot repeat '''
Access_Token_Url = Splice(scheme="https",
domain="api.weibo.com",
path="/oauth2/access_token",
query={
"grant_type": "authorization_code",
"client_id": WEIBO_APP_ID,
"client_secret": WEIBO_APP_KEY,
"code": code,
"redirect_uri": WEIBO_REDIRECT_URI
}).geturl
data = requests.post(Access_Token_Url, timeout=timeout,
verify=verify).json()
if "access_token" in data:
access_token = data.get("access_token")
expires_in = data.get("expires_in")
uid = requests.get(
"https://api.weibo.com/2/account/get_uid.json?access_token=%s" %
access_token,
timeout=timeout,
verify=verify).json().get("uid", data.get("uid"))
User_Info_Url = Splice(scheme="https",
domain="api.weibo.com",
path="/2/users/show.json",
query={
"access_token": access_token,
"uid": uid
}).geturl
data = requests.get(User_Info_Url, timeout=timeout,
verify=verify).json()
logger.debug(data)
username = "******" + access_token[4:13]
user_cname = data.get("screen_name")
user_avater = data.get("profile_image_url")
user_weibo = "http://weibo.com/" + data.get("profile_url")
user_extra = data.get("description")
user_gender = u"男" if data.get("gender") == "m" else u"女"
try:
UserSQL = "INSERT INTO User (username, cname, avatar, time, weibo, gender, extra) VALUES (%s, %s, %s, %s, %s, %s, %s)"
mysql.insert(UserSQL, username, user_cname, user_avater,
How_Much_Time(), user_weibo, user_gender, user_extra)
OAuthSQL = "INSERT INTO OAuth (oauth_username, oauth_type, oauth_openid, oauth_access_token, oauth_expires) VALUES (%s, %s, %s, %s, %s)"
mysql.insert(OAuthSQL, username, "Weibo", uid, access_token,
How_Much_Time(seconds=int(expires_in)))
except IntegrityError, e:
logger.debug(e, exc_info=True)
#Check if it has been registered
CheckSQL = "SELECT oauth_username FROM OAuth WHERE oauth_username=%s"
if mysql.get(CheckSQL, username):
UpdateSQL = "UPDATE OAuth SET oauth_access_token=%s, oauth_expires=%s, oauth_openid=%s WHERE oauth_username=%s"
mysql.update(UpdateSQL, access_token,
How_Much_Time(seconds=int(expires_in)), uid,
username)
#update user profile
UpdateUserSQL = "UPDATE User SET cname=%s, avatar=%s, weibo=%s, gender=%s, extra=%s WHERE username=%s"
mysql.update(UpdateUserSQL, user_cname, user_avater,
user_weibo, user_gender, user_extra, username)
return {
"username": username,
"expires_in": expires_in,
"uid": uid
}
except Exception, e:
logger.error(e, exc_info=True)
return False
UserQzoneInfo.get("city"))
logger.info(UserQzoneInfo)
try:
UserSQL = "INSERT INTO User (username, cname, avatar, time, gender, extra) VALUES (%s, %s, %s, %s, %s, %s)"
mysql.insert(UserSQL, username, UserQzoneInfo.get("nickname"),
UserQzoneInfo.get("figureurl_qq_1"),
How_Much_Time(), UserQzoneInfo.get("gender"),
user_extra)
OAuthSQL = "INSERT INTO OAuth (oauth_username, oauth_type, oauth_openid, oauth_access_token, oauth_expires) VALUES (%s, %s, %s, %s, %s)"
mysql.insert(OAuthSQL, username, "QQ", openid, access_token,
How_Much_Time(seconds=int(expires_in)))
except IntegrityError, e:
logger.debug(e, exc_info=True)
#Check if it has been registered
CheckSQL = "SELECT oauth_username FROM OAuth WHERE oauth_username=%s"
if mysql.get(CheckSQL, username):
UpdateSQL = "UPDATE OAuth SET oauth_access_token=%s, oauth_expires=%s WHERE oauth_username=%s"
mysql.update(UpdateSQL, access_token,
How_Much_Time(seconds=int(expires_in)),
username)
#update user profile
UpdateUserSQL = "UPDATE User SET cname=%s,gender=%s,extra=%s WHERE username=%s"
mysql.update(UpdateUserSQL, UserQzoneInfo.get("nickname"),
UserQzoneInfo.get("gender"), user_extra,
username)
return {
"username": username,
"expires_in": expires_in,
"openid": openid
}
except Exception, e:
def OSChina_Login_Page_State(code,
OSCHINA_APP_ID,
OSCHINA_APP_KEY,
OSCHINA_REDIRECT_URI,
timeout=5,
verify=False):
''' Authorization Code cannot repeat '''
Access_Token_Url = Splice(scheme="https",
netloc="www.oschina.net",
path="/action/openapi/token",
query={
"grant_type": "authorization_code",
"client_id": OSCHINA_APP_ID,
"client_secret": OSCHINA_APP_KEY,
"code": code,
"redirect_uri": OSCHINA_REDIRECT_URI
}).geturl
data = requests.post(Access_Token_Url,
timeout=timeout,
verify=verify,
headers=headers).json()
if "access_token" in data:
access_token = data.get("access_token")
refresh_token = data.get("refresh_token")
expires_in = data.get("expires_in")
uid = data.get("uid")
User_Info_Url = Splice(scheme="https",
netloc="www.oschina.net/",
path="/action/openapi/user",
query={
"access_token": access_token
}).geturl
data = requests.get(User_Info_Url,
timeout=timeout,
verify=verify,
headers=headers).json()
logger.debug(data)
username = "******" + access_token[4:13]
user_cname = data.get("name")
user_avater = data.get("avatar")
user_extra = data.get("location")
user_gender = u"男" if data.get("gender") == "male" else u"女"
user_url = data.get("url")
try:
UserSQL = "INSERT INTO user_profile (username, cname, avatar, time, url, gender, extra) VALUES (%s, %s, %s, %s, %s, %s, %s)"
mysql.insert(UserSQL, username, user_cname, user_avater,
How_Much_Time(), user_url, user_gender, user_extra)
OAuthSQL = "INSERT INTO user_oauth (oauth_username, oauth_type, oauth_openid, oauth_access_token, oauth_expires) VALUES (%s, %s, %s, %s, %s)"
mysql.insert(OAuthSQL, username, "OSChina", uid, access_token,
How_Much_Time(seconds=int(expires_in)))
except IntegrityError, e:
logger.debug(e, exc_info=True)
#Check if it has been registered
CheckSQL = "SELECT oauth_username FROM user_oauth WHERE oauth_username=%s"
if mysql.get(CheckSQL, username):
UpdateSQL = "UPDATE user_oauth SET oauth_access_token=%s, oauth_expires=%s, oauth_openid=%s WHERE oauth_username=%s"
mysql.update(UpdateSQL, access_token,
How_Much_Time(seconds=int(expires_in)), uid,
username)
#update user profile
UpdateUserSQL = "UPDATE user_profile SET cname=%s, url=%s, gender=%s, extra=%s WHERE username=%s"
mysql.update(UpdateUserSQL, user_cname, user_url, user_gender,
user_extra, username)
return {
"username": username,
"expires_in": expires_in,
"uid": uid
}
except Exception, e:
logger.error(e, exc_info=True)
return False
def Instagram_Login_Page_State(code,
INSTAGRAM_APP_ID,
INSTAGRAM_APP_KEY,
INSTAGRAM_REDIRECT_URI,
timeout=5,
verify=False):
''' Authorization Code cannot repeat '''
proxies = {
"http": "http://ip:port",
"https": "http://ip:port",
}
Access_Token_Url = Splice(scheme="https",
netloc="api.instagram.com",
path="/oauth/access_token",
query={
"client_id": INSTAGRAM_APP_ID,
"client_secret": INSTAGRAM_APP_KEY,
"code": code,
"redirect_uri": INSTAGRAM_REDIRECT_URI,
"grant_type": "authorization_code"
}).geturl
logger.debug(Access_Token_Url)
data = requests.post(Access_Token_Url,
timeout=timeout,
verify=verify,
proxies=proxies).json()
if "access_token" in data:
access_token = data.get("access_token")
data = requests.get(User_Info_Url,
timeout=timeout,
verify=verify,
proxies=proxies).json()
User_Info_Url = Splice(scheme="https",
netloc="api.instagram.com",
path="/v1/users/self/",
query={
"access_token": access_token
}).geturl
data = requests.get(User_Info_Url,
timeout=timeout,
verify=verify,
proxies=proxies).json()
username = "******" + data.get("username")
user_id = data.get("id")
user_cname = data.get("full_name")
user_avater = data.get("profile_picture")
user_url = data.get("website")
user_motto = data.get("bio")
user_extra = data.get("counts")
try:
UserSQL = "INSERT INTO user_profile (username, cname, motto, avatar, time, url, extra) VALUES (%s, %s, %s, %s, %s, %s, %s)"
mysql.insert(UserSQL, username, user_cname, user_motto,
user_avater, How_Much_Time(), user_url, user_extra)
OAuthSQL = "INSERT INTO user_oauth (oauth_username, oauth_type, oauth_openid, oauth_access_token, oauth_expires) VALUES (%s, %s, %s, %s, %s)"
mysql.insert(OAuthSQL, username, "Instagram", user_id,
access_token, How_Much_Time())
except IntegrityError, e:
logger.debug(e, exc_info=True)
#Check if it has been registered
CheckSQL = "SELECT oauth_username FROM user_oauth WHERE oauth_username=%s"
if mysql.get(CheckSQL, username):
UpdateSQL = "UPDATE user_oauth SET oauth_access_token=%s, oauth_expires=%s, oauth_openid=%s WHERE oauth_username=%s"
mysql.update(UpdateSQL, access_token, How_Much_Time(), user_id,
username)
#update user profile
UpdateUserSQL = "UPDATE user_profile SET cname=%s, url=%s, motto=%s, extra=%s WHERE username=%s"
mysql.update(UpdateUserSQL, user_cname, user_url, user_motto,
user_extra, username)
return {"username": username, "uid": user_id}
except Exception, e:
logger.error(e, exc_info=True)
return False