Hey guys,

we've recently started implementing SF, and I'm helping out with the VF pages and Apex Classes. My background is mainly web development, but have struggled through the Apex Class parts of this process. During the trial I wrote a class that we were able to utilize, However since going live I've been introduced to the Sandbox and TestMethod steps.

I spent the best part of yesterday wrestling with my Class, trying to build some testMethods to cover the code. I understand the importance of this and want to do it properly however I've ran into a few issues that I was hoping I might get help on.

I should note that the class works absolutely fine, I'm just unable to edit it in any way until I can write a testMethod that works.

First some info... I've written an extension class for an Article Type (Knowledge) standard controller. It is currently implemented like so:

public class queryDocument{
     
    public queryDocument(ApexPages.StandardController stdController) {
    }

}

 This appeared to be the accepted way to get an extension written.

So my questions are as follows:

1. How do I get access to the Record's Fields in the Class without using: "ApexPages.currentPage().getParameters().get('id');" and running a SOQL for each method.
2. Or How can I write a testMethod (within this Class) to spoof the CurrentRecord / or Page... I think I've got this done, but wanted to check
   

   // Do an Insert
   List<Virtual_Support_Team__kav> testList = new List<Virtual_Support_Team__kav>{};
   Virtual_Support_Team__kav testItem = new Virtual_Support_Team__kav(Title = 'TestTitle', UrlName = 'TestTitle', Section_Code__c = 'TestCode', Product__c = 'TestProduct');
   testList.add(testItem);
   Insert testList;
   // Retrieve Insert
   List<Virtual_Support_Team__kav> insertedItem = [SELECT Title, Id, KnowledgeArticleId FROM Virtual_Support_Team__kav WHERE Id IN :testList];
   
   // Set ID
   PageReference testPage = new PageReference('/apex/VirtualSupportTeam?id='+insertedItem[0].KnowledgeArticleId ); 
   Test.setCurrentPage(testPage);

3. Lastly my main problem/question... The KnowledgeArticleVersion table (which is what is the model used when requesting custom object Virtual_Support_Team__kav), requires that your SELECT includes a PublishStatus and Language condition (WHERE). The problem is, any INSERT done via the API by default gets the PublishStatus = Draft, and you cannot set this to Online, which is the condition I SELECT based on in my code. How can I ever get the testMethod to cover these portions of code? An example of my code is below:
   

   /**[ Video Content from Guide Article ]********************/
   public List<ContentVersion> getVideoContentFromGuide() {
   	// Get Article ID
   	String articleId = ApexPages.currentPage().getParameters().get('id');
   	
   	// Get current Article Details
   	List<Virtual_Support_Team__kav> art = new List<Virtual_Support_Team__kav>();
   	art = [SELECT Section_Code__c, Product__c FROM Virtual_Support_Team__kav WHERE KnowledgeArticleId = :articleId AND PublishStatus = 'Online' AND Language = 'en_US'];
   
   	// Prepare Related List Object
   	List<ContentVersion> videos = new List<ContentVersion>();
   			
   	//Handle no Article
   	if (art.size() != 0){
   		// Build Search Term
   		String searchTerm = art[0].Product__c + '%Training Video%[%' + art[0].Section_Code__c + '%]%';
   		
   		// Look for Video Content
   		videos = [SELECT Id, ContentDocument.title, ContentDocument.LatestPublishedVersionId, ContentUrl, FileType FROM ContentVersion WHERE ContentDocument.Title LIKE :searchTerm AND PublishStatus = 'P' AND isLatest = true LIMIT 1];
   	}
   	
   	// List of Video from Content Library
   	return videos;      
   }

Any advice would be greatly appreciated. As I'm at a bit of a loss.

cheers,

Jon