public static void SequoiadbInitialize(TestContext testContext)
{
if ( config == null )
config = new Config();
sdb = new Sequoiadb(config.conf.Coord.Address);
sdb.Connect(config.conf.UserName, config.conf.Password);
}
// connect to a given database
public static void Connect(Sequoiadb sdb)
{
try
{
// connect to database
sdb.Connect();
}
catch (Exception e)
{
Console.WriteLine("Failed to connect to database at {0}:{1}", sdb.ServerAddr.Host, sdb.ServerAddr.Port);
Console.WriteLine(e.Message);
Environment.Exit(0);
}
}
public void CollectionTest()
{
string csName = "testCS1";
string clName = "testCL1";
CollectionSpace cs = null;
Sequoiadb sdb = new Sequoiadb(config.conf.Coord.Address);
sdb.Connect(config.conf.UserName, config.conf.Password);
if(sdb.IsCollectionSpaceExist(csName))
cs = sdb.GetCollecitonSpace(csName);
else
cs = sdb.CreateCollectionSpace(csName);
if (!cs.IsCollectionExist(clName))
cs.CreateCollection(clName);
cs.DropCollection(clName);
Assert.IsFalse(cs.IsCollectionExist(clName));
sdb.DropCollectionSpace(csName);
sdb.Disconnect();
}
public void MyTestCleanup()
{
// check whether it is in the cluster environment or not
if (!Constants.isClusterEnv(sdb))
{
Console.WriteLine("removeRG is for cluster environment only.");
return;
}
group = sdb.GetReplicaGroup(groupName);
if (group != null)
{
// drop all the cs in current group, and then remove this group
int nodeNum = group.GetNodeNum(SDBConst.NodeStatus.SDB_NODE_ALL);
if (nodeNum > 0)
{
SequoiaDB.Node nd = group.GetMaster();
Sequoiadb db = new Sequoiadb(nd.HostName, nd.Port);
Assert.IsTrue(nd.Start());
db.Connect(config.conf.UserName, config.conf.Password);
DBCursor cursor = db.ListCollectionSpaces();
while (cursor.Next() != null)
{
BsonDocument obj = cursor.Current();
string temp = null;
if (obj.Contains("Name"))
temp = obj["Name"].AsString;
sdb.DropCollectionSpace(temp);
}
db.Disconnect();
}
Assert.IsTrue(group.Stop());
// remove group
try
{
sdb.RemoveReplicaGroup(group.GroupName);
}
catch (BaseException e)
{
string errInfo = e.Message;
Console.WriteLine("Error code is: " + errInfo);
}
}
sdb.Disconnect();
}
/** \fn Sequoiadb Connect(string username, string password)
* \brief Connect to remote Sequoiadb database node
* \username Sequoiadb connection user name
* \password Sequoiadb connection password
* \return The Sequoiadb handle
* \exception SequoiaDB.BaseException
* \exception System.Exception
*/
public Sequoiadb Connect(string username, string password)
{
Sequoiadb sdb = null;
sdb = new Sequoiadb(hostName, port);
sdb.Connect(username, password);
return sdb;
}
public void MyTestInitialize()
{
// check whether it is in the cluster environment or not
if (!Constants.isClusterEnv(sdb))
{
Console.WriteLine("removeRG is for cluster environment only.");
return;
}
// argument
groupName = config.conf.Groups[0].GroupName;
hostName = config.conf.Groups[0].Nodes[0].HostName;
port = config.conf.Groups[0].Nodes[0].Port;
dbpath = config.conf.Groups[0].Nodes[0].DBPath;
// drop the exist group
group = sdb.GetReplicaGroup(groupName);
if (group != null)
{
// drop all the cs in current group, and then remove this group
int nodeNum = group.GetNodeNum(SDBConst.NodeStatus.SDB_NODE_ALL);
if (nodeNum > 0)
{
SequoiaDB.Node nd = group.GetMaster();
Sequoiadb db = new Sequoiadb(nd.HostName, nd.Port);
Assert.IsTrue(nd.Start());
db.Connect(config.conf.UserName, config.conf.Password);
DBCursor cursor = db.ListCollectionSpaces();
while (cursor.Next() != null)
{
BsonDocument obj = cursor.Current();
string temp = null;
if (obj.Contains("Name"))
temp = obj["Name"].AsString;
sdb.DropCollectionSpace(temp);
}
db.Disconnect();
}
try
{
sdb.RemoveReplicaGroup(group.GroupName);
}
catch (BaseException e)
{
string errInfo = e.Message;
Console.WriteLine("Error code is: " + errInfo);
}
}
// create a new group
group = sdb.CreateReplicaGroup(groupName);
Assert.IsTrue(groupName.Equals(group.GroupName));
// create a node
Dictionary<string, string> map = new Dictionary<string, string>();
map.Add("diaglevel", config.conf.Groups[0].Nodes[0].DiagLevel);
node = group.CreateNode(hostName, port, dbpath, map);
Assert.IsNotNull(node);
group.Start();
}
public void ConnectTest()
{
Sequoiadb sdb2 = new Sequoiadb(config.conf.Coord.Address);
System.Console.WriteLine(config.conf.Coord.Address.ToString());
// check whether it is in the cluster environment or not
if (!Constants.isClusterEnv(sdb))
{
System.Console.WriteLine("ConnectWithAuth is for cluster environment only.");
return;
}
sdb.CreateUser("testusr", "testpwd");
sdb2.Connect("testusr", "testpwd");
Assert.IsNotNull(sdb.Connection);
sdb2.RemoveUser("testusr", "testpwd");
sdb2.Disconnect();
Assert.IsNull(sdb2.Connection);
try
{
sdb2.Connect("testusr", "testpwd");
}
catch (BaseException e)
{
Assert.IsTrue(e.ErrorType == "SDB_AUTH_AUTHORITY_FORBIDDEN");
}
}
public void ConnectWithSSLTest()
{
ConfigOptions cfgOpt = null ;
CollectionSpace cs2 = null;
DBCollection coll2 = null;
Sequoiadb sdb2 = new Sequoiadb(config.conf.Coord.Address);
System.Console.WriteLine(config.conf.Coord.Address.ToString());
// set connect using ssl
cfgOpt = new ConfigOptions();
cfgOpt.UseSSL = true;
// connect to database
sdb2.Connect("", "", cfgOpt);
if (true == sdb2.IsCollectionSpaceExist("testSSL"))
cs2 = sdb2.GetCollecitonSpace("testSSL");
else
cs2 = sdb2.CreateCollectionSpace("testSSL");
if (true == cs2.IsCollectionExist("testSSL"))
coll2 = cs2.GetCollection("testSSL");
else
coll2 = cs2.CreateCollection("testSSL");
sdb2.DropCollectionSpace("testSSL");
}
public void setSessionAttrTest()
{
// create another node
string host = "192.168.20.42";
int port = 55555;
string dataPath = "/opt/sequoiadb/database/data/55555";
string groupName = "group1";
ReplicaGroup rg = null;
try
{
// get the exist group
rg = sdb.GetReplicaGroup(groupName);
// remove the node we going to use
SequoiaDB.Node node = rg.GetNode(host, port);
if (node != null)
{
rg.RemoveNode(host, port, new BsonDocument());
}
// create node
Dictionary<string, string> opt = new Dictionary<string, string>();
rg.CreateNode(host, port, dataPath, opt);
rg.Start();
// insert some records first
int num = 10;
List<BsonDocument> insertor = new List<BsonDocument>();
for (int i = 0; i < num; i++)
{
BsonDocument obj = new BsonDocument();
obj.Add("id", i);
insertor.Add(obj);
}
coll.BulkInsert(insertor, 0);
// begin a new session
Sequoiadb sdb2 = new Sequoiadb(config.conf.Coord.Address);
sdb2.Connect(config.conf.UserName, config.conf.Password);
Assert.IsNotNull(sdb2.Connection);
// TODO:
BsonDocument conf = new BsonDocument("PreferedInstance", "m");
sdb2.SetSessionAttr(conf);
// check
// record the slave note "TotalDataRead" before query
Sequoiadb sddb = new Sequoiadb(host, port);
sddb.Connect(config.conf.UserName, config.conf.Password);
DBCursor cur1 = sddb.GetSnapshot(6, null, null, null);
BsonDocument status1 = cur1.Next();
long count1 = status1.GetValue("TotalDataRead").AsInt64;
// query
DBCursor cursor = coll.Query(null, null, null, null, 0, -1);
BsonDocument o = new BsonDocument();
long count = 0;
while ((o = cursor.Next()) != null)
count++;
// record the slave note "TotalRead" after query
DBCursor cur2 = sddb.GetSnapshot(6, null, null, null);
BsonDocument status2 = cur2.Next();
long count2 = status2.GetValue("TotalDataRead").AsInt64;
//Assert.IsTrue(num == count2 - count1);
long temp = count2 - count1;
Console.WriteLine("count2 is " + count2 + ", count1 is " + count1);
DBCursor cur3 = sddb.GetSnapshot(6, null, null, null);
BsonDocument status3 = cur3.Next();
long count3 = status3.GetValue("TotalRead").AsInt64;
}
finally
{
// remove the newly build node
SequoiaDB.Node node = rg.GetNode(host, port);
if (node != null)
{
rg.RemoveNode(host, port, new BsonDocument());
}
}
}
public void IsValidTest()
{
bool result = false;
Sequoiadb sdb2 = new Sequoiadb(config.conf.Coord.Address);
System.Console.WriteLine(config.conf.Coord.Address.ToString());
sdb2.Connect("", "");
Assert.IsNotNull(sdb2.Connection);
// check before disconnect
result = sdb2.IsValid();
Assert.IsTrue(result);
// check after disconnect
sdb2.Disconnect();
result = sdb2.IsValid();
Assert.IsFalse(result);
/*
// check after shutdown database manually
sdb2 = new Sequoiadb(config.conf.Coord.Address);
sdb2.Connect("", "");
result = true;
result = sdb2.IsValid();
Assert.IsFalse(result);
*/
}
public void IsClosedTest()
{
//bool result = false;
Sequoiadb sdb2 = new Sequoiadb(config.conf.Coord.Address);
System.Console.WriteLine(config.conf.Coord.Address.ToString());
sdb2.Connect("", "");
Assert.IsNotNull(sdb2.Connection);
// TODO:
//result = sdb2.IsClosed();
Assert.IsFalse(false);
// check
sdb2.Disconnect();
//result = sdb2.IsClosed();
Assert.IsTrue(true);
}
public void GetSnapshotTest()
{
Sequoiadb sdb2 = new Sequoiadb(config.conf.Coord.Address);
sdb2.Connect();
BsonDocument dummy = new BsonDocument();
DBCursor cursor = sdb2.GetSnapshot(SDBConst.SDB_SNAP_CONTEXTS, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
BsonDocument bson = cursor.Next();
Assert.IsNotNull(bson);
cursor = sdb2.GetSnapshot(SDBConst.SDB_SNAP_CONTEXTS_CURRENT, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
bson = cursor.Next();
Assert.IsNotNull(bson);
cursor = sdb2.GetSnapshot(SDBConst.SDB_SNAP_SESSIONS, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
bson = cursor.Next();
Assert.IsNotNull(bson);
cursor = sdb2.GetSnapshot(SDBConst.SDB_SNAP_SESSIONS_CURRENT, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
bson = cursor.Next();
Assert.IsNotNull(bson);
cursor = sdb2.GetSnapshot(SDBConst.SDB_SNAP_COLLECTIONS, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
bson = cursor.Next();
Assert.IsNotNull(bson);
cursor = sdb2.GetSnapshot(SDBConst.SDB_SNAP_COLLECTIONSPACES, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
bson = cursor.Next();
Assert.IsNotNull(bson);
cursor = sdb2.GetSnapshot(SDBConst.SDB_SNAP_DATABASE, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
bson = cursor.Next();
Assert.IsNotNull(bson);
cursor = sdb2.GetSnapshot(SDBConst.SDB_SNAP_SYSTEM, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
bson = cursor.Next();
Assert.IsNotNull(bson);
if (Constants.isClusterEnv(sdb))
{
cursor = sdb.GetSnapshot(SDBConst.SDB_SNAP_CATALOG, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
BsonDocument obj = cursor.Next();
Assert.IsNotNull(obj);
}
sdb2.Disconnect();
}
public void GetListTest()
{
BsonDocument dummy = new BsonDocument();
BsonDocument bson = null;
DBCursor cursor = null;
// list cs
cursor = sdb.GetList(SDBConst.SDB_LIST_COLLECTIONSPACES, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
bson = cursor.Next();
Assert.IsNotNull(bson);
// list cl
cursor = sdb.GetList(SDBConst.SDB_LIST_COLLECTIONS, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
bson = cursor.Next();
Assert.IsNotNull(bson);
BsonDocument obj = new BsonDocument("test", "test");
coll.Insert(obj);
// list groups
// check whether it is in the cluster environment or not
if (Constants.isClusterEnv(sdb))
{
cursor = sdb.GetList(SDBConst.SDB_LIST_GROUPS, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
bson = cursor.Next();
Assert.IsNotNull(bson);
}
// list task
cursor = sdb.GetList(SDBConst.SDB_LIST_TASKS, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
// list domains
if (Constants.isClusterEnv(sdb))
{
string dmName = "testListDomain";
Domain dm = sdb.CreateDomain(dmName, null);
cursor = null;
cursor = sdb.ListDomains(null, null, null, null);
Assert.IsNotNull(cursor);
Assert.IsNotNull(cursor.Next());
sdb.DropDomain(dmName);
}
// list stored procedure
cursor = sdb.GetList(SDBConst.SDB_LIST_STOREPROCEDURES, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
// list all the contexts
if (Constants.isClusterEnv(sdb))
{
sdb.Disconnect();
sdb = new Sequoiadb(config.conf.Data.Address);
sdb.Connect(config.conf.UserName, config.conf.Password);
}
cursor = sdb.GetList(SDBConst.SDB_LIST_CONTEXTS, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
bson = cursor.Next();
Assert.IsNotNull(bson);
// list current context
cursor = sdb.GetList(SDBConst.SDB_LIST_CONTEXTS_CURRENT, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
bson = cursor.Next();
Assert.IsNotNull(bson);
// list all the sessions
cursor = sdb.GetList(SDBConst.SDB_LIST_SESSIONS, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
bson = cursor.Next();
Assert.IsNotNull(bson);
// list current session
cursor = sdb.GetList(SDBConst.SDB_LIST_SESSIONS_CURRENT, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
bson = cursor.Next();
Assert.IsNotNull(bson);
// list storge units
cursor = sdb.GetList(SDBConst.SDB_LIST_STORAGEUNITS, dummy, dummy, dummy);
Assert.IsNotNull(cursor);
bson = cursor.Next();
Assert.IsNotNull(bson);
}
public void CreateReplicaCataSetTest()
{
try
{
System.Console.WriteLine(config.conf.Groups[2].Nodes[0].HostName.ToString());
System.Console.WriteLine(config.conf.Groups[2].Nodes[0].Port.ToString());
System.Console.WriteLine(config.conf.Groups[2].Nodes[0].DBPath.ToString());
string str1 = config.conf.Groups[2].Nodes[0].HostName.ToString();
string str2 = config.conf.Groups[2].Nodes[0].Port.ToString();
string str3 = config.conf.Groups[2].Nodes[0].DBPath.ToString();
sdb.CreateReplicaCataGroup(config.conf.Groups[2].Nodes[0].HostName,
config.conf.Groups[2].Nodes[0].Port,
config.conf.Groups[2].Nodes[0].DBPath,
null);
}
catch (BaseException)
{
}
Sequoiadb sdb2 = new Sequoiadb(config.conf.Groups[2].Nodes[0].HostName,
config.conf.Groups[2].Nodes[0].Port);
sdb2.Connect();
Assert.IsNotNull(sdb2.Connection);
sdb2.Disconnect();
}
public void Connect_With_Serval_Arg_Test()
{
List<string> list = new List<string>();
list.Add("192.168.20.35:12340");
list.Add("192.168.20.36:12340");
list.Add("123:123");
list.Add("");
list.Add("192.168.20.40");
list.Add("192.168.30.161:11810");
list.Add("localhost:50000");
list.Add("192.168.20.42:50000");
list.Add("192.168.20.42:11810");
list.Add("192.168.20.165:11810");
list.Add("localhost:12340");
list.Add("192.168.20.40:12340");
ConfigOptions options = new ConfigOptions();
options.MaxAutoConnectRetryTime = 0;
options.ConnectTimeout = 100;
// connect
Sequoiadb sdb1 = new Sequoiadb(list);
sdb1.Connect("", "", options);
// set option and change the connect
options.ConnectTimeout = 2000;
sdb1.ChangeConnectionOptions(options);
// check
DBCursor cursor = sdb1.GetList(4, null, null, null);
Assert.IsTrue(cursor != null);
sdb1.Disconnect();
}
public void MyTestInitialize()
{
sdb = new Sequoiadb(config.conf.Coord.Address);
sdb.Connect(config.conf.UserName, config.conf.Password);
if (sdb.IsCollectionSpaceExist(csName))
sdb.DropCollectionSpace(csName);
cs = sdb.CreateCollectionSpace(csName);
coll = cs.CreateCollection(cName);
}
public void MyTestInitialize()
{
try
{
sdb = new Sequoiadb(config.conf.Coord.Address);
sdb.Connect(config.conf.UserName, config.conf.Password);
if (sdb.IsCollectionSpaceExist(csName))
sdb.DropCollectionSpace(csName);
cs = sdb.CreateCollectionSpace(csName);
coll = cs.CreateCollection(cName);
}
catch (BaseException e)
{
Console.WriteLine("Failed to Initialize in DBCollectionTest, ErrorType = {0}", e.ErrorType);
Environment.Exit(0);
}
}
public void setSessionAttr_Arguments_Test()
{
// begin a new session
Sequoiadb sdb2 = new Sequoiadb(config.conf.Coord.Address);
sdb2.Connect(config.conf.UserName, config.conf.Password);
Assert.IsNotNull(sdb2.Connection);
// TODO:
BsonDocument conf = null;
string[] str = { "M", "m", "S", "s", "A", "a" };
int[] nodeNumber = { 1, 2, 3, 4, 5, 6, 7 };
Random rnd = new Random();
int r = rnd.Next(2);
int n = -1;
if (r == 0)
{
n = rnd.Next(6);
conf = new BsonDocument("PreferedInstance", str[n]);
}
else
{
n = rnd.Next(7);
conf = new BsonDocument("PreferedInstance", nodeNumber[n]);
}
try
{
sdb2.SetSessionAttr(conf);
}
catch (BaseException e)
{
Console.WriteLine(e.ErrorType);
Assert.Fail();
}
}