-
-
Notifications
You must be signed in to change notification settings - Fork 1
Module Bible
On Windows, the database path is
%AppData%\Roaming\com.i53\Aletheia Bible Study
and the file is dbAletheia-bible.sqlite
Important
On database table is rename to bible_version
class BibleVersion {
int id;
String? language;
String versionName;
String versionAbrev;
String? copyright;
bool? hasStrong;
}
Column | Type | Required | Description | Default Value |
---|---|---|---|---|
id | int | yes | ||
language | String | no | if not informed, deafalt = "pr-br" | pt-br |
version_name | String | yes | Version name of the bible | |
version_abrev | String | yes | Version abreviation | |
copyright | String | no | copyright informed of the bible | |
has_strong | int as bool | no | inform if this version has Strong Reference associated, [0 = false, 1 = true] | 0 |
insert into `bible_version` (`copyright`, `has_strong`, `id`, `language`, `version_abrev`, `version_name`) values ('Dr. Jonathan Gallagher. Lançado sob licença Creative Commons Atribuição-CompartilhaIgual 4.0 Não Adaptada. Para correções envie email para [email protected] Dr. Jonathan Gallagher. Released under Creative Commons Attribution-ShareAlike 4.0 Unported License. For corrections send email to [email protected]', '0', '4', 'pt-br', 'BLT', 'Biblia Livre Para Todos')
Note
Data from the SQL
id | language | version_name | version_abrev | copyright | has_strong |
---|---|---|---|---|---|
4 | pt-br | Biblia Livre Para Todos | BLT | Dr. Jonathan Gallagher. Lançado sob licença Creative Commons Atribuição-CompartilhaIgual 4.0 Não Adaptada. Para correções envie email para [email protected] Dr. Jonathan Gallagher. Released under Creative Commons Attribution-ShareAlike 4.0 Unported License. For corrections send email to [email protected] | 0 |
Important
On database table is rename to bible_version_books
The table BibleVersionBooks is used to set the books that go to the version of bible. Some bible has only the New Testament, others has only the Old Testament and others bouth, other like Apocrypha can have other books not included on protestant cannon. If the version have another book not included on the list of books displayed on books doc, need to include on table book, and set the book on the version, and the sequence of display of this book.
class BibleVersionBooks {
int? id;
int idBook;
int idBibleVersion;
int? sequence;
int? numberChapters;
String? nameTranslation;
String? abrevTranslation;
}
Column | Type | Required | Description | Default Value |
---|---|---|---|---|
id | int | yes | ||
id_book | int | yes | Id related to Book | |
id_bible_version | int | yes | Id related to the Table BibleVersion | |
sequence | int | no | sequence of the book, to order when show the books of this version | |
number_chapters | int | no | number of chapter that the book contain | |
name_translation | String | no | Name used on translation, if not set, will be used the name on the table book | |
abrev_translation | String | no | Abreviation of the book, if not set, will be used the abreviation on the table book |
insert into `bible_version_books` (`abrev_translation`, `id`, `id_bible_version`, `id_book`, `name_translation`, `number_chapters`, `sequence`) values ('Mt', '661', '4', '40', 'Mateus', '28', '40')
Important
On database table is rename to book
class Book {
int id;
//overwrite on [BibleVersionBooks]
String name;
//overwrite on [BibleVersionBooks]
String abrev;
Division division;
String literaryGenre;
String? cannon;
}
Column | Type | Required | Description | Default Value |
---|---|---|---|---|
id | int | yes | ||
name | String | yes | Name of the book (English). This field is overrided in Table BibleVersionBook by the field nameTranslation | |
abrev | String | yes | Abreviation of the book name. This field is overrided in Table BibleVersionBook by the field abrevTranslation | |
division | String | yes | Division of the book [0 -> Old Testament, 1 -> new Testament, 2 -> Apocryphal, 3 -> Other] | |
literary_genre | String | yes | Litetary Genre of the book | empty value |
cannon | String | no | Cannon of the book | "Protestant" |
id | division |
---|---|
0 | Old Testament |
1 | New Testament |
2 | Apocryphal |
3 | Other |
The App consider the books that has on Protestant cannon as his main core, but another books can be set without the range of book on this list. **One important consideration is that in some parts of the app you can use the Reference passing the id of the book, so if id has not correlation with the Id set on book, the Reference will not be displayed.
Note
You can use the table described on MyBible.zone Doc and add +100
to the number if the book is a Apocryphal.
id | name | abrev | division |
---|---|---|---|
1 | Gênesis | Gn | 0 |
2 | Êxodo | Êx | 0 |
3 | Levítico | Lv | 0 |
4 | Números | Nm | 0 |
5 | Deuteronômio | Dt | 0 |
6 | Josué | Js | 0 |
7 | Juízes | Jz | 0 |
8 | Rute | Rt | 0 |
9 | 1 Samuel | 1 Sm | 0 |
10 | 2 Samuel | 2 Sm | 0 |
11 | 1 Reis | 1 Rs | 0 |
12 | 2 Reis | 2 Rs | 0 |
13 | 1 Crônicas | 1 Cr | 0 |
14 | 2 Crônicas | 2 Cr | 0 |
15 | Esdras | Ed | 0 |
16 | Neemias | Ne | 0 |
17 | Ester | Et | 0 |
18 | Jó | Jó | 0 |
19 | Salmos | Sl | 0 |
20 | Provérbios | Pv | 0 |
21 | Eclesiastes | Ec | 0 |
22 | Cânticos | Ct | 0 |
23 | Isaías | Is | 0 |
24 | Jeremias | Jr | 0 |
25 | Lamentações | Lm | 0 |
26 | Ezequiel | Ez | 0 |
27 | Daniel | Dn | 0 |
28 | Oséias | Os | 0 |
29 | Joel | Jl | 0 |
30 | Amós | Am | 0 |
31 | Obadias | Ob | 0 |
32 | Jonas | Jn | 0 |
33 | Miquéias | Mq | 0 |
34 | Naum | Na | 0 |
35 | Habacuque | Hc | 0 |
36 | Sofonias | Sf | 0 |
37 | Ageu | Ag | 0 |
38 | Zacarias | Zc | 0 |
39 | Malaquias | Ml | 0 |
40 | Mateus | Mt | 1 |
41 | Marcos | Mc | 1 |
42 | Lucas | Lc | 1 |
43 | João | Jo | 1 |
44 | Atos | At | 1 |
45 | Romanos | Rm | 1 |
46 | 1 Coríntios | 1 Co, | 1 |
47 | 2 Coríntios | 2 Co | 1 |
48 | Gálatas | Gl | 1 |
49 | Efésios | Ef | 1 |
50 | Filipenses | Fp | 1 |
51 | Colossenses | Cl | 1 |
52 | 1 Tessalonicenses | 1 Ts | 1 |
53 | 2 Tessalonicenses | 2 Ts | 1 |
54 | 1 Timóteo | 1 Tm | 1 |
55 | 2 Timóteo | 2 Tm | 1 |
56 | Tito | Tt | 1 |
57 | Filemom | Fm | 1 |
58 | Hebreus | Hb | 1 |
59 | Tiago | Tg | 1 |
60 | 1 Pedro | 1 Pe | 1 |
61 | 2 Pedro | 2 Pe | 1 |
62 | 1 João | 1 Jo | 1 |
63 | 2 João | 2 Jo | 1 |
64 | 3 João | 3 Jo | 1 |
65 | Judas | Jd | 1 |
66 | Apocalipse | Ap | 1 |
insert into `book` (`abrev`, `cannon`, `division`, `id`, `literary_genre`, `name`) values ('Mt', 'Protestante', '1', '40', , 'Mateus')
Important
On database table is rename to verse
abstract class VerseCore {
int id;
int idBibleVersion;
int idBook;
int numberChapter;
int numberVerse;
///for some type of bible version that has verses jointed
int? numberVerseEnd;
List<Content> content;
String contentWithOutFormat;
}
Column | Type | Required | Description | Default Value |
---|---|---|---|---|
id | int | yes | ||
id_bible_version | int | yes | id of bible version | |
id_book | int | yes | book id, see Table Book | |
number_chapter | int | yes | number of the chapter | |
number_verse | int | yes | number of the verse | |
number_verse_end | int | yes | if version contain joined verses, use this to set the number of the verse with is joined | |
content | List of Json Content | yes | the content of the verse in his style (bold, break line, italic, Jesus words, ...), see Content | |
content_with_out_format | String | yes | the all verse without format, this include if verse is joined |
(Json Only)
Content is used on table Verse as List of Json. This is the core to view the verse text with all information and style, please see the Attributes that is supported in Aletheia Bible, the App make the conversion of this attributes in style for the Text that is presented in every sequence. If the text has no attribute, normaly will be passed a List with one Content 1, if the text has style, the words that has style need to be in one sequence[2](#example of-content-with-jesus-words-in-highlight).
Important
Aletheia bible don't use HTML format on verse, some part of the app accept some text in HTML format like (Commentary, Dictionary, Lexico), but not in Verse. The Verse Style is build using the Content Schema described here.
class Content {
int seq; //sq
///to the text have breakline need to have \n with the text
String text; //T
TypeContent typeContent; //tC
Map<String, dynamic>? attributes; //at
List<String>? refLexicos; //rS
@Deprecated
List<SubText>? subText; //sT
String? anottation; //an
String? comment; // cm
//can be a list of references
List<Reference>? reference; //rf
String? footnote; //fn
///tag that represents the beginning of a paragraph
///
///the first letter will be bold
bool? paragraph; //pr
}
key Name | Type | Required | Description | Values Description | Implemented? |
---|---|---|---|---|---|
sq | int | yes | sequence of the data | [✅] | |
T | String | yes | the text. if the text has break line, need to have \n | ||
tC | String | yes | type of content, see example | [verse, title] | [✅] |
at | Json Attribute | yes | the Attributes related to this text | [bold, italic, underline, color (int value), backgroundColor (int value), jesuswords (true or false), fontSize (add to font), highlight (used with the user data, do not include on bible database)] | [✅] |
rS | String | no | list of lexico references, flag BibleVersion hasStrong = true | See example | [✅] |
an | String | no | anottation of this text | [❌] | |
cm | String | no | commentary of this text | [❌] | |
rf | List Reference | no | List of references of this text, see Reference | [❌] | |
fn | String | no | footnotes of this text ***Not implemented yet | [❌] | |
pr | bool | no | use this if is new line and need to Capitalize the first word | [✅] |
[
{
"sq": 0,
"T": "A criação dos céus e da terra",
"tC": "title"
},
{
"sq": 1,
"T": " No princípio, Deus criou os céus e a terra.",
"tC": "verse"
}
]
[
{
"sq": 0,
"T": "No ",
"tC": "verse",
"rS": [],
"pr": true
},
{
"sq": 1,
"T": "princípio",
"tC": "verse",
"rS": [
"H7225"
]
},
{
"sq": 2,
"T": ", ",
"tC": "verse"
},
{
"sq": 3,
"T": "criou ",
"tC": "verse",
"rS": [
"H1254",
"8804",
"H853"
]
},
{
"sq": 4,
"T": "Deus ",
"tC": "verse",
"rS": [
"H430"
]
},
{
"sq": 5,
"T": "os ",
"tC": "verse",
"rS": []
},
{
"sq": 6,
"T": "céus ",
"tC": "verse",
"rS": [
"H8064"
]
},
{
"sq": 7,
"T": "e ",
"tC": "verse",
"rS": [
"H853"
]
},
{
"sq": 8,
"T": "a ",
"tC": "verse",
"rS": []
},
{
"sq": 9,
"T": "terra",
"tC": "verse",
"rS": [
"H776"
]
},
{
"sq": 10,
"T": ". ",
"tC": "verse"
}
]
[
{
"sq": 0,
"T": "Em seguida, disse-lhe Jesus: ",
"tC": "verse",
"at": {},
"rS": [],
"pr": false
},
{
"sq": 1,
"T": "“Veja que não digas isto a ninguém, mas segue, mostra teu corpo ao sacerdote, e faze a oferta que Moisés ordenou, para que sirva de testemunho.” ",
"tC": "verse",
"at": {
"jesuswords": true
},
"rS": [],
"pr": false
},
{
"sq": 2,
"T": " Um comandante romano crente",
"tC": "verse",
"at": {},
"rS": [],
"pr": false
}
]
(Json only)
enum Attributes {bold,
italic,
underline,
color,
backgroundColor,
jesuswords,
fontSize,}
key | Type | Obs |
---|---|---|
bold | bool | |
italic | bool | |
underline | bool | |
color | int | int value of the color |
backgroundColor | int | int value of the backgound color |
jesuswords | bool | if true, words will be red |
fontSize | int | plus to font size |
key "at" can be passed to the content to set the style to the text
"at": {
"jesuswords": true,
"bold": true,
"italic":true,
"underline": true
},
Important
(Json only)
Not implemented yet to display on verse. Current version 1.0.0.8
This Schema is used on another part of the app to build reference, like when user add some notes.
Not implemented yet on current version 1.0.0.8
class Reference {
int bookNumber;
int chapterNumber;
int? verseNumber;
int? endChapterNumber;
int? endVerseNumber;
List<int>? verseNumbers;
}
key | Type | Required | Description |
---|---|---|---|
bookNumber | int | yes | id of book |
chapterNumber | int | yes | numberof chapter |
verseNumber | int | no | number of verse |
endChapterNumber | int | no | number of chapter reference end |
endVerseNumber | int | no | number of verse reference end |
verseNumbers | List of int | no | ***Not implemented yet |