/// <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;
}
