ChristianTools

This repository will contain scripts, database files, and many other tools that will help christian software developers.

Bible_Ordered_Chapters.ods and Bible_Ordered_Chapters.xlsx

ods: stands for open document spreadshet which is used in open source spreadsheet software such as libreoffice.
xlsx The second file is to be used in Microsoft Excel.

The Column Headers:

ChronID (INTEGER NOT NULL): represents where the corresponding "(Book,Chapter)" is chronologically.
NormID (INTEGER NOT NULL): This is an integer that represents where the corresponding "(Book,Chapter)" in the normal order of the bible.
Books (TEXT NOT NULL): This is the book of the bible that the (Book,Chapter) corresponds to.
Chapter (INTEGER NOT NULL): This is the chapter that the (Book,Chapter) corresponds to.
Testament (CHAR NOT NULL): This is the testament (Old Testament or New Testament) that the (Book,Chapter) corresponds to.

This spreadsheet can be exported to a csv. I have included the .csv file in this directory.

SQLITE3

I have uploaded an sqlite3 database to this repository of these files. To use this you need to install sqlite3:

Ubuntu/Debian:

`sudo apt-get update`  
`sudo apt-get install sqlite3`

CentOS / Fedora / RedHat:

`yum install sqlite3`

Some examples of the usage is this:

Get all the chapters in the old testament in chronological order:
SELECT Books, Chapter FROM Bible_Ordered_Chapters WHERE Testament="O" ORDER BY ChronID
Get all the chapters in the new testament in the normal order of the bible:
SELECT Books, Chapter FROM Bible_Ordered_Chapters WHERE Testament="O" ORDER BY NormID