public static void AddDatabase(string databaseName, CHXDatabaseParameters connectionParameters, CHXDatabaseType databaseType)
{
lock (_locker)
{
var db = new CHXDatabaseContainer()
{
Name = databaseName
};
db.Database = new CHXDatabaseManager(new CHXDatabase.IO.CHXDatabase(connectionParameters, databaseType));
AddDatabase(db);
}
}
public static CHXDatabaseConnection GetDatabase(CHXDatabaseParameters connectionParameters, CHXDatabaseType?databaseType, ICHXDatabase manager)
{
lock (_locker)
{
switch (databaseType)
{
case CHXDatabaseType.PostgreSql:
return(new CHXPostgreSql(connectionParameters, manager));
default:
return(null);
}
}
}
public CHXDatabaseContainer Add(string databaseName, CHXDatabaseParameters connectionParameters, CHXDatabaseType databaseType)
{
CHXDatabaseContainer db = null;
if (this[databaseName] == null)
{
db = new CHXDatabaseContainer()
{
Name = databaseName
};
db.Database = new CHXDatabaseManager(new CHXDatabase.IO.CHXDatabase(connectionParameters, databaseType));
this.Add(db);
}
return(db);
}
static void Main(string[] args)
{
string aaa = "denemeveri";
var test = aaa.HasSpecialChars();
var tt = new CHXGeometry();
tt.ReadWkt("MULTILINESTRING((31.4496904 36.7991082,31.4504789 36.7986288), (31.4496904 36.7991082,31.4504789 36.7986288))");
var parameters = new CHXDatabaseParameters();
parameters.Add("Server", "192.168.2.188");
parameters.Add("Port", "5432");
parameters.Add("Database", "atakumgis");
parameters.Add("User Id", "postgres");
parameters.Add("Password", "ntc123*");
var mydatabase = new CHXDatabase.IO.CHXDatabase(parameters, CHXDatabaseType.PostgreSql);
var manager = new CHXDatabaseLibrary.CHXDatabaseManager(mydatabase);
//var query = manager.ConvertQuery<string>(@"{ ""server"": ""kbb2"", ""schema"": ""public"", ""query"": { ""geoyol"": { ""type"": ""table"", ""addgeometry"": true, ""field"": [ ""objectid"", ""yol_adi"" ], ""find"": [ { ""yol_tipi_id"": 4, ""yol_turu_id"": 5 }, { ""yol_turu_id"": 4 } ] }, ""kod_yol_turu"": { ""type"": ""table"", ""field"": [ ""adi => yol_turu"" ] }, ""kod_yol_tipi"": { ""type"": ""table"", ""field"": [ ""adi => yol_tipi"" ] } }, ""join"": { ""inner"": { ""kod_yol_turu.kod"": ""geoyol.yol_turu_id"" }, ""left"": { ""kod_yol_tipi.kod"": ""geoyol.yol_tipi_id"" } } }",
// CHXDatabaseLibrary.CHXQueryType.Json);
//var query = manager.ConvertQuery<string>(@"{ ""server"": ""atakumgis"", ""schema"": ""public"", ""query"": { ""parsel"": { ""type"": ""table"", ""addgeometry"": true, ""field"": [ ""objectid"", ""adaparsel"", ""alan"" ], ""find"": [ { ""tapu_mah_adi"": ""AKALAN"" } ], ""geo_shape"": { ""location"": { ""shape"": { ""type"": ""Point"", ""coordinates"" : [515458.256064797, 4585609.61491352] }, ""relation"": ""intersect"" } } } } }",
// CHXQueryType.Json);
var query = manager.ConvertQuery <string>(@"{ ""server"": ""atakumgis"", ""schema"": ""public"", ""limit"":2, ""query"": { ""parsel"": { ""type"": ""table"", ""addgeometry"": true, ""field"": [ ""objectid"", ""adaparsel"", ""alan"" ], ""geo_shape"": { ""location"": { ""shape"": { ""type"": ""Point"", ""coordinates"" : [515458.256064797, 4585609.61491352] }, ""relation"": ""distance"", ""distance"" : 20 } } } } }",
CHXQueryType.Json);
var result = manager.RunQuery <dynamic>(query);
var json = JsonConvert.SerializeObject(result, Newtonsoft.Json.Formatting.Indented,
new Newtonsoft.Json.JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
}
);
}
public override object Call(CHXRequest data, string method)
{
if (method.ToLower() != "put")
{
return(null);
}
var _name = data.Find("name");
var _type = data.Find("type");
var _parameters = data.Find("parameters");
if (_name == null)
{
return(null);
}
if (_type == null)
{
return(null);
}
if (_parameters == null)
{
return(null);
}
if (CHXDatabaseFactory.DatabaseCollection[_name.Value.ToString()] != null)
{
return("Aynı isimden veri tabanı bulunuyor");
}
CHXDatabaseType databaseType = (CHXDatabaseType)System.Enum.Parse(typeof(CHXDatabaseType), _type.Value.ToString());
var parameters = new CHXDatabaseParameters();
parameters.AddRange(_parameters.Select(p => new CHXDatabaseParameter(p.Name, p.Value.ToString())));
CHXDatabaseFactory.AddDatabase(_name.Value.ToString(), parameters, databaseType);
return(_name.Value.ToString());
}
public CHXPostgreSql(CHXDatabaseParameters connectionParameters, ICHXDatabase manager) : base(connectionParameters, manager)
{
}
