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); }