5. Pytest Historic Tables - adiralashiva8/pytest-historic GitHub Wiki

Pytest-Historic consist of following Database & Tables

---

Default Database & Table

Database		
	pytesthistoric	
		
Table		
	TB_PROJECT	
		
Columns		
	Project_Id	INT NOT NULL auto_increment primary key
	Project_Name	TEXT
	Project_Desc	TEXT
	Project_Image	TEXT
	Created_Date	DATETIME
	Last_Updated	DATETIME
	Total_Executions	INT
	Recent_Pass_Perc	FLOAT
        Overall_Pass_Perc    FLOAT

Project Database & Table

• When new project is created new database is created and database info is stored in pytesthistoric.tb_project table.
• Following tables will be created in newly added database (project)

Database

Database		
	Project-Name

Execution

Table		
	TB_EXECUTION	
		
Columns		
	Execution_Id	INT NOT NULL auto_increment primary key
	Execution_Date	DATETIME
	Execution_Desc	TEXT
	Execution_Executed  INT
	Execution_Pass	INT
	Execution_Fail	INT
	Execution_Skip	INT
	Execution_xPass	INT
	Execution_xFail	INT
	Execution_Error	INT
	Execution_Time	FLOAT

Suite

Table		
	TB_SUITE	
		
Columns		
	Suite_Id	INT NOT NULL auto_increment primary key
	Execution_Id	INT
	Suite_Name	TEXT
	Suite_Executed	INT
	Suite_Pass	INT
	Suite_Fail	INT
	Suite_Skip	INT
	Suite_xPass	INT
	Suite_xFail	INT
	Suite_Error	INT

Test

Table		
	TB_TEST	
		
Columns		
	Test_Id	INT NOT NULL auto_increment primary key
	Execution_Id	INT
	Test_Name	TEXT
	Test_Status	CHAR(5)
	Test_Time	FLOAT
	Test_Error	TEXT
	Test_Comment	TEXT