public ColumnDidNotFoundException(string message, string dbString, string tableName, string columnName, DatabaseCursor cursor) : base(message) { this.dbString = dbString; this.tableName = tableName; this.columnName = columnName; this.cursor = cursor; }
public DatabaseScreen(StartupScreen startupScreen, string dbPath) { this.startupScreen = startupScreen; this.dbPath = dbPath; database = new DatabaseCursor(); InitializeComponent(); }
private void ExampleMain() { // Veritabanı imleci oluşturup bir veritabanına bağlanır DatabaseCursor database = new DatabaseCursor(); database.Connect(@"C:\Users\Ali Efe GÜR\Desktop\myDatabase.alfdb"); // İmleci bir tabloya götürür database.GoToTable("personalData"); /* * İmlecin bulunduğu tabloda 0. indeksten 5. indekse kadar olan kayıttan * id, ad ve soyad sütunlarındaki verileri çeker */ object[][] fetchedDatas = new object[4][]; for (int i = 0; i < 4; i++) { fetchedDatas[i] = database.FetchRecordByIndex(i); } foreach (object[] i in fetchedDatas) { foreach (object j in i) { Console.WriteLine(j); } } }
private void GoToMainMenu(object sender, EventArgs e) { // Bu sayfayı gizleyip başlangıç sayfasını gösterir Hide(); startupScreen.Show(); // RAM'i gereksiz verilerden temizler startupScreen = null; database = null; Dispose(); GC.Collect(); }
public Save() { DatabaseCursor db = new DatabaseCursor(); db.Connect(@"C:\Users\Ali Efe GÜR\Desktop\saveTestAsync.alfdb"); DateTime start = DateTime.Now; DateTime start1 = DateTime.Now; db.CreateTable("students", true, new string[] { "id", "name", "last_name", "class", "mark" }); db.GoToTable("students"); for (int i = 0; i < 10; i++) { for (int j = 0; j < 10000; j++) { db.AddRecord(new string[] { "name", "last_name", "class", "mark" }, new string[] { "Ali Efe", "GÜR", "11/B", "97.38" }); } DateTime finishTime1 = DateTime.Now; Console.WriteLine(((i + 1) * 10000).ToString() + " tane kayıt keydedildi!"); Console.WriteLine((finishTime1 - start1).TotalMilliseconds.ToString() + " milisaniyede\n"); start1 = DateTime.Now; } Console.WriteLine("Tüm kayıtlar", (DateTime.Now - start).ToString() + " sürede işlendi!"); db.CommitAsync(); Console.WriteLine(DateTime.Now - start); }
public TableDidNotSetException(string message, DatabaseCursor cursor) : base(message) { this.cursor = cursor; }
public TableAlreadyExistsException(string message, string dbString, string tableName, DatabaseCursor cursor) : base(message) { this.dbString = dbString; this.cursor = cursor; this.tableName = tableName; }
public DatabaseScreen() { database = new DatabaseCursor(); InitializeComponent(); }
public TableDidNotFoundException(string message, string dbString, DatabaseCursor cursor) : base(message) { this.dbString = dbString; this.cursor = cursor; }
public SaveData() { // Veritabanı imleci oluşturup bir veritabanına bağlanır DatabaseCursor database = new DatabaseCursor(); database.Connect(@"C:\Users\Ali Efe GÜR\Desktop\myDatabase.alfdb"); database.CreateTableIfNotExists("personalData", true, new string[] { "id", "name", "last_name" }); database.CreateTableIfNotExists("students", false, new string[] { "no", "class", "school", "markAverage" }); database.CreateTableIfNotExists("teachers", false, new string[] { "name", "last_name", "branch" }); database.CreateTableIfNotExists("workers", false, new string[] { "name", "last_name", "department", "salary" }); database.CreateTableIfNotExists("products", false, new string[] { "model", "brand", "price", "rate" }); database.CreateTableIfNotExists("films", false, new string[] { "name", "director", "imdb" }); database.CreateTableIfNotExists("games", false, new string[] { "name", "platform", "type" }); database.CreateTableIfNotExists("programmingLanguages", false, new string[] { "name", "compilable", "platform" }); database.GoToTable("personalData"); database.AddRecord(new string[] { "name", "last_name" }, new string[] { "Ali Efe", "GÜR" }); database.AddRecord(new string[] { "name", "last_name" }, new string[] { "Mehmet", "YILMAZ" }); database.AddRecord(new string[] { "name", "last_name" }, new string[] { "Hale", "KAYA" }); database.AddRecord(new string[] { "name", "last_name" }, new string[] { "Orhun Ege", "GÜR" }); Console.WriteLine("Database saving..."); database.Commit(); Console.WriteLine("Database saved!"); }