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(); }