internal Database(string dataFile) { FilePath = dataFile; Connection = File.Exists(dataFile) ? new SQLiteConnector(dataFile, true) : CreateEmptyDatabase(dataFile); }
static Program() { string dataFolder = GetDataFolder(); string dataFile = Path.Combine(dataFolder, AppName + ".data"); try { if (File.Exists(dataFile)) { dataConn = new SQLiteConnector(dataFile, true); } else { const string ddlFile = "Data_definition.sql"; // SQL script file that creates an empty database. if (!File.Exists(ddlFile)) { MessageBox.Show("Application file missing!\n" + ddlFile, AppName, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } Directory.CreateDirectory(dataFolder); // does nothing if already existing. dataConn = new SQLiteConnector(dataFile, false); dataConn.Write(File.ReadAllText(ddlFile)); } } catch (Exception err) { MessageBox.Show($"Error creating database file!\n\n{err.GetType().Name}\n{err.Message}", AppName, MessageBoxButtons.OK, MessageBoxIcon.Error); dataConn = null; // to trigger early return from Main(). return; } Debug.Assert(dataConn != null && File.Exists(dataFile)); }
public Data(SQLiteConnector connection) { Debug.Assert(connection != null); this.connection = connection; Dirty = true; }
static void RunTest() { SQLiteConnector dbConnector = SQLiteConnector.Instance; // act //dbConnector.EmptyDB(); //dbConnector.selectAll(dbTables.tblTermContent); }
public MainWindowVM() { bool status = false; string db_file = "db_file.sqlite"; //Init and Test Database Connection IDBConnectorEF dbconn = new SQLiteConnector(db_file); status = dbconn.Open(); if (status) { dbconn.Close(); } if (status) { //Assign to application wide shared variable. AppData.DBConn = dbconn; //Add ViewModel to the Content list _ContentVM.Add(new Module.Client.ClientManagerVM()); _ContentVM.Add(new Module.Service.ClientManagerVM()); _ContentVM.Add(new Module.Other.OtherManagerVM()); //Init Menu Bar Commands. InitializeCommands(); } }
public FormCuentas(AdminMain parent) { InitializeComponent(); this.Icon = Icon.ExtractAssociatedIcon(Application.ExecutablePath); con = new SQLiteConnector(); fillGrids(); this.parent = parent; }
public FormAddAcc(FormCuentas parent) { InitializeComponent(); this.Icon = Icon.ExtractAssociatedIcon(Application.ExecutablePath); this.parent = parent; con = new SQLiteConnector(); isEditing = false; }
/// <summary> /// Select which Datastorage to use /// </summary> /// <param name="dbType"></param> public static void InitalizeConnections(DataBaseType dbType) { if (dbType == DataBaseType.SQLite) { SQLiteConnector sql = new SQLiteConnector(); Connection = sql; } }
private SQLiteConnector CreateEmptyDatabase(string dataFile) { Directory.CreateDirectory(Path.GetDirectoryName(dataFile)); var connection = new SQLiteConnector(dataFile, false); connection.Write(ddl); return(connection); }
public FormCrearTrabajo(string idCourse, FormProfessor p) { InitializeComponent(); this.Icon = Icon.ExtractAssociatedIcon(Application.ExecutablePath); this.idCourse = idCourse; con = new SQLiteConnector(); parent = p; }
public FormForum(string idAuthor, string idCourse, ForumMenu parent) { InitializeComponent(); this.Icon = Icon.ExtractAssociatedIcon(Application.ExecutablePath); this.idAuthor = idAuthor; this.idCourse = idCourse; con = new SQLiteConnector(); this.parent = parent; }
public void InsertNewArrayAttributeRelationship() { using (SQLiteConnector connector = new SQLiteConnector(TestDataHelper.FilePath)) { string sql = $"INSERT INTO DataSeries_Attributes (DataSeries_Id, Attributes_AttributeName) values('3', 'Some other attribute')"; connector.WriteTextData(sql); } }
public void WhenIAddANewAttribute(string attributeName) { using (SQLiteConnector connector = new SQLiteConnector(TestDataHelper.FilePath)) { string sql = $"INSERT INTO Attributes (AttributeName) values('{attributeName}')"; connector.WriteTextData(sql); } }
public FormEnviarCal(string idStudent, string idAssignment, FormRevisar parent) { InitializeComponent(); this.Icon = Icon.ExtractAssociatedIcon(Application.ExecutablePath); con = new SQLiteConnector(); this.idAssignment = idAssignment; this.idStudent = idStudent; this.parent = parent; setMax(); }
public FormAddAcc(FormCuentas parent, string idUs, string accType) { InitializeComponent(); con = new SQLiteConnector(); idUser = idUs; this.parent = parent; isEditing = true; accountType = accType; fillFields(); }
public void InsertNewAttribute() { using (SQLiteConnector connector = new SQLiteConnector(TestDataHelper.FilePath)) { string uniqueAttribute = "attribute " + DateTime.Now.ToString("ddMMyyyy_HHmmss.f"); string sql = $"INSERT INTO Attributes (AttributeName) values('{uniqueAttribute}')"; connector.WriteTextData(sql); } }
public FormPosts(string idForum, string idAutor) { InitializeComponent(); this.Icon = Icon.ExtractAssociatedIcon(Application.ExecutablePath); con = new SQLiteConnector(); this.idForum = idForum; this.idAutor = idAutor; getTitle(); GetOP(); }
public void MuseReturnNameWhenUsingWrongId() { SQLiteConnector con = new SQLiteConnector(); using (var context = con.GetContext()) { var r3 = con.GetRecord(4); Assert.IsNull(r3); } }
public void MuseReturnNameWhenUsingWrongHebrewName() { SQLiteConnector con = new SQLiteConnector(); using (var context = con.GetContext()) { var r2 = con.GetRecord("ניסים"); Assert.IsNull(r2.Result); } }
public FormRevisar(string idAssignment, string AssName, FormProfessor parent) { InitializeComponent(); this.Icon = Icon.ExtractAssociatedIcon(Application.ExecutablePath); this.idAssignment = idAssignment; AssignmentName = AssName; setTitle(); con = new SQLiteConnector(); fillDataGridTrabajos(); this.parent = parent; }
public FormProfessor(FormLogin l, string idAccount) { InitializeComponent(); this.Icon = Icon.ExtractAssociatedIcon(Application.ExecutablePath); con = new SQLiteConnector(); login = l; this.idAccount = idAccount; setTitle(); FillDataGridView(); selectedCourse = ""; }
public FormEditStudent(string idCourse, FormSendCourse parent) { InitializeComponent(); this.Icon = Icon.ExtractAssociatedIcon(Application.ExecutablePath); this.idCourse = idCourse; numericUpDown1.Maximum = decimal.MaxValue; numericUpDown1.Minimum = 1; this.parent = parent; con = new SQLiteConnector(); }
public void WhenIAssociateDataSeriesWithSomeOtherAttribute(int recordNum, string attributeName) { using (SQLiteConnector connector = new SQLiteConnector(TestDataHelper.FilePath)) { string sql = $"INSERT INTO DataSeries_Attributes (DataSeries_Id, Attributes_AttributeName) values('{recordNum}', '{attributeName}')"; connector.WriteTextData(sql); } UpdateDatabaseResults(); }
public FormSendCourse(string idCourse, string courseName, string teacherID) { InitializeComponent(); this.Icon = Icon.ExtractAssociatedIcon(Application.ExecutablePath); con = new SQLiteConnector(); numericUpDown1.Minimum = 1; numericUpDown1.Maximum = decimal.MaxValue; this.idCourse = idCourse; textBox1.Text = courseName; numericUpDown1.Value = Convert.ToDecimal(teacherID); fillStudents(); }
public void MuseReturnNameWhenUsingHebrewName() { SQLiteConnector con = new SQLiteConnector(); using (var context = con.GetContext()) { var r1 = con.GetRecord(1); Assert.IsNotNull(r1); Assert.AreEqual(r1.Hebrew, "משה"); Assert.AreEqual(r1.English, "Moshe"); } }
public void MuseReturnNameWhenUsingId() { SQLiteConnector con = new SQLiteConnector(); using (var context = con.GetContext()) { var r1 = con.GetRecord(1); Assert.IsNotNull(r1); File.WriteAllText(@"c:\log\output.txt", r1.English); Assert.AreEqual(r1.Hebrew, "משה"); Assert.AreEqual(r1.English, "Moshe"); } }
public void DbContextMustNotBeNull() { SQLiteConnector con = new SQLiteConnector(); using (var context = con.GetContext()) { Assert.IsNotNull(context); var r2 = con.GetRecord("דוד"); Assert.IsNotNull(r2); Assert.AreEqual(r2.Result.Hebrew, "דוד"); Assert.AreEqual(r2.Result.English, "David"); } }
public void WhenIAddANewDataSeriesToTheDatabase() { double[,] multiArray = DbDataConverter.ConvertTwoDoubleArrayToMultiDimArray(TestDataHelper.RetentionVols, TestDataHelper.RI); byte[] serializedScatterSeries = DbDataConverter.SerializeMultiDimentionalDoubleArray(multiArray); string name = "Visual Studio Test"; string date = DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss.f"); using (SQLiteConnector connector = new SQLiteConnector(TestDataHelper.FilePath)) { string sql = $"INSERT INTO DataSeries (Name, AcquisitionDate, Data) values('{name}', '{date}', @serializedScatterSeries)"; connector.WriteDataContainingParameters(sql, new KeyValuePair <string, byte[]>("serializedScatterSeries", serializedScatterSeries)); } }
public static void InitializeConnections() { //if (db == DatabaseType.SQLite) //{ // SQLiteConnector sqlite = new SQLiteConnector(); // Connection = sqlite; //} //else if (db == DatabaseType.TextFile) //{ // TextConnector text = new TextConnector(); // Connection = text; //} SQLiteConnector sqlite = new SQLiteConnector(); Connection = sqlite; }
/// <summary> /// Initialize connections. /// This connections we want to set up. /// (called at program starts). /// </summary> public static void InitializeConnections(DatabaseType db) { if (db == DatabaseType.SqlDb) { // TODO - St up the SQL Connection properly. SqlDbConnector sql = new SqlDbConnector(); Connection = (IDataConnection)sql; CnnString = ConfigurationManager.ConnectionStrings["SQLServer"].ConnectionString; } else if (db == DatabaseType.SQLite) { // TODO - Create Access Connection SQLiteConnector sql = new SQLiteConnector(); Connection = sql; //CnnString = ConfigurationManager.ConnectionStrings["SQLite"].ConnectionString; CnnString = "Data Source=" + Environment.CurrentDirectory + "\\LessonsSchedulerDB.db;"; } }
/// <summary> /// Obtiene el comando de SQLite para ser ejecutado en la conexión dada /// </summary> /// <param name="db">Conexión a la base de datos</param> /// <returns>El comando SQLite</returns> public SQLiteCommand GetCommand(SQLiteConnector db) { var result = db.Connection.CreateCommand(); result.CommandText = SQL; result.Transaction = db.Transaction; if (parameters != null) { foreach (var parameterKey in parameters.Keys) { var value = parameters[parameterKey]; result.Parameters.AddWithValue(parameterKey, value); } } return result; }