Android Open Source - digital-ocean-swimmer Size Dao

• Back to Image/api  ↑

From Project

Back to project page digital-ocean-swimmer.

License

The source code is released under:

MIT License

Java Source Code

package com.yassirh.digitalocean.data;
/*from w w w  .  j  a va2 s .c  o  m*/
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

import com.yassirh.digitalocean.model.Size;

import java.util.ArrayList;
import java.util.List;

public class SizeDao extends SqlDao<Size> {

  private DatabaseHelper mDatabaseHelper;
  
  public SizeDao(DatabaseHelper databaseHelper) {
    super();
    this.mDatabaseHelper = databaseHelper;
  }

  public long create(Size size) {
    ContentValues values = new ContentValues();
    values.put(SizeTable.SIZE_SLUG, size.getSlug());
    values.put(SizeTable.MEMORY, size.getMemory());
    values.put(SizeTable.CPU, size.getCpu());
    values.put(SizeTable.DISK, size.getDisk());
    values.put(SizeTable.TRANSFER, size.getTransfer());
    values.put(SizeTable.COST_PER_HOUR, size.getCostPerHour());
    values.put(SizeTable.COST_PER_MONTH, size.getCostPerMonth());
        return db.insertWithOnConflict(getTableHelper().TABLE_NAME, null, values,SQLiteDatabase.CONFLICT_REPLACE);
  }  

  public Size newInstance(Cursor c) {
    Size size = new Size();
    size.setSlug(c.getString(c.getColumnIndex(SizeTable.SIZE_SLUG)));
    size.setMemory(c.getInt(c.getColumnIndex(SizeTable.MEMORY)));
    size.setCpu(c.getInt(c.getColumnIndex(SizeTable.CPU)));
    size.setDisk(c.getInt(c.getColumnIndex(SizeTable.DISK)));
    size.setTransfer(c.getInt(c.getColumnIndex(SizeTable.TRANSFER)));
    size.setCostPerHour(c.getFloat(c.getColumnIndex(SizeTable.COST_PER_HOUR)));
    size.setCostPerMonth(c.getFloat(c.getColumnIndex(SizeTable.COST_PER_MONTH)));
    return size;
  }

  @Override
  public DatabaseHelper getDatabaseHelper() {
    return this.mDatabaseHelper;
  }

  @Override
  public TableHelper getTableHelper() {
    return new SizeTable();
  }

    public List<Size> getByMinMemory(int minMemory) {
        List<Size> sizes = new ArrayList<Size>();
        Cursor cursor = db.query(getTableHelper().TABLE_NAME,
                getTableHelper().getAllColumns(), String.format("%s >= %d", SizeTable.MEMORY, minMemory), null, null, null, SizeTable.MEMORY);

        if(cursor.moveToFirst()){
            while (!cursor.isAfterLast()) {
                Size size = newInstance(cursor);
                sizes.add(size);
                cursor.moveToNext();
            }
        }
        cursor.close();
        return sizes;
    }
}

Java Source Code List

• Back to Image/api  ↑