OpportunityLineItem in test classes

Question

I am trying to insert OpportunityLineItem record in my test class but unable to insert.

Account acc = new Account(Name = 'Test');
insert acc;

Opportunity oppObj = new Opportunity(Name = 'TestOpp',AccountID = acc.Id,Amount = 2000,CloseDate=Date.today(),StageName='Close Won',Type='New Customer');
insert oppObj;

Product2 newProd = new Product2(Name = 'test product', family = 'test family');
insert newProd;

PriceBookEntry pbEntry = new PriceBookEntry(
    UnitPrice = 300,
    PriceBook2Id = [select id from PriceBook2 where isStandard = true].Id,
    Product2Id = newProd.Id,
    IsActive = true);

insert pbEntry ;

OpportunityLineItem oppLine = new OpportunityLineItem(pricebookentryid=pbEntry.Id,TotalPrice=2000,Quantity = 2,OpportunityID = oppObj.Id);
insert oppLine;

[select id from PriceBook2 where isStandard = true] is not returning any data.

any idea how to insert OpportunityLineItem.

Thanks

Answer 1

Instead of of this:

Pricebook = [select id from PriceBook2 where isStandard = true].Id

Why not try this instead?

PriceBook2Id = Test.getStandardPricebookId()

Answer 2

The reason it is not working in your test class is because to run SOQL query on data in org use need to annotate the Test class with SeeAllData=true. Else you can use Test.getStandardPricebookId(); to get ID of the standard price book in your organization regardless of whether the test can query organization data (irrespective of the state of SeeAllData).