/*
**
** Copyright (C) 2014, 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.providers.telephony;

import android.content.ContentProvider;
import android.content.ContentUris;
import android.content.ContentValues;
import android.content.UriMatcher;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteQueryBuilder;
import android.database.Cursor;
import android.database.SQLException;
import android.net.Uri;
import android.text.TextUtils;
import android.util.Log;
import java.util.HashMap;

import com.android.internal.telephony.HbpcdLookup;
import com.android.internal.telephony.HbpcdLookup.MccIdd;
import com.android.internal.telephony.HbpcdLookup.MccLookup;
import com.android.internal.telephony.HbpcdLookup.MccSidConflicts;
import com.android.internal.telephony.HbpcdLookup.ArbitraryMccSidMatch;
import com.android.internal.telephony.HbpcdLookup.MccSidRange;
import com.android.internal.telephony.HbpcdLookup.NanpAreaCode;

public class HbpcdLookupProvider extends ContentProvider {
    private static boolean DBG = false;
    private static final String TAG = "HbpcdLookupProvider";

    public static final String TABLE_MCC_IDD = "mcc_idd";
    public static final String TABLE_MCC_LOOKUP_TABLE = "mcc_lookup_table";
    public static final String TABLE_MCC_SID_CONFLICT = "mcc_sid_conflict";
    public static final String TABLE_MCC_SID_RANGE = "mcc_sid_range";
    public static final String TABLE_NANP_AREA_CODE = "nanp_area_code";
    public static final String TABLE_ARBITRARY_MCC_SID_MATCH= "arbitrary_mcc_sid_match";

    private static final int MCC_IDD = 1;
    private static final int MCC_LOOKUP_TABLE = 2;
    private static final int MCC_SID_CONFLICT = 3;
    private static final int MCC_SID_RANGE = 4;
    private static final int NANP_AREA_CODE = 5;
    private static final int ARBITRARY_MCC_SID_MATCH = 6;
    private static final int MCC_IDD_ID = 8;
    private static final int MCC_LOOKUP_TABLE_ID = 9;
    private static final int MCC_SID_CONFLICT_ID = 10;
    private static final int MCC_SID_RANGE_ID = 11;
    private static final int NANP_AREA_CODE_ID = 12;
    private static final int ARBITRARY_MCC_SID_MATCH_ID = 13;

    private static final UriMatcher sURIMatcher = new UriMatcher(UriMatcher.NO_MATCH);

    private static final HashMap<String, String> sIddProjectionMap;
    private static final HashMap<String, String> sLookupProjectionMap;
    private static final HashMap<String, String> sConflictProjectionMap;
    private static final HashMap<String, String> sRangeProjectionMap;
    private static final HashMap<String, String> sNanpProjectionMap;
    private static final HashMap<String, String> sArbitraryProjectionMap;

    static {
        sURIMatcher.addURI(HbpcdLookup.AUTHORITY, HbpcdLookup.PATH_MCC_IDD, MCC_IDD);
        sURIMatcher.addURI(HbpcdLookup.AUTHORITY,
                HbpcdLookup.PATH_MCC_LOOKUP_TABLE, MCC_LOOKUP_TABLE);
        // following URI is a joint table of MCC_LOOKUP_TABLE and MCC_SID_CONFLIct.
        sURIMatcher.addURI(HbpcdLookup.AUTHORITY,
                HbpcdLookup.PATH_MCC_SID_CONFLICT, MCC_SID_CONFLICT);
        sURIMatcher.addURI(HbpcdLookup.AUTHORITY, HbpcdLookup.PATH_MCC_SID_RANGE, MCC_SID_RANGE);
        sURIMatcher.addURI(HbpcdLookup.AUTHORITY, HbpcdLookup.PATH_NANP_AREA_CODE, NANP_AREA_CODE);
        sURIMatcher.addURI(HbpcdLookup.AUTHORITY,
                HbpcdLookup.PATH_ARBITRARY_MCC_SID_MATCH, ARBITRARY_MCC_SID_MATCH);
        sURIMatcher.addURI(HbpcdLookup.AUTHORITY, HbpcdLookup.PATH_MCC_IDD + "/#", MCC_IDD_ID);
        sURIMatcher.addURI(HbpcdLookup.AUTHORITY,
                HbpcdLookup.PATH_MCC_LOOKUP_TABLE + "/#", MCC_LOOKUP_TABLE_ID);
        sURIMatcher.addURI(HbpcdLookup.AUTHORITY,
                HbpcdLookup.PATH_MCC_SID_CONFLICT + "/#", MCC_SID_CONFLICT_ID);
        sURIMatcher.addURI(HbpcdLookup.AUTHORITY,
                HbpcdLookup.PATH_MCC_SID_RANGE + "/#", MCC_SID_RANGE_ID);
        sURIMatcher.addURI(HbpcdLookup.AUTHORITY,
                HbpcdLookup.PATH_NANP_AREA_CODE + "/#", NANP_AREA_CODE_ID);
        sURIMatcher.addURI(HbpcdLookup.AUTHORITY,
                HbpcdLookup.PATH_ARBITRARY_MCC_SID_MATCH + "/#", ARBITRARY_MCC_SID_MATCH_ID);

        sIddProjectionMap = new HashMap<String, String>();
        sIddProjectionMap.put(HbpcdLookup.ID, HbpcdLookup.ID);
        sIddProjectionMap.put(MccIdd.MCC, MccIdd.MCC);
        sIddProjectionMap.put(MccIdd.IDD, MccIdd.IDD);

        sLookupProjectionMap = new HashMap<String, String>();
        sLookupProjectionMap.put(HbpcdLookup.ID, HbpcdLookup.ID);
        sLookupProjectionMap.put(MccLookup.MCC, MccLookup.MCC);
        sLookupProjectionMap.put(MccLookup.COUNTRY_CODE, MccLookup.COUNTRY_CODE);
        sLookupProjectionMap.put(MccLookup.COUNTRY_NAME, MccLookup.COUNTRY_NAME);
        sLookupProjectionMap.put(MccLookup.NDD, MccLookup.NDD);
        sLookupProjectionMap.put(MccLookup.NANPS, MccLookup.NANPS);
        sLookupProjectionMap.put(MccLookup.GMT_OFFSET_LOW, MccLookup.GMT_OFFSET_LOW);
        sLookupProjectionMap.put(MccLookup.GMT_OFFSET_HIGH, MccLookup.GMT_OFFSET_HIGH);
        sLookupProjectionMap.put(MccLookup.GMT_DST_LOW, MccLookup.GMT_DST_LOW);
        sLookupProjectionMap.put(MccLookup.GMT_DST_HIGH, MccLookup.GMT_DST_HIGH);

        // when we do query, we will join it with MccLookup table
        sConflictProjectionMap = new HashMap<String, String>();
        // MccLookup.MCC is duped to MccSidConflicts.MCC
        sConflictProjectionMap.put(MccLookup.GMT_OFFSET_LOW,
                TABLE_MCC_LOOKUP_TABLE + "." + MccLookup.GMT_OFFSET_LOW);
        sConflictProjectionMap.put(MccLookup.GMT_OFFSET_HIGH,
                TABLE_MCC_LOOKUP_TABLE + "." + MccLookup.GMT_OFFSET_HIGH);
        sConflictProjectionMap.put(MccLookup.GMT_DST_LOW,
                TABLE_MCC_LOOKUP_TABLE + "." + MccLookup.GMT_DST_LOW);
        sConflictProjectionMap.put(MccLookup.GMT_DST_HIGH,
                TABLE_MCC_LOOKUP_TABLE + "." + MccLookup.GMT_DST_HIGH);
        sConflictProjectionMap.put(MccSidConflicts.MCC,
                TABLE_MCC_SID_CONFLICT + "." + MccSidConflicts.MCC);
        sConflictProjectionMap.put(MccSidConflicts.SID_CONFLICT,
                TABLE_MCC_SID_CONFLICT + "." + MccSidConflicts.SID_CONFLICT);

        sRangeProjectionMap = new HashMap<String, String>();
        sRangeProjectionMap.put(HbpcdLookup.ID, HbpcdLookup.ID);
        sRangeProjectionMap.put(MccSidRange.MCC, MccSidRange.MCC);
        sRangeProjectionMap.put(MccSidRange.RANGE_LOW, MccSidRange.RANGE_LOW);
        sRangeProjectionMap.put(MccSidRange.RANGE_HIGH, MccSidRange.RANGE_HIGH);

        sNanpProjectionMap = new HashMap<String, String>();
        sNanpProjectionMap.put(HbpcdLookup.ID, HbpcdLookup.ID);
        sNanpProjectionMap.put(NanpAreaCode.AREA_CODE, NanpAreaCode.AREA_CODE);

        sArbitraryProjectionMap = new HashMap<String, String>();
        sArbitraryProjectionMap.put(HbpcdLookup.ID, HbpcdLookup.ID);
        sArbitraryProjectionMap.put(ArbitraryMccSidMatch.MCC, ArbitraryMccSidMatch.MCC);
        sArbitraryProjectionMap.put(ArbitraryMccSidMatch.SID, ArbitraryMccSidMatch.SID);
    }

    private HbpcdLookupDatabaseHelper mDbHelper;

    @Override
    public boolean onCreate() {
        if (DBG) {
            Log.d(TAG, "onCreate");
        }
        mDbHelper = new HbpcdLookupDatabaseHelper(getContext());

        mDbHelper.getReadableDatabase();
        return true;
    }

    @Override
    public String getType(Uri uri) {
        if (DBG) {
            Log.d(TAG, "getType");
        }

        return null;
    }

    @Override
    public Cursor query(Uri uri, String[] projectionIn, String selection,
                        String[] selectionArgs, String sortOrder) {
        SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
        String orderBy = null;
        String groupBy = null;
        boolean useDefaultOrder = TextUtils.isEmpty(sortOrder);

        int match = sURIMatcher.match(uri);
        switch (match) {
            case MCC_IDD: {
                qb.setTables(TABLE_MCC_IDD);
                qb.setProjectionMap(sIddProjectionMap);
                if (useDefaultOrder) {
                    orderBy = MccIdd.DEFAULT_SORT_ORDER;
                }
                break;
            }
            case MCC_LOOKUP_TABLE: {
                qb.setTables(TABLE_MCC_LOOKUP_TABLE);
                qb.setProjectionMap(sLookupProjectionMap);
                if (useDefaultOrder) {
                    orderBy = MccLookup.DEFAULT_SORT_ORDER;
                }
                groupBy = MccLookup.COUNTRY_NAME;
                break;
            }
            case MCC_SID_CONFLICT: {
                StringBuilder joinT = new StringBuilder();
                joinT.append(TABLE_MCC_LOOKUP_TABLE);
                joinT.append(" INNER JOIN ");
                joinT.append(TABLE_MCC_SID_CONFLICT);
                joinT.append(" ON (");
                joinT.append(TABLE_MCC_LOOKUP_TABLE); // table name
                joinT.append(".");
                joinT.append(MccLookup.MCC); // column name
                joinT.append(" = ");
                joinT.append(TABLE_MCC_SID_CONFLICT); // table name
                joinT.append(".");
                joinT.append(MccSidConflicts.MCC); //column name
                joinT.append(")");
                qb.setTables(joinT.toString());
                qb.setProjectionMap(sConflictProjectionMap);
                break;
            }
            case MCC_SID_RANGE: {
                qb.setTables(TABLE_MCC_SID_RANGE);
                qb.setProjectionMap(sRangeProjectionMap);
                if (useDefaultOrder) {
                    orderBy = MccIdd.DEFAULT_SORT_ORDER;
                }
                break;
            }
            case NANP_AREA_CODE: {
                qb.setTables(TABLE_NANP_AREA_CODE);
                qb.setProjectionMap(sNanpProjectionMap);
                if (useDefaultOrder) {
                    orderBy = NanpAreaCode.DEFAULT_SORT_ORDER;
                }
                break;
            }
            case ARBITRARY_MCC_SID_MATCH: {
                qb.setTables(TABLE_ARBITRARY_MCC_SID_MATCH);
                qb.setProjectionMap(sArbitraryProjectionMap);
                if (useDefaultOrder) {
                    orderBy = ArbitraryMccSidMatch.DEFAULT_SORT_ORDER;
                }
                break;
            }
            case MCC_IDD_ID: {
                qb.setTables(TABLE_MCC_IDD);
                qb.setProjectionMap(sIddProjectionMap);
                qb.appendWhere(TABLE_MCC_IDD + "._id=");
                qb.appendWhere(uri.getPathSegments().get(1));
                if (useDefaultOrder) {
                    orderBy = MccIdd.DEFAULT_SORT_ORDER;
                }
                break;
            }
            case MCC_LOOKUP_TABLE_ID: {
                qb.setTables(TABLE_MCC_LOOKUP_TABLE);
                qb.setProjectionMap(sLookupProjectionMap);
                qb.appendWhere(TABLE_MCC_LOOKUP_TABLE + "._id=");
                qb.appendWhere(uri.getPathSegments().get(1));
                if (useDefaultOrder) {
                    orderBy = MccLookup.DEFAULT_SORT_ORDER;
                }
                break;
            }
            case MCC_SID_CONFLICT_ID: {
                qb.setTables(TABLE_MCC_SID_CONFLICT);
                qb.appendWhere(TABLE_MCC_SID_CONFLICT + "._id=");
                qb.appendWhere(uri.getPathSegments().get(1));
                if (useDefaultOrder) {
                    orderBy = MccSidConflicts.DEFAULT_SORT_ORDER;
                }
                break;
            }
            case MCC_SID_RANGE_ID: {
                qb.setTables(TABLE_MCC_SID_RANGE);
                qb.setProjectionMap(sRangeProjectionMap);
                qb.appendWhere(TABLE_MCC_SID_RANGE + "._id=");
                qb.appendWhere(uri.getPathSegments().get(1));
                if (useDefaultOrder) {
                    orderBy = MccIdd.DEFAULT_SORT_ORDER;
                }
                break;
            }
            case NANP_AREA_CODE_ID: {
                qb.setTables(TABLE_NANP_AREA_CODE);
                qb.setProjectionMap(sNanpProjectionMap);
                qb.appendWhere(TABLE_NANP_AREA_CODE + "._id=");
                qb.appendWhere(uri.getPathSegments().get(1));
                if (useDefaultOrder) {
                    orderBy = NanpAreaCode.DEFAULT_SORT_ORDER;
                }
                break;
            }
            case ARBITRARY_MCC_SID_MATCH_ID: {
                qb.setTables(TABLE_ARBITRARY_MCC_SID_MATCH);
                qb.setProjectionMap(sArbitraryProjectionMap);
                qb.appendWhere(TABLE_ARBITRARY_MCC_SID_MATCH + "._id=");
                qb.appendWhere(uri.getPathSegments().get(1));
                if (useDefaultOrder) {
                    orderBy = ArbitraryMccSidMatch.DEFAULT_SORT_ORDER;
                }
                break;
            }
            default:
                throw new IllegalArgumentException("Unknown URI " + uri);
        }

        if (!useDefaultOrder) {
            orderBy = sortOrder;
        }

        SQLiteDatabase db = mDbHelper.getReadableDatabase();
        Cursor c = qb.query(db, projectionIn, selection, selectionArgs, groupBy, null, orderBy);
        if (c != null) {
            c.setNotificationUri(getContext().getContentResolver(), uri);
        }

        return c;
    }

    @Override
    public Uri insert(Uri uri, ContentValues values) {
        throw new UnsupportedOperationException("Failed to insert row into " + uri);
    }

    @Override
    public int delete(Uri uri, String selection, String[] selectionArgs) {
        throw new UnsupportedOperationException("Cannot delete URL: " + uri);
    }

    @Override
    public int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) {
        int count = 0;
        final SQLiteDatabase db = mDbHelper.getWritableDatabase();

        final int match= sURIMatcher.match(uri);
        switch (match) {
            case MCC_LOOKUP_TABLE:
                count = db.update(TABLE_MCC_LOOKUP_TABLE, values, selection, selectionArgs);
                break;
            default:
                throw new UnsupportedOperationException("Cannot update URL: " + uri);
        }

        return count;
    }
}