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