public class Xoh_stat_tbl implements Rls_able {
private static final String tbl_name = "hdump_stats";
private static final Dbmeta_fld_list flds = new Dbmeta_fld_list();
private static final String fld_page_id = flds.Add_int_pkey("page_id"),
fld_wtxt_len = flds.Add_int("wtxt_len"),
fld_row_orig_len = flds.Add_int("row_orig_len"),
fld_row_zip_len = flds.Add_int("row_zip_len"),
fld_body_len = flds.Add_int("body_len"),
fld_display_ttl_len = flds.Add_int("display_ttl_len"),
fld_content_sub_len = flds.Add_int("content_sub_len"),
fld_sidebar_div_len = flds.Add_int("sidebar_div_len"),
fld_js_math = flds.Add_int("js_math"),
fld_js_imap = flds.Add_int("js_imap"),
fld_js_packed = flds.Add_int("js_packed"),
fld_js_hiero = flds.Add_int("js_hiero"),
fld_a_rhs = flds.Add_int("a_rhs"),
fld_lnki_text_n = flds.Add_int("lnki_text_n"),
fld_lnki_text_y = flds.Add_int("lnki_text_y"),
fld_lnke_free = flds.Add_int("lnke_free"),
fld_lnke_auto = flds.Add_int("lnke_auto"),
fld_lnke_text = flds.Add_int("lnke_text"),
fld_hdr_1 = flds.Add_int("hdr_1"),
fld_hdr_2 = flds.Add_int("hdr_2"),
fld_hdr_3 = flds.Add_int("hdr_3"),
fld_hdr_4 = flds.Add_int("hdr_4"),
fld_hdr_5 = flds.Add_int("hdr_5"),
fld_hdr_6 = flds.Add_int("hdr_6"),
fld_img_full = flds.Add_int("img_full");
private final Db_conn conn;
private Db_stmt stmt_insert;
public Xoh_stat_tbl(Db_conn conn) {
this.conn = conn;
this.Create_tbl();
conn.Stmt_delete(tbl_name).Exec_delete(); // always zap table
conn.Rls_reg(this);
}
public void Create_tbl() {
conn.Meta_tbl_create(
Dbmeta_tbl_itm.New(
tbl_name, flds, Dbmeta_idx_itm.new_unique_by_tbl(tbl_name, "pkey", fld_page_id)));
}
public void Rls() {
stmt_insert = Db_stmt_.Rls(stmt_insert);
}
public void Insert(
Xoh_page hpg, Xoh_stat_itm hzip, int wtxt_len, int row_orig_len, int row_zip_len) {
Xopg_module_mgr js_mgr = hpg.Head_mgr();
if (stmt_insert == null) stmt_insert = conn.Stmt_insert(tbl_name, flds);
stmt_insert.Clear()
.Val_int(fld_page_id, hpg.Page_id())
.Val_int(fld_wtxt_len, wtxt_len)
.Val_int(fld_row_orig_len, row_orig_len)
.Val_int(fld_row_zip_len, row_zip_len)
.Val_int(fld_body_len, Len_or_0(hpg.Db().Html().Html_bry()))
.Val_int(fld_display_ttl_len, Len_or_0(hpg.Display_ttl()))
.Val_int(fld_content_sub_len, Len_or_0(hpg.Content_sub()))
.Val_int(fld_sidebar_div_len, Len_or_0(hpg.Sidebar_div()))
.Val_bool_as_byte(fld_js_math, js_mgr.Math_exists())
.Val_bool_as_byte(fld_js_imap, js_mgr.Imap_exists())
.Val_bool_as_byte(fld_js_packed, js_mgr.Gallery_packed_exists())
.Val_bool_as_byte(fld_js_hiero, js_mgr.Hiero_exists())
.Val_int(fld_a_rhs, hzip.A_rhs())
.Val_int(fld_lnki_text_n, hzip.Lnki_text_n())
.Val_int(fld_lnki_text_y, hzip.Lnki_text_y())
.Val_int(fld_lnke_free, hzip.Lnke__free())
.Val_int(fld_lnke_auto, hzip.Lnke__auto())
.Val_int(fld_lnke_text, hzip.Lnke__text())
.Val_int(fld_hdr_1, hzip.Hdr_1())
.Val_int(fld_hdr_2, hzip.Hdr_2())
.Val_int(fld_hdr_3, hzip.Hdr_3())
.Val_int(fld_hdr_4, hzip.Hdr_4())
.Val_int(fld_hdr_5, hzip.Hdr_5())
.Val_int(fld_hdr_6, hzip.Hdr_6())
.Val_int(fld_img_full, hzip.Img_full())
.Exec_insert();
}
private int Len_or_0(byte[] bry) {
return bry == null ? 0 : bry.length;
}
}
public Xobc_import_step_tbl(Db_conn conn) {
this.conn = conn;
this.tbl_name = "import_step";
this.fld_step_id = flds.Add_int_pkey("step_id");
this.fld_host_id = flds.Add_int("host_id");
this.fld_wiki_abrv = flds.Add_str("wiki_abrv", 255);
this.fld_wiki_date = flds.Add_str("wiki_date", 8);
this.fld_import_name = flds.Add_str("import_name", 255);
this.fld_import_type = flds.Add_int("import_type");
this.fld_import_zip = flds.Add_byte("import_zip");
this.fld_import_size_zip = flds.Add_long("import_size_zip");
this.fld_import_size_raw = flds.Add_long("import_size_raw");
this.fld_import_md5 = flds.Add_str("import_md5", 48);
this.fld_prog_size_end = flds.Add_long("prog_size_end");
this.fld_prog_count_end = flds.Add_long("prog_count_end");
conn.Rls_reg(this);
}
