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
