Styjun

I don't know how I can achieve this data structure in Firestore.

I have this structure:

Firestore-root
 |
 --- liturgia (collection)
 | |
 | --- lh (documents)
 | |
 | --- oficio (collection)
 | |
 | --- 03070101 (documents)
 | |
 | --- himno: "Today himno for today oficio"
 | |
 | --- read: "Today read for today oficio"
 |
 | --- 03070102 (documents)
 | |
 | --- himno: "Today himno for today oficio"
 | |
 | --- read: "Today read for today oficio"
 |
 | --- 09070325 (documents)
 | |
 | --- himno: "Today himno for today oficio"
 | |
 | --- read: "Today read for today oficio"
 |
 | --- laudes (collection)
 | |
 | --- 03070101 (documents)
 | |
 | --- himno: "Today himno for today laudes"
 | |
 | --- read: "Today read for today laudes"
 |
 | --- 03070102 (documents)
 | |
 | --- himno: "Today himno for today laudes"
 | |
 | --- read: "Today read for today laudes"
 |
 | --- 09070325 (documents)
 | |
 | --- himno: "Today himno for today laudes"
 | |
 | --- read: "Today read for today laudes"

In oficio or in laudes there are documents with fixed content, this content never change, and I need to use that content according to the date.

For example:

I have any date, on this date, one entire content is needed. For example, when I need to show the today content for oficio (or for laudes):

• For 2019-03-25 i will need the content of 09070325


• 
  

  For 2019-03-26 i will need the content of 03070102

  
  
  

  ...

  
  



• For 2020-03-25 i will need the content of 09070325



• 
  

  For 2020-03-26 i will need the content of 03070103

  
  
  

  ...

  
  



• For 2021-03-25 i will need the content of 03070101

I think of a structure to relate the fixed content according to the dates, but I do not know how to do it.

In my application, the current date will be taken, and based on this data, must find the fixed content for oficio, for laudes, etc.

For example, in 2019-03-25 and in 2020-03-25 is needed the content 09070325, but in 2021-03-25 is needed the content 03070101:

20190325
 oficio : 09070325
 laudes : 09070325

20190326
 oficio : 03070102
 laudes : 03070102

20200325
 oficio : 03070101
 laudes : 03070101

20210325
 oficio : 03070101
 laudes : 03070101

How can I organize my data structure to:

• not having to update the fixed content documents


• put in relation the fixed content with the dates each year


• obtain the fixed content according to a given date consuming the least amount of resources
  

The simplest solution I can think of is to use a date property of type String for each of your documents and simplify your structure a little bit. So a possible structure might be:

Firestore-root
 |
 --- liturgia (collection)
 |
 --- 03070101 (document)
 |
 --- himno: "Today himno for today oficio"
 |
 --- read: "Today read for today oficio"
 |
 --- date: "20190325"
 |
 --- length: "1h"

To get today's document, simply use the following query:

FirebaseFirestore rootRef = FirebaseFirestore.getInstance();
CollectionReference liturgiaRef = rootRef.collection("liturgia");
Query query = liturgiaRef.whereEqualTo("date", today);

In which today is 20190325. That's it!

Edit:

According to your comment, instead of storing the data as date: "20190325" store it only as date: "0325". This means that you can query according to the month and day no matter what the year is. In this case, today is only 0325. This way it will work for evey year.

Edit2:

According to OP's comments, we agree that a possible solution would be to create a calendar node that relates the dates and the contents.