Examples with DeviceDatabase wseemann.media.romote.database.DeviceDatabase used on opensource projects

Example 1 with DeviceDatabase

use of wseemann.media.romote.database.DeviceDatabase in project RoMote by wseemann.

the class DBUtils method insertDevice.

public static long insertDevice(Context context, Device device) {
    long id = -1;
    if (deviceExists(context, device.getSerialNumber())) {
        return -1;
    }
    DeviceDatabase deviceDatabase = new DeviceDatabase(context);
    SQLiteDatabase db = deviceDatabase.getWritableDatabase();
    ContentValues values = new ContentValues();
    values.put(DeviceDatabase.HOST, device.getHost());
    values.put(DeviceDatabase.UDN, device.getUdn());
    values.put(DeviceDatabase.SERIAL_NUMBER, device.getSerialNumber());
    values.put(DeviceDatabase.DEVICE_ID, device.getDeviceId());
    values.put(DeviceDatabase.VENDOR_NAME, device.getVendorName());
    values.put(DeviceDatabase.MODEL_NUMBER, device.getModelNumber());
    values.put(DeviceDatabase.MODEL_NAME, device.getModelName());
    values.put(DeviceDatabase.WIFI_MAC, device.getWifiMac());
    values.put(DeviceDatabase.ETHERNET_MAC, device.getEthernetMac());
    values.put(DeviceDatabase.NETWORK_TYPE, device.getNetworkType());
    values.put(DeviceDatabase.USER_DEVICE_NAME, device.getUserDeviceName());
    values.put(DeviceDatabase.SOFTWARE_VERSION, device.getSoftwareVersion());
    values.put(DeviceDatabase.SOFTWARE_BUILD, device.getSoftwareBuild());
    values.put(DeviceDatabase.SECURE_DEVICE, device.getSecureDevice());
    values.put(DeviceDatabase.LANGUAGE, device.getLanguage());
    values.put(DeviceDatabase.COUNTY, device.getCountry());
    values.put(DeviceDatabase.LOCALE, device.getLocale());
    values.put(DeviceDatabase.TIME_ZONE, device.getTimeZone());
    values.put(DeviceDatabase.TIME_ZONE_OFFSET, device.getTimeZoneOffset());
    values.put(DeviceDatabase.POWER_MODE, device.getPowerMode());
    values.put(DeviceDatabase.SUPPORTS_SUSPEND, device.getSupportsSuspend());
    values.put(DeviceDatabase.SUPPORTS_FIND_REMOTE, device.getSupportsFindRemote());
    values.put(DeviceDatabase.SUPPORTS_AUDIO_GUIDE, device.getSupportsAudioGuide());
    values.put(DeviceDatabase.DEVELOPER_ENABLED, device.getDeveloperEnabled());
    values.put(DeviceDatabase.KEYED_DEVELOPER_ID, device.getKeyedDeveloperId());
    values.put(DeviceDatabase.SEARCH_ENABLED, device.getSearchEnabled());
    values.put(DeviceDatabase.VOICE_SEARCH_ENABLED, device.getVoiceSearchEnabled());
    values.put(DeviceDatabase.NOTIFICATIONS_ENABLED, device.getNotificationsEnabled());
    values.put(DeviceDatabase.NOTIFICATIONS_FIRST_USE, device.getNotificationsFirstUse());
    values.put(DeviceDatabase.SUPPORTS_PRIVATE_LISTENING, device.getSupportsPrivateListening());
    values.put(DeviceDatabase.HEADPHONES_CONNECTED, device.getHeadphonesConnected());
    id = db.insert(DeviceDatabase.DEVICES_TABLE_NAME, null, values);
    db.close();
    deviceDatabase.close();
    return id;
}

Example 2 with DeviceDatabase

use of wseemann.media.romote.database.DeviceDatabase in project RoMote by wseemann.

the class DBUtils method deviceExists.

private static boolean deviceExists(Context context, String serialNumber) {
    boolean exists = false;
    DeviceDatabase deviceDatabase = new DeviceDatabase(context);
    SQLiteDatabase db = deviceDatabase.getWritableDatabase();
    Cursor cursor = db.query(DeviceDatabase.DEVICES_TABLE_NAME, null, DeviceDatabase.SERIAL_NUMBER + " = ?", new String[] { serialNumber }, null, null, null);
    if (cursor.moveToNext()) {
        exists = true;
    }
    cursor.close();
    db.close();
    deviceDatabase.close();
    return exists;
}

Example 3 with DeviceDatabase

use of wseemann.media.romote.database.DeviceDatabase in project RoMote by wseemann.

the class DBUtils method removeDevice.

public static int removeDevice(Context context, String serialNumber) {
    int rowsAffected = 0;
    DeviceDatabase deviceDatabase = new DeviceDatabase(context);
    SQLiteDatabase db = deviceDatabase.getWritableDatabase();
    rowsAffected = db.delete(DeviceDatabase.DEVICES_TABLE_NAME, DeviceDatabase.SERIAL_NUMBER + " = ?", new String[] { serialNumber });
    db.close();
    deviceDatabase.close();
    return rowsAffected;
}

Example 4 with DeviceDatabase

use of wseemann.media.romote.database.DeviceDatabase in project RoMote by wseemann.

the class DBUtils method getDevice.

public static Device getDevice(Context context, String serialNumber) {
    Device device = null;
    if (serialNumber == null) {
        return device;
    }
    DeviceDatabase deviceDatabase = new DeviceDatabase(context);
    SQLiteDatabase db = deviceDatabase.getWritableDatabase();
    Cursor cursor = db.query(DeviceDatabase.DEVICES_TABLE_NAME, null, DeviceDatabase.SERIAL_NUMBER + " = ?", new String[] { serialNumber }, null, null, null);
    if (cursor.moveToNext()) {
        device = parseDevice(cursor);
    }
    cursor.close();
    db.close();
    deviceDatabase.close();
    return device;
}

Example 5 with DeviceDatabase

use of wseemann.media.romote.database.DeviceDatabase in project RoMote by wseemann.

the class DBUtils method getAllDevices.

public static List<Device> getAllDevices(Context context) {
    List<Device> devices = new ArrayList<Device>();
    DeviceDatabase deviceDatabase = new DeviceDatabase(context);
    SQLiteDatabase db = deviceDatabase.getWritableDatabase();
    Cursor cursor = db.query(DeviceDatabase.DEVICES_TABLE_NAME, null, null, null, null, null, null);
    while (cursor.moveToNext()) {
        devices.add(parseDevice(cursor));
    }
    cursor.close();
    db.close();
    deviceDatabase.close();
    return devices;
}