/// <summary>
/// this method will set up schema for new user, will return unique id to application
/// </summary>
/// <returns></returns>
public long SetupSchema(ShardStartegyData dto)
{
// call ShardStrategy with app name
// Strategy will return me shardid.
// call cedar data method which would execute schema def statements in above shard id
var dataReader = new DataFactory().GetdataReader(FetchMode.Sql);
dto.App = _app;
var shardId = ShardStrategy.ShardSelectionStrategy.SelectShardIdForExistingObject(dto);
var worker = new IdWorker(shardId);
var uniqueId = worker.GetUniqueId();
//_currentShard = uniqueId;
var appSchema = dataReader.GetAppSchema(shardId);
var cedarSession = new CedarSession(uniqueId) { EnableTrasaction = true };
cedarSession.SetupSchema(appSchema);
cedarSession.Close();
new DataFactory().GetdataReader(FetchMode.Sql).UpdateShard(shardId);
_app.Shards = new DataFactory().GetdataReader(FetchMode.Sql).GetAllShardByAppname(_app.ApplicationName);
return uniqueId;
}
public void Whether_Cedardb_Execute_Query()
{
var uuid = 174931025376227328;
using (var cedarSession = new CedarSession(uuid))
{
Assert.AreNotEqual(null, "Cedar session is not null, cedar connection opened");
var ctr =
cedarSession.Insert(
"insert into employee_" + uuid +
" (first_name,last_name,address) values (@FirstName,@LastName,@Address)", new[]
{
new
{
FirstName
= "Tarun",
LastName
= "Kumar",
Address
=
"C-25 Noida"
},
new
{
FirstName
=
"Parkash",
LastName
= "Bhatt",
Address
=
"C-25 Noida"
},
new
{
FirstName
= "Hemant",
LastName
= "Kumar",
Address
=
"C-25 Noida"
},
new
{
FirstName
=
"Gurpreet",
LastName
= "Kaur",
Address
=
"C-25 Noida"
},
},
Cedar.CommandType.Query);
Assert.AreEqual(4, ctr, "4 rows inserted");
cedarSession.Close();
}
}
public void Whether_Ceder_Update_Query_Work()
{
var uuid = 174103530611572736;
var cedarSession = new CedarSession(uuid );
Assert.AreNotEqual(null, "Cedar session is not null, cedar connection opened");
var ctr = cedarSession.Select("select * from employee_"+uuid, null, Cedar.CommandType.Query);
Assert.AreEqual(4, ctr.Count(), "4 Rows selected");
var address = "C-25 New Delhi";
cedarSession.Update("update employee_" + uuid + " set address=@Address where first_name=@FirstName", new { FirstName = "Prakash", Address = address }, Cedar.CommandType.Query);
ctr = cedarSession.Select("select address from employee__" + uuid + " where first_name=@FirstName", new { FirstName = "Prakash" }, Cedar.CommandType.Query);
Assert.AreEqual(address,ctr, "Changed adress updated");
cedarSession.Close();
}
public void Whether_Ceder_Select_Query_Work()
{
var uuid = 174103530611572736;
var cedarSession = new CedarSession(uuid );
Assert.AreNotEqual(null, "Cedar session is not null, cedar connection opened");
var ctr = cedarSession.Select("select * from employee_"+uuid, null, Cedar.CommandType.Query);
Assert.AreEqual(4, ctr.Count(), "4 Rows selected");
ctr = cedarSession.Select("select * from employee_"+uuid+" where first_name=@FirstName", new { FirstName = "Tarun" }, Cedar.CommandType.Query);
Assert.AreEqual(1, ctr.Count(), "1 Rows selected");
cedarSession.Close();
}
public void Whether_Cedardb_SqlConnection_Opened()
{
var cedarSession = new CedarSession(174103530611572736);
Assert.AreNotEqual(null,"Cedar session is not null, cedar connection opened");
cedarSession.Close();
}
public void SetupSchema(long shardId, long uuid)
{
var app = new App();
var shard = GetShardById(shardId);
var connectionString = shard.connection_string;
var appSchema = GetAppSchema(shard.application_name);
app.AppId = uuid;
app.ApplicationName = shard.application_name;
app.Shards.Add(shard);
var cedarSession = new CedarSession(shardId);
cedarSession.EnableTrasaction = true;
cedarSession.SetupSchema(appSchema);
cedarSession.Close();
}