VendorDbAdapter.java

package com.openfarmanager.android.core.dbadapters;

import android.database.sqlite.SQLiteDatabase;

import static com.openfarmanager.android.core.dbadapters.VendorDbAdapter.Columns.*;

/**
 * @author Vlad Namashko.
 */
public class VendorDbAdapter {

    private static final String TABLE_NAME = "mac_vendors";
    public static final String CREATE_TABLE = "CREATE TABLE " + TABLE_NAME + " ("
            + Columns.MAC + " INT NOT NULL, "
            + Columns.VENDOR + " TEXT NOT NULL);"
            + "CREATE INDEX mac_index on mac_vendors (mac)";
    private static final String DATA_FILE_NAME = "mac_vendors_data";

    public static void createTable(SQLiteDatabase db) {
        DbAdapterTools.createTableLoadData(db, CREATE_TABLE, DATA_FILE_NAME);
    }

    public static String getVendor(int mac) {
        return DbAdapterTools.getField(mac, TABLE_NAME, MAC, VENDOR);
    }

    public static final class Columns {
        public static final String MAC = "mac";
        public static final String VENDOR = "vendor";
    }
}