Tag: Database

I develop a simple form in which the user can attach multiple images and save locally with the help of SQLite. I am able to save other data and have already saved it when attaching a single image. However, you must create the one-to-many patient relationship for photo and save all photos from the form. Since I am now learning how to use SQLite and I do not have much experience with Android, I can not save multiple images of a single form and create the relationship one to several of the SQLite schema.

INSERT DATA CODE IN BANK

public class PacienteDAO {

private Conexao conexao;
private SQLiteDatabase banco;
private byte() imageInBytes;

public PacienteDAO(Context context) {
    conexao = new Conexao(context);
    banco = conexao.getWritableDatabase();
}


public long inserirPaciente(Paciente paciente){

   /*Bitmap() imageToStoreBitmap = paciente.getFotos();
    ByteArrayOutputStream objectByteArrayOutputStream = new ByteArrayOutputStream();
    imageToStoreBitmap.compress(Bitmap.CompressFormat.PNG, 100, objectByteArrayOutputStream);
    imageInBytes = objectByteArrayOutputStream.toByteArray();*/

    ContentValues values = new ContentValues();
    values.put("nome", paciente.getNome());
    values.put("cpf", paciente.getCpf());
    values.put("data", paciente.getData());
    values.put("foto",imageInBytes);
    return banco.insert("paciente", null, values);

}
}

Creating the table

@Override
public void onCreate(SQLiteDatabase db) {

    db.execSQL("create table paciente(id integer primary key autoincrement, nome varchar(50), cpf varchar(11), data varchar(15), fotos BLOB )");
    //db.execSQL("create table foto(id integer primary key autoincrement, enviado int(2), fotoBitmap BLOB,  FOREIGN KEY(pacienteId) REFERENCES paciente(id))");
    Log.d("TAG", "Banco criado com sucesso");

}

In this part, I add all the images, whether from the mobile gallery or taken by the camera in a list of tables: final List bitmaps = new ArrayList<>();

@Override
public void onActivityResult(int requestCode, int resultCode, Intent data) {
    super.onActivityResult(requestCode, resultCode, data);
    final ImageView imageView = findViewById(R.id.imageDisplay);
    if(requestCode == 0 && resultCode == RESULT_OK && data != null) {
        Bitmap bt = (Bitmap) data.getExtras().get("data");
        bitmaps.add(bt);

    }else {
        ClipData clipData = data.getClipData();
        if (clipData != null) {
            for (int i = 0; i < clipData.getItemCount(); i++) {
                Uri uri = clipData.getItemAt(i).getUri();

                try {
                    InputStream inputStream = getContentResolver().openInputStream(uri);
                    Bitmap bitmap = BitmapFactory.decodeStream(inputStream);
                    bitmaps.add(bitmap);

                } catch (FileNotFoundException e) {
                    e.printStackTrace();
                }

            }
        }else {
            Uri uri = data.getData();
            try {
                InputStream inputStream = getContentResolver().openInputStream(uri);
                Bitmap bitmap = BitmapFactory.decodeStream(inputStream);
                bitmaps.add(bitmap);
            } catch (FileNotFoundException e) {
                e.printStackTrace();
            }
        }

    }
  }

The patient model:

public class Paciente implements Serializable {

@NonNull
@Expose
private String nome;
@NonNull
@Expose
private String cpf;
@NonNull
@Expose
public  List fotos;
@Expose
@NonNull
private String data;

...GETTER E SETTER.

Patient is the Photo class that contains the list of captured images.

public class Foto implements Serializable {
@Expose
private List fotoBitmap;
@Expose
private boolean enviado;
...GETTER E SETTER.