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) { }