/// <summary> /// Parses the values from the dictionary and /// add them to the variables /// </summary> /// <param name="settings">settings dictionary</param> public static void Set(Dictionary<string, string> settings) { // Server Settings ServerIP = (String) ParseSetting(ref settings, DType.String, "server_ip", "127.0.0.1"); Port = (Int16)ParseSetting(ref settings, DType.Int16, "server_port", (Int16) 8841); AcceptorKey = (String)ParseSetting(ref settings, DType.String, "acceptor_key", "secret"); GameServerPort = (Int16)ParseSetting(ref settings, DType.Int16, "gameserver_port", (Int16)4444); // Loads default SQL Settings String defaultSqlHost = (String) ParseSetting(ref settings, DType.String, "sql.hostname", "127.0.0.1"); Int16 defaultSqlPort = (Int16)ParseSetting(ref settings, DType.Int16, "sql.port", (Int16)3306); String defaultSqlUser = (String) ParseSetting(ref settings, DType.String, "sql.username", "rappelz"); String defaultSqlPass = (String) ParseSetting(ref settings, DType.String, "sql.password", "rappelz"); String defaultSqlDb = (String) ParseSetting(ref settings, DType.String, "sql.database", "rappelz"); // Database Engine SqlEngine = (SqlEngine)(Int32)ParseSetting(ref settings, DType.Int32, "sql.engine", 1); // Auth Database Settings SqlIp = (String) ParseSetting(ref settings, DType.String, "sql.auth_hostname", defaultSqlHost, true); SqlPort = (Int16)ParseSetting(ref settings, DType.Int16, "sql.auth_port", defaultSqlPort, true); SqlUsername = (String) ParseSetting(ref settings, DType.String, "sql.auth_username", defaultSqlUser, true); SqlPassword = (String) ParseSetting(ref settings, DType.String, "sql.auth_password", defaultSqlPass, true); SqlDatabase = (String) ParseSetting(ref settings, DType.String, "sql.auth_database", defaultSqlDb, true); // Other Settings LoginDebug = (Boolean)ParseSetting(ref settings, DType.Bool, "login_debug", false); WindowTitle = (String)ParseSetting(ref settings, DType.String, "window_name", "Auth"); UseMD5 = (Boolean)ParseSetting(ref settings, DType.Bool, "use_md5", false); Boolean DebugOnStart = (Boolean)ParseSetting(ref settings, DType.Bool, "debug_onstart", false, true); if (DebugOnStart) ConsoleHelper.Windows_ShowDebug(null); }
private void ConfirmLogin_Click(object sender, RoutedEventArgs e) { //create instance to SqlEngine for selected database SqlEngine sql = SqlEngine.GetInstance(); ////check if login data are correct /// bool isLogged = sql.TryLogin(cb_db_name.Text, login.Text, pass.Password.ToString()); if (isLogged) { //if login data are correctthen we can create main window. //we can pass sql instance to main window so we don't have to create another instance in main window //and we can use passed instance MainWindow mw = new MainWindow(sql); mw.Show(); this.Close(); } else { pass.Clear(); login.Clear(); MessageBox.Show("Niepoprawne dane logowania"); } }
public void CreateTableSql_SingleStringModel() { var sqlEngine = new SqlEngine(); var createTableSql = sqlEngine.CreateTable(SingleString.TableName, SingleString.ModelProperties); Assert.AreEqual("CREATE TABLE singlestrings (myattribute TEXT, id INTEGER PRIMARY KEY AUTOINCREMENT);", createTableSql); }
public void GetLastPrimaryKey() { var sqlEngine = new SqlEngine(); var getLastPrimaryKey = sqlEngine.GetLastPrimaryKey(); Assert.AreEqual("SELECT last_insert_rowid();", getLastPrimaryKey); }
public void CheckDbTableSql() { var sqlEngine = new SqlEngine(); var checkTableSql = sqlEngine.CheckTable("models"); Assert.AreEqual("SELECT name FROM sqlite_master WHERE type='table' AND name='models';", checkTableSql); }
public NamedConnectionString(string name, string providerName, string connectionString, string version) { Name = name; ProviderName = providerName; ConnectionString = connectionString; Version = version; SqlEngine = SqlEngineSemanticFormatter.GetSqlEngineByProviderName(ProviderName); }
public void CreateTableSql_SingleReferencingModel() { var sqlEngine = new SqlEngine(); var createTableSql = sqlEngine.CreateTable(SingleReferencingModel.TableName, SingleReferencingModel.ModelProperties); Assert.AreEqual("CREATE TABLE singlereferencingmodels (myreference int FOREIGN KEY REFERENCES referencedmodels(id), id int IDENTITY(1,1) PRIMARY KEY);", createTableSql); }
protected SqlEngineVersion(SqlEngine engine, string uniqueName, string versionString, string versionNumber, string providerName) { Engine = engine; UniqueName = uniqueName; VersionString = versionString; VersionNumber = versionNumber; ProviderName = providerName; }
public void GetLastPrimaryKey() { var sqlEngine = new SqlEngine(); var getLastPrimaryKey = sqlEngine.GetLastPrimaryKey(); Assert.AreEqual("SELECT LAST_INSERT_ID();", getLastPrimaryKey); }
public void CreateTableSql_UniqueValueModel() { var sqlEngine = new SqlEngine(); var createTableSql = sqlEngine.CreateTable(UniqueValue.TableName, UniqueValue.ModelProperties); Assert.AreEqual("CREATE TABLE uniquevalues (myattribute Nvarchar(255) UNIQUE, id int IDENTITY(1,1) PRIMARY KEY);", createTableSql); }
public void CreateTableSql_MultipleStringModel() { var sqlEngine = new SqlEngine(); var createTableSql = sqlEngine.CreateTable(MultipleString.TableName, MultipleString.ModelProperties); Assert.AreEqual("CREATE TABLE multiplestrings (myattribute1 TEXT, myattribute2 TEXT, myattribute3 TEXT, id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT);", createTableSql); }
public void CreateTableSql_MultipleStringModel() { var sqlEngine = new SqlEngine(); var createTableSql = sqlEngine.CreateTable(MultipleString.TableName, MultipleString.ModelProperties); Assert.AreEqual("CREATE TABLE multiplestrings (myattribute1 Nvarchar(max), myattribute2 Nvarchar(max), myattribute3 Nvarchar(max), id int IDENTITY(1,1) PRIMARY KEY);", createTableSql); }
public void CreateTableSql_MixedTypeModel() { var sqlEngine = new SqlEngine(); var createTableSql = sqlEngine.CreateTable(MixedType.TableName, MixedType.ModelProperties); Assert.AreEqual("CREATE TABLE mixedtypes (myattribute1 Nvarchar(max), myattribute2 int, myattribute3 binary, id int IDENTITY(1,1) PRIMARY KEY);", createTableSql); }
public void CreateTableSql_MixedTypeModel() { var sqlEngine = new SqlEngine(); var createTableSql = sqlEngine.CreateTable(MixedType.TableName, MixedType.ModelProperties); Assert.AreEqual("CREATE TABLE mixedtypes (myattribute1 TEXT, myattribute2 INTEGER, myattribute3 BLOB, id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT);", createTableSql); }
public void GetLastPrimaryKey() { var sqlEngine = new SqlEngine(); var getLastPrimaryKey = sqlEngine.GetLastPrimaryKey(); Assert.AreEqual("SELECT SCOPE_IDENTITY();", getLastPrimaryKey); }
public void CreateTableSql_UniqueValueModel() { var sqlEngine = new SqlEngine(); var createTableSql = sqlEngine.CreateTable(UniqueValue.TableName, UniqueValue.ModelProperties); Assert.AreEqual("CREATE TABLE uniquevalues (myattribute VARCHAR(255) UNIQUE, id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT);", createTableSql); }
public void CreateTableSql_SingleReferencingModel() { var sqlEngine = new SqlEngine(); var createTableSql = sqlEngine.CreateTable(SingleReferencingModel.TableName, SingleReferencingModel.ModelProperties); Assert.AreEqual("CREATE TABLE singlereferencingmodels (myreference INTEGER, id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, FOREIGN KEY(myreference) REFERENCES referencedmodels(id));", createTableSql); }
public void CreateTableSql_StringPk() { var sqlEngine = new SqlEngine(); var createTableSql = sqlEngine.CreateTable(StringPkModel.TableName, StringPkModel.ModelProperties); Assert.AreEqual("CREATE TABLE stringpkmodels (id VARCHAR(255) NOT NULL PRIMARY KEY);", createTableSql); }
public void CheckDbTableSql() { var sqlEngine = new SqlEngine(); var checkTableSql = sqlEngine.CheckTable("models"); Assert.AreEqual("SELECT table_name FROM information_schema.tables WHERE table_name='models' AND table_schema=DATABASE();", checkTableSql); }
public void CreateTableSql_MultipleReferencingModel() { var sqlEngine = new SqlEngine(); var createTableSql = sqlEngine.CreateTable(MultipleReferencingModel.TableName, MultipleReferencingModel.ModelProperties); Assert.AreEqual("CREATE TABLE multiplereferencingmodels (myreference1 INTEGER, myreference2 INTEGER, id INTEGER PRIMARY KEY AUTOINCREMENT, " + "FOREIGN KEY(myreference1) REFERENCES referencedmodels(id), FOREIGN KEY(myreference2) REFERENCES referencedmodels(id));", createTableSql); }
public MainWindow(SqlEngine sqlEngine) { shopService = new ShopService(new ShopRepository()); bankAccountService = new BankAccountService(new BankAccountRepository()); invoiceService = new InvoiceService(sqlEngine); reportService = new ReportService(sqlEngine); categoryService = new CategoryService(sqlEngine); budgetService = new BudgetService(new BudgetRepository()); InitializeComponent(); Main.Content = new InvoicePage(invoiceService, shopService, bankAccountService); this.Closed += new EventHandler(MainWindow_Closed); }
public void Example() { var credential = new D365Credential("instanceName", "crm4", "username", "password"); var engine = new SqlEngine(credential); var sql = @" select top 5 c.firstname, lastname 'Last Name', emailaddress1 Email from contact as c where emailaddress1 is not null and firstname = 'abc' and emailaddress1 like'*****@*****.**' order by c.firstname asc, lastname desc"; var dsResults = engine.Execute(sql); Assert.IsNotNull(dsResults); }
public static LolipopEngine CreateNewEngine(DataEngine engine) { LolipopEngine en = null; switch (engine) { case DataEngine.MySqlDataEngine: en = new MySqlEngine(); break; case DataEngine.SqlDataEngine: en = new SqlEngine(); break; } return(en); }
/// <summary> /// Executes when <see cref="Provider"/> initialization is complete. /// </summary> /// <param name="type">Aviable <see cref="Provider"/> <see cref="SqlEngine"/>.</param> /// <param name="activeConnectionsCount"><see cref="Provider"/> active connections count.</param> private static void OnProviderInitialized( SqlEngine type, byte activeConnectionsCount ) { Aviable = true; // audit record DataProvider.DataBase.ServiceAudit ( Settings.Default.ServiceUniqueID, ( byte )ServiceType.CacheService, ServiceAuditType.ServiceStarted, null ); Logger.WriteLine(Source.DataProvider, "{0} data provider initialized with {1} opened connections", type, activeConnectionsCount); // starting real time caching RealtimeManager.StartUp(); }
/// <summary> /// Executes when <see cref="Provider"/> initialization is complete. /// </summary> /// <param name="type">Aviable <see cref="Provider"/> <see cref="SqlEngine"/>.</param> /// <param name="activeConnectionsCount"><see cref="Provider"/> active connections count.</param> private static void OnProviderInitialized(SqlEngine type, byte activeConnectionsCount) { Aviable = true; // audit record DataProvider.DataBase.ServiceAudit ( Settings.Default.ServiceUniqueID, ( byte )ServiceType.CacheService, ServiceAuditType.ServiceStarted, null ); Logger.WriteLine(Source.DataProvider, "{0} data provider initialized with {1} opened connections", type, activeConnectionsCount); // starting real time caching RealtimeManager.StartUp(); }
/// <summary> /// Initializes data provider. /// </summary> /// <param name="sqlType"><see cref="SqlEngine"/> of data provider to use.</param> /// <param name="connectionString">Database engine connection string.</param> /// <param name="poolSize"><see cref="Provider"/> connections pool capacity.</param> /// <param name="queueDumpInterval">Interval in which cache service will execute cached commands.</param> internal static void Initialize( SqlEngine sqlType, string connectionString, byte poolSize, TimeSpan queueDumpInterval ) { switch ( sqlType ) { case SqlEngine.MsSql: { Instance = new MsSqlDataProvider(connectionString, poolSize, queueDumpInterval); Instance.OnInitialized += new ProviderInitializedEventDelegate(OnProviderInitialized); Instance.OnStopped += new ProviderStoppedEventDelegate(OnProviderStopped); Instance.Initialize(); return; } default: { Logger.WriteLine(Source.DataProvider, "Unsupported data provider: {0}", sqlType); return; } } }
/// <summary> /// Initializes data provider. /// </summary> /// <param name="sqlType"><see cref="SqlEngine"/> of data provider to use.</param> /// <param name="connectionString">Database engine connection string.</param> /// <param name="poolSize"><see cref="Provider"/> connections pool capacity.</param> /// <param name="queueDumpInterval">Interval in which cache service will execute cached commands.</param> internal static void Initialize(SqlEngine sqlType, string connectionString, byte poolSize, TimeSpan queueDumpInterval) { switch (sqlType) { case SqlEngine.MsSql: { Instance = new MsSqlDataProvider(connectionString, poolSize, queueDumpInterval); Instance.OnInitialized += new ProviderInitializedEventDelegate(OnProviderInitialized); Instance.OnStopped += new ProviderStoppedEventDelegate(OnProviderStopped); Instance.Initialize(); return; } default: { Logger.WriteLine(Source.DataProvider, "Unsupported data provider: {0}", sqlType); return; } } }
public void DbTypeToString_Decimal() => Assert.AreEqual("DECIMAL", SqlEngine.DbTypeToString(System.Data.DbType.Decimal));
public void DbTypeToString_Double() => Assert.AreEqual("DOUBLE", SqlEngine.DbTypeToString(System.Data.DbType.Double));
public void DbTypeToString_Single() => Assert.AreEqual("FLOAT", SqlEngine.DbTypeToString(System.Data.DbType.Single));
public void DbTypeToString_Binary() => Assert.AreEqual("BLOB", SqlEngine.DbTypeToString(System.Data.DbType.Binary));
public void DbTypeToString_Date() => Assert.AreEqual("DATETIME(4)", SqlEngine.DbTypeToString(System.Data.DbType.DateTime));
/// <summary> /// Initializes new instance of <see cref="Provider"/> class. /// </summary> /// <param name="sqlType"><see cref="Provider"/> SQL type.</param> /// <param name="connectionString">Connection string.</param> /// <param name="queueDumpInterval">Interval in which lazy commands queue will execute collected commands.</param> public Provider( SqlEngine sqlType, string connectionString, TimeSpan queueDumpInterval ) { ConnectionString = connectionString; Type = sqlType; QueueDumpInterval = queueDumpInterval; }
/// <summary> /// Initializes new instance of <see cref="DataBaseInstaller"/> object. /// </summary> /// <param name="engine">Database engine type.</param> public DataBaseInstaller( SqlEngine engine ) { Engine = engine; }
public InvoiceService(SqlEngine sqlEngine) { this.sqlEngine = sqlEngine; }
internal static void SetConnectionData(SqlEngine engine, string authCon, string gameCon, string userCon) { ConType = engine; AuthConString = authCon; GameConString = gameCon; UserConString = userCon; }