Exemple #1
0
        public void Can_read_table_with_boolean_column()
        {
            var table = new DataTable();

            table.Columns.Add("Boolean Column");
            var row1 = table.NewRow();
            var row2 = table.NewRow();

            row1["Boolean Column"] = "true";
            row2["Boolean Column"] = "false";

            table.Rows.Add(row1);
            table.Rows.Add(row2);

            IDataTableReader tableReader = new DataTableReader();

            tableReader.Open(table);

            Assert.That(tableReader.Read(), Is.EqualTo(true));
            Assert.That(tableReader.GetBoolean("Boolean Column"), Is.EqualTo(true));

            Assert.That(tableReader.Read(), Is.EqualTo(true));
            Assert.That(tableReader.GetBoolean("Boolean Column"), Is.EqualTo(false));

            Assert.That(tableReader.Read(), Is.EqualTo(false));
        }
Exemple #2
0
        public void Can_read_table_with_decimal_column()
        {
            var table = new DataTable();

            table.Columns.Add("Decimal Column");
            DataRow row1 = table.NewRow();
            DataRow row2 = table.NewRow();

            row1["Decimal Column"] = "2.1";
            row2["Decimal Column"] = "3.1";

            table.Rows.Add(row1);
            table.Rows.Add(row2);

            IDataTableReader tableReader = new DataTableReader();

            tableReader.Open(table);

            Assert.That(tableReader.Read(), Is.EqualTo(true));
            Assert.That(tableReader.GetDecimal("Decimal Column"), Is.EqualTo(2.1M));

            Assert.That(tableReader.Read(), Is.EqualTo(true));
            Assert.That(tableReader.GetDecimal("Decimal Column"), Is.EqualTo(3.1M));

            Assert.That(tableReader.Read(), Is.EqualTo(false));
        }
Exemple #3
0
        public void Can_read_table_with_string_column()
        {
            var table = new DataTable();

            table.Columns.Add("String Column");
            DataRow row1 = table.NewRow();
            DataRow row2 = table.NewRow();

            row1["String Column"] = "First String";
            row2["String Column"] = "Second String";

            table.Rows.Add(row1);
            table.Rows.Add(row2);

            IDataTableReader tableReader = new DataTableReader();

            tableReader.Open(table);

            Assert.That(tableReader.Read(), Is.EqualTo(true));
            Assert.That(tableReader.GetString("String Column"), Is.EqualTo("First String"));

            Assert.That(tableReader.Read(), Is.EqualTo(true));
            Assert.That(tableReader.GetString("String Column"), Is.EqualTo("Second String"));

            Assert.That(tableReader.Read(), Is.EqualTo(false));
        }
Exemple #4
0
        public void Can_read_enumerated_column()
        {
            var table = new DataTable();

            table.Columns.Add("Mode Column");
            var row1 = table.NewRow();
            var row2 = table.NewRow();

            row1["Mode Column"] = "Archive";
            row2["Mode Column"] = "Live";

            table.Rows.Add(row1);
            table.Rows.Add(row2);

            IDataTableReader tableReader = new DataTableReader();

            tableReader.Open(table);

            Assert.That(tableReader.Read(), Is.EqualTo(true));
            Assert.That(tableReader.GetEnumeration <PersistenceMode>("Mode Column"), Is.EqualTo(PersistenceMode.Archive));

            Assert.That(tableReader.Read(), Is.EqualTo(true));
            Assert.That(tableReader.GetEnumeration <PersistenceMode>("Mode Column"), Is.EqualTo(PersistenceMode.Live));

            Assert.That(tableReader.Read(), Is.EqualTo(false));
        }
Exemple #5
0
        public void Can_read_table_with_partially_null_row()
        {
            var table = new DataTable();

            table.Columns.Add("String Column");
            table.Columns.Add("Integer Column");
            DataRow row1 = table.NewRow();
            DataRow row2 = table.NewRow();

            row1["String Column"]  = "First String";
            row1["Integer Column"] = 7;

            row2["String Column"]  = null;
            row2["Integer Column"] = 12;

            table.Rows.Add(row1);
            table.Rows.Add(row2);

            IDataTableReader tableReader = new DataTableReader();

            tableReader.Open(table);

            Assert.That(tableReader.Read(), Is.EqualTo(true));
            Assert.That(tableReader.Read(), Is.EqualTo(true));
            Assert.That(tableReader.Read(), Is.EqualTo(false));
        }
		public void Can_read_table_with_boolean_column()
		{
			var table = new DataTable();
			table.Columns.Add("Boolean Column");
			var row1 = table.NewRow();
			var row2 = table.NewRow();

			row1["Boolean Column"] = "true";
			row2["Boolean Column"] = "false";

			table.Rows.Add(row1);
			table.Rows.Add(row2);

			IDataTableReader tableReader = new DataTableReader();

			tableReader.Open(table);

			Assert.That(tableReader.Read(), Is.EqualTo(true));
			Assert.That(tableReader.GetBoolean("Boolean Column"), Is.EqualTo(true));

			Assert.That(tableReader.Read(), Is.EqualTo(true));
			Assert.That(tableReader.GetBoolean("Boolean Column"), Is.EqualTo(false));

			Assert.That(tableReader.Read(), Is.EqualTo(false));
		}
Exemple #7
0
        public void Can_read_table_with_integer_column()
        {
            var table = new DataTable();

            table.Columns.Add("Integer Column");
            DataRow row1 = table.NewRow();
            DataRow row2 = table.NewRow();

            row1["Integer Column"] = "5";
            row2["Integer Column"] = "7";

            table.Rows.Add(row1);
            table.Rows.Add(row2);

            IDataTableReader tableReader = new DataTableReader();

            tableReader.Open(table);

            Assert.That(tableReader.Read(), Is.EqualTo(true));
            Assert.That(tableReader.GetInteger("Integer Column"), Is.EqualTo(5));

            Assert.That(tableReader.Read(), Is.EqualTo(true));
            Assert.That(tableReader.GetInteger("Integer Column"), Is.EqualTo(7));

            Assert.That(tableReader.Read(), Is.EqualTo(false));
        }
		public void Can_read_table_with_decimal_column()
		{
			var table = new DataTable();
			table.Columns.Add("Decimal Column");
			DataRow row1 = table.NewRow();
			DataRow row2 = table.NewRow();

			row1["Decimal Column"] = "2.1";
			row2["Decimal Column"] = "3.1";

			table.Rows.Add(row1);
			table.Rows.Add(row2);

			IDataTableReader tableReader = new DataTableReader();

			tableReader.Open(table);

			Assert.That(tableReader.Read(), Is.EqualTo(true));
			Assert.That(tableReader.GetDecimal("Decimal Column"), Is.EqualTo(2.1M));

			Assert.That(tableReader.Read(), Is.EqualTo(true));
			Assert.That(tableReader.GetDecimal("Decimal Column"), Is.EqualTo(3.1M));

			Assert.That(tableReader.Read(), Is.EqualTo(false));
		}
		public void Can_read_enumerated_column()
		{
			var table = new DataTable();
			table.Columns.Add("Mode Column");
			var row1 = table.NewRow();
			var row2 = table.NewRow();

			row1["Mode Column"] = "Archive";
			row2["Mode Column"] = "Live";

			table.Rows.Add(row1);
			table.Rows.Add(row2);

			IDataTableReader tableReader = new DataTableReader();

			tableReader.Open(table);

			Assert.That(tableReader.Read(), Is.EqualTo(true));
			Assert.That(tableReader.GetEnumeration<PersistenceMode>("Mode Column"), Is.EqualTo(PersistenceMode.Archive));

			Assert.That(tableReader.Read(), Is.EqualTo(true));
			Assert.That(tableReader.GetEnumeration<PersistenceMode>("Mode Column"), Is.EqualTo(PersistenceMode.Live));

			Assert.That(tableReader.Read(), Is.EqualTo(false));
		}
Exemple #10
0
        public void Can_read_table_with_empty_string_values_at_the_end()
        {
            var table = new DataTable();

            table.Columns.Add("String Column");
            DataRow row1 = table.NewRow();
            DataRow row2 = table.NewRow();

            row1["String Column"] = "First String";
            row2["String Column"] = string.Empty;

            table.Rows.Add(row1);
            table.Rows.Add(row2);

            IDataTableReader tableReader = new DataTableReader();

            tableReader.Open(table);

            Assert.That(tableReader.Read(), Is.EqualTo(true));
            Assert.That(tableReader.Read(), Is.EqualTo(false));
        }
Exemple #11
0
        public void Returns_null_for_an_empty_string_value()
        {
            var table = new DataTable();

            table.Columns.Add("String Column");
            table.Columns.Add("Decimal Column");
            DataRow row1 = table.NewRow();

            row1["String Column"]  = string.Empty;
            row1["Decimal Column"] = 5.5M;

            table.Rows.Add(row1);

            IDataTableReader tableReader = new DataTableReader();

            tableReader.Open(table);

            Assert.That(tableReader.Read(), Is.EqualTo(true));
            Assert.That(tableReader.GetString("String Column"), Is.Null);
            Assert.That(tableReader.GetDecimal("Decimal Column"), Is.EqualTo(5.5M));

            Assert.That(tableReader.Read(), Is.EqualTo(false));
        }
		public void Can_read_table_with_empty_string_values_at_the_end()
		{
			var table = new DataTable();
			table.Columns.Add("String Column");
			DataRow row1 = table.NewRow();
			DataRow row2 = table.NewRow();

			row1["String Column"] = "First String";
			row2["String Column"] = string.Empty;

			table.Rows.Add(row1);
			table.Rows.Add(row2);

			IDataTableReader tableReader = new DataTableReader();

			tableReader.Open(table);

			Assert.That(tableReader.Read(), Is.EqualTo(true));
			Assert.That(tableReader.Read(), Is.EqualTo(false));
		}
		public void Returns_null_for_an_empty_string_value()
		{
			var table = new DataTable();
			table.Columns.Add("String Column");
			table.Columns.Add("Decimal Column");
			DataRow row1 = table.NewRow();

			row1["String Column"] = string.Empty;
			row1["Decimal Column"] = 5.5M;

			table.Rows.Add(row1);

			IDataTableReader tableReader = new DataTableReader();

			tableReader.Open(table);

			Assert.That(tableReader.Read(), Is.EqualTo(true));
			Assert.That(tableReader.GetString("String Column"), Is.Null);
			Assert.That(tableReader.GetDecimal("Decimal Column"), Is.EqualTo(5.5M));

			Assert.That(tableReader.Read(), Is.EqualTo(false));
		}
		public void Can_read_table_with_string_column()
		{
			var table = new DataTable();
			table.Columns.Add("String Column");
			DataRow row1 = table.NewRow();
			DataRow row2 = table.NewRow();

			row1["String Column"] = "First String";
			row2["String Column"] = "Second String";

			table.Rows.Add(row1);
			table.Rows.Add(row2);

			IDataTableReader tableReader = new DataTableReader();

			tableReader.Open(table);

			Assert.That(tableReader.Read(), Is.EqualTo(true));
			Assert.That(tableReader.GetString("String Column"), Is.EqualTo("First String"));

			Assert.That(tableReader.Read(), Is.EqualTo(true));
			Assert.That(tableReader.GetString("String Column"), Is.EqualTo("Second String"));

			Assert.That(tableReader.Read(), Is.EqualTo(false));
		}
		public void Can_read_table_with_partially_null_row()
		{
			var table = new DataTable();
			table.Columns.Add("String Column");
			table.Columns.Add("Integer Column");
			DataRow row1 = table.NewRow();
			DataRow row2 = table.NewRow();

			row1["String Column"] = "First String";
			row1["Integer Column"] = 7;

			row2["String Column"] = null;
			row2["Integer Column"] = 12;

			table.Rows.Add(row1);
			table.Rows.Add(row2);

			IDataTableReader tableReader = new DataTableReader();

			tableReader.Open(table);

			Assert.That(tableReader.Read(), Is.EqualTo(true));
			Assert.That(tableReader.Read(), Is.EqualTo(true));
			Assert.That(tableReader.Read(), Is.EqualTo(false));
		}
		public void Can_read_table_with_integer_column()
		{
			var table = new DataTable();
			table.Columns.Add("Integer Column");
			DataRow row1 = table.NewRow();
			DataRow row2 = table.NewRow();

			row1["Integer Column"] = "5";
			row2["Integer Column"] = "7";

			table.Rows.Add(row1);
			table.Rows.Add(row2);

			IDataTableReader tableReader = new DataTableReader();

			tableReader.Open(table);

			Assert.That(tableReader.Read(), Is.EqualTo(true));
			Assert.That(tableReader.GetInteger("Integer Column"), Is.EqualTo(5));

			Assert.That(tableReader.Read(), Is.EqualTo(true));
			Assert.That(tableReader.GetInteger("Integer Column"), Is.EqualTo(7));

			Assert.That(tableReader.Read(), Is.EqualTo(false));
		}