def testLoginFailsWithInvalidPassword(self):
try:
conn = Connection(dbhost, dbname, dbuser, 'xxx', 3306, 60.0)
self.fail('expected ServerException')
except ServerException, ex:
log.debug('Exception = %s:%s' % (type(ex), ex))
self.assertTrue(str(ex).find('password'))
def __init__(self):
handlers = [(r'/', MainHandler), (r'/users/([^/]*)', UserHandler),
(r'/gacha/([^/]*)', GachaHandler),
(r'/avatar/([^/]*)', AvatarHandler),
(r'/ad/([^/]*)', AdHandler),
(r'/finance/([^/]*)', FinanceHandler),
(r'/guestmsg/([^/]*)', GuestmsgHandler),
(r'/activity/([^/]*)', ActivityHandler),
(r'/apl/([^/]*)', AplHandler),
(r'/activity_notice/([^/]*)', ActivityNoticeHandler),
(r'/pic/([^/]*)', PicHandler),
(r'/event/([^/]*)', EventHandler),
(r'/level/([^/]*)', LevelHandler),
(r'/mainten/([^/]*)', MaintenHandler),
(r'/playerids/([^/]*)', PlayerIDsHandler),
(r'/playerdatas/([^/]*)', PlayerDatasHandler),
(r'/playercommands/([^/]*)', PlayerCommandsHandler),
(r'/logout', LogoutHandler), (r'/login', LoginHandler)]
settings = dict(template_path=os.path.join(os.path.dirname(__file__),
"templates"),
static_path=os.path.join(os.path.dirname(__file__),
"static"),
xsrf_cookies=False,
cookie_secret="dsfc333cdddW!0de",
login_url="/login")
super(Application, self).__init__(handlers, **settings)
# Have one global connection to the blog DB across all handlers
self.db = Connection(host=options.mysql_host,
database=options.mysql_database,
user=options.mysql_user,
password=options.mysql_password)
self.maybe_create_tables()
def testLoginFailsWhenMySQLNotListeningOnPort(self):
try:
conn = Connection(dbhost, dbname, dbuser, dbpassword, 9999, 60.0)
fail('expected failure')
except socket.error, ex:
log.debug('Exception = %s:%s' % (type(ex), ex))
self.assertTrue(str(ex).find('refused'), 'Error msg didnt match')
def testLoginFailsWhenConnectingToNonExistantHostname(self):
try:
conn = Connection('1.1.1.1', dbname, dbuser, dbpassword, 3306, 1)
fail('expected ServerException')
except Exception, e:
#except socket.timeout, e:
errorMessage = str(e)
log.debug('Exception = %s:%s' % (type(e), errorMessage))
def testLoginFailsWithInvalidUser(self):
try:
conn = Connection(dbhost, dbname, 'xxx', dbpassword, 3306, 60.0)
fail('expected ServerException')
except ServerException, e:
errorMessage = str(e)
log.debug('Exception = %s:%s' % (type(e), errorMessage))
self.assertTrue(errorMessage.find('denied'))
self.assertTrue(errorMessage.find('user'))
def getConn(self):
__pool = self._pool
if __pool:
currConn = __pool.pop(0)
if currConn.testConn():
# 连接有效
# print('连接有效')
# 不作处理
pass
else:
print('连接无效')
currConn.reConn()
return currConn
else:
# 连接数不足则新增连接
conn = Connection.Connection()
self._pool.append(conn)
def ocr():
if request.method == 'POST':
HoldStatus("").writeFile("", "_serial")
HoldStatus("").writeFile("", "_lastScan")
HoldStatus("").writeFile("0", "_lastScanCount")
HoldStatus("").writeFile("2", "_scan")
HoldStatus("").writeFile("0", "_serialrowcount")
HoldStatus("").writeFile("0", "_serialpostCount")
HoldStatus("").writeFile("", "_goodData")
HoldStatus("").writeFile("0", "_processing")
dict = {}
for value in Connection().getModels(request.form['customer'],
request.form['model']):
mdict1 = {value[1]: value[2]}
dict.update(mdict1)
HoldStatus("").writeFile(json.dumps(dict), "_validation")
return App.render(render_template("ocr.html", user=session['user']))
def check_conn(self, transaction=False):
# if self._pool is not None:
# __conn = self._pool.getConn()
# else:
# __conn = self._db
# self._conn = __conn
# self._db = __conn.getConnect()
try:
if not self._db:
# 无连接,需要获取连接
# print('没有发现连接,尝试获取连接')
if self._poolFlag:
# 连接池
self._conn = self._pool.getConn()
self._db = self._conn.getConnect()
else:
# 单个连接理论上只执行一次,过后直接关闭
self._db = Connection()
except Exception as e:
print(e)
raise Exception('检查连接失败')
def testCloseSucceeds(self):
conn = Connection(dbhost, dbname, dbuser, dbpassword, 3306, 60.0)
conn.close()
self.assertFalse(conn.isConnected)
def model(m_id):
return jsonify(Connection().getModel(m_id)), 200
def testGetErrorMessageIsEmptyWhenNothingDone(self):
conn = Connection(dbhost, dbname, dbuser, dbpassword, 3306, 60.0)
errorMessage = conn.getErrorMsg()
self.assertEquals(0, len(errorMessage))
#!/usr/bin/env python
import sys
import datetime
from mysql import Connection
db = Connection(host="172.31.15.206:3306",
database="admin",
user="******",
password="******")
values = {}
datestr = sys.argv[1]
sql = "delete from Level where datestr='%s'" % (datestr)
db.execute(sql)
for l in sys.stdin:
try:
version, level, stats, count = l.strip().split('\t')
if stats == "ad":
sql = "INSERT INTO Ad SET ad_id='%s',ad_ui='%s', datestr='%s',count=%s ON DUPLICATE KEY UPDATE count=%s" % (
version, level, datestr, count, count)
db.execute(sql)
continue
if stats == "gacha":
sql = "INSERT INTO Gacha SET item_id='%s', datestr='%s',count=%s ON DUPLICATE KEY UPDATE count=%s" % (
version, datestr, count, count)
db.execute(sql)
continue
if stats == "fight_avatar":
sql = "INSERT INTO FightAvatar SET level=%s, avatar='%s', datestr='%s',count=%s ON DUPLICATE KEY UPDATE count=%s" % (
def models(customer_id):
responseBody = {"results": Connection().getModels(customer_id)}
return jsonify(responseBody), 200
def serial(m_id, s):
return jsonify(Connection().insertModel(m_id, s)), 200
def testSuccessiveCallsToCloseHaveNoAdverseEffects(self):
conn = Connection(dbhost, dbname, dbuser, dbpassword, 3306, 60.0)
conn.close()
conn.close()
conn.close()
self.assertFalse(conn.isConnected)
def testGetErrorCodeIsNoneWhenNothingDone(self):
conn = Connection(dbhost, dbname, dbuser, dbpassword, 3306, 60.0)
errorCode = conn.getErrorCode()
self.assertTrue(errorCode is None)
def testLoginPasses(self):
conn = Connection(dbhost, dbname, dbuser, dbpassword, 3306, 60.0)
self.assertTrue(conn, 'connection null')
conn.close()
def setUp(self):
self.host = dbhost
self.dbName = dbname
self.username = dbuser
self.password = dbpassword
self.conn = Connection(self.host, self.dbName, self.username, self.password, 3306, 10)
def customers():
responseBody = {"results": Connection().getCustomer()}
return jsonify(responseBody), 200
