public void TestAttributeSchemaUpsert()
{
String conn = GMGameManager.Properties.Settings.Default.ConnString;
SqlDataIntegration dataIntegration = null;
SqlDataRecordset records = null;
SqlRecordsetIntegration recordIntegration = null;
AttributeSchema Schema;
bool result;
try
{
dataIntegration = new SqlDataIntegration(conn);
}
catch (Exception ex)
{
Assert.Fail("Fail at connection: " + ex.Message);
}
Schema = new AttributeSchema();
Schema.Name = "weight";
Schema.IsRequired = true;
Schema.Multiplicity = 1;
Schema.PropertySchema.Id = 1;
result = dataIntegration.SendActionRequest(SqlDataIntegration.RecordType.AttributeSchema, SqlDataIntegration.RequestType.Upsert,
SqlRecordsetIntegration.ParameterizeAttributeSchema(Schema));
Assert.IsTrue(result);
}
public void TestAttributeConstructionSql()
{
String conn = GMGameManager.Properties.Settings.Default.ConnString;
SqlDataIntegration dataIntegration = null;
SqlDataRecordset records = null;
SqlRecordsetIntegration recordIntegration = null;
Dictionary <int, AttributeItem> attrs = null;
try
{
dataIntegration = new SqlDataIntegration(conn);
}
catch (Exception ex)
{
Assert.Fail("Fail at connection: " + ex.Message);
}
try
{
records = (SqlDataRecordset)dataIntegration.SendDataRequest(DataIntegration.RecordType.AttributeItem, null);
if (records.Dataset.Tables.Count == 0)
{
Assert.Fail("No tables retrieved");
}
for (int i = 0; i < records.Dataset.Tables.Count; i++)
{
DataTable table = records.Dataset.Tables[i];
if (records.Dataset.Tables[i].Rows.Count == 0)
{
Assert.Fail(String.Format("Table {0} return no results.",
records.Dataset.Tables[i].TableName));
}
}
}
catch (Exception ex)
{
Assert.Fail("Fail at request: " + ex.Message);
}
recordIntegration = new SqlRecordsetIntegration(records);
Assert.IsNotNull(recordIntegration, "Fail - record integration is null.");
try
{
attrs = recordIntegration.BuildAttributeDictionary();
Assert.IsNotNull(attrs, "Fail - schemas result is null.");
if (attrs.Count == 0)
{
Assert.Fail("No records retrieved");
}
}
catch (Exception ex)
{
Assert.Fail("Fail at object build: " + ex.Message);
}
AttributeItem ability = attrs[1];
AttributeItem bonus = attrs[2];
AttributeItem desc = attrs[3];
Assert.AreEqual <string>("strength", ability.Value);
Assert.AreEqual <string>("4", bonus.Value);
Assert.AreEqual <string>("+4 strength bonus", desc.Value);
}
public void TestAttributeSchemaConstructorSqlTvp()
{
String conn = GMGameManager.Properties.Settings.Default.ConnString;
SqlDataIntegration dataIntegration = null;
SqlDataRecordset records = null;
SqlRecordsetIntegration recordIntegration = null;
Dictionary <int, AttributeSchema> schemas = null;
try
{
dataIntegration = new SqlDataIntegration(conn);
}
catch (Exception ex)
{
Assert.Fail("Fail at connection: " + ex.Message);
}
try
{
records = (SqlDataRecordset)dataIntegration.SendDataRequest(SqlDataIntegration.RecordType.AttributeSchema, GetTestIdList(), 0);
if (records.Dataset.Tables.Count == 0)
{
Assert.Fail("No tables retrieved");
}
for (int i = 0; i < records.Dataset.Tables.Count; i++)
{
DataTable table = records.Dataset.Tables[i];
if (records.Dataset.Tables[i].Rows.Count == 0)
{
Assert.Fail(String.Format("Table {0} return no results.",
records.Dataset.Tables[i].TableName));
}
}
}
catch (Exception ex)
{
Assert.Fail("Fail at request: " + ex.Message);
}
recordIntegration = new SqlRecordsetIntegration(records);
Assert.IsNotNull(recordIntegration, "Fail - record integration is null.");
try
{
schemas = recordIntegration.BuildAttributeSchemaDictionary();
Assert.IsNotNull(schemas, "Fail - schemas result is null.");
if (schemas.Count == 0)
{
Assert.Fail("No records retrieved");
}
}
catch (Exception ex)
{
Assert.Fail("Fail at object build: " + ex.Message);
}
AttributeSchema ability = schemas[1];
AttributeSchema bonus = schemas[2];
AttributeSchema desc = schemas[3];
Assert.AreEqual <string>("ability", ability.Name);
Assert.AreEqual <string>("bonus", bonus.Name);
Assert.AreEqual <string>("description", desc.Name);
}
