/*
 * Copyright (C) 2023 The Android Open Source Project
 *
 * Licensed 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.
 */

package com.android.server.healthconnect.storage.request;

import java.util.List;

/**
 * Creates a new index in the given table.
 *
 * @hide
 */
public final class CreateIndexRequest {

    private final String mTableName;
    private final String mIndexName;
    private final boolean mIsUnique;
    private final List<String> mColumnNames;

    public CreateIndexRequest(
            String tableName, String indexName, boolean isUnique, List<String> columnNames) {
        if (columnNames.isEmpty()) {
            throw new IllegalArgumentException("Index must have at least one column");
        }
        mTableName = tableName;
        mIndexName = indexName;
        mIsUnique = isUnique;
        mColumnNames = columnNames;
    }

    /** Returns a ready-for-use SQL command. */
    public String getCommand() {
        final StringBuilder builder = new StringBuilder("CREATE ");

        if (mIsUnique) {
            builder.append("UNIQUE ");
        }

        builder.append("INDEX ")
                .append(mIndexName)
                .append(" ON ")
                .append(mTableName)
                .append(" (")
                .append(String.join(", ", mColumnNames))
                .append(")");

        return builder.toString();
    }
}