private void Dado_Uma_TableAdadpter_com_log_ativo_e_sem_chave() { _tableWithlog = DbTesteNampula.CreateObject <FakeTableWithLog>(); _tableWithlog.TableAdapterLog.Detach(); _tableWithlog.Collumns.ForEach(c => c.Key = false); _tableWithlog.KeyFields.Clear(); }
public void Passar_Listas_Vazias_Para_Sql_NotIn_Nao_Deve_Retornar_Nenhum_Registro() { Criar20Registros(); var fakeTable = DbTesteNampula.CreateObject <FakeTableForQuery>(); var tableQuery = new TableQuery(fakeTable); tableQuery.Where.Add( new QueryParam(fakeTable.Collumns["Id"], eCondition.ecNotIn, new object[] { })); var resultOfConsult = _scriptWizard.GetSelectComplexStatment(tableQuery); Console.WriteLine("Query : \n{0}", resultOfConsult.Item1); Console.WriteLine("Parameters : "); foreach (var paramter in resultOfConsult.Item2) { Console.WriteLine("{0}:{1}", paramter.Name, paramter.Value); } var data = fakeTable.FillCollection <FakeTableForQuery>(tableQuery); Assert.AreEqual(20, data.Count); fakeTable = DbTesteNampula.CreateObject <FakeTableForQuery>(); tableQuery = new TableQuery(fakeTable); tableQuery.Where.Add( new QueryParam(fakeTable.Collumns["Id"], eCondition.ecNotIn, null)); data = fakeTable.FillCollection <FakeTableForQuery>(tableQuery); Assert.AreEqual(20, data.Count); }
public void Deve_Permitir_Consultar_Sql_Not_In() { Criar20Registros(); var fakeTable = DbTesteNampula.CreateObject <FakeTableForQuery>(); var tableQuery = new TableQuery(fakeTable); tableQuery.Where.Add( new QueryParam(fakeTable.Collumns["Id"], eCondition.ecNotIn, new[] { 1, 2 })); var resultOfConsult = _scriptWizard.GetSelectComplexStatment(tableQuery); Console.WriteLine("Query : \n{0}", resultOfConsult.Item1); Console.WriteLine("Parameters : "); foreach (var paramter in resultOfConsult.Item2) { Console.WriteLine("{0}:{1}", paramter.Name, paramter.Value); } var data = fakeTable.FillCollection <FakeTableForQuery>(tableQuery); Assert.AreEqual(18, data.Count); Assert.AreEqual(false, data.Any(c => c.Id == 1)); Assert.AreEqual(false, data.Any(c => c.Id == 2)); }
private void Dado_uma_tabela_com_log_ativado_criada_no_banco_dados() { _tableWithlog = DbTesteNampula.CreateObject <FakeTableWithLog>(); Connection.Instance.DropTable(_tableWithlog.TableName); Connection.Instance.DropTable(_tableWithlog.TableName + "Log"); _tableWithlog.Create(); }
private void Criar20Registros() { Connection.Instance.SqlServerExecute("DELETE FROM DbTesteNampula..FakeTableForQuery"); foreach (var i in Enumerable.Range(1, 20)) { var fakeTable = DbTesteNampula.CreateObject <FakeTableForQuery>(); fakeTable.Id = i; fakeTable.Description = "Teste " + i; fakeTable.Add(); } }
private void Dado_uma_tabela_com_log_de_2_instancias_com_data() { _tableWithlog = DbTesteNampula.CreateObject <FakeTableWithLogWithThreFields>(); Connection.Instance.DropTable(_tableWithlog.TableName); Connection.Instance.DropTable(_tableWithlog.TableName + "Log"); _tableWithlog.Create(); AdicionarRegistro("Fábio Oliveira", DateTime.Now.AddDays(-2)); AtualizarRegistra("Fabio Nascimento 2", DateTime.Now); var instances = _tableWithlog.TableAdapterLog.GetByBaseId(); instances.Rows.Count.Should().Be.EqualTo(2); }
public void Dado_Uma_TableAdadpter_com_log_ativo() { _tableWithlog = DbTesteNampula.CreateObject <FakeTableWithLog>(); }
private void Dado_Uma_TableAdadpter_com_log_desativado() { _tableWithlog = DbTesteNampula.CreateObject <FakeTableWithLog>(); _tableWithlog.SetAutoLog(false); }