tests/e2e/SessionPool.test.ts

/**
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 */

import { SessionPool } from '../../src/client/SessionPool';

describe('SessionPool E2E Tests', () => {
  const IOTDB_HOST = process.env.IOTDB_HOST || 'localhost';
  const IOTDB_PORT = parseInt(process.env.IOTDB_PORT || '6667');
  const IOTDB_USER = process.env.IOTDB_USER || 'root';
  const IOTDB_PASSWORD = process.env.IOTDB_PASSWORD || 'root';

  let pool: SessionPool;
  let isConnected = false;

  beforeAll(async () => {
    pool = new SessionPool(IOTDB_HOST, IOTDB_PORT, {
      username: IOTDB_USER,
      password: IOTDB_PASSWORD,
      maxPoolSize: 5,
      minPoolSize: 2
    });

    try {
      await pool.init();
      isConnected = true;
    } catch (error) {
      console.warn('Could not connect to IoTDB. E2E tests will be skipped.');
      console.warn('Set IOTDB_HOST, IOTDB_PORT to run E2E tests against a real instance.');
    }
  }, 60000);

  afterAll(async () => {
    if (pool && isConnected) {
      await pool.close();
    }
  }, 60000);

  test('Should initialize pool with minimum connections', async () => {
    if (!isConnected) {
      console.log('Skipping test - no IoTDB connection');
      return;
    }

    expect(pool.getPoolSize()).toBeGreaterThanOrEqual(2);
  });

  test('Should execute query using pool', async () => {
    if (!isConnected) {
      console.log('Skipping test - no IoTDB connection');
      return;
    }

    const result = await pool.executeQueryStatement('SHOW DATABASES');

    expect(result).toBeDefined();
    expect(result.columns).toBeDefined();
    expect(Array.isArray(result.rows)).toBe(true);
  });

  test('Should execute non-query using pool', async () => {
    if (!isConnected) {
      console.log('Skipping test - no IoTDB connection');
      return;
    }

    try {
      await pool.executeNonQueryStatement('CREATE DATABASE root.test_pool');
      // Should not throw
    } catch (error: any) {
      // Might fail if database already exists, that's ok
      if (!error.message.includes('already exists')) {
        throw error;
      }
    }
  });

  test('Should handle multiple concurrent queries', async () => {
    if (!isConnected) {
      console.log('Skipping test - no IoTDB connection');
      return;
    }

    const promises = [];
    for (let i = 0; i < 10; i++) {
      promises.push(pool.executeQueryStatement('SHOW DATABASES'));
    }

    const results = await Promise.all(promises);

    expect(results).toHaveLength(10);
    results.forEach((result) => {
      expect(result).toBeDefined();
      expect(result.columns).toBeDefined();
    });
  });

  test('Should insert tablet using pool', async () => {
    if (!isConnected) {
      console.log('Skipping test - no IoTDB connection');
      return;
    }

    const tablet = {
      deviceId: 'root.test_pool.device1',
      measurements: ['temperature'],
      dataTypes: [3], // FLOAT
      timestamps: [Date.now()],
      values: [[25.5]],
    };

    try {
      await pool.insertTablet(tablet);
      // Should not throw
    } catch (error: any) {
      console.warn('Insert tablet via pool failed:', error.message);
    }
  });

  test('Should support multi-node configuration', async () => {
    // Skip this test in 1C1D setup - only run in 3C3D
    if (!process.env.MULTI_NODE) {
      console.log('Skipping multi-node test in 1C1D configuration');
      return;
    }

    const multiNodePool = new SessionPool(
      [IOTDB_HOST, 'localhost'],
      IOTDB_PORT,
      {
        username: IOTDB_USER,
        password: IOTDB_PASSWORD,
        maxPoolSize: 3,
        minPoolSize: 1,
      }
    );

    try {
      await multiNodePool.init();
      expect(multiNodePool.getPoolSize()).toBeGreaterThanOrEqual(1);
      await multiNodePool.close();
    } catch (error) {
      console.warn('Multi-node test failed, this is expected if IoTDB is not available');
    }
  });

  test('Should report pool statistics', async () => {
    if (!isConnected) {
      console.log('Skipping test - no IoTDB connection');
      return;
    }

    const poolSize = pool.getPoolSize();
    const availableSize = pool.getAvailableSize();

    expect(poolSize).toBeGreaterThan(0);
    expect(availableSize).toBeGreaterThanOrEqual(0);
    expect(availableSize).toBeLessThanOrEqual(poolSize);
  });

  test('Should support explicit session management with getSession/releaseSession', async () => {
    if (!isConnected) {
      console.log('Skipping test - no IoTDB connection');
      return;
    }

    // Get a session from the pool
    const session = await pool.getSession();
    expect(session).toBeDefined();
    expect(session.isOpen()).toBe(true);

    // Track pool statistics
    const inUseBefore = pool.getInUseSize();
    const availableBefore = pool.getAvailableSize();

    try {
      // Execute operations with the explicit session
      const result = await session.executeQueryStatement('SHOW DATABASES');
      expect(result).toBeDefined();
      expect(result.columns).toBeDefined();

      // Session should still be open
      expect(session.isOpen()).toBe(true);

    } finally {
      // Release the session back to the pool
      pool.releaseSession(session);
    }

    // Verify pool statistics updated correctly
    const inUseAfter = pool.getInUseSize();
    const availableAfter = pool.getAvailableSize();
    
    expect(inUseAfter).toBe(inUseBefore - 1);
    expect(availableAfter).toBe(availableBefore + 1);
  });

  test('Should handle multiple explicit sessions concurrently', async () => {
    if (!isConnected) {
      console.log('Skipping test - no IoTDB connection');
      return;
    }

    const sessionPromises = [];
    
    // Get multiple sessions concurrently
    for (let i = 0; i < 3; i++) {
      sessionPromises.push(
        pool.getSession().then(async (session) => {
          try {
            // Execute a query with this session
            const result = await session.executeQueryStatement('SHOW DATABASES');
            expect(result).toBeDefined();
            return session;
          } catch (error) {
            pool.releaseSession(session);
            throw error;
          }
        })
      );
    }

    const sessions = await Promise.all(sessionPromises);
    
    // All sessions should be valid
    expect(sessions.length).toBe(3);
    sessions.forEach(session => {
      expect(session.isOpen()).toBe(true);
    });

    // Release all sessions
    sessions.forEach(session => {
      pool.releaseSession(session);
    });

    // All sessions should be available again
    expect(pool.getAvailableSize()).toBeGreaterThanOrEqual(3);
  });
});