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