public void TestInsertOperationHanaShortTypes() { IScriptBuilder builder = new ScriptHanaBuilder(); var cliente = new Employee() { Id = 1, Name = "Moisés", Age = 25 }; var hanaConnection = new HanaConnection(); hanaConnection.ConnectionString = ConnectionStringReader.GetConnstring("hana"); hanaConnection.Open(); var trans = hanaConnection.BeginTransaction(); var createTableScript = builder.GetCreateTableCommand <Employee>(); hanaConnection.Execute(createTableScript); hanaConnection.Insert <Employee>(cliente); var employeeFromDatabase = hanaConnection.GetAll <Employee>(); Assert.AreEqual(1, employeeFromDatabase.Count()); hanaConnection.Execute("drop table \"Employee\""); }
public void SapHanaSelectContractWhereName() { var conn = new Sap.Data.Hana.HanaConnection(); conn.ConnectionString = ConnectionStringReader.GetConnstring("hana"); var dicTypes = new Dictionary <int, string>(); dicTypes.Add(1, "Teste"); var currentDate = new DateTime(2019, 1, 1); var contractId = 2; foreach (var item in dicTypes) { conn.Select <ProductSaleReport>(c => c.SaleDate == currentDate && c.RevenueTypeId == item.Key && c.ContractId == contractId).LastOrDefault(); } //var conn = new Sap.Data.Hana.HanaConnection(); //conn.ConnectionString = ConnectionStringReader.GetConnstring("hana"); //var scriptBuilder = conn.GetScriptBuild(); //var contract = TestData.GetContract(); //var createTableScript = scriptBuilder.GetCreateTableCommand<Contract>(); //conn.Execute(createTableScript); //var id = conn.InsertReturningId<Contract>(contract); //var contracts = conn.Select<Contract>(c => c.BusinessPartnerName == "MOISÉS J. MIRANDA" && c.ID==1 && c.TypeContract==0); //Assert.AreEqual(1, contracts.Count()); //Assert.AreEqual("MOISÉS J. MIRANDA", contracts.ToList()[0].BusinessPartnerName); //conn.Execute("drop table \"Contract\""); }
public void TestHanaCreateTableScriptShorts() { IScriptBuilder builder = new ScriptHanaBuilder(); var connStr = ConnectionStringReader.GetConnstring("hana"); var conn = new HanaConnection(connStr); var sql = $@"SELECT [OUSR].[USER_CODE], [OUSR].[USERID], [OUSR].[U_NAME], [dpto].[Name] as [DepartmentName], [OUSR].[Department], [OUSR].[GENDER], [OUSR].[objType], [OUSR].[userSign], [OUSR].[SUPERUSER], [OUSR].[updateDate] FROM [OUSR] left join [OUDP] [dpto] on [dpto].[Code] = [OUSR].[Department]" .Replace("[", "\"").Replace("]", "\""); var users = conn.Query <OUSR>(sql); }
public void SapHanaDeleteModel222() { var conn = new Sap.Data.Hana.HanaConnection(ConnectionStringReader.GetConnstring("hana")); var sql = "SELECT * FROM \"@IV_LP_LABELMODEL\""; var result = conn.Query <LabelModel>(sql); }