本文整理汇总了C#中CUBRID.Data.CUBRIDClient.CUBRIDConnection.InsertElementInSequence方法的典型用法代码示例。如果您正苦于以下问题：C# CUBRIDConnection.InsertElementInSequence方法的具体用法？C# CUBRIDConnection.InsertElementInSequence怎么用？C# CUBRIDConnection.InsertElementInSequence使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类CUBRID.Data.CUBRIDClient.CUBRIDConnection的用法示例。
在下文中一共展示了CUBRIDConnection.InsertElementInSequence方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Test_SequenceOperations
/// <summary>
/// Test SEQUENCE operations
/// </summary>
private static void Test_SequenceOperations()
{
using (CUBRIDConnection conn = new CUBRIDConnection())
{
conn.ConnectionString = TestCases.connString;
conn.Open();
TestCases.ExecuteSQL("DROP TABLE IF EXISTS t", conn);
//Create a new table with a sequence
TestCases.ExecuteSQL("CREATE TABLE t(seq SEQUENCE(int))", conn);
//Insert some data in the sequence column
TestCases.ExecuteSQL("INSERT INTO t(seq) VALUES({0,1,2,3,4,5,6})", conn);
CUBRIDOid oid = new CUBRIDOid("@0|0|0");
using (CUBRIDCommand cmd = new CUBRIDCommand("SELECT t FROM t", conn))
{
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
oid = (CUBRIDOid)reader[0];
}
}
}
String attributeName = "seq";
int value = 7;
int SeqSize = conn.GetCollectionSize(oid, attributeName);
Debug.Assert(SeqSize == 7);
conn.UpdateElementInSequence(oid, attributeName, 1, value);
SeqSize = conn.GetCollectionSize(oid, attributeName);
Debug.Assert(SeqSize == 7);
using (CUBRIDCommand cmd = new CUBRIDCommand("SELECT * FROM t", conn))
{
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
int[] expected = { 7, 1, 2, 3, 4, 5, 6 };
object[] o = (object[])reader[0];
for (int i = 0; i < SeqSize; i++)
{
Debug.Assert(Convert.ToInt32(o[i]) == expected[i]);
}
}
}
}
conn.InsertElementInSequence(oid, attributeName, 5, value);
SeqSize = conn.GetCollectionSize(oid, attributeName);
Debug.Assert(SeqSize == 8);
using (CUBRIDCommand cmd = new CUBRIDCommand("SELECT * FROM t", conn))
{
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
int[] expected = { 7, 1, 2, 3, 7, 4, 5, 6 };
object[] o = (object[])reader[0];
for (int i = 0; i < SeqSize; i++)
{
Debug.Assert(Convert.ToInt32(o[i]) == expected[i]);
}
}
}
}
conn.DropElementInSequence(oid, attributeName, 5);
SeqSize = conn.GetCollectionSize(oid, attributeName);
Debug.Assert(SeqSize == 7);
using (CUBRIDCommand cmd = new CUBRIDCommand("SELECT * FROM t", conn))
{
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
int[] expected = { 7, 1, 2, 3, 4, 5, 6 };
object[] o = (object[])reader[0];
for (int i = 0; i < SeqSize; i++)
{
Debug.Assert(Convert.ToInt32(o[i]) == expected[i]);
}
}
}
}
TestCases.ExecuteSQL("DROP t", conn);
}
}示例2: CollectionSequence_Test
public void CollectionSequence_Test()
{
Log("Test GetCollectionSize, UpdateElementInSequence, InsertElementInSequence, DropElementInSequence");
using (CUBRIDConnection conn = new CUBRIDConnection())
{
conn.ConnectionString = DBHelper.connString;
conn.Open();
DBHelper.ExecuteSQL("DROP TABLE IF EXISTS t", conn);
//Create a new table with a sequence
DBHelper.ExecuteSQL("CREATE TABLE t(seq SEQUENCE(int))", conn);
//Insert some data in the sequence column
DBHelper.ExecuteSQL("INSERT INTO t(seq) VALUES({0,1,2,3,4,5,6})", conn);
CUBRIDOid oid = new CUBRIDOid("@0|0|0");
LogTestStep("Test UpdateElementInSequence");
using (CUBRIDCommand cmd = new CUBRIDCommand("SELECT t FROM t", conn))
{
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
oid = (CUBRIDOid)reader[0];
}
}
}
String attributeName = "seq";
int SeqSize = conn.GetCollectionSize(oid, attributeName);
Assert.AreEqual(7, SeqSize);
conn.UpdateElementInSequence(oid, attributeName, 1, 11);
SeqSize = conn.GetCollectionSize(oid, attributeName);
Assert.AreEqual(7, SeqSize);
using (CUBRIDCommand cmd = new CUBRIDCommand("SELECT * FROM t", conn))
{
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
int[] expected = { 11, 1, 2, 3, 4, 5, 6 };
object[] o = (object[])reader[0];
for (int i = 0; i < SeqSize; i++)
{
Assert.AreEqual(expected[i], Convert.ToInt32(o[i]));
}
}
}
}
LogStepPass();
LogTestStep("Test InsertElementInSequence");
conn.InsertElementInSequence(oid, attributeName, 5, 12);
SeqSize = conn.GetCollectionSize(oid, attributeName);
Assert.AreEqual(8, SeqSize);
using (CUBRIDCommand cmd = new CUBRIDCommand("SELECT * FROM t", conn))
{
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
int[] expected = { 11, 1, 2, 3, 12, 4, 5, 6 };
object[] o = (object[])reader[0];
for (int i = 0; i < SeqSize; i++)
{
Assert.AreEqual(expected[i], Convert.ToInt32(o[i]));
}
}
}
}
LogStepPass();
LogTestStep("Test DropElementInSequence");
conn.DropElementInSequence(oid, attributeName, 6);
SeqSize = conn.GetCollectionSize(oid, attributeName);
Assert.AreEqual(7, SeqSize);
using (CUBRIDCommand cmd = new CUBRIDCommand("SELECT * FROM t", conn))
{
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
int[] expected = { 11, 1, 2, 3, 12, 5, 6 };
object[] o = (object[])reader[0];
for (int i = 0; i < SeqSize; i++)
{
Assert.AreEqual(expected[i], Convert.ToInt32(o[i]));
}
}
}
}
LogStepPass();
//revert test db
//.........这里部分代码省略.........