public RunOneSqlTest()
{
DataBase.Configure();
DatabaseItemService = new DatabaseItemService();
SqlService = new SqlService(DatabaseItemService);
UserService = new UserService();
}
public DatabaseItemController(DatabaseItemService databaseItemService)
{
DatabaseItemService = databaseItemService;
}
public SqlController(SqlService sqlService, DatabaseItemService databaseItemService)
{
SqlService = sqlService;
DatabaseItemService = databaseItemService;
}
public void Test1()
{
var user = new User
{
Email = "*****@*****.**",
NickName = "Jonas",
Password = "******",
Created = DateTime.Now,
CreaterId = -1
};
var userExample = user;
var users = UserService.Select(u => u.Email == userExample.Email).ToList();
if (users.Any())
{
user = users.First();
}
else
{
UserService.Insert(user);
}
var databaseItem = new DatabaseItem
{
Title = "Test Server",
Type = MySqlClientBuilder.ForType,
Server = "localhost",
Port = 3306,
DatabaseName = "test",
Uid = "root",
Pwd = "",
Removed = false,
CreaterId = user.Id,
Created = DateTime.Now
};
var example = databaseItem;
var databaseItems = DatabaseItemService.Select(item => item.DatabaseName == example.DatabaseName).ToList();
if (databaseItems.Any())
{
databaseItem = databaseItems.First();
}
else
{
DatabaseItemService.Insert(databaseItem);
}
var sql = new SqlItem
{
DatabaseId = databaseItem.Id,
Content = "INSERT INTO test.table1 (c1, c2, c3, c4) VALUES ('Hello', 'World', 0, '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") +
"');",
CreaterId = user.Id,
Created = DateTime.Now
};
SqlService.Insert(sql);
SqlService.Run(sql, user);
}
