def db(request): db_config = load_config(request.config.getoption("--target"))["db"] dbfixture = DbFixture(host=db_config["host"], name=db_config["name"], user=db_config["user"], password=db_config["password"]) def fin(): dbfixture.destroy() request.addfinalizer(fin) return dbfixture
def db(request): db_config = load_config(pytest.config.getoption('--config'))['db'] dbfixture = DbFixture(host=db_config['host'], db=db_config['db'], user=db_config['user'], password=db_config['password']) def fin(): dbfixture.destroy() request.addfinalizer(fin) return dbfixture
def db(request): db_conf = load_config(request.config.getoption("--settings"))["db"] dbfixture = DbFixture(host=db_conf["host"], name=db_conf["name"], user=db_conf["username"], password=db_conf["password"]) def fin(): dbfixture.finish() request.addfinalizer(fin) return dbfixture
def db(request): db_config = load_config(request.config.getoption("--target"))['db'] dbfixture = DbFixture(host=db_config['host'], name=db_config['name'], user=db_config['user'], password=db_config['password']) def fin(): dbfixture.destroy() request.addfinalizer(fin) return dbfixture
def db(request ): # request содержит инфо об опциях переданны при запеске фреймворка db_config = load_config(request.config.getoption("--target"))['db'] dbfixture = DbFixture(host=db_config['host'], name=db_config['name'], user=db_config['user'], password=db_config['password']) def fin(): dbfixture.destroy() request.addfinalizer(fin) return dbfixture
def db(request): db_config = load_config(request.config.getoption('--target'))[ 'db'] # открыть конфиг из json, часть с db dbfixture = DbFixture(host=db_config['host'], name=db_config['name'], user=db_config['user'], password=db_config['password']) def final(): dbfixture.destroy() request.addfinalizer(final) return dbfixture
def db(request): db_config = load_config(request.config.getoption("--target"))['db'] db_fixture = DbFixture(host=db_config['host'], database=db_config['database'], user=db_config['user'], password=db_config['password']) def fin(): db_fixture.disconect() request.addfinalizer(fin) return db_fixture
def db(request, config): # db_config = config['db'] dbfixture = DbFixture( host=config['db']['host'], name=config['db']['name'], user=config['db']['user'], password=config['db']['password'], ) def fin(): dbfixture.destroy() request.addfinalizer(fin) return dbfixture
def db( request ): #Фикстура для взаимодействия с БД, request содержит инфу об опциях переданных при запуске фреймворка db_config = load_config(request.config.getoption("--target"))['db'] dbfixture = DbFixture(host=db_config['host'], name=db_config['name'], user=db_config['user'], password=db_config['password'] ) # инициализируем не соединение, а свой класс def fin(): # объявляем для него финализацию dbfixture.destroy() request.addfinalizer(fin) return dbfixture
def db(request): global dbfixture db_config = load_config(request.config.getoption("--target"))['db'] if dbfixture is None or not dbfixture.is_valid(): dbfixture = DbFixture(database=db_config['database'], user=db_config['user'], password=db_config['password'], host=db_config['host'], port=db_config['port']) def fin(): dbfixture.destroy() request.addfinalizer(fin) return dbfixture
def db(request): db_config = load_config(request.config.getoption('--target'))["db"] dbfixture = DbFixture(ssh=db_config["ssh"], ssh_host=db_config["ssh_host"], ssh_user=db_config["ssh_user"], ssh_password=db_config["ssh_password"], host=db_config["host"], database_name=db_config["database_name"], user=db_config["user"], password=db_config["password"], user_id=db_config["user_id"]) def fin(): dbfixture.destroy() request.addfinalizer(fin) return dbfixture
def db(request, config): db = DbFixture(host=config['db']['host'], name=config['db']['name'], user=config['db']['user'], password=config['db']['password']) return db
for row in cursor.fetchall(): print(row) finally: connection.close() """ json_config = None def load_config(file): global json_config if json_config is None: config_file_path = os.path.join( os.path.dirname(os.path.abspath(__file__)), file) with open(config_file_path) as config_file: json_config = json.load(config_file) return json_config db_config = load_config("config.json")["db"] dbfixture = DbFixture(host=db_config["host"], database=db_config["database"], user=db_config["user"], password=db_config["password"]) try: cursor = dbfixture.connection.cursor() cursor.execute("select * from group_list") for row in cursor.fetchall(): print(row) finally: dbfixture.connection.close()
#import mysql.connector import pymysql.cursors from fixture.db import DbFixture db = DbFixture(host="127.0.0.1", name="addressbook", user="******", password="") try: contacts = db.get_contact_list() for contact in contacts: print(contact) print(len(contacts)) finally: db.destroy()
def init_fixtures(self): self.fixture = Application(browser=self.browser, base_url=self.target['web']['baseUrl']) self.fixture.session.check_login(username=self.target['web']['username'], password=self.target['web']['password']) db_config = self.target['db'] self.dbfixture = DbFixture(host=db_config['host'], name=db_config['name'], user=db_config['user'], password=db_config['password'])
import random from fixture.db import DbFixture # from model.group import Group db = DbFixture(host="localhost", database="bugtracker", user="******", password="") try: # if len(db.get_group_list()) > 0: # group = random.choice(db.create_groupid_list()) # print("\n" + "-" * 10 + "Contacts" + "-" * 10) print("-" * 20) l = db.get_project_list() for item in l: print(item) print("-" * 20) print("Count projects: " + str(len(l)) + "\n") # print("*** Total contacts count: " + str(len(l)) + " ***" + "\n" + "\n" + "-" * 10 + "Groups" + "-" * 10) # l = db.get_group_list() # for item in l: # print(item) # print("*** Total groups count: " + str( # len(l)) + " ***" + "\n" + "\n" + "-" * 10 + "Contacts in group" + "-" * 10) # if len(db.get_group_list()) > 0: # l = db.get_contacts_in_group(Group(id=group)) # for item in l: # print(item) # print("*** Total contacts in group id " + group + " count: " + str(
''' db = ORMFixture(host='localhost', name='addressbook', user='******', password= '') try: l = db.get_contacts_in_group(Group(id = '151')) #l = db.get_contact_list() for item in l: print(item) print(len(l)) finally: pass #db.destroy() ''' #тянем запросами db = DbFixture(host='localhost', name='addressbook', user='******', password='') try: groups = db.get_group_id_list_with_contact('57') # contacts = db.get_contact_list() # for contact in contacts: # print(contact) # print(len(contacts)) # # contacts = db.get_contact_list_not_in_group() # for contact in contacts: # print(contact) # print(len(contacts)) # # contacts = db.get_contact_list_in_group() # for contact in contacts:
import pymysql.cursors from fixture.db import DbFixture connection = pymysql.connect(host="127.0.0.1", database="bugtracker", user="******", password="") try: cursor = connection.cursor() cursor.execute("select * from mantis_project_table") for row in cursor.fetchall(): print(row) finally: connection.close() db = DbFixture(host="127.0.0.1", database="bugtracker", user="******", password="") try: projects = db.get_projects_list() for project in projects: print(project) print(len(projects)) finally: db.destroy()
import pymysql.cursors from fixture.db import DbFixture #from fixture.orm import ORMFixture #from model.group import Group connection = pymysql.connect(host="127.0.0.1", database="bugtracker", user="******", password="") db = DbFixture(_host="127.0.0.1", _database="bugtracker", _user="******", _password="") try: list = db.get_project_list() for item in list: print(item) print(len(list)) finally: connection.close() #try: # cursor = connection.cursor() # cursor.execute("select * from group_list") # for row in cursor.fetchall(): #fetchall returns all info as list of rows(like in db) # print(row) #finally: # connection.close()
from fixture.db import DbFixture db = DbFixture(host='127.0.0.1', name='addressbook', user='******', password='') try: groups = db.get_group_list() for group in groups: print(group) print(len(groups)) finally: db.destroy() from fixture.db import DbFixture db = DbFixture(host='127.0.0.1', name='addressbook', user='******', password='') try: contacts = db.get_contact_list() for contact in contacts: print(contact) print(len(contacts)) finally: db.destroy()
def db(request): dbfixture = DbFixture(host='localhost', database='bugtracker', user='******', password='') def fin(): dbfixture.destroy() request.addfinalizer(fin) return dbfixture