public Period loadFurtherData()
{
var Period = new Period();
//var bptProjectsActiveNames = new List<String>();
var bptProjectsActive = this.GetActive();
foreach (var bptProject in bptProjectsActive)
{
var period = new Period();
var sqlMaker = new SqlMakerFurther(this.SqlMakerProjects.bptConnection, this.SqlMakerProjects.Connection, this.SqlMakerProjects.typeUpdate, bptProject);
bptProject.LoadDataTests(sqlMaker);
bptProject.LoadDataTestsConfigs(sqlMaker);
bptProject.LoadDataTestCycle(sqlMaker);
bptProject.LoadDataRuns(sqlMaker);
bptProject.LoadDataSteps(sqlMaker);
bptProject.LoadDataTestsCriteria(sqlMaker);
bptProject.LoadDataComponents(sqlMaker);
bptProject.LoadDataComponentsSteps(sqlMaker);
bptProject.LoadDataDesSteps(sqlMaker);
bptProject.LoadDataRunsCriteria(sqlMaker);
bptProject.LoadDataTestsToComponents(sqlMaker);
bptProject.LoadDataBugs(sqlMaker);
bptProject.LoadDataIteration(sqlMaker);
bptProject.LoadDataIterParam(sqlMaker);
bptProject.LoadDataParam(sqlMaker);
bptProject.LoadDataFrameworkParam(sqlMaker);
bptProject.LoadDataAssetRelations(sqlMaker);
bptProject.LoadDataResources(sqlMaker);
period.End = DateTime.Now;
var Tempo = (int)period.End.Subtract(period.Start).Seconds;
//string Nome_Projeto_BITI = Conn_SGQ.Get_String(string.Format("select Nome from biti_subprojetos where id = '{0}'", item.Subprojeto));
//projectsNames.Add(Tempo.ToString().PadLeft(4, '0') + " seg, " + item.Nome + " - " + Nome_Projeto_BITI);
}
//Conn_SGQ.Dispose();
//DateTime Dt_Fim_Geral = DateTime.Now;
//if (Projetos.Count > 0)
//{
// Gerais.Enviar_Email_Atualizacao_Projetos(
// Assunto: string.Format("SGQ-ALMA: Atualizou projetos - Tipo Atualização: INCREMENTAL"),
// projectList: List_Nome_Projetos,
// Dt_Inicio: Dt_Inicio_Geral,
// Dt_Fim: Dt_Fim_Geral
// );
//}
Period.End = DateTime.Now;
return(Period);
}
public BptTestsCriteria(SqlMakerFurther sqlMaker)
{
if (sqlMaker != null)
{
this.SqlMaker = sqlMaker;
}
else
{
throw new ArgumentNullException("sqlMaker", "O parâmetro 'sqlMaker' não pode ser null");
}
this.SqlMaker.dataSource = $"{SqlMaker.BptProject.Esquema}.test_criteria";
this.SqlMaker.dataSourceFieldId = "tcr_id";
this.SqlMaker.dataSourceFieldDateUpdade = "";
this.SqlMaker.dataSourceCondition =
$@"exists(select distinct 1
from {SqlMaker.BptProject.Esquema}.testcycl tc
where tc.tc_test_id = tcr_test_id)";
this.SqlMaker.TargetTable = "BPT_Tests_Criteria";
this.SqlMaker.fields = new List <Field>();
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Subprojeto", source = $"'{SqlMaker.BptProject.Subprojeto}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Entrega", source = $"'{SqlMaker.BptProject.Entrega}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "N", target = "Id", source = "tcr_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Nome", source = "upper(tcr_name)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Test_Id", source = "tcr_test_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Status", source = "upper(tcr_execution_status)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Main", source = "tcr_is_main_criterion"
});
this.SqlMaker.fields.Add(new Field()
{
target = "Dt_Criacao", source = "to_char(tcr_creation_Date,'dd-mm-yy')"
});
}
public BptTestsConfigs(SqlMakerFurther sqlMaker)
{
if (sqlMaker != null)
{
this.SqlMaker = sqlMaker;
}
else
{
throw new ArgumentNullException("sqlMaker", "O parâmetro 'sqlMaker' não pode ser null");
}
this.SqlMaker.dataSource = $"{SqlMaker.BptProject.Esquema}.test_configs";
this.SqlMaker.dataSourceFieldId = "tsc_id";
this.SqlMaker.dataSourceFieldDateUpdade = "tsc_vts";
this.SqlMaker.dataSourceCondition =
$@"exists(select distinct 1
from {SqlMaker.BptProject.Esquema}.testcycl tc
where tc.tc_test_id = tsc_test_id)";
this.SqlMaker.TargetTable = "BPT_Tests_Configs";
this.SqlMaker.fields = new List <Field>();
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Subprojeto", source = $"'{SqlMaker.BptProject.Subprojeto}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Entrega", source = $"'{SqlMaker.BptProject.Entrega}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "N", target = "Id", source = "tsc_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Nome", source = "upper(tsc_name)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Test_Id", source = "tsc_test_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Status_Execucao", source = "upper(tsc_exec_status)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Criacao", source = "to_char(tsc_creation_date,'dd-mm-yy')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Alteracao", source = "substr(tsc_vts,9,2) || '-' || substr(tsc_vts,6,2) || '-' || substr(tsc_vts,3,2) || ' ' || substr(tsc_vts,12,8)"
});
}
public BptRunsCriteria(SqlMakerFurther sqlMaker)
{
if (sqlMaker != null)
{
this.SqlMaker = sqlMaker;
}
else
{
throw new ArgumentNullException("sqlMaker", "O parâmetro 'sqlMaker' não pode ser null");
}
this.SqlMaker.dataSource = $"{SqlMaker.BptProject.Esquema}.run_criteria";
this.SqlMaker.dataSourceFieldId = "rcr_id";
this.SqlMaker.dataSourceFieldDateUpdade = "";
this.SqlMaker.dataSourceCondition = "";
this.SqlMaker.TargetTable = "BPT_Runs_Criteria";
this.SqlMaker.fields = new List <Field>();
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Subprojeto", source = $"'{SqlMaker.BptProject.Subprojeto}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Entrega", source = $"'{SqlMaker.BptProject.Entrega}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "N", target = "Id", source = "rcr_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Nome", source = "upper(replace(rcr_name,'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Run_Id", source = "rcr_run_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Test_Criteria_Id", source = "rcr_criterion_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Test_Config_Id", source = "rcr_configuration_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Status_Execucao", source = "upper(rcr_status)"
});
}
public BptParam(SqlMakerFurther sqlMaker)
{
if (sqlMaker != null)
{
this.SqlMaker = sqlMaker;
}
else
{
throw new ArgumentNullException("sqlMaker", "O parâmetro 'sqlMaker' não pode ser null");
}
this.SqlMaker.dataSource = $"{SqlMaker.BptProject.Esquema}.bp_param ";
this.SqlMaker.dataSourceFieldId = "bpp_id";
this.SqlMaker.dataSourceFieldDateUpdade = "";
this.SqlMaker.dataSourceCondition = "";
this.SqlMaker.TargetTable = "BPT_Param";
this.SqlMaker.fields = new List <Field>();
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Subprojeto", source = $"'{SqlMaker.BptProject.Subprojeto}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Entrega", source = $"'{SqlMaker.BptProject.Entrega}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "N", target = "Id", source = "bpp_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "BPC_Id", source = "bpp_bpc_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Param_Id", source = "bpp_param_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Tipo", source = "upper(replace((bpp_type),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Ref_Id", source = "bpp_ref_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Usuario_Checkout", source = "upper(replace((bpp_vc_checkout_user_name),'''',''))"
});
}
public BptComponentsSteps(SqlMakerFurther sqlMaker)
{
if (sqlMaker != null)
{
this.SqlMaker = sqlMaker;
}
else
{
throw new ArgumentNullException("sqlMaker", "O parâmetro 'sqlMaker' não pode ser null");
}
this.SqlMaker.dataSource = $"{SqlMaker.BptProject.Esquema}.component_step";
this.SqlMaker.dataSourceFieldId = "cs_step_id";
this.SqlMaker.dataSourceFieldDateUpdade = "";
this.SqlMaker.dataSourceCondition = "";
this.SqlMaker.TargetTable = "BPT_Components_Steps";
this.SqlMaker.fields = new List <Field>();
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Subprojeto", source = $"'{SqlMaker.BptProject.Subprojeto}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Entrega", source = $"'{SqlMaker.BptProject.Entrega}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "N", target = "Id", source = "cs_step_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Nome", source = "upper(replace(trim(cs_step_name),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Component_Id", source = "cs_component_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Ordem", source = "cs_step_order"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Descricao", source = "replace(trim(cs_description),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Resultado_Esperado", source = "replace(trim(cs_expected),'''','')"
});
}
public BptLinks(SqlMakerFurther sqlMaker)
{
if (sqlMaker != null)
{
this.SqlMaker = sqlMaker;
}
else
{
throw new ArgumentNullException("sqlMaker", "O parâmetro 'sqlMaker' não pode ser null");
}
this.SqlMaker.dataSource = $"{SqlMaker.BptProject.Esquema}.Link";
this.SqlMaker.dataSourceFieldId = "ln_bug_id";
this.SqlMaker.dataSourceFieldDateUpdade = "to_char(ln_creation_date,'yy-mm-dd')";
this.SqlMaker.dataSourceCondition = "";
this.SqlMaker.TargetTable = "BPT_Links";
this.SqlMaker.fields = new List <Field>();
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Subprojeto", source = "'{Subprojeto}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Entrega", source = "'{Entrega}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "N", target = "Id", source = "ln_link_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Bug_Id", source = "ln_bug_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Tabela", source = "ln_entity_type"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Tabela_Id", source = "ln_entity_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Atualizador", source = "upper(ln_created_by)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Alteracao", source = "to_char(ln_creation_date,'dd-mm-yy')"
});
}
public void LoadDataTestsCriteria(SqlMakerFurther sqlMaker)
{
var bptTestsCriteria = new BptTestsCriteria(sqlMaker);
bptTestsCriteria.LoadData();
}
public void LoadDataTestsConfigs(SqlMakerFurther sqlMaker)
{
var bptTestsConfigs = new BptTestsConfigs(sqlMaker);
bptTestsConfigs.LoadData();
}
public BptAssetRelations(SqlMakerFurther sqlMaker)
{
if (sqlMaker != null)
{
this.SqlMaker = sqlMaker;
}
else
{
throw new ArgumentNullException("sqlMaker", "O parâmetro 'sqlMaker' não pode ser null");
}
this.SqlMaker.dataSource = $"{SqlMaker.BptProject.Esquema}.asset_relations";
this.SqlMaker.dataSourceFieldId = "fp_id";
this.SqlMaker.dataSourceFieldDateUpdade = "";
this.SqlMaker.dataSourceCondition = "";
this.SqlMaker.TargetTable = "BPT_Asset_Relations";
this.SqlMaker.fields = new List <Field>();
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Subprojeto", source = $"'{SqlMaker.BptProject.Subprojeto}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Entrega", source = $"'{SqlMaker.BptProject.Entrega}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "N", target = "Id", source = "asr_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Owner_Id", source = "asr_owner_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Owner_type", source = "upper(replace((asr_owner_type),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Related_Id", source = "asr_related_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Related_type", source = "upper(replace((asr_related_type),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Ordem", source = "asr_order"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Condicao", source = "upper(replace((asr_condition),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Mapeamento_Dados", source = "upper(replace((asr_data_mapping),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Usuario_Checkout", source = "upper(replace((asr_vc_checkout_user_name),'''',''))"
});
}
public BptTestsToComponents(SqlMakerFurther sqlMaker)
{
if (sqlMaker != null)
{
this.SqlMaker = sqlMaker;
}
else
{
throw new ArgumentNullException("sqlMaker", "O parâmetro 'sqlMaker' não pode ser null");
}
this.SqlMaker.dataSource = $"{SqlMaker.BptProject.Esquema}.bptest_to_components";
this.SqlMaker.dataSourceFieldId = "bc_id";
this.SqlMaker.dataSourceFieldDateUpdade = "";
this.SqlMaker.dataSourceCondition =
$@"exists(select distinct 1
from {SqlMaker.BptProject.Esquema}.testcycl tc
where tc.tc_test_id = bc_bpt_id)";
this.SqlMaker.TargetTable = "BPT_Tests_To_Components";
this.SqlMaker.fields = new List <Field>();
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Subprojeto", source = $"'{SqlMaker.BptProject.Subprojeto}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Entrega", source = $"'{SqlMaker.BptProject.Entrega}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "N", target = "Id", source = "bc_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Ordem", source = "bc_order"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Test_Id", source = "bc_bpt_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Component_Id", source = "bc_co_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Test_Criteria_Id", source = "bc_criterion_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Condicao_Falha", source = "upper(bc_fail_cond)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Pai", source = "upper(bc_Parent_type)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Pai_Id", source = "bc_Parent_id"
});
}
public void LoadDataTestCycle(SqlMakerFurther sqlMaker)
{
var bptTestsCycle = new BptTestsCycle(sqlMaker);
bptTestsCycle.LoadData();
}
public void LoadDataResources(SqlMakerFurther sqlMaker)
{
var BptResources = new BptResources(sqlMaker);
BptResources.LoadData();
}
public void LoadDataFrameworkParam(SqlMakerFurther sqlMaker)
{
var BptFrameworkParam = new BptFrameworkParam(sqlMaker);
BptFrameworkParam.LoadData();
}
public BptBugs(SqlMakerFurther sqlMaker)
{
if (sqlMaker != null)
{
this.SqlMaker = sqlMaker;
}
else
{
throw new ArgumentNullException("sqlMaker", "O parâmetro 'sqlMaker' não pode ser null");
}
this.SqlMaker.dataSource = $"{SqlMaker.BptProject.Esquema}.Bug";
this.SqlMaker.dataSourceFieldId = "bg_bug_id";
this.SqlMaker.dataSourceFieldDateUpdade = "bg_vts";
this.SqlMaker.dataSourceCondition = "";
this.SqlMaker.TargetTable = "BPT_Bugs";
//bg_dev_comments, Comentarios
//bg_description, Descricao
//bg_detected_in_rel, Detectado Na Release
//bg_detection_date Detectado No Dia
//bg_detection_version, Detected In Version
//bg_responsible, Enviado Para
//bg_estimated_fix_time, Estimated Fix Time
//bg_planned_closing_ver, Planned Closing Version
//bg_project, Project
//bg_reproducible, Reproducible
//bg_subject, Subject
//bg_target_rcyc, Target Cycle
//bg_target_rel, Target Release
this.SqlMaker.fields = new List <Field>();
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Subprojeto", source = $"'{SqlMaker.BptProject.Subprojeto}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Entrega", source = $"'{SqlMaker.BptProject.Entrega}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "N", target = "Id", source = "bg_bug_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Nome", source = "upper(replace(bg_summary,'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Detectado_Por", source = "bg_detected_by"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Release", source = $"replace(upper((select r.rel_name from {SqlMaker.BptProject.Esquema}.release_cycles rc, {SqlMaker.BptProject.Esquema}.releases r where rc.rcyc_id = bg_detected_in_rcyc and r.rel_id = rc.rcyc_parent_id)),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Ciclo", source = $"upper((select rc.rcyc_name from {SqlMaker.BptProject.Esquema}.release_cycles rc where rc.rcyc_id = bg_detected_in_rcyc))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Prioridade", source = "upper(bg_priority)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Severidade", source = "upper(bg_severity)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Inicial", source = "to_char(BG_DETECTION_DATE, 'dd-mm-yy')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Final", source = "(case when BG_CLOSING_DATE is null then '' else to_char(BG_CLOSING_DATE,'dd-mm-yy') || ' ' || substr(bg_vts,12,8) end)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Prevista_Solucao_Defeito", source = "(case when bg_user_template_04 is not null then substr(bg_user_template_04, 9, 2) || '-' || substr(bg_user_template_04, 6, 2) || '-' || substr(bg_user_template_04, 3, 2) || ' ' || substr(bg_user_template_04, 12, 8) else '' end)"
});
//this.SqlMaker.fields.Add(new Field() { type = "A", target = "Dt_Ultimo_Status", source = $"to_char(Dt_Ultimo_Status_Bug('{SqlMaker.BptProject.Esquema}', bg_bug_id, bg_status),'dd-mm-yy hh24:mi:ss')" });
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Status", source = "upper(bg_status)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Tempo_Resolucao_Dias", source = "bg_actual_fix_time"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Detalhamento_CR_PKE", source = "bg_user_template_13"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Encaminhado_Para", source = "upper(bg_user_template_09)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Erro_Detectavel_Em_Desenvolvimento", source = "replace(upper(bg_user_template_06),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Ja_Foi_Rejeitado", source = "upper(bg_user_template_08)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Motivo_Pendencia", source = "upper(bg_user_template_10)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Natureza", source = "upper(bg_user_template_01)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Origem", source = "upper(bg_user_template_05)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Qtd_CTs_Impactados", source = "bg_user_template_11"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Qtd_Reincidencia", source = "bg_user_template_07"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Sistema_CT", source = "upper(bg_user_template_03)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Sistema_Defeito", source = "upper(bg_user_template_02)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Test_Cycle_Id", source = $"(select (case when ln_entity_type = 'TESTCYCL' then (select TC.tc_testcycl_id from {SqlMaker.BptProject.Esquema}.testcycl TC where TC.tc_testcycl_id = L.ln_entity_id) when ln_entity_type = 'RUN' then (select R.rn_testcycl_id from {SqlMaker.BptProject.Esquema}.run R where R.rn_run_id = L.ln_entity_id) when ln_entity_type = 'STEP' then (select R.rn_testcycl_id from {SqlMaker.BptProject.Esquema}.run R where R.rn_run_id = (select S.st_run_id from {SqlMaker.BptProject.Esquema}.step S where S.st_id = L.ln_entity_id)) end) from {SqlMaker.BptProject.Esquema}.Link L where L.ln_bug_id = bg_bug_id and rownum=1)"
});
//this.SqlMaker.fields.Add(new Field() { type = "n", target = "SLA", source = "SLA(bg_severity)" });
this.SqlMaker.fields.Add(new Field()
{
type = "n", target = "Qtd_Reopen", source = "0"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Alteracao", source = "substr(bg_vts,9,2) || '-' || substr(bg_vts,6,2) || '-' || substr(bg_vts,3,2) || ' ' || substr(bg_vts,12,8)"
});
}
public BptResources(SqlMakerFurther sqlMaker)
{
if (sqlMaker != null)
{
this.SqlMaker = sqlMaker;
}
else
{
throw new ArgumentNullException("sqlMaker", "O parâmetro 'sqlMaker' não pode ser null");
}
this.SqlMaker.dataSource = $"{SqlMaker.BptProject.Esquema}.resources";
this.SqlMaker.dataSourceFieldId = "rsc_id";
this.SqlMaker.dataSourceFieldDateUpdade = "rsc_vts";
this.SqlMaker.dataSourceCondition = "";
this.SqlMaker.TargetTable = "BPT_Resources";
this.SqlMaker.fields = new List <Field>();
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Subprojeto", source = $"'{SqlMaker.BptProject.Subprojeto}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Entrega", source = $"'{SqlMaker.BptProject.Entrega}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "N", target = "Id", source = "rsc_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Nome", source = "upper(replace((rsc_name),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Nome_Arquivo", source = "upper(replace((rsc_file_name),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Tipo_Localizacao", source = "upper(replace((rsc_location_type),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Tipo", source = "upper(replace((rsc_type),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Descricao", source = "upper(replace((rsc_description),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Parent_Id", source = "rsc_parent_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Status", source = "upper(replace((rsc_vc_status),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Usuario_Checkout", source = "upper(replace((rsc_vc_checkin_user_name),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Criacao", source = "to_char(rsc_creation_date,'dd-mm-yy')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Alteracao", source = "substr(rsc_vts,9,2) || '-' || substr(rsc_vts,6,2) || '-' || substr(rsc_vts,3,2) || ' ' || substr(rsc_vts,12,8)"
});
}
public BptRuns(SqlMakerFurther sqlMaker)
{
if (sqlMaker != null)
{
this.SqlMaker = sqlMaker;
}
else
{
throw new ArgumentNullException("sqlMaker", "O parâmetro 'sqlMaker' não pode ser null");
}
this.SqlMaker.dataSource = $"{SqlMaker.BptProject.Esquema}.run";
this.SqlMaker.dataSourceFieldId = "rn_run_id";
this.SqlMaker.dataSourceFieldDateUpdade = "rn_vts";
this.SqlMaker.dataSourceCondition =
$@"exists(select distinct 1
from {SqlMaker.BptProject.Esquema}.testcycl tc
where rn_test_id = rn_test_id)";
this.SqlMaker.TargetTable = "BPT_Runs";
this.SqlMaker.fields = new List <Field>();
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Subprojeto", source = $"'{SqlMaker.BptProject.Subprojeto}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Entrega", source = $"'{SqlMaker.BptProject.Entrega}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "N", target = "Id", source = "rn_run_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Nome", source = "upper(replace(rn_run_name,'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Test_Id", source = "rn_test_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Test_Config_Id", source = "rn_test_config_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Test_Cycle_Id", source = "rn_testcycl_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Execucao", source = "to_char(rn_execution_date, 'dd-mm-yy') || ' ' || rn_execution_time"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Duracao", source = "rn_duration"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Status", source = "upper(replace((rn_status),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Testador", source = "upper(replace((rn_tester_name),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Tem_Anexo", source = "upper(rn_attachment)"
});
//this.SqlMaker.fields.Add(new Field() { target = "Evidencia_Comentario_Tecnica", source = "replace(upper(rn_user_template_05),'''','')" });
//this.SqlMaker.fields.Add(new Field() { target = "Evidencia_Comentario_Cliente", source = "replace(upper(rn_user_template_10),'''','')" });
//this.SqlMaker.fields.Add(new Field() { target = "Evidencia_Motivo_Rejeicao_Tecnica", source = "replace(upper(rn_user_template_04),'''','')" });
//this.SqlMaker.fields.Add(new Field() { target = "Evidencia_Motivo_Rejeicao_Cliente", source = "replace(upper(rn_user_template_08),'''','')" });
//this.SqlMaker.fields.Add(new Field() { target = "Evidencia_Aprovador_Tecnico", source = "upper(rn_user_template_06)" });
//this.SqlMaker.fields.Add(new Field() { target = "Evidencia_Aprovador_Cliente", source = "upper(rn_user_template_11)" });
//this.SqlMaker.fields.Add(new Field() { target = "Evidencia_Validacao_Tecnica", source = "replace(upper(rn_user_template_03),'''','')" });
//this.SqlMaker.fields.Add(new Field() { target = "Evidencia_Validacao_Cliente", source = "replace(upper(rn_user_template_07),'''','')" });
//this.SqlMaker.fields.Add(new Field() { target = "Execucao_Automatica", source = "upper(replace(rn_user_template_01,'''',''))" });
//this.SqlMaker.fields.Add(new Field() { target = "Motivo_Execucao_Manual", source = "upper(replace(rn_user_template_02,'''',''))" });
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Alteracao", source = "substr(rn_vts,9,2) || '-' || substr(rn_vts,6,2) || '-' || substr(rn_vts,3,2) || ' ' || substr(rn_vts,12,8)"
});
}
public BptFrameworkParam(SqlMakerFurther sqlMaker)
{
if (sqlMaker != null)
{
this.SqlMaker = sqlMaker;
}
else
{
throw new ArgumentNullException("sqlMaker", "O parâmetro 'sqlMaker' não pode ser null");
}
this.SqlMaker.dataSource = $"{SqlMaker.BptProject.Esquema}.framework_param";
this.SqlMaker.dataSourceFieldId = "fp_id";
this.SqlMaker.dataSourceFieldDateUpdade = "";
this.SqlMaker.dataSourceCondition = "";
this.SqlMaker.TargetTable = "BPT_Framework_Param";
this.SqlMaker.fields = new List <Field>();
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Subprojeto", source = $"'{SqlMaker.BptProject.Subprojeto}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Entrega", source = $"'{SqlMaker.BptProject.Entrega}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "N", target = "Id", source = "fp_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Component_Id", source = "fp_component_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Nome", source = "upper(replace((fp_name),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Descricao", source = "upper(replace((fp_desc),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Valor", source = "upper(replace((fp_value),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Saida", source = "upper(replace((fp_is_out),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Escopo", source = "upper(replace((fp_scope),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Data_Center_List_Id", source = "fp_datacenter_list_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Ordem", source = "fp_order"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Tipo", source = "upper(replace((fp_value_type),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Contator_Referencia", source = "fp_ref_count"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "BPTA_Valor", source = "upper(replace((fp_bpta_long_value),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Source_Param_Id", source = "fp_source_param_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Meta_Data", source = "upper(replace((fp_metadata),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Usuario_Checkout", source = "upper(replace((fp_vc_checkout_user_name),'''',''))"
});
}
public BptComponents(SqlMakerFurther sqlMaker)
{
if (sqlMaker != null)
{
this.SqlMaker = sqlMaker;
}
else
{
throw new ArgumentNullException("sqlMaker", "O parâmetro 'sqlMaker' não pode ser null");
}
this.SqlMaker.dataSource = $"{SqlMaker.BptProject.Esquema}.component";
this.SqlMaker.dataSourceFieldId = "co_id";
this.SqlMaker.dataSourceFieldDateUpdade = "co_vts";
this.SqlMaker.dataSourceCondition = "";
this.SqlMaker.TargetTable = "BPT_Components";
this.SqlMaker.fields = new List <Field>();
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Subprojeto", source = $"'{SqlMaker.BptProject.Subprojeto}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Entrega", source = $"'{SqlMaker.BptProject.Entrega}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "N", target = "Id", source = "co_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Nome", source = "upper(co_name)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Status", source = "upper(co_status)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Tipo", source = "upper(co_script_type)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Folder_Id", source = "co_folder_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Path_Id", source = "co_physical_path"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Src_Id", source = "co_src_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Complexidade_Acc", source = "replace(upper(CO_USER_TEMPLATE_03),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Complexidade_Link", source = "replace(upper(CO_USER_TEMPLATE_04),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Componente_Automatizado", source = "replace(upper(CO_USER_TEMPLATE_09),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Fabrica_Desenvolvimento", source = "replace(upper(CO_USER_TEMPLATE_08),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Fabrica_Teste", source = "replace(upper(CO_USER_TEMPLATE_07),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Fornecedor", source = "replace(upper(CO_USER_TEMPLATE_02),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Geracao_Massa", source = "replace(upper(CO_USER_TEMPLATE_06),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Motivo_Exec_Manual", source = "replace(upper(CO_USER_TEMPLATE_11),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Tipo_Execucao", source = "replace(upper(CO_USER_TEMPLATE_10),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Sistema", source = "replace(upper(CO_USER_TEMPLATE_01),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "UAT", source = "replace(upper(CO_USER_TEMPLATE_05),'''','')"
});
//this.SqlMaker.fields.Add(new Field() { type = "A", target = "Plano_Validacao_Tecnica", source = "replace(upper(co_user_template_08),'''','')" });
//this.SqlMaker.fields.Add(new Field() { type = "A", target = "Plano_Motivo_Rejeicao_Tecnica", source = "replace(upper(co_user_template_09),'''','')" });
//this.SqlMaker.fields.Add(new Field() { type = "A", target = "Complexidade_Acc", source = "replace(upper(co_user_template_01),'''','')" });
//this.SqlMaker.fields.Add(new Field() { type = "A", target = "Complexidade_Link", source = "replace(upper(co_user_template_02),'''','')" });
//this.SqlMaker.fields.Add(new Field() { type = "A", target = "Componente_Automatizado", source = "replace(upper(co_user_template_06),'''','')" });
//this.SqlMaker.fields.Add(new Field() { type = "A", target = "Fornecedor", source = "replace(upper(co_user_template_03),'''','')" });
//this.SqlMaker.fields.Add(new Field() { type = "A", target = "Geracao_Massa", source = "replace(upper(co_user_template_05),'''','')" });
//this.SqlMaker.fields.Add(new Field() { type = "A", target = "Projeto", source = "replace(upper(co_user_template_07),'''','')" });
//this.SqlMaker.fields.Add(new Field() { type = "A", target = "Sistema", source = "replace(upper(co_user_template_04),'''','')" });
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Criacao", source = "to_char(co_creation_Date,'dd-mm-yy')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Alteracao", source = "substr(co_vts,9,2) || '-' || substr(co_vts,6,2) || '-' || substr(co_vts,3,2) || ' ' || substr(co_vts,12,8)"
});
}
public void LoadDataIteration(SqlMakerFurther sqlMaker)
{
var BptIteration = new BptIteration(sqlMaker);
BptIteration.LoadData();
}
public void LoadDataIterParam(SqlMakerFurther sqlMaker)
{
var BptIterParam = new BptIterParam(sqlMaker);
BptIterParam.LoadData();
}
public BptDesSteps(SqlMakerFurther sqlMaker)
{
if (sqlMaker != null)
{
this.SqlMaker = sqlMaker;
}
else
{
throw new ArgumentNullException("sqlMaker", "O parâmetro 'sqlMaker' não pode ser null");
}
this.SqlMaker.dataSource = $"{SqlMaker.BptProject.Esquema}.dessteps";
this.SqlMaker.dataSourceFieldId = "ds_id";
this.SqlMaker.dataSourceFieldDateUpdade = "ds_vts";
this.SqlMaker.dataSourceCondition =
$@"exists(select distinct 1
from {SqlMaker.BptProject.Esquema}.testcycl tc
where tc.tc_test_id = ds_test_id)";
this.SqlMaker.TargetTable = "BPT_Des_Steps";
this.SqlMaker.fields = new List <Field>();
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Subprojeto", source = "'{Subprojeto}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Entrega", source = "'{Entrega}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "N", target = "Id", source = "ds_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Nome", source = "upper(replace(trim(ds_step_name),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Test_Id", source = "ds_test_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Ordem", source = "ds_step_order"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Descricao", source = "replace(trim(DS_DESCRIPTION),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Resultado_Esperado", source = "replace(trim(DS_expected),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Tem_Paramentro", source = "upper(ds_has_params)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Alteracao", source = "substr(ds_vts,9,2) || '-' || substr(ds_vts,6,2) || '-' || substr(ds_vts,3,2) || ' ' || substr(ds_vts,12,8)"
});
}
public void LoadDataAssetRelations(SqlMakerFurther sqlMaker)
{
var BptAssetRelations = new BptAssetRelations(sqlMaker);
BptAssetRelations.LoadData();
}
public BptSteps(SqlMakerFurther sqlMaker)
{
if (sqlMaker != null)
{
this.SqlMaker = sqlMaker;
}
else
{
throw new ArgumentNullException("sqlMaker", "O parâmetro 'sqlMaker' não pode ser null");
}
this.SqlMaker.dataSource = $"{SqlMaker.BptProject.Esquema}.step";
this.SqlMaker.dataSourceFieldId = "st_id";
this.SqlMaker.dataSourceFieldDateUpdade = "";
this.SqlMaker.dataSourceCondition = "";
this.SqlMaker.TargetTable = "BPT_Steps";
this.SqlMaker.fields = new List <Field>();
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Subprojeto", source = $"'{SqlMaker.BptProject.Subprojeto}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Entrega", source = $"'{SqlMaker.BptProject.Entrega}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "N", target = "Id", source = "st_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Run_Id", source = "st_run_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Teste_Id", source = "st_test_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Nome", source = "upper(replace(trim(st_step_name),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Status", source = "upper(replace(trim(st_status),'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Execucao", source = "to_char(st_execution_date,'dd-mm-yy')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Hora_Execucao", source = "st_execution_time"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Descricao", source = "replace(trim(st_description),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Resultado_Esperado", source = "replace(trim(st_expected),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Ordem", source = "st_step_order"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Nivel_Id", source = "ST_OBJ_ID"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Nivel", source = "ST_LEVEL"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Id_Step_Pai", source = "ST_PARENT_ID"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Id_Objeto_Relacionado", source = "ST_REL_OBJ_ID"
});
}
public void LoadDataComponentsSteps(SqlMakerFurther sqlMaker)
{
var bptComponentsSteps = new BptComponentsSteps(sqlMaker);
bptComponentsSteps.LoadData();
}
public BptTestsCycle(SqlMakerFurther sqlMaker)
{
if (sqlMaker != null)
{
this.SqlMaker = sqlMaker;
}
else
{
throw new ArgumentNullException("sqlMaker", "O parâmetro 'sqlMaker' não pode ser null");
}
this.SqlMaker.dataSource =
$@"{SqlMaker.BptProject.Esquema}.testcycl tc
JOIN {SqlMaker.BptProject.Esquema}.cycle ts
ON ts.cy_cycle_id = tc.tc_cycle_id
left JOIN {SqlMaker.BptProject.Esquema}.cycl_fold tsfolder
ON tsfolder.cf_item_id = ts.cy_folder_id";
this.SqlMaker.dataSourceFieldId = "tc_testcycl_id";
this.SqlMaker.dataSourceFieldDateUpdade = "tc_vts";
this.SqlMaker.dataSourceCondition = "";
this.SqlMaker.TargetTable = "BPT_Tests_Cycle";
this.SqlMaker.fields = new List <Field>();
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Subprojeto", source = $"'{SqlMaker.BptProject.Subprojeto}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "A", target = "Entrega", source = $"'{SqlMaker.BptProject.Entrega}'"
});
this.SqlMaker.fields.Add(new Field()
{
key = true, type = "N", target = "Id", source = "tc.tc_testcycl_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Test_Config_Id", source = "tc.tc_test_Config_id"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Nome", source = "upper(substr((select t.ts_name from {SqlMaker.BptProject.Esquema}.test t where t.ts_test_id=tc.tc_test_id),0,199))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Test_Id", source = "tc.tc_test_id"
});
this.SqlMaker.fields.Add(new Field()
{
target = "Path",
source = @"
substr(
(select tablepath.pth from
(select in_cf.cf_item_id, sys_connect_by_path (in_cf.CF_ITEM_NAME, ' \ ') pth
from {SqlMaker.BptProject.Esquema}.cycl_fold in_cf connect by prior in_cf.cf_item_id = in_cf.cf_father_id
start with in_cf.cf_father_id = 0
) tablepath
left join {SqlMaker.BptProject.Esquema}.cycle in_cy
on (in_cy.cy_folder_id = tablepath.cf_item_id)
where in_cy.cy_cycle_id = ts.cy_cycle_id
),4)
"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Release", source = "replace(upper((select r.rel_name from {SqlMaker.BptProject.Esquema}.release_cycles rc, {SqlMaker.BptProject.Esquema}.releases r where rc.rcyc_id = tc.tc_assign_rcyc and r.rel_id = rc.rcyc_parent_id)),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Ciclo", source = "upper((select distinct rc.rcyc_name from {SqlMaker.BptProject.Esquema}.release_cycles rc where rc.rcyc_id=tc.tc_assign_rcyc))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Tipo", source = "upper(tc.tc_subtype_id)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Iterations", source = "tc.tc_iterations"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Instanciador", source = "tc.tc_tester_name"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Testador", source = "(case when tc.tc_actual_tester is not null or tc.tc_actual_tester <> '' then tc.tc_actual_tester else tc.tc_tester_name end)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Planejamento", source = "to_char(tc.tc_plan_scheduling_date,'dd-mm-yy')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Execucao", source = "case when tc.tc_exec_date is not null then to_char(tc.tc_exec_date,'dd-mm-yy') || ' ' || tc.tc_exec_time else '' end"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Status_Execucao", source = "upper(tc.tc_status)"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Causa_Blocked", source = "replace(upper(tc.tc_user_template_06),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Detalhe_Blocked", source = "replace(upper(tc.tc_user_template_07),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Motivo_Cancelamento_CT", source = "replace(upper(tc.tc_user_template_23),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Nro_Cenario", source = "replace(tc.tc_user_template_05,'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "N", target = "Previcao_Desbloqueio", source = "replace(tc.tc_user_template_03,'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Priorizacao", source = "upper(replace(tc_user_template_24,'''',''))"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Variante", source = "replace(upper(tc.tc_user_template_31),'''','')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Criacao", source = "to_char((select min(l.au_time) from {SqlMaker.BptProject.Esquema}.audit_log l where l.au_entity_type = 'testcycl' group by TO_NUMBER(l.au_entity_id) having TO_NUMBER(l.au_entity_id) = TO_NUMBER(tc.tc_testcycl_id)),'dd-mm-yy hh:mm:ss')"
});
this.SqlMaker.fields.Add(new Field()
{
type = "A", target = "Dt_Alteracao", source = "substr(tc.tc_vts,9,2) || '-' || substr(tc.tc_vts,6,2) || '-' || substr(tc.tc_vts,3,2) || ' ' || substr(tc.tc_vts,12,8)"
});
}
public void LoadDataBugs(SqlMakerFurther sqlMaker)
{
var bptBugs = new BptBugs(sqlMaker);
bptBugs.LoadData();
}
public void LoadDataDesSteps(SqlMakerFurther sqlMaker)
{
var bptDesSteps = new BptDesSteps(sqlMaker);
bptDesSteps.LoadData();
}
public void LoadDataRuns(SqlMakerFurther sqlMaker)
{
var bptRuns = new BptRuns(sqlMaker);
bptRuns.LoadData();
}
public void LoadDataTestsToComponents(SqlMakerFurther sqlMaker)
{
var bptTestsToComponents = new BptTestsToComponents(sqlMaker);
bptTestsToComponents.LoadData();
}
