Пример #1
0
        /// <summary>
        /// Initializes a new instance of the <see cref="Database"/> class providing
        /// a given parent <see cref="IDatabaseContext"/>.
        /// </summary>
        /// <param name="context">The database context that provides the required
        /// configurations and services to the database.</param>
        public Database(IDatabaseContext context)
        {
            DatabaseContext = context;

            DiscoverDataVersion();

            TableComposite = new TableSourceComposite(this);

            // Create the single row table
            var t = new TemporaryTable(context, "SINGLE_ROW_TABLE", new ColumnInfo[0]);
            t.NewRow();
            SingleRowTable = t;

            TransactionFactory = new DatabaseTransactionFactory(this);
        }
Пример #2
0
        public void TestSetUp()
        {
            var tableInfo = new TableInfo(new ObjectName("test_table"));
            tableInfo.AddColumn("id", PrimitiveTypes.Numeric());
            tableInfo.AddColumn("name", PrimitiveTypes.String());
            tableInfo.AddColumn("date", PrimitiveTypes.DateTime());

            var cornerTime = DateTimeOffset.UtcNow;

            var tmpTable = new TemporaryTable(tableInfo);

            AddRow(tmpTable, 1, "test1", cornerTime);
            AddRow(tmpTable, 2, "test2", cornerTime.AddSeconds(2));
            AddRow(tmpTable, 3, "test3", cornerTime.AddSeconds(5));

            tmpTable.BuildIndexes();

            table = tmpTable;
        }
Пример #3
0
        public void TestSetUp()
        {
            var tableName = ObjectName.Parse("APP.test_table");
            var tableInfo = new TableInfo(tableName);
            tableInfo.AddColumn("id", PrimitiveTypes.Numeric(), true);
            tableInfo.AddColumn("name", PrimitiveTypes.String(SqlTypeCode.VarChar));
            tableInfo.AddColumn("date", PrimitiveTypes.DateTime());

            cornerTime = DateTimeOffset.UtcNow;

            var tmpTable = new TemporaryTable(tableInfo);

            AddRow(tmpTable, 1, "test1", cornerTime);
            AddRow(tmpTable, 2, "test2", cornerTime.AddSeconds(2));
            AddRow(tmpTable, 3, "test3", cornerTime.AddSeconds(5));

            tmpTable.BuildIndexes(DefaultIndexTypes.BlindSearch);

            table = tmpTable;
        }
Пример #4
0
 private void AddRow(TemporaryTable tmpTable, long id, string name, DateTimeOffset date)
 {
     var row = new DataObject[3];
     row[0] = DataObject.BigInt(id);
     row[1] = DataObject.String(name);
     row[2] = DataObject.Date(date);
     tmpTable.NewRow(row);
 }