public void InvalidQuarterlyDatabase()
{
using (var qdb = new QuarterlyDatabase())
{
Assert.False(qdb.Load("2015q5"));
}
}
public void ValidQuarterlyDatabase()
{
using (var qdb = new QuarterlyDatabase())
{
Assert.True(qdb.Load("2015q4"));
}
}
public void GetAllPreRecords()
{
using (var qdb = new QuarterlyDatabase())
{
qdb.Load("2015q4");
var allRecords = qdb.Pre.Records;
Assert.Equal <int>(885791, allRecords.Count);
}
}
public void GetAllSubRecords()
{
using (var qdb = new QuarterlyDatabase())
{
qdb.Load("2015q4");
var allRecords = qdb.Sub.Records;
Assert.Equal <int>(6928, allRecords.Count);
}
}
public void FindExactlyOneSubRecordForCik913290()
{
using (var qdb = new QuarterlyDatabase())
{
qdb.Load("2015q4");
var matchingRecords = qdb.Sub.GetRecordsMatchingCik("913290");
Assert.Equal <int>(1, matchingRecords.Count);
}
}
public void GetAllTagRecords()
{
using (var qdb = new QuarterlyDatabase())
{
qdb.Load("2015q4");
var allRecords = qdb.Tag.Records;
Assert.Equal <int>(70602, allRecords.Count);
}
}
public void GetAllNumRecords()
{
using (var qdb = new QuarterlyDatabase())
{
qdb.Load("2015q4");
var allRecords = qdb.Num.Records;
Assert.Equal <int>(1800907, allRecords.Count);
}
}
public void EnsureNoMatchingNumRecordForFirstPreRecord()
{
using (var qdb = new QuarterlyDatabase())
{
qdb.Load("2015q4");
var firstPreRecord = qdb.Pre.Records[0];
var matchingNumRecords = qdb.Num.GetRecordsMatchingAccessionNumberTagAndVersion(firstPreRecord.AccessionNumber, firstPreRecord.Tag, firstPreRecord.Version);
Assert.True(matchingNumRecords.Count == 0);
}
}
public void CheckXbrlInstanceUrlOnSubRecordForCik913290()
{
using (var qdb = new QuarterlyDatabase())
{
qdb.Load("2015q4");
var matchingRecords = qdb.Sub.GetRecordsMatchingCik("913290");
var match = matchingRecords[0];
Assert.Equal <string>("http://www.sec.gov/Archives/edgar/data/913290/000091329015000007/fro-20150630.xml", match.XbrlInstanceUrl);
}
}
public void CheckFilingStatusOnSubRecordForCik913290()
{
using (var qdb = new QuarterlyDatabase())
{
qdb.Load("2015q4");
var matchingRecords = qdb.Sub.GetRecordsMatchingCik("913290");
var match = matchingRecords[0];
Assert.Equal <SubRecord.FilerStatusValue>(SubRecord.FilerStatusValue.Accelerated, match.FilerStatus);
}
}
public void CheckFilingDateOnSubRecordForCik913290()
{
using (var qdb = new QuarterlyDatabase())
{
qdb.Load("2015q4");
var matchingRecords = qdb.Sub.GetRecordsMatchingCik("913290");
var match = matchingRecords[0];
var expectedDate = new DateTime(2015, 10, 5);
Assert.Equal <DateTime>(expectedDate, match.FilingDate);
}
}
public void GetMatchingSubRecordForFirstNumRecord()
{
using (var qdb = new QuarterlyDatabase())
{
qdb.Load("2015q4");
var firstPreRecord = qdb.Pre.Records[0];
var matchingSubRecords = qdb.Sub.GetRecordsMatchingAccessionNumber(firstPreRecord.AccessionNumber);
Assert.True(matchingSubRecords.Count == 1);
var matchingSubRecord = matchingSubRecords[0];
Assert.Equal <string>(firstPreRecord.AccessionNumber, matchingSubRecord.AccessionNumber);
}
}
public void GetMatchingTagRecordForFirstPreRecord()
{
using (var qdb = new QuarterlyDatabase())
{
qdb.Load("2015q4");
var firstPreRecord = qdb.Pre.Records[0];
var matchingTagRecords = qdb.Tag.GetRecordsMatchingTagAndVersion(firstPreRecord.Tag, firstPreRecord.Version);
Assert.True(matchingTagRecords.Count == 1);
var matchingTagRecord = matchingTagRecords[0];
Assert.Equal <string>(firstPreRecord.Tag, matchingTagRecord.Tag);
Assert.Equal <string>(firstPreRecord.Version, matchingTagRecord.Version);
}
}
public void GetMatchingNumRecordForPreRecord()
{
using (var qdb = new QuarterlyDatabase())
{
qdb.Load("2015q4");
var firstPreRecord = qdb.Pre.Records[9];
var matchingNumRecords = qdb.Num.GetRecordsMatchingAccessionNumberTagAndVersion(firstPreRecord.AccessionNumber, firstPreRecord.Tag, firstPreRecord.Version);
Assert.True(matchingNumRecords.Count > 0);
foreach (var matchingNumRecord in matchingNumRecords)
{
Assert.Equal <string>(firstPreRecord.AccessionNumber, matchingNumRecord.AccessionNumber);
Assert.Equal <string>(firstPreRecord.Tag, matchingNumRecord.Tag);
Assert.Equal <string>(firstPreRecord.Version, matchingNumRecord.Version);
}
}
}
