Android Studio - Adding different data to SQLite Database

Question

I´m working on a cookbook app. It´s already possible to store new recipes in my SQLite database and show them in a ListView. But now I´m trying to add the possibility to add the required ingredients and how much you need of them for the recipe. For different recipes there will be different amounts of ingredients required.

For example for a cake I need: 1 apple 2 eggs

but for a cookie: 1 chocolate 1 egg 3 smarties

For now I store fixed data (name, description, cooking time) in my database. But with the ingredients I think I will need a variable way to store them. I hope you get what my problem is. Is there a way to store these variable Objects in my database?

Martin

Answer 1

well, you can use whatever of this ways to add your app:

1- Add as much columns as you need, but if you don't need one, just store empty value, later check if isn't empty

ContentValues contentValues = new ContentValues(); 
                            contentValues.put("ingredient1", Et1.getText().toString()); // string containing 2 eggs
                            contentValues.put("ingredient2", Et2.getText().toString()); // string containing 2 apples
                            contentValues.put("ingredient3", Et3.getText().toString().trim()); //string containing 1 chocolate
                            db.insert(TABLE_NAME, null, contentValues); //

---

2.- Another one is just to create a large string of all ingredients and store it in 1 column

String data ="";
                    data="2 eggs"+"*"+"1 chocolate "+"*"+"5 apples";
                    ContentValues contentValues = new ContentValues(); // 
                    contentValues.put("column1", data); // string containing 2 eggs
                    db.insert(TABLE_NAME, null, contentValues); // 

after that, use a stringTokenizer to get every token, in this case "*"

StringTokenizer st = new StringTokenizer(data,"*");
While(st.hasMoreTokens()){
    String aux = st.nextToken()// do somethig like show or replace with this
}