m5db

var ColumnNamesCsv_CNT = "IDX_inbatch, RelFP, AbsFP, Descr, T_Cre, T_Imp, T_Edt, " +
	"RawMT, Mimtp, MType, Contt"

ColumnNamesCsv_CNT TODO: this can be left unset and then (easily!) auto-generated from ColumnSpecsCNT.

var ColumnNamesCsv_INB = "FilCt, Descr, T_Cre, T_Imp, T_Edt, RelFP, AbsFP"

ColumnNamesCsv_INB is TODO: It should be auto-generated!

var ColumnNamesCsv_TRF = "idx_cnt_map, idx_cnt_tpc"

ColumnNamesCsv_TRF is TODO: It should be auto-generated!

var ColumnSpecsCNT = []D.ColumnSpec{
	D.ColumnSpec{D.SFT_FRKEY.DT(), "idx_inbatch", "inbatch",
		"Input batch of imported content"},
	D.DD_RelFP,
	D.DD_AbsFP,
	D.ColumnSpec{D.SFT_FTEXT.DT(), "descr", "Description",
		"Content entity description"},
	D.DD_T_Cre,
	D.DD_T_Imp,
	D.DD_T_Edt,
	D.ColumnSpec{D.SFT_TOKEN.DT(), "rawmt", "Markup type", "Raw markup type"},
	D.ColumnSpec{D.SFT_STRNG.DT(), "mimtp", "MIME type", "MIME type"},
	D.ColumnSpec{D.SFT_STRNG.DT(), "mtype", "MType", "MType"},
	D.ColumnSpec{D.SFT_FTEXT.DT(), "contt", "Content", "Entity raw content"},
}

ColumnSpecsCNT field order MUST be kept in sync with ColumnNamesCsvCNT and [ColumnPtrsCNT] and it specifies:

• a primary key (actually, it does NOT - a primary key is assumed, and handled elsewhere)
• a foreign key "inbatch"
• two path fields (rel & abs)
• three time fields (creation, import, last-edit)
• a description
• three content-type fields (raw markup type, MIME-type, MType); NOTE: these are persisted in the DB because
• - they are useful in searching thru content
• - they can be expensive to calculate at import time
• - they can be overridden by choices made by users
• the content itself
• (not for now!) XML content type and XML DOCTYPE
• (not for now!) two LwDITA fields (flavor [xdita,hdita!,mdita]), LwDITA content type)

.

var ColumnSpecsINB = []D.ColumnSpec{
	D.ColumnSpec{D.SFT_COUNT.DT(), "filct",
		"Nr. of files", "Number of files"},
	D.ColumnSpec{D.SFT_FTEXT.DT(), "descr",
		"Batch descr.", "Inbatch description"},
	D.DD_T_Cre,
	D.DD_T_Imp,
	D.DD_T_Edt,
	D.DD_RelFP,
	D.DD_AbsFP,
}

ColumnSpecsINB field order MUST be kept in sync with ColumnNamesCsvINB and [ColumnPtrsINB]. It specifies:

• file count
• two path fields (rel & abs) (placed at the end because they tend to be looong)
• three time fields (creation, import, last-edit) (the meaning of creation is TBD)
• description
• NOT the primary key, which is handled automatically

.

var ColumnSpecsTRF = []D.ColumnSpec{
	D.ColumnSpec{D.SFT_FRKEY.DT(), "idx_cnt_map", "contentity",
		"Referencing map"},
	D.ColumnSpec{D.SFT_FRKEY.DT(), "idx_cnt_tpc", "contentity",
		"Referenced topic"},
}

ColumnSpecsTRF field order MUST be kept in sync with ColumnNamesCsvTRF and [ColumnPtrsTRF] and it specifies:

• the primary index into table "contentity" of the map that makes the reference
• the primary index into table "contentity" of the topic that is referred to
• NOT the primary key, which is handled automatically

Note that it is unclear ATM so far whether this table also includes maps referring to submaps, or topics referring to other topics. .

var M5_TableDetails = []DRM.TableDetails{
	TableDetailsCNT,
	TableDetailsINB,
	TableDetailsTRF,
}

M5_TableDetails configures the three key tables.

var PKSpecCNT = D.ColumnSpec{D.SFT_PRKEY.DT(),
	"idx_contentity", "Pri.key", "Primary key"}

PKSpecCNT should be auto.generated!

var PKSpecINB = D.ColumnSpec{D.SFT_PRKEY.DT(),
	"idx_inbatch", "Pri.key", "Primary key"}

PKSpecINB specifies the table's primary key. TODO: It should be auto.generated!

var PKSpecTRF = D.ColumnSpec{D.SFT_PRKEY.DT(),
	"idx_topicref", "Pri.key", "Primary key"}

PKSpecTRF specifies the table's primary key. TODO: It should be auto.generated!

var TableDetailsCNT = DRM.TableDetails{
	TableSummaryCNT,
	"idx_contentity",
	"IDX_inbatch, RelFP, AbsFP, Descr, T_Cre, T_Imp, T_Edt, " +
		"RawMT, Mimtp, MType, Contt",

	ColumnSpecsCNT,
	ColumnPtrsFuncCNT,

	&ContentityRow{},
}

TableDetailsCNT specifies 11 DB columns, incl primary key (assumed) and one foreign key, "inbatch".

var TableDetailsINB = DRM.TableDetails{
	TableSummaryINB,
	"idx_inbatch",
	ColumnNamesCsv_INB,
	ColumnSpecsINB,
	ColumnPtrsFuncINB,
	&InbatchRow{},
}

TableDetailsINB TBS has no foreign keys.

var TableDetailsTRF = DRM.TableDetails{
	TableSummaryTRF,
	"idx_topicref",
	ColumnNamesCsv_TRF,
	ColumnSpecsTRF,
	ColumnPtrsFuncTRF,
	&TopicrefRow{},
}

TableDetailsTRF specifies only two foreign keys.

var TableSummaryCNT = D.TableSummary{
	D.SCT_TABLE.DT(), "contentity", "cnt", "Content entity"}

TableSummaryCNT summarizes the table.

var TableSummaryINB = D.TableSummary{
	D.SCT_TABLE.DT(), "inbatch", "inb",
	"Input batch of imported files"}

var TableSummaryTRF = D.TableSummary{
	D.SCT_TABLE.DT(), "topicref", "trf",
	"Reference from map to topic"}