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(); }
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 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); }