public void CanInsertMoreThanForOnePage() { var tableFile = RandomFilename; var schema = new Schema(); schema.AddIntField("field"); _tableInfo = new TableInfo(tableFile, schema); _recordFile = new RecordFile(_tableInfo, _transaction); _recordFile.BeforeFirst(); for (int i = 0; i < 12; ++i) { _recordFile.Insert(); } // And this folk would go to the next page _recordFile.Insert(); var rid = _recordFile.CurrentRID; Assert.AreEqual(1, rid.BlockNumber); Assert.AreEqual(0, rid.Id); }
public void CanDeleteRecord() { var tableFile = RandomFilename; var schema = new Schema(); schema.AddIntField("field"); _tableInfo = new TableInfo(tableFile, schema); _recordFile = new RecordFile(_tableInfo, _transaction); _recordFile.BeforeFirst(); _recordFile.Insert(); _recordFile.SetInt("field", 10); _recordFile.Delete(); _transaction.Commit(); var block = new IO.Primitives.Block(tableFile + ".tbl", 0); var page = _fileManager.ResolvePage(block); page.Read(block); page.GetInt(0, out var used); Assert.AreEqual(0, used); }
public void CanCreateIndexOnFilledTable() { var recordFile = new RecordFile(tableInfo, _transaction); recordFile.BeforeFirst(); for (int i = 0; i < 10; ++i) { recordFile.Insert(); recordFile.SetInt("Id", i - 1); } recordFile.Close(); metadataManager = new MetadataManager(_fileManager, tableManager, viewManager, indexManager, statisticsManager); Assert.DoesNotThrow(() => { metadataManager.CreateIndex(RandomFilename, tableName, "Id", _transaction); }); var index = metadataManager.GetIndexInfo(tableName, _transaction); Assert.IsNotNull(index); Assert.AreEqual(0, index["Id"].BlocksAccessed()); Assert.AreEqual(2, index["Id"].RecordsOutput()); }
public void CanGetStatisticsFromNewTableInTheSameTransaction() { manager = new StatisticsManager(tableManager, _transaction, tableCatalogName, fieldCatalogName, 1); var newTableName = RandomFilename; var schema = new Schema(); schema.AddIntField("Id"); schema.AddStringField("Guid", 40); var newTableInfo = new TableInfo(newTableName, schema); tableManager.CreateTable(newTableName, schema, _transaction); var recordFile = new RecordFile(newTableInfo, _transaction); recordFile.BeforeFirst(); for (int i = 0; i < 50; ++i) { recordFile.Insert(); recordFile.SetInt("Id", i + 10); recordFile.SetString("Guid", Guid.NewGuid().ToString()); } var updatedData = manager.GetStatisticalInfo(newTableName, _transaction); Assert.AreEqual(50, updatedData.RecordsOutput); Assert.AreEqual(3, updatedData.BlocksAccessed); Assert.AreEqual(17, updatedData.DistinctValues("Id")); }
public void CanGetStatisticsFromTableFilledWithValuesInTheSameTransaction() { manager = new StatisticsManager(tableManager, _transaction, tableCatalogName, fieldCatalogName, 1); var data = manager.GetStatisticalInfo(tableName, _transaction); var recordFile = new RecordFile(tableInfo, _transaction); recordFile.BeforeFirst(); for (int i = 0; i < 30; ++i) { recordFile.Insert(); recordFile.SetInt("Id", i + 10); } //Before update Assert.AreEqual(1, data.BlocksAccessed); Assert.AreEqual(0, data.RecordsOutput); Assert.AreEqual(1, data.DistinctValues("Id")); //After update var updatedData = manager.GetStatisticalInfo(tableName, _transaction); Assert.AreEqual(30, updatedData.RecordsOutput); Assert.AreEqual(1, updatedData.BlocksAccessed); Assert.AreEqual(11, updatedData.DistinctValues("Id")); }
public void CanNavigateThourghExistingRecordsMoreRecords() { var tableFile = RandomFilename; var schema = new Schema(); schema.AddIntField("field"); _tableInfo = new TableInfo(tableFile, schema); _recordFile = new RecordFile(_tableInfo, _transaction); _recordFile.BeforeFirst(); for (int i = 0; i < 12; ++i) { _recordFile.Insert(); _recordFile.SetInt("field", i); } // And this folk would go to the next page _recordFile.Insert(); _recordFile.SetInt("field", 123); _transaction.Commit(); var cm = new ConcurrencyManager(); var newTr = new Transaction(_dispatcher, _bufferManager, cm, _fileManager, _logManager); var rf = new RecordFile(_tableInfo, newTr); rf.BeforeFirst(); for (int i = 0; i < 12; ++i) { rf.Next(); var value = rf.GetInt("field"); Assert.AreEqual(i, value); } rf.Next(); var lastValue = rf.GetInt("field"); Assert.AreEqual(123, lastValue); var canMoveNext = rf.Next(); Assert.IsFalse(canMoveNext); }
public void CreateIndex(string indexName, string tableName, string fieldName, Transaction transaction) { var recordFile = new RecordFile(_tableInfo, transaction); recordFile.Insert(); recordFile.SetString("idxname", indexName); recordFile.SetString("tblname", tableName); recordFile.SetString("fldname", fieldName); recordFile.Close(); }
public void CreateView(string viewName, string viewDefinition, Transaction transaction) { var tableInfo = _tableManager.GetTableInfo(_viewTableName, transaction); var recordFile = new RecordFile(tableInfo, transaction); recordFile.Insert(); recordFile.SetString("viewname", viewName); recordFile.SetString("viewdef", viewDefinition); recordFile.Close(); }
public void CanGetBeforeFirstAndInsertValues() { var tableFile = RandomFilename; var schema = new Schema(); schema.AddIntField("field"); _tableInfo = new TableInfo(tableFile, schema); _recordFile = new RecordFile(_tableInfo, _transaction); _recordFile.BeforeFirst(); _recordFile.Insert(); _recordFile.SetInt("field", 10); _recordFile.Insert(); _recordFile.SetInt("field", 20); _transaction.Commit(); var block = new IO.Primitives.Block(tableFile + ".tbl", 0); var page = _fileManager.ResolvePage(block); page.Read(block); page.GetInt(0, out var used1); page.GetInt(8, out var used2); page.GetInt(4, out var value1); page.GetInt(12, out var value2); Assert.AreEqual(1, used1); Assert.AreEqual(1, used2); Assert.AreEqual(10, value1); Assert.AreEqual(20, value2); }
public void CanCreatePlanFromTableWithData() { var recordFile = new RecordFile(tableInfo, _transaction); recordFile.BeforeFirst(); for (int i = 0; i < 30; ++i) { recordFile.Insert(); recordFile.SetInt("Id", i + 10); } _transaction.Commit(); tablePlan = new TablePlan(tableName, metadataManager, _transaction); Assert.DoesNotThrow(() => { var scan = tablePlan.Open(); }); }
public void CanGetRecordsOutputOnMoreThanOneBlock() { var recordFile = new RecordFile(tableInfo, _transaction); recordFile.BeforeFirst(); for (int i = 0; i < 1024; ++i) { recordFile.Insert(); recordFile.SetInt("Id", i * i); } recordFile.Close(); _transaction.Commit(); _concurrencyManager = new ConcurrencyManager(); _transaction = new Transaction(_dispatcher, _bufferManager, _concurrencyManager, _fileManager, _logManager); indexInfo = new IndexInfo("index", tableName, "Id", tableManager, statisticsManager, _transaction, 1024); var recordsOutput = indexInfo.RecordsOutput(); Assert.AreEqual(2, recordsOutput); }
public void CreateTable(string tableName, Schema schema, Transaction transaction) { var tableInfo = new TableInfo(tableName, schema); var tableCatalogFile = new RecordFile(_tableCatalogInfo, transaction); tableCatalogFile.Insert(); tableCatalogFile.SetString("tblname", tableName); tableCatalogFile.SetInt("reclength", tableInfo.RecordLength); tableCatalogFile.Close(); var fieldCatalogFile = new RecordFile(_fieldCatalogInfo, transaction); foreach (var fieldName in schema.Fields) { fieldCatalogFile.Insert(); fieldCatalogFile.SetString("tblname", tableName); fieldCatalogFile.SetString("fldname", fieldName.Key); fieldCatalogFile.SetInt("type", (int)fieldName.Value.Type); fieldCatalogFile.SetInt("length", fieldName.Value.Length); fieldCatalogFile.SetInt("offset", tableInfo.Offset(fieldName.Key)); } fieldCatalogFile.Close(); }
public void Insert() => _recordFile.Insert();