python sql模板_GitHub - dushitaoyuan/py_mybatis: python mybatis 实现,python SqlTemplate

from py_mybatis.sql.mybatis_sql_session import MybatisMapperScanner, MybatisSqlSession, PooledDB

import pymysql

import os

import unittest

import time

class PyMybatisTest(unittest.TestCase):

@classmethod

def setUpClass(cls):

path = os.path.abspath("./")

mapper_scanner = MybatisMapperScanner()

mybatis_mapper_dict = mapper_scanner.mapper_xml_scan(mapper_xml_dir=path)

pool = PooledDB(

creator=pymysql,

maxconnections=6,

mincached=2,

maxcached=5,

blocking=True,

maxusage=None,

setsession=[],

ping=0,

host="localhost",

user="root",

password="root",

database="api_user",

cursorclass=pymysql.cursors.DictCursor,

charset='utf8'

)

cls.sql_session = MybatisSqlSession(mapper_dict=mybatis_mapper_dict, dataSource=pool)

cls.sql_namespace = 'Test.'

def test_base(self):

self.sql_id = self.sql_namespace + 'testBasic'

print("============{}============,sql_result:{}".format(self.sql_id, self.sql_session.select_list(self.sql_id)))

def test_parameters(self):

self.sql_id = self.sql_namespace + 'testParameters'

params = {'category': 'apple', 'price': '15.0', 'type': '001', 'content': '图书'}

print("============{}============,sql_result:{}".format(self.sql_id, self.sql_session.select_list(self.sql_id,

params=params)))

def test_include(self):

s