code: def test_completion_openai_with_prompt_template(self):
      # create project
      self.run_sql("create database proj")
  
      # completion with openai using prompt_template in create with single format variable
  
      self.run_sql(
          f"""
              CREATE MODEL proj.test_litellm_handler_on_completion_openai_prompt_template
              PREDICT text
              USING
              engine="litellm",
              model="gpt-3.5-turbo",
              api_key='{OPENAI_API_KEY}',
              prompt_template="I like to eat {{text}}"
              """
      )
  
      self.wait_predictor(
          "proj",
          "test_litellm_handler_on_completion_openai_prompt_template",
      )
  
      # run predict
  
      ret = self.run_sql(
          """
              SELECT *
              FROM proj.test_litellm_handler_on_completion_openai_prompt_template
              where text = "pizza" and mock_response = "test"
              """
      )
  
      assert ret["result"][0]
  
      # completion with openai using prompt_template in create with multiple format variables
  
      self.run_sql(
          f"""
              CREATE MODEL proj.test_litellm_handler_on_completion_openai_prompt_template_multiple
              PREDICT text
              USING
              engine="litellm",
              model="gpt-3.5-turbo",
              api_key='{OPENAI_API_KEY}',
              prompt_template="I like to eat {{text1}} and {{text2}}"
              """
      )
  
      self.wait_predictor(
          "proj",
          "test_litellm_handler_on_completion_openai_prompt_template_multiple",
      )
  
      # run predict
  
      ret = self.run_sql(
          """
              SELECT *
              FROM proj.test_litellm_handler_on_completion_openai_prompt_template_multiple
              where text1 = "pizza" and text2 = "pasta" and mock_response = "test"
              """
      )
  
      assert ret["result"][0]
  
      # use prompt_template in predict
  
      self.run_sql(
          """
              CREATE MODEL proj.test_litellm_handler_on_completion_openai_prompt_template_predict
              PREDICT text
              USING
              engine="litellm",
              model="gpt-3.5-turbo",
              api_key='{OPENAI_API_KEY}'
              """
      )
  
      self.wait_predictor(
          "proj",
          "test_litellm_handler_on_completion_openai_prompt_template_predict",
      )
  
      # run predict
  
      ret = self.run_sql(
          """
              SELECT *
              FROM proj.test_litellm_handler_on_completion_openai_prompt_template_predict
              where text = "pizza" and prompt_template = "I like to eat {{text}}" and mock_response = "test"
              """
      )
  
      assert ret["result"][0]
  
file_path: mindsdb/mindsdb/integrations/handlers/litellm_handler/tests/test_litellm.py
imports: import os
  import time
  import pandas
  import pytest
  from mindsdb_sql import parse_sql
  from tests.unit.executor_test_base import BaseExecutorTest
label_desc: Use image node_id 4 for calling the TestLiteLLM obj's underlying member method code with example usage: obj.test_completion_openai_with_prompt_template() without return types