# -*- coding: utf-8 -*-
#!/usr/bin/python
# filename: login_admin.py
# codedtime: 2014-9-7 11:26:11

import bottle
import mysql.connector  # 導(dǎo)入mysql數(shù)據(jù)庫(kù)連接器

def check_userinfo():
  a_list = []  # 創(chuàng)建一個(gè)空列表
  username = bottle.request.GET.get('loginname','').strip() # 用戶(hù)名
  password = bottle.request.GET.get('password','').strip()  # 密碼
  if username is not None or password is not None:
    try:
      # 連接數(shù)據(jù)庫(kù) 
      conn = mysql.connector.connect(user='root', password='123456', database='myblog')   
      cursor = conn.cursor() # 創(chuàng)建數(shù)據(jù)游標(biāo)
      
      # 執(zhí)行查詢(xún)
      query = ("SELECT username, password FROM mb_users "
           "WHERE username=%s and password=%s")
      cursor.execute(query, (username, password))

      a_list = cursor.fetchall() # fetchone獲取一個(gè)元組
      #count = int(cursor.rowcount) # 獲取元組個(gè)數(shù) 
      return a_list

    except mysql.connector.Error as err:
      print("Something went wrong: {}".format(err))
      exit()
      
    finally:
      conn.commit() # 提交修改
      cursor.close() # 關(guān)閉數(shù)據(jù)庫(kù)
      conn.close()
  else:
    return a_list

def login_admin():
  if bottle.request.GET.get('bs-submit','').strip(): #點(diǎn)擊登錄按鈕
    a_list = check_userinfo()
    if a_list:
      a_name = a_list[0][0] # 獲得用戶(hù)名
      return bottle.template('templates/index_user.tpl', username = a_name)
    else:
      return bottle.template('templates/login_admin.tpl', action='/login_admin', 
              error_info='請(qǐng)輸入正確的用戶(hù)名或密碼！')
  else:
    return bottle.template('templates/login_admin.tpl', action='', error_info=' ')