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)
