Python set_debug_mode示例

示例#1

import py2neo
import pymysql

cnx = pymysql.connect(host='localhost',
                      user='******',
                      password='******',
                      db='lahman2017',
                      charset='utf8mb4',
                      cursorclass=pymysql.cursors.DictCursor)

fg = fct.FanGraph(auth=('neo4j', 'password'),
                  host="localhost",
                  port=7687,
                  secure=False)

ut.set_debug_mode(True)


def load_players():

    q = "SELECT playerID, nameLast, nameFirst FROM People where " + \
        "exists (select * from appearances where appearances.playerID = people.playerID and yearID >= 2017)"

    curs = cnx.cursor()
    curs.execute(q)

    r = curs.fetchone()
    cnt = 0
    while r is not None:
        print(r)
        cnt += 1

示例#2

from dbservice import dataservice
import utils.utils as ut
import json

ut.set_debug_mode(False)
dataservice.set_config()


def test_get_resource():
    template = {"nameLast": "Williams", "nameFirst": "Ted"}

    fields = ['playerID', 'nameFirst', 'bats', 'birthCity']

    result = dataservice.retrieve_by_template("people", template, fields)
    print("Result = ", json.dumps(result, indent=2))


def test_cache1():
    # first miss then hit
    template = {"nameLast": "Williams", "nameFirst": "Ted"}
    fields = ['playerID', 'nameFirst', 'birthCity']

    result = dataservice.retrieve_by_template("people", template, fields)
    print("Result = ", json.dumps(result, indent=2))
    result = dataservice.retrieve_by_template("people", template, fields)
    print("Result = ", json.dumps(result, indent=2))


def test_cache2():
    # cache miss
    template = {"nameLast": "Williams", "nameFirst": "Ted"}