public void Insert_Test()
{
var model = new Models.SampleModel()
{
Age = 15,
Created = new DateTime(2016, 05, 01, 23, 23, 0),
Id = 56,
IsValid = true,
Name = "Test"
};
var insert = Builder.InsertModel.Create(model);
Assert.NotNull(insert);
Assert.NotNull(insert.Columns);
Assert.NotNull(insert.Values);
Assert.Equal(5, insert.Columns.Count);
Assert.Equal(5, insert.Values.Count);
Assert.Equal("age", insert.Columns[0]);
Assert.Equal("created", insert.Columns[1]);
Assert.Equal("id", insert.Columns[2]);
Assert.Equal("is_valid", insert.Columns[3]);
Assert.Equal("name", insert.Columns[4]);
Assert.Equal("15", insert.Values[0]);
Assert.Equal("'2016-05-01 23:23:00'", insert.Values[1]);
Assert.Equal("56", insert.Values[2]);
Assert.Equal("true", insert.Values[3]);
Assert.Equal("'Test'", insert.Values[4]);
Assert.Equal("\"public\".\"sample\"", insert.FullName);
var query = $"INSERT INTO \"public\".\"sample\"(\"age\", \"created\", \"id\", \"is_valid\", \"name\") VALUES (15, '2016-05-01 23:23:00', 56, true, 'Test') RETURNING id;";
Assert.Equal(query, insert.Build());
query = $"INSERT INTO \"public\".\"sample\"(\"age\", \"created\", \"is_valid\", \"name\") VALUES (15, '2016-05-01 23:23:00', true, 'Test') RETURNING id;";
Assert.Equal(query, insert.Build(true));
var add = new KeyValuePair <string, string>[] { new KeyValuePair <string, string>("gender", "'male'") };
query = $"INSERT INTO \"public\".\"sample\"(\"age\", \"created\", \"is_valid\", \"name\", \"gender\") VALUES (15, '2016-05-01 23:23:00', true, 'Test', 'male') RETURNING id;";
Assert.Equal(query, insert.Build(true, add));
}
public void Select_Test()
{
var model = new Models.SampleModel();
var select = Builder.SelectModel.Create(model);
Assert.NotNull(select);
Assert.NotNull(select.Columns);
Assert.Equal(5, select.Columns.Count);
Assert.Equal("id", select.Columns[0]);
Assert.Equal("name", select.Columns[1]);
Assert.Equal("age", select.Columns[2]);
Assert.Equal("is_valid", select.Columns[3]);
Assert.Equal("created", select.Columns[4]);
Assert.Equal("\"public\".\"sample\"", select.FullName);
var query = "SELECT \"id\", \"name\", \"age\", \"is_valid\", \"created\" FROM \"public\".\"sample\";";
Assert.Equal(query, select.Build());
}
public async void InsertAsync()
{
var model = new Models.SampleModel()
{
Age = 56,
Created = DateTime.UtcNow,
Id = 3,
IsValid = false,
Name = "AddAsync"
};
// Clean
var clean = await Query.VoidAsync("DELETE FROM sample WHERE id = 3;", this.Common.ConnectionString, this.Cancellation.Token);
Assert.True(clean);
// Insert
var query = await Query.InsertAsync(model, this.Common.ConnectionString, this.Cancellation.Token);
Assert.Equal(3, query);
}
public void Insert()
{
var model = new Models.SampleModel()
{
Age = 56,
Created = DateTime.UtcNow,
Id = 2,
IsValid = false,
Name = "Add"
};
// Clean
var clean = Query.Void("DELETE FROM sample WHERE id = 2;", this.Common.ConnectionString);
Assert.True(clean);
// Insert
var query = Query.Insert(model, this.Common.ConnectionString);
Assert.Equal(2, query);
}