/// <summary>
/// The main entry point for the application.
/// </summary>
static void Main()
{
SQLiteClient db;
SQLiteResultSet results;
Console.WriteLine("Basic test app for SQLite.NET. Enter a single line sql query and it will be run against the database.\r\n");
Console.WriteLine("Opening database 'test.db'...\r\n");
try {
// Open database
db = new SQLiteClient("test.db");
} catch (SQLiteException e) {
Console.WriteLine("Fatal error: {0}", e.Message);
Console.ReadLine();
return;
}
Console.WriteLine("Available tables:");
ArrayList tables = db.GetColumn("SELECT name FROM sqlite_master WHERE type = 'table'");
foreach (string tableName in tables) {
Console.WriteLine("\t" + tableName);
}
// Main loop
while (true) {
Console.Write("SQL> ");
string input = Console.ReadLine();
if (input == null || input.Trim() == "") {
continue;
}
if (input == ".quit") {
return;
}
try {
results = db.Execute(input);
ConsoleTable table = new ConsoleTable();
table.SetHeaders(results.ColumnNames);
// Loop through the results and display them
foreach (ArrayList arr in results.Rows) {
table.AppendRow(arr);
}
while (results.IsMoreData) {
Hashtable foo = results.GetRowHash();
foo.GetType();
}
Console.WriteLine(table.ToString());
} catch (SQLiteException e) {
Console.WriteLine(e.Message);
}
}
}
/// <summary>
/// The main entry point for the application.
/// </summary>
static void Main()
{
SQLiteClient db;
SQLiteResultSet results;
Console.WriteLine("Basic test app for SQLite.NET. Enter a single line sql query and it will be run against the database.\r\n");
Console.WriteLine("Opening database 'test.db'...\r\n");
try {
// Open database
db = new SQLiteClient("test.db");
} catch (SQLiteException e) {
Console.WriteLine("Fatal error: {0}", e.Message);
Console.ReadLine();
return;
}
Console.WriteLine("Available tables:");
ArrayList tables = db.GetColumn("SELECT name FROM sqlite_master WHERE type = 'table'");
foreach (string tableName in tables)
{
Console.WriteLine("\t" + tableName);
}
// Main loop
while (true)
{
Console.Write("SQL> ");
string input = Console.ReadLine();
if (input == null || input.Trim() == "")
{
continue;
}
if (input == ".quit")
{
return;
}
try {
results = db.Execute(input);
ConsoleTable table = new ConsoleTable();
table.SetHeaders(results.ColumnNames);
// Loop through the results and display them
foreach (ArrayList arr in results.Rows)
{
table.AppendRow(arr);
}
while (results.IsMoreData)
{
Hashtable foo = results.GetRowHash();
foo.GetType();
}
Console.WriteLine(table.ToString());
} catch (SQLiteException e) {
Console.WriteLine(e.Message);
}
}
}
