public void Insert( int step_id, int host_id, byte[] wiki_abrv, String wiki_date, String import_name, int import_type, byte zip_type, byte[] md5, long size_zip, long size_raw, long prog_size_end, int prog_count_end) { if (insert_stmt == null) insert_stmt = conn.Stmt_insert(tbl_name, flds); insert_stmt.Clear() .Val_int(fld_step_id, step_id) .Val_int(fld_host_id, host_id) .Val_bry_as_str(fld_wiki_abrv, wiki_abrv) .Val_str(fld_wiki_date, wiki_date) .Val_str(fld_import_name, import_name) .Val_int(fld_import_type, import_type) .Val_byte(fld_import_zip, zip_type) .Val_long(fld_import_size_zip, size_zip) .Val_long(fld_import_size_raw, size_raw) .Val_bry_as_str(fld_import_md5, md5) .Val_long(fld_prog_size_end, prog_size_end) .Val_int(fld_prog_count_end, prog_count_end) .Exec_insert(); }
public void Split__trg__nth__rls(Split_ctx ctx, Db_conn trg_conn) { // make rndm_rng and add Rndm_rng_itm rng_itm = bldr.Exec_rng_end_or_null(); if (rng_itm == null) return; Rndm_rng_tbl rng_tbl = new Rndm_rng_tbl(trg_conn); rng_tbl.Create_tbl(); Db_stmt rng_stmt = rng_tbl.Insert_stmt(); rng_tbl.Insert( rng_stmt, rng_itm.Mgr_idx(), rng_itm.Rng_idx(), rng_itm.Seq_bgn(), rng_itm.Seq_end()); rng_stmt.Rls(); bldr.Conn().Txn_end(); // make rndm_seq and bulk copy Rndm_seq_tbl seq_tbl = new Rndm_seq_tbl(trg_conn); seq_tbl.Create_tbl(); Split_tbl_.Bld_insert_by_select(tmp_bfr, seq_tbl.Tbl_name(), seq_tbl.Flds()); tmp_bfr.Add_str_u8_fmt( "WHERE {0} = {1} AND {2} = {3}", seq_tbl.Fld__qry_idx(), bldr.Qry_idx(), seq_tbl.Fld__rng_idx(), bldr.Rng_idx()); attach_mgr.Conn_main_(trg_conn).Conn_links_(new Db_attach_itm("src_db", bldr.Conn())); attach_mgr.Exec_sql(tmp_bfr.To_str_and_clear()); // bldr.Conn().Txn_bgn("rndm"); }
public static void Insert(Db_stmt stmt, byte status, int id, byte wkr_tid, String wkr_msg) { stmt.Clear().Val_int(id).Val_byte(status).Val_byte(wkr_tid).Val_str(wkr_msg).Exec_insert(); }