public static void ExecuteBySqlTest()
{
StringBuilder sbCreateTableSql = new StringBuilder();
//附属信息
sbCreateTableSql.Append("Create table ControllerAttachedInfo(ID in9teger not null primary key autoincrement,controllerID integer not null,FileVersion varchar(4), ProtocolVersion varchar(4));");
string strDBFile = "E:\\test.db";
//_logHelper = Substitute.For<SCA.Interface.ILogRecorder>();
_dbConn = new SCA.DatabaseAccess.SQLiteDatabaseAccess(strDBFile, _logHelper, _fileService);
int returnValue = _dbConn.ExecuteBySql(sbCreateTableSql);
//Assert.AreEqual(0, returnValue);
// _dbConn.Dispose();
//ILogRecorder _logHelper;
//IFileService _fileService;
//IDatabaseService _dbConn;// = new SCA.DatabaseAccess.SQLiteDatabaseAccess("test.db", logHelper);
//StringBuilder sbCreateTableSql = new StringBuilder();
////附属信息
//sbCreateTableSql.Append("Create table ControllerAttachedInfo(ID integer not null primary key autoincrement,controllerID integer not null,FileVersion varchar(4), ProtocolVersion varchar(4));");
//string strDBFile = "test.db";
//_logHelper = Substitute.For<SCA.Interface.ILogRecorder>();
//_fileService = Substitute.For<SCA.Interface.IFileService>();
//_dbConn = new SCA.DatabaseAccess.SQLiteDatabaseAccess(strDBFile, _logHelper, _fileService);
//int returnValue = _dbConn.ExecuteBySql(sbCreateTableSql);
// Assert.AreEqual(0, returnValue);
//_dbConn.Dispose();
}
private void AddInstagramAccount_Click(object sender, EventArgs e)
{
var instagramAccount = new InstagramAccount()
{
EmailPhone = instaEmailPhone.Text,
Password = instaPassword.Text,
UserId = SQLiteDatabaseAccess.GetLoggedUser().Id,
FollowedPersonLinkString = Guid.NewGuid().ToString(),
LikedPersonLinkString = Guid.NewGuid().ToString(),
};
try
{
var succes = SQLiteDatabaseAccess.AddInstagramAccount(instagramAccount);
if (succes)
{
MessageBox.Show("Added account with success", "Success", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
// clear listview and display new list
listOfInstagramAccounts.Clear();
LoadInstaAccountsFromDB();
}
else
{
MessageBox.Show("Problems occured adding the account", "Error", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
instaEmailPhone.Clear();
instaPassword.Clear();
}
}
catch (Exception ex) { }
}
public static IDBServer FromConnectionString(string connectionString)
{
var connProvider = new DBConnectionProvider(connectionString, () => new SQLiteConnection(connectionString));
var dbAccess = new SQLiteDatabaseAccess(connProvider);
var version =
connProvider.PerformFunc(conn => conn.ExecuteScalar <string>("SELECT sqlite_version();"));
return(new DBServer(dbAccess, version));
}
public void CreateDatabase()
{
_dbConn = new DatabaseAccess.SQLiteDatabaseAccess(strDBFile, _logHelper, _fileService);
_dbConn.CreateDBFile();
bool fileExistFlag = _fileService.IsExistFile(strDBFile);
Assert.AreEqual(true, fileExistFlag);
//_dbConn.Dispose();
}
public void AddUser()
{
User user = new User()
{
Username = "******",
Password = "******",
};
SQLiteDatabaseAccess.AddUser(user);
}
private void LoadInstaAccountsFromDB()
{
var instagramAccountsList = SQLiteDatabaseAccess.GetInstagramAccount(SQLiteDatabaseAccess.GetLoggedUser().Id);
foreach (var acc in instagramAccountsList)
{
ListViewItem lvi = new ListViewItem(acc.EmailPhone);
listOfInstagramAccounts.Items.Add(lvi);
}
}
public void ExecuteBySqlTest()
{
StringBuilder sbCreateTableSql = new StringBuilder();
//附属信息
sbCreateTableSql.Append("Create table ControllerAttachedInfo(ID integer not null primary key autoincrement,controllerID integer not null,FileVersion varchar(4), ProtocolVersion varchar(4));");
_dbConn = new DatabaseAccess.SQLiteDatabaseAccess(strDBFile, _logHelper, _fileService);
int returnValue = _dbConn.ExecuteBySql(sbCreateTableSql);
Assert.AreEqual(0, returnValue);
}
private void Register_Click(object sender, EventArgs e)
{
User user = new User()
{
Username = usernameTextbox.Text,
Password = passwordTextbox.Text,
};
SQLiteDatabaseAccess.AddUser(user);
MessageBox.Show("Register Success", "Success", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
}
public void AddFollowedPerson()
{
var user = SQLiteDatabaseAccess.GetUser("morti", "mati");
var instagramAccount = SQLiteDatabaseAccess.GetInstagramAccount("0765835785");
FollowedPerson followedPerson = new FollowedPerson()
{
FollowedPersonLinkString = instagramAccount.FollowedPersonLinkString,
FollowDate = DateTime.Now,
UserURL = "https://www.instagram.com/cacat.la_punga/"
};
SQLiteDatabaseAccess.AddFollowedPerson(followedPerson);
}
public void GetObjectValueTest()
{
StringBuilder sbCreateTableSql = new StringBuilder();
//附属信息
sbCreateTableSql.Append("Create table ControllerAttachedInfo2(ID integer not null primary key autoincrement,controllerID integer not null,FileVersion varchar(4), ProtocolVersion varchar(4));");
_dbConn = new DatabaseAccess.SQLiteDatabaseAccess(strDBFile, _logHelper, _fileService);
_dbConn.ExecuteBySql(sbCreateTableSql);
int intControllerAttachedInfoNum = Convert.ToInt16(_dbConn.GetObjectValue(new StringBuilder("select count(*) from ControllerAttachedInfo2")));
Assert.AreEqual(0, intControllerAttachedInfoNum);
//_dbConn.Dispose();
}
public static void GetObjectValueTest()
{
StringBuilder sbCreateTableSql = new StringBuilder();
//附属信息
sbCreateTableSql.Append("Create table ControllerAttachedInfo2(ID integer not null primary key autoincrement,controllerID integer not null,FileVersion varchar(4), ProtocolVersion varchar(4));");
string strDBFile = "E:\\test.db";
//_logHelper = Substitute.For<SCA.Interface.ILogRecorder>();
//_fileService = new SCA.BusinessLib.Utility.FileService();
_dbConn = new SCA.DatabaseAccess.SQLiteDatabaseAccess(strDBFile, _logHelper, _fileService);
_dbConn.ExecuteBySql(sbCreateTableSql);
int intControllerAttachedInfoNum = Convert.ToInt16(_dbConn.GetObjectValue(new StringBuilder("select count(*) from Co9ntrollerAttachedInfo2")));
_dbConn.Dispose();
}
public void GetDataListBySQLTest()
{
IList <LoopModel> lstLoopModel = new List <LoopModel>();
StringBuilder sbCreateTableSql = new StringBuilder();
//回路信息
sbCreateTableSql.Append("Create table Loop(id integer not null primary key autoincrement,name varchar(20),Code varchar(6),controllerID int,DeviceAmount int );");
_dbConn = new DatabaseAccess.SQLiteDatabaseAccess(strDBFile, _logHelper, _fileService);
_dbConn.ExecuteBySql(sbCreateTableSql);
_dbConn.ExecuteBySql(new StringBuilder("insert into Loop(id,name,Code,controllerID,DeviceAmount) values(1,'william','0101',1,55)"));
lstLoopModel = (List <LoopModel>)_dbConn.GetDataListBySQL <SCA.Model.LoopModel>(new StringBuilder("select * from Loop"));
Assert.AreEqual(1, lstLoopModel.Count);
}
private void LoginButton_Click(object sender, EventArgs e)
{
var user = SQLiteDatabaseAccess.GetUser(usernameTextbox.Text, passwordTextbox.Text);
if (user != null)
{
SQLiteDatabaseAccess.LoadUser(user);
Homepage homepage = new Homepage();
homepage.Show();
this.Hide();
}
else
{
MessageBox.Show("Failed to login", "Failed", MessageBoxButtons.OK,
MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
}
}
private void UseSelectedAccount_Click(object sender, EventArgs e)
{
if (listOfInstagramAccounts.SelectedItems.Count == 1)
{
var selectedAccountEmailPhone = SQLiteDatabaseAccess.GetInstagramAccount(listOfInstagramAccounts.SelectedItems[0].Text);
if (selectedAccountEmailPhone != null)
{
InstaToolFeatures itf = new InstaToolFeatures(selectedAccountEmailPhone);
itf.Show();
this.Hide();
}
}
else
{
MessageBox.Show("Please select an account from the list", "Warning", MessageBoxButtons.OK,
MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1);
}
}
public Home PerformLogin(string emailOrPhone)
{
InstagramAccount instaAccount = null;
try
{
instaAccount = SQLiteDatabaseAccess.GetInstagramAccount(emailOrPhone);
LoggedAccount = emailOrPhone;
}
catch (Exception ex) { }
if (instaAccount != null)
{
try
{
IWebElement cookiesAccept = DriverExtensions.FindElement(InstaDriver, By.XPath("//*[contains(@class,'aOOlW bIiDR ')]"), 20);
cookiesAccept.Click();
IWebElement loginEmail = InstaDriver.FindElementByXPath("//*[contains(@aria-label,'Phone number, username, or email')]");
loginEmail.SendKeys(emailOrPhone);
IWebElement loginPassword = InstaDriver.FindElementByXPath("//*[contains(@aria-label,'Password')]");
loginPassword.SendKeys(instaAccount.Password);
IWebElement loginButton = InstaDriver.FindElementByXPath("//*[contains(@type,'submit')]");
loginButton.Click();
if (CheckIsLoggedIn())
{
PassLoginPopUps();
LogHelper.Log("Succesfully logged in");
return(new Home(InstaDriver));
}
}
catch (Exception ex)
{
LogHelper.Log($"Some error occured trying to login..., {ex.GetType()}");
}
}
return(null);
}
public DataTable LoadDataTable(string tableName)
{
return(SQLiteDatabaseAccess.LoadDataTable(tableName));
}
public void GetListOfFollowedPersons()
{
var list = SQLiteDatabaseAccess.GetFollowedPersonsOfInstaAccount("0765835785");
}
public void RetrieveUsers()
{
var people = SQLiteDatabaseAccess.LoadUsers();
}
public DataTable CreateTable(string tableName)
{
return(SQLiteDatabaseAccess.CreateTable("AAA"));
}
public ArrayList GetTableNames()
{
return(SQLiteDatabaseAccess.GetTableNames());
}
public void SaveTable(DataTable table)
{
SQLiteDatabaseAccess.SaveTable(table);
}
public void DeleteTable(DataTable table)
{
SQLiteDatabaseAccess.DeleteTable(table.TableName);
}
