从mysql数据库 加载所有用例和加载单条用例

# coding = utf-8
from util.db_util import MysqlDb # 导入数据库工具类

class XdclassTestCase:

    def loadAllCaseByApp(self, app):
        """
        根据app加载全部测试用例
        :param app:
        :return:
        """
        print("loadAllCaseByApp")
        my_db = MysqlDb()
        sql = "select * from `case` where app='{0}'".format(app)
        results = my_db.query(sql)
        return results


    def finCaseById(self, case_id):
        """
        根据id找测试用例
        :param case_id:
        :return:
        """
        print("finCaseById")
        my_db = MysqlDb()
        sql = "select * from `case` where id='{0}'".format(case_id)
        results = my_db.query(sql, state='one') # state 默认为all
        return results



if __name__ == '__main__':
    M = XdclassTestCase()
    # r = M.loadAllCaseByApp(app='小滴课堂')
    # print(r)
    r = M.finCaseById(case_id='10')
    print(r)