public async Task Single_series_field_projection_to_anonymous_type()
{
var h2o_feet = new WaterDepth();
var query = InfluxQuery.From(h2o_feet)
.Select(fields => new { fields.water_level })
.Where("location = 'santa_monica'");
var results = await fixture.Client.Query(query.Statement);
var expectedFirstTwoPoints = new[]
public override string ToString() =>
string.Join(',', new string[]
{ SurveyType.ToString(),
WaterDepth.ToString(),
X.ToString(),
Y.ToString(),
GNSSAltitude.ToString(),
GNSSHeading.ToString(),
GNSSSpeed.ToString(),
MagneticHeading.ToString(),
MinRange.ToString(),
MaxRange.ToString(),
WaterTemperature.ToString(),
WaterSpeed.ToString(),
HardwareTime.ToString(),
Frequency.ToString(),
Milliseconds.ToString() + '\n' });
public async Task <double> SumTheWaterLevel(string endpoint, string database)
{
var h2o_feet = new WaterDepth();
var query = InfluxQuery.From(h2o_feet).Select(x => new { x.water_level });
var client = new InfluxQLClient(new Uri(endpoint), database);
var results = await client.Query(query.Statement);
double total = 0;
foreach (var(time, values) in results)
{
total += values.water_level;
}
return(total);
}
public void ApplyVideo()
{
XmlDocument xmlDoc = new XmlDocument();
try{
using (FileStream fs = new FileStream(mFilepath, FileMode.Open, FileAccess.Read, FileShare.Read)) {
xmlDoc.Load(fs);
}
}catch (Exception e) {
GameLog.HandleIOException(e, GameLog.EIOFileType.Settings);
xmlDoc = new XmlDocument();
}
XmlElement findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("QualityLevel");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("QualityLevel");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("Index", mQualityLevel.ToString());
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("GLSetting");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("GLSetting");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("value", GLSetting);
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("LightCount");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("LightCount");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("Index", mLightCount.ToString());
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("AnisotropicFiltering");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("AnisotropicFiltering");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("Index", mAnisotropicFiltering.ToString());
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("AntiAliasing");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("AntiAliasing");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("Index", mAntiAliasing.ToString());
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("ShadowProjection");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("ShadowProjection");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("Index", mShadowProjection.ToString());
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("ShadowDistance");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("ShadowDistance");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("Index", mShadowDistance.ToString());
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("ShadowCascades");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("ShadowCascades");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("Index", mShadowCascades.ToString());
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("mWaterReflection");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("mWaterReflection");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("Index", mWaterReflection.ToString());
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("WaterRefraction");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("WaterRefraction");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("Index", WaterRefraction.ToString());
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("WaterDepth");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("WaterDepth");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("Index", WaterDepth.ToString());
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("GrassDensity");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("GrassDensity");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("Index", GrassDensity.ToString());
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("GrassLod");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("GrassLod");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("Index", ((int)mGrassLod).ToString());
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("Terrain");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("Terrain");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("Index", TerrainLevel.ToString());
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("RandomTerrain");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("RandomTerrain");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("Index", RandomTerrainLevel.ToString());
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("DepthBlur");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("DepthBlur");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("value", mDepthBlur.ToString());
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("SSAO");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("SSAO");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("value", mSSAO.ToString());
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("SyncCount");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("SyncCount");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("value", SyncCount.ToString());
ResetVSync();
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("Tree");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("Tree");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("Index", mTreeLevel.ToString());
// GrassMgr.RefreshSettings(GrassDensity, (int)GrassLod);
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("HDREffect");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("HDREffect");
xmlDoc.DocumentElement.AppendChild(findNode);
}
findNode.SetAttribute("Index", HDREffect.ToString());
findNode = (XmlElement)xmlDoc.DocumentElement.SelectSingleNode("FastLightingMode");
if (null == findNode)
{
findNode = xmlDoc.CreateElement("FastLightingMode");
xmlDoc.DocumentElement.AppendChild(findNode);
}
//mFastLightingMode = true;
findNode.SetAttribute("Index", mFastLightingMode.ToString());
switch (mQualityLevel)
{
case 0:
QualitySettings.SetQualityLevel(0);
#if Win32Ver
TerrainLevel = 0;
#else
TerrainLevel = 1; //increase from 128M to 256M for bug 502857
#endif
RandomTerrainLevel = 0;
mTreeLevel = 1;
HDREffect = false;
break;
case 1:
QualitySettings.SetQualityLevel(1);
TerrainLevel = 1; //increase from 128M to 256M for bug 502857
RandomTerrainLevel = 0;
mTreeLevel = 1;
HDREffect = false;
break;
case 2:
QualitySettings.SetQualityLevel(2);
TerrainLevel = 1;
RandomTerrainLevel = 1;
mTreeLevel = 1;
HDREffect = false;
break;
case 3:
QualitySettings.SetQualityLevel(3);
TerrainLevel = 2;
RandomTerrainLevel = 1;
mTreeLevel = 3;
HDREffect = true;
break;
case 4:
QualitySettings.SetQualityLevel(4);
TerrainLevel = 3;
RandomTerrainLevel = 2;
mTreeLevel = 4;
HDREffect = true;
break;
case 5:
QualitySettings.SetQualityLevel(5);
TerrainLevel = 3;
RandomTerrainLevel = 2;
mTreeLevel = 5;
HDREffect = true;
break;
case 6:
QualitySettings.SetQualityLevel(3); // for Ubuntu with AMD card, larger than 3 will cause game select GL_FBCONFIG 47/55 which can not render defered-render cam
QualitySettings.pixelLightCount = mLightCount;
switch (mAnisotropicFiltering)
{
case 0:
QualitySettings.anisotropicFiltering = AnisotropicFiltering.Disable;
break;
case 1:
QualitySettings.anisotropicFiltering = AnisotropicFiltering.Enable;
break;
case 2:
QualitySettings.anisotropicFiltering = AnisotropicFiltering.ForceEnable;
break;
}
QualitySettings.antiAliasing = (mAntiAliasing > 0)? 4 : 0;
QualitySettings.shadowProjection = (mShadowProjection == 1)? ShadowProjection.StableFit :ShadowProjection.CloseFit;
switch (mShadowDistance)
{
case 0:
QualitySettings.shadowDistance = 1;
break;
case 1:
QualitySettings.shadowDistance = 50;
break;
case 2:
QualitySettings.shadowDistance = 100;
break;
case 3:
QualitySettings.shadowDistance = 200;
break;
case 4:
QualitySettings.shadowDistance = 400;
break;
}
switch (mShadowCascades)
{
case 0:
QualitySettings.shadowCascades = 0;
break;
case 1:
QualitySettings.shadowCascades = 2;
break;
case 2:
QualitySettings.shadowCascades = 4;
break;
}
break;
}
PeGrassSystem.Refresh(GrassDensity, (int)GrassLod);
PECameraMan.ApplySysSetting();
try{
using (FileStream fs = new FileStream(mFilepath, FileMode.Create, FileAccess.Write, FileShare.None)) {
xmlDoc.Save(fs);
}
}catch (Exception e) {
GameLog.HandleIOException(e, GameLog.EIOFileType.Settings);
}
}
