docstr:     This testcase make sure that the `batch_mem_size` is correctly passed to
  the storage engine.
docstr_tok: ["This","testcase","make","sure","that","the","`","batch_mem_size","`","is","correctly","passed","to","the","storage","engine","."]
code: def test_batch_mem_size_for_sqlite_storage_engine(self):
      """
          This testcase make sure that the `batch_mem_size` is correctly passed to
      the storage engine.
      """
      test_batch_mem_size = 100
      execute_query_fetch_all(
          self.evadb, f"SET batch_mem_size={test_batch_mem_size}"
      )
      create_table_query = """
              CREATE TABLE IF NOT EXISTS MyCSV (
                  id INTEGER UNIQUE,
                  frame_id INTEGER,
                  video_id INTEGER,
                  dataset_name TEXT(30),
                  label TEXT(30),
                  bbox NDARRAY FLOAT32(4),
                  object_id INTEGER
              );"""
      execute_query_fetch_all(self.evadb, create_table_query)
  
      select_table_query = "SELECT * FROM MyCSV;"
      with patch.object(SQLStorageEngine, "read") as mock_read:
          mock_read.__iter__.return_value = []
          execute_query_fetch_all(self.evadb, select_table_query)
          mock_read.assert_called_with(ANY, test_batch_mem_size)
  
file_path: evadb/test/unit_tests/optimizer/rules/test_batch_mem_size.py
imports: import unittest
  from test.util import get_evadb_for_testing
  from mock import ANY, patch
  from evadb.server.command_handler import execute_query_fetch_all
  from evadb.storage.sqlite_storage_engine import SQLStorageEngine
label_desc: Use image node_id 3 for calling the BatchMemSizeTest obj's underlying member method code with example usage: obj.test_batch_mem_size_for_sqlite_storage_engine() without return types