public long GetTransactionSourceOutputRowsToUpdate()
{
const string sqlCountRowsToUpdateCommand = @"SELECT COUNT(1) FROM TransactionInput WHERE SourceTransactionOutputId = -1";
return(AdoNetLayer.ConvertDbValue <int>(this.adoNetLayer.ExecuteScalar(sqlCountRowsToUpdateCommand)));
}
public bool IsSchemaSetup()
{
return(AdoNetLayer.ConvertDbValue <int>(this.adoNetLayer.ExecuteScalar(
"SELECT CASE WHEN EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'dbo' AND TABLE_NAME = 'BtcDbSettings') THEN 1 ELSE 0 END AS IsSchemaSetup")) == 1);
}
public string GetLastKnownBlockchainFileName()
{
return(AdoNetLayer.ConvertDbValue <string>(this.adoNetLayer.ExecuteScalar("SELECT TOP 1 BlockchainFileName FROM BlockchainFile ORDER BY BlockchainFileId DESC")));
}
public bool IsDatabaseEmpty()
{
return(AdoNetLayer.ConvertDbValue <int>(this.adoNetLayer.ExecuteScalar("SELECT CASE WHEN EXISTS (SELECT 1 FROM Block) THEN 0 ELSE 1 END AS IsEmpty")) == 1);
}