def fill_halo(snap, buhid, val, co, cu): cmd = "INSERT INTO halo(id, snap, buhid) " cmd += " VALUES ('"+my.md5(snap, buhid) cmd += "','"+str(snap)+"','"+str(buhid)+"')"; cmd += " ON DUPLICATE KEY UPDATE atime=now();" my.sqlcu(cmd,co,cu) fmhires = float(val[38-1]) mvir = float(val[4-1]); if(is_dmonly()): m_gas = 0.0 m_star = 0.0 else: m_gas = float(val[45-1]) m_star = 0.0 m_star=float(val[65-1]) m_dm = mvir-m_gas-m_star cmd = "UPDATE halo SET " cmd += "npart='" +val[5-1]+"', " cmd += "fmhires='" +str(fmhires)+"', " cmd += "xc='"+val[6-1]+"', yc='"+val[7-1]+"', zc='"+val[8-1]+"', " cmd += "vxc='"+val[9-1]+"',vyc='"+val[10-1]+"',vzc='"+val[11-1]+"', " cmd += "mvir='"+val[4-1]+"', rvir='"+val[12-1]+"', " cmd += "vmax='"+val[17-1]+"', rmax='"+val[13-1]+"', " cmd += "sigv='"+val[19-1]+"', lambda='"+val[20-1]+"', " cmd += "lx='"+val[22-1]+"',ly='"+val[23-1]+"',lz='"+val[24-1]+"', " cmd += "a='1', eax='"+val[27-1]+"',eay='"+val[28-1]+"',eaz='"+val[29-1]+"', " cmd += "b='"+val[25-1]+"', ebx='"+val[30-1]+"',eby='"+val[31-1]+"',ebz='"+val[32-1]+"', " cmd += "c='"+val[26-1]+"', ecx='"+val[33-1]+"',ecy='"+val[34-1]+"',ecz='"+val[35-1]+"', " cmd += "ovdens='"+val[36-1]+"', " cmd += "redge='"+val[13-1]+"', " cmd += "nbins='"+val[37-1]+"', " cmd += "ekin='"+val[39-1]+"',epot='"+val[40-1]+"', " # cmd += "mbp_offset='"+val[16-1]+"', com_offset='"+val[17-1]+"', " cmd += "r2='"+val[14-1]+"', " cmd += "lambdae='"+val[21-1]+"', " cmd += "v_esc='"+val[18-1]+"', " cmd += "phi0='"+val[42-1]+"', " if(not is_dmonly()): cmd += "n_gas='"+val[44-1]+"', m_gas='"+val[45-1]+"', " cmd += "lambda_gas='"+val[46-1]+"', " cmd += "lx_gas='"+val[48-1]+"',ly_gas='"+val[49-1]+"',lz_gas='"+val[50-1]+"', " cmd += "a_gas='1', eax_gas='"+val[53-1]+"',eay_gas='"+val[54-1]+"',eaz_gas='"+val[55-1]+"', " cmd += "b_gas='"+val[51-1]+"', ebx_gas='"+val[56-1]+"',eby_gas='"+val[57-1]+"',ebz_gas='"+val[58-1]+"', " cmd += "c_gas='"+val[52-1]+"', ecx_gas='"+val[59-1]+"',ecy_gas='"+val[60-1]+"',ecz_gas='"+val[61-1]+"', " cmd += "ekin_gas='"+val[62-1]+"', epot_gas='"+val[63-1]+"', " cmd += "lambdae_gas='"+val[47-1]+"', " cmd += "n_star='"+val[64-1]+"', " cmd += "m_star='"+val[65-1]+"', " cmd += "lambda_star='"+val[66-1]+"', " cmd += "lx_star='"+val[68-1]+"',ly_star='"+val[69-1]+"',lz_star='"+val[70-1]+"', " cmd += "a_star='1', eax_star='"+val[73-1]+"',eay_star='"+val[74-1]+"',eaz_star='"+val[75-1]+"', " cmd += "b_star='"+val[71-1]+"', ebx_star='"+val[76-1]+"',eby_star='"+val[77-1]+"',ebz_star='"+val[78-1]+"', " cmd += "c_star='"+val[72-1]+"', ecx_star='"+val[79-1]+"',ecy_star='"+val[80-1]+"',ecz_star='"+val[81-1]+"', " cmd += "ekin_star='"+val[82-1]+"', epot_star='"+val[83-1]+"', " cmd += "lambdae_star='"+val[67-1]+"', " cmd += "m_dm='"+str(m_dm)+"', " cmd += "sim='"+get_active_sim()+"', " cmd += "atime=now() " cmd += "WHERE id='"+my.md5(snap,buhid)+"';" my.sqlcu(cmd,co,cu)
def fill_halo(snap, buhid, val): cmd = "INSERT INTO halo(id,snap,buhid) " cmd += " VALUES ('" + my.md5(snap, buhid) cmd += "','" + str(snap) + "','" + str(buhid) + "')" cmd += " ON DUPLICATE KEY UPDATE atime=now();" my.sql(cmd) cmd = "UPDATE halo SET " cmd += "npart='" + val[0] + "', " cmd += "fmhires='" + val[1] + "', " cmd += "xc='" + val[2] + "', yc='" + val[3] + "', zc='" + val[4] + "', " cmd += "vxc='" + val[5] + "',vyc='" + val[6] + "',vzc='" + val[7] + "', " cmd += "mvir='" + val[8] + "', rvir='" + val[9] + "', " cmd += "vmax='" + val[10] + "', rmax='" + val[11] + "', " cmd += "sigv='" + val[12] + "', " cmd += "lambda='" + val[13] + "', " cmd += "lx='" + val[14] + "',ly='" + val[15] + "',lz='" + val[16] + "', " cmd += "a='" + val[17] + "', " cmd += "eax='" + val[18] + "',eay='" + val[19] + "',eaz='" + val[20] + "', " cmd += "b='" + val[21] + "', " cmd += "ebx='" + val[22] + "',eby='" + val[23] + "',ebz='" + val[24] + "', " cmd += "c='" + val[25] + "', " cmd += "ecx='" + val[26] + "',ecy='" + val[27] + "',ecz='" + val[28] + "', " cmd += "ovdens='" + val[29] + "', " cmd += "redge='" + val[30] + "', " cmd += "nbins='" + val[31] + "', " cmd += "ekin='" + val[32] + "',epot='" + val[33] + "', " cmd += "mbp_offset='" + val[34] + "', " cmd += "com_offset='" + val[35] + "', " cmd += "r2='" + val[36] + "', " cmd += "lambdae='" + val[37] + "', " cmd += "v_esc='" + val[38] + "', " cmd += "phi0='" + val[39] + "', " cmd += "n_gas='" + val[40] + "', m_gas='" + val[41] + "', " cmd += "lambda_gas='" + val[42] + "', " cmd += "lx_gas='" + val[43] + "',ly_gas='" + val[44] + "',lz_gas='" + val[ 45] + "', " cmd += "a_gas='" + val[46] + "', " cmd += "eax_gas='" + val[47] + "',eay_gas='" + val[ 48] + "',eaz_gas='" + val[49] + "', " cmd += "b_gas='" + val[50] + "', " cmd += "ebx_gas='" + val[51] + "', " cmd += "eby_gas='" + val[52] + "', " cmd += "ebz_gas='" + val[53] + "', " cmd += "c_gas='" + val[54] + "', " cmd += "ecx_gas='" + val[55] + "', " cmd += "ecy_gas='" + val[56] + "', " cmd += "ecz_gas='" + val[57] + "', " cmd += "ekin_gas='" + val[58] + "', " cmd += "epot_gas='" + val[59] + "', " cmd += "lambdae_gas='" + val[60] + "', " cmd += "n_star='" + val[61] + "', " cmd += "m_star='" + val[62] + "', " cmd += "lambda_star='" + val[63] + "', " cmd += "lx_star='" + val[64] + "', " cmd += "ly_star='" + val[65] + "', " cmd += "lz_star='" + val[66] + "', " cmd += "a_star='" + val[67] + "', " cmd += "eax_star='" + val[68] + "', " cmd += "eay_star='" + val[69] + "', " cmd += "eaz_star='" + val[70] + "', " cmd += "b_star='" + val[71] + "', " cmd += "ebx_star='" + val[72] + "', " cmd += "eby_star='" + val[73] + "', " cmd += "ebz_star='" + val[74] + "', " cmd += "c_star='" + val[75] + "', " cmd += "ecx_star='" + val[76] + "', " cmd += "ecy_star='" + val[77] + "', " cmd += "ecz_star='" + val[78] + "', " cmd += "ekin_star='" + val[79] + "', " cmd += "epot_star='" + val[80] + "', " cmd += "lambdae_star='" + val[81] + "', " cmd += "atime=now() " cmd += "WHERE id='" + my.md5(snap, buhid) + "';" my.sql(cmd)
def fill_halo(snap,buhid,val): cmd = "INSERT INTO halo(id,snap,buhid) " cmd += " VALUES ('"+my.md5(snap,buhid) cmd += "','"+str(snap)+"','"+str(buhid)+"')"; cmd += " ON DUPLICATE KEY UPDATE atime=now();" my.sql(cmd) cmd = "UPDATE halo SET " cmd += "npart='" +val[0]+"', " cmd += "fmhires='" +val[1]+"', " cmd += "xc='"+val[2]+"', yc='"+val[3]+"', zc='"+val[4]+"', " cmd += "vxc='"+val[5]+"',vyc='"+val[6]+"',vzc='"+val[7]+"', " cmd += "mvir='"+val[8]+"', rvir='"+val[9]+"', " cmd += "vmax='"+val[10]+"', rmax='"+val[11]+"', " cmd += "sigv='"+val[12]+"', " cmd += "lambda='"+val[13]+"', " cmd += "lx='"+val[14]+"',ly='"+val[15]+"',lz='"+val[16]+"', " cmd += "a='"+val[17]+"', " cmd += "eax='"+val[18]+"',eay='"+val[19]+"',eaz='"+val[20]+"', " cmd += "b='"+val[21]+"', " cmd += "ebx='"+val[22]+"',eby='"+val[23]+"',ebz='"+val[24]+"', " cmd += "c='"+val[25]+"', " cmd += "ecx='"+val[26]+"',ecy='"+val[27]+"',ecz='"+val[28]+"', " cmd += "ovdens='"+val[29]+"', " cmd += "redge='"+val[30]+"', " cmd += "nbins='"+val[31]+"', " cmd += "ekin='"+val[32]+"',epot='"+val[33]+"', " cmd += "mbp_offset='"+val[34]+"', " cmd += "com_offset='"+val[35]+"', " cmd += "r2='"+val[36]+"', " cmd += "lambdae='"+val[37]+"', " cmd += "v_esc='"+val[38]+"', " cmd += "phi0='"+val[39]+"', " cmd += "n_gas='"+val[40]+"', m_gas='"+val[41]+"', " cmd += "lambda_gas='"+val[42]+"', " cmd += "lx_gas='"+val[43]+"',ly_gas='"+val[44]+"',lz_gas='"+val[45]+"', " cmd += "a_gas='"+val[46]+"', " cmd += "eax_gas='"+val[47]+"',eay_gas='"+val[48]+"',eaz_gas='"+val[49]+"', " cmd += "b_gas='"+val[50]+"', " cmd += "ebx_gas='"+val[51]+"', " cmd += "eby_gas='"+val[52]+"', " cmd += "ebz_gas='"+val[53]+"', " cmd += "c_gas='"+val[54]+"', " cmd += "ecx_gas='"+val[55]+"', " cmd += "ecy_gas='"+val[56]+"', " cmd += "ecz_gas='"+val[57]+"', " cmd += "ekin_gas='"+val[58]+"', " cmd += "epot_gas='"+val[59]+"', " cmd += "lambdae_gas='"+val[60]+"', " cmd += "n_star='"+val[61]+"', " cmd += "m_star='"+val[62]+"', " cmd += "lambda_star='"+val[63]+"', " cmd += "lx_star='"+val[64]+"', " cmd += "ly_star='"+val[65]+"', " cmd += "lz_star='"+val[66]+"', " cmd += "a_star='"+val[67]+"', " cmd += "eax_star='"+val[68]+"', " cmd += "eay_star='"+val[69]+"', " cmd += "eaz_star='"+val[70]+"', " cmd += "b_star='"+val[71]+"', " cmd += "ebx_star='"+val[72]+"', " cmd += "eby_star='"+val[73]+"', " cmd += "ebz_star='"+val[74]+"', " cmd += "c_star='"+val[75]+"', " cmd += "ecx_star='"+val[76]+"', " cmd += "ecy_star='"+val[77]+"', " cmd += "ecz_star='"+val[78]+"', " cmd += "ekin_star='"+val[79]+"', " cmd += "epot_star='"+val[80]+"', " cmd += "lambdae_star='"+val[81]+"', " cmd += "atime=now() " cmd += "WHERE id='"+my.md5(snap,buhid)+"';" my.sql(cmd)