Method getTableIndexes

src/connectors/sqlite/index.ts:312–384

(tableName: string, schema?: string)

  }

  async getTableIndexes(tableName: string, schema?: string): Promise<TableIndex[]> {
    if (!this.db) {
      throw new Error("Not connected to SQLite database");
    }

    // In SQLite, schema parameter is ignored (no schema concept)
    try {
      // Get all indexes for the specified table
      const indexInfoRows = this.queryAll<{ index_name: string; is_unique: number }>(
        `
        SELECT
          name as index_name,
          0 as is_unique
        FROM sqlite_master
        WHERE type = 'index'
        AND tbl_name = ?
      `,
        tableName
      );

      // Get unique info from PRAGMA index_list which provides the unique flag
      // Note: PRAGMA commands require proper identifier quoting for special characters
      const quotedTableName = quoteIdentifier(tableName, "sqlite");
      const indexListRows = this.queryAll<{ name: string; unique: number }>(
        `PRAGMA index_list(${quotedTableName})`
      );

      // Create a map of index names to unique status
      const indexUniqueMap = new Map<string, boolean>();
      for (const indexListRow of indexListRows) {
        indexUniqueMap.set(indexListRow.name, indexListRow.unique === 1);
      }

      // Get the primary key info
      const tableInfo = this.queryAll<SQLiteTableInfo>(`PRAGMA table_info(${quotedTableName})`);

      // Find primary key columns
      const pkColumns = tableInfo.filter((col) => col.pk > 0).map((col) => col.name);

      const results: TableIndex[] = [];

      // Add regular indexes
      for (const indexInfo of indexInfoRows) {
        // Get the columns for this index
        const quotedIndexName = quoteIdentifier(indexInfo.index_name, "sqlite");
        const indexDetailRows = this.queryAll<{ name: string }>(
          `PRAGMA index_info(${quotedIndexName})`
        );
        const columnNames = indexDetailRows.map((row) => row.name);

        results.push({
          index_name: indexInfo.index_name,
          column_names: columnNames,
          is_unique: indexUniqueMap.get(indexInfo.index_name) || false,
          is_primary: false,
        });
      }