private void InitializeTables()
{
List <string> tableNames = _Database.ListTables();
tableNames = tableNames.ConvertAll(d => d.ToLower());
if (!tableNames.Contains(USER_TABLE.ToLower()))
{
List <Column> userColumns = UserMaster.GetTableColumns();
_Database.CreateTable(USER_TABLE, userColumns);
}
if (!tableNames.Contains(API_KEY_TABLE.ToLower()))
{
List <Column> apiKeyColumns = ApiKey.GetTableColumns();
_Database.CreateTable(API_KEY_TABLE, apiKeyColumns);
}
if (!tableNames.Contains(PERMISSION_TABLE.ToLower()))
{
List <Column> permissionColumns = Permission.GetTableColumns();
_Database.CreateTable(PERMISSION_TABLE, permissionColumns);
}
if (!tableNames.Contains(LOCKS_TABLE.ToLower()))
{
List <Column> locksColumns = UrlLock.GetTableColumns();
_Database.CreateTable(LOCKS_TABLE, locksColumns);
}
if (!tableNames.Contains(CONTAINERS_TABLE.ToLower()))
{
List <Column> containerColumns = Container.GetTableColumns();
_Database.CreateTable(CONTAINERS_TABLE, containerColumns);
}
if (!tableNames.Contains(OBJECTS_TABLE.ToLower()))
{
List <Column> objectColumns = ObjectMetadata.GetTableColumns();
_Database.CreateTable(OBJECTS_TABLE, objectColumns);
}
if (!tableNames.Contains(CONTAINERS_KVP_TABLE.ToLower()))
{
List <Column> containerMetadataColumns = ContainerKeyValuePair.GetTableColumns();
_Database.CreateTable(CONTAINERS_KVP_TABLE, containerMetadataColumns);
}
if (!tableNames.Contains(OBJECTS_KVP_TABLE.ToLower()))
{
List <Column> objectMetadataColumns = ObjectKeyValuePair.GetTableColumns();
_Database.CreateTable(OBJECTS_KVP_TABLE, objectMetadataColumns);
}
if (!tableNames.Contains(AUDIT_LOG_TABLE.ToLower()))
{
List <Column> auditLogColumns = AuditLogEntry.GetTableColumns();
_Database.CreateTable(AUDIT_LOG_TABLE, auditLogColumns);
}
}
private void InitializeTables()
{
List <string> tableNames = _Database.ListTables();
tableNames = tableNames.ConvertAll(d => d.ToLower());
if (!tableNames.Contains(USER_TABLE.ToLower()))
{
List <Column> userColumns = UserMaster.GetTableColumns();
_Database.CreateTable(USER_TABLE, userColumns);
}
if (!tableNames.Contains(API_KEY_TABLE.ToLower()))
{
List <Column> apiKeyColumns = ApiKey.GetTableColumns();
_Database.CreateTable(API_KEY_TABLE, apiKeyColumns);
}
if (!tableNames.Contains(PERMISSION_TABLE.ToLower()))
{
List <Column> permissionColumns = Permission.GetTableColumns();
_Database.CreateTable(PERMISSION_TABLE, permissionColumns);
}
if (!tableNames.Contains(LOCKS_TABLE.ToLower()))
{
List <Column> locksColumns = UrlLock.GetTableColumns();
_Database.CreateTable(LOCKS_TABLE, locksColumns);
}
if (!tableNames.Contains(CONTAINERS_TABLE.ToLower()))
{
List <Column> containerColumns = Container.GetTableColumns();
_Database.CreateTable(CONTAINERS_TABLE, containerColumns);
}
}
/// <summary>
/// Create table (if it doesn't exist) for a given class.
/// Adding a table that has already been added will throw an ArgumentException.
/// </summary>
/// <param name="t">Class for which a table should be created.</param>
public void InitializeTable(Type t)
{
if (!_Initialized)
{
throw new InvalidOperationException("Initialize WatsonORM and database using the .InitializeDatabase() method first.");
}
if (t == null)
{
throw new ArgumentNullException(nameof(t));
}
string tableName = ReflectionHelper.GetTableNameFromType(t);
string primaryKeyPropertyName = ReflectionHelper.GetPrimaryKeyPropertyName(t);
List <Column> columns = ReflectionHelper.GetColumnsFromType(t);
if (String.IsNullOrEmpty(tableName))
{
throw new InvalidOperationException("Type '" + t.Name + "' does not have a 'Table' attribute.");
}
if (String.IsNullOrEmpty(primaryKeyPropertyName))
{
throw new InvalidOperationException("Type '" + t.Name + "' does not have a property with the 'PrimaryKey' attribute.");
}
if (columns == null || columns.Count < 1)
{
throw new InvalidOperationException("Type '" + t.Name + "' does not have any properties with a 'Column' attribute.");
}
if (!_Database.TableExists(tableName))
{
_Database.CreateTable(tableName, columns);
}
_TypeMetadataMgr.Add(t, new TypeMetadata(tableName, primaryKeyPropertyName, columns));
_Logger?.Invoke(_Header + "initialized table " + tableName + " for type " + t.Name + " with " + columns.Count + " column(s)");
}
static async Task PostTableCreate(RequestMetadata md)
{
string dbName = md.Http.Request.Url.Elements[0];
DatabaseClient db = _Databases.GetDatabaseClient(dbName);
if (db == null)
{
md.Http.Response.StatusCode = 404;
md.Http.Response.ContentType = "application/json";
await md.Http.Response.Send(SerializationHelper.SerializeJson(new ErrorResponse(ErrorCodeEnum.NotFound, "The requested object was not found", null), true));
return;
}
if (md.Http.Request.Data == null || md.Http.Request.ContentLength < 1)
{
_Logging.Warn("PostTableCreate no request body supplied");
md.Http.Response.StatusCode = 400;
md.Http.Response.ContentType = "application/json";
await md.Http.Response.Send(SerializationHelper.SerializeJson(new ErrorResponse(ErrorCodeEnum.MissingRequestBody, "Invalid request", "No request body supplied"), true));
return;
}
Table table = SerializationHelper.DeserializeJson <Table>(md.Http.Request.DataAsString);
db.CreateTable(table.Name, table.Columns);
_Logging.Info("PostTableCreate created table " + table.Name + " in database " + dbName);
md.Http.Response.StatusCode = 201;
md.Http.Response.ContentType = "application/json";
await md.Http.Response.Send();
return;
}
/// <summary>
/// Create table (if it doesn't exist) for a given class.
/// Adding a table that has already been added will throw an ArgumentException.
/// </summary>
/// <param name="t">Class for which a table should be created.</param>
public void InitializeTable(Type t)
{
if (!_Initialized)
{
throw new InvalidOperationException("Initialize WatsonORM and database using the .InitializeDatabase() method first.");
}
if (t == null)
{
throw new ArgumentNullException(nameof(t));
}
string tableName = ReflectionHelper.GetTableNameFromType(t);
string primaryKeyPropertyName = ReflectionHelper.GetPrimaryKeyPropertyName(t);
List <Column> columns = ReflectionHelper.GetColumnsFromType(t);
if (String.IsNullOrEmpty(tableName))
{
throw new InvalidOperationException("Type '" + t.Name + "' does not have a 'Table' attribute.");
}
if (String.IsNullOrEmpty(primaryKeyPropertyName))
{
throw new InvalidOperationException("Type '" + t.Name + "' does not have a property with the 'PrimaryKey' attribute.");
}
if (columns == null || columns.Count < 1)
{
throw new InvalidOperationException("Type '" + t.Name + "' does not have any properties with a 'Column' attribute.");
}
if (!_Database.TableExists(tableName))
{
_Database.CreateTable(tableName, columns);
}
else
{
List <Column> existingColumns = _Database.DescribeTable(tableName);
foreach (Column column in columns)
{
if (!existingColumns.Exists(c => c.Name.Equals(column.Name)))
{
throw new InvalidOperationException("Table '" + tableName + "' exists but column '" + column.Name + "' does not.");
}
}
List <string> existingColumnNames = existingColumns.Select(c => c.Name).ToList();
List <string> definedColumnNames = columns.Select(c => c.Name).ToList();
List <string> delta = existingColumnNames.Except(definedColumnNames).ToList();
if (delta != null && delta.Count > 0)
{
string deltaStr = "";
foreach (string currDelta in delta)
{
if (!String.IsNullOrEmpty(deltaStr))
{
deltaStr = deltaStr + ", ";
}
deltaStr += currDelta;
}
_Logger?.Invoke(_Header + "table " + tableName + " contains additional columns not decorated in the class definition: " + deltaStr);
}
}
_TypeMetadataMgr.Add(t, new TypeMetadata(tableName, primaryKeyPropertyName, columns));
_Logger?.Invoke(_Header + "initialized table " + tableName + " for type " + t.Name + " with " + columns.Count + " column(s)");
}
static void Main(string[] args)
{
Console.WriteLine("Opening file");
DatabaseClient sql = new DatabaseClient("test");
sql.Logger = Logger;
sql.LogQueries = true;
sql.LogResults = true;
Console.WriteLine("Creating table...");
List <Column> columns = new List <Column>();
columns.Add(new Column("id", true, DataType.Integer, false));
columns.Add(new Column("name", false, DataType.Text, true));
columns.Add(new Column("postal", false, DataType.Integer, true));
sql.CreateTable("company", columns);
Console.WriteLine("Checking if table 'company' exists: " + sql.TableExists("company"));
Console.WriteLine("Retrieving list of tables...");
List <string> tableNames = sql.ListTables();
if (tableNames != null && tableNames.Count > 0)
{
foreach (string curr in tableNames)
{
Console.WriteLine(" " + curr);
}
}
Console.WriteLine("Describing database...");
Dictionary <string, List <Column> > describeResult = sql.DescribeDatabase();
if (describeResult != null && describeResult.Count > 0)
{
foreach (KeyValuePair <string, List <Column> > curr in describeResult)
{
Console.WriteLine(" Table " + curr.Key);
if (curr.Value != null && curr.Value.Count > 0)
{
foreach (Column col in curr.Value)
{
Console.WriteLine(" " + col.ToString());
}
}
}
}
Console.WriteLine("Describing table 'company'...");
List <Column> cols = sql.DescribeTable("company");
if (cols != null && cols.Count > 0)
{
foreach (Column curr in cols)
{
Console.WriteLine(" " + curr.ToString());
}
}
Console.WriteLine("Adding data...");
Dictionary <string, object> d1 = new Dictionary <string, object>();
d1.Add("name", "company 1");
d1.Add("postal", 95128);
Dictionary <string, object> d2 = new Dictionary <string, object>();
d2.Add("name", "company 2");
d2.Add("postal", 62629);
Dictionary <string, object> d3 = new Dictionary <string, object>();
d3.Add("name", "company 3");
d3.Add("postal", 10101);
Dictionary <string, object> d4 = new Dictionary <string, object>();
d4.Add("name", "company 4");
d4.Add("postal", 90210);
Console.WriteLine("Created ID: " + sql.Insert("company", d1).ToString());
Console.WriteLine("Created ID: " + sql.Insert("company", d2).ToString());
Console.WriteLine("Created ID: " + sql.Insert("company", d3).ToString());
Console.WriteLine("Created ID: " + sql.Insert("company", d4).ToString());
Console.WriteLine("Selecting companies with postal > 70000...");
Expression eRetrieve1 = new Expression("postal", Operators.GreaterThan, 70000);
DataTable selectResult1 = sql.Select("company", 0, null, null, eRetrieve1, null);
Console.WriteLine("Retrieved " + selectResult1.Rows.Count + " rows");
Console.WriteLine("Selecting companies with postal > 70000 or postal < 50000...");
Expression eRetrieve2 = new Expression
{
LeftTerm = new Expression("postal", Operators.GreaterThan, 70000),
Operator = Operators.Or,
RightTerm = new Expression("postal", Operators.LessThan, 50000)
};
DataTable selectResult2 = sql.Select("company", 0, null, null, eRetrieve2, null);
Console.WriteLine("Retrieved " + selectResult2.Rows.Count + " rows");
Console.WriteLine("Deleting records...");
Expression eDelete = new Expression("id", Operators.GreaterThan, 0);
sql.Delete("company", eDelete);
Console.WriteLine("Dropping table...");
sql.DropTable("company");
}
static void Main(string[] args)
{
try
{
#region Select-Database-Type
/*
*
*
* Create the database 'test' before proceeding if using mssql, mysql, or pgsql
*
*
*/
Console.Write("User: "******"Password: "******"localhost", 1433, user, pass, null, "test");
_Database = new DatabaseClient(_Settings);
_Database.Logger = Logger;
_Database.LogQueries = true;
_Database.LogResults = true;
#endregion
#region Drop-Table
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Dropping table '" + _Table + "'...");
_Database.DropTable(_Table);
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Create-Table
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Creating table '" + _Table + "'...");
List <Column> columns = new List <Column>();
columns.Add(new Column("id", true, DataType.Int, 11, null, false));
columns.Add(new Column("firstname", false, DataType.Nvarchar, 30, null, false));
columns.Add(new Column("lastname", false, DataType.Nvarchar, 30, null, false));
columns.Add(new Column("age", false, DataType.Int, 11, null, true));
columns.Add(new Column("value", false, DataType.Long, 12, null, true));
columns.Add(new Column("birthday", false, DataType.DateTime, null, null, true));
columns.Add(new Column("hourly", false, DataType.Decimal, 18, 2, true));
_Database.CreateTable(_Table, columns);
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Check-Existence-and-Describe
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Table '" + _Table + "' exists: " + _Database.TableExists(_Table));
Console.WriteLine("Table '" + _Table + "' configuration:");
columns = _Database.DescribeTable(_Table);
foreach (Column col in columns)
{
Console.WriteLine(col.ToString());
}
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Load-Update-Retrieve-Delete
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Loading rows...");
LoadRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Loading multiple rows...");
LoadMultipleRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
Console.WriteLine("Checking existence...");
ExistsRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
Console.WriteLine("Counting age...");
CountAge();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
Console.WriteLine("Summing age...");
SumAge();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Updating rows...");
UpdateRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving rows...");
RetrieveRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving rows by index...");
RetrieveRowsByIndex();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving rows by between...");
RetrieveRowsByBetween();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving sorted rows...");
RetrieveRowsSorted();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Deleting rows...");
DeleteRows();
Console.WriteLine("Press ENTER to continue");
Console.ReadLine();
#endregion
#region Cause-Exception
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Testing exception...");
try
{
_Database.Query("SELECT * FROM " + _Table + "(((");
}
catch (Exception e)
{
Console.WriteLine("Caught exception: " + e.Message);
Console.WriteLine("Query: " + e.Data["Query"]);
}
#endregion
#region Drop-Table
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Dropping table...");
_Database.DropTable(_Table);
Console.ReadLine();
#endregion
}
catch (Exception e)
{
ExceptionConsole("Main", "Outer exception", e);
}
}
static void Main(string[] args)
{
try
{
#region Setup-Database
Console.Write("Filename: ");
string filename = Console.ReadLine();
if (String.IsNullOrEmpty(filename))
{
return;
}
_Settings = new DatabaseSettings(filename);
_Database = new DatabaseClient(_Settings);
_Database.Logger = Logger;
_Database.LogQueries = true;
_Database.LogResults = true;
#endregion
#region Drop-Table
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Dropping table 'person'...");
_Database.DropTable("person");
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Create-Table
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Creating table 'person'...");
List <Column> columns = new List <Column>();
columns.Add(new Column("id", true, DataType.Int, 11, null, false));
columns.Add(new Column("firstName", false, DataType.Nvarchar, 30, null, false));
columns.Add(new Column("lastName", false, DataType.Nvarchar, 30, null, false));
columns.Add(new Column("age", false, DataType.Int, 11, null, true));
columns.Add(new Column("value", false, DataType.Long, 12, null, true));
columns.Add(new Column("birthday", false, DataType.DateTime, null, null, true));
columns.Add(new Column("hourly", false, DataType.Decimal, 18, 2, true));
_Database.CreateTable("person", columns);
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Check-Existence-and-Describe
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Table 'person' exists: " + _Database.TableExists("person"));
Console.WriteLine("Table 'person' configuration:");
columns = _Database.DescribeTable("person");
foreach (Column col in columns)
{
Console.WriteLine(col.ToString());
}
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Load-Update-Retrieve-Delete
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Loading rows...");
LoadRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Updating rows...");
UpdateRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving rows...");
RetrieveRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving rows by index...");
RetrieveRowsByIndex();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving rows by between...");
RetrieveRowsByBetween();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Deleting rows...");
DeleteRows();
Console.WriteLine("Press ENTER to continue");
Console.ReadLine();
#endregion
#region Drop-Table
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Dropping table...");
_Database.DropTable("person");
Console.ReadLine();
#endregion
}
catch (Exception e)
{
ExceptionConsole("Main", "Outer exception", e);
}
}
static void Main(string[] args)
{
try
{
#region Select-Database-Type
/*
*
*
* Create the database 'test' before proceeding
*
*
*/
Console.Write("DB type [mssql|mysql|pgsql]: ");
string dbType = Console.ReadLine();
if (String.IsNullOrEmpty(dbType))
{
return;
}
Console.Write("User: "******"Password: "******"mssql":
client = new DatabaseClient(DbTypes.MsSql, "localhost", 1433, user, password, null, "test");
break;
case "mysql":
client = new DatabaseClient(DbTypes.MySql, "localhost", 3306, user, password, null, "test");
break;
case "pgsql":
client = new DatabaseClient(DbTypes.PgSql, "localhost", 5432, user, password, null, "test");
break;
default:
return;
}
client.DebugRawQuery = true;
client.DebugResultRowCount = true;
#endregion
#region Drop-Table
Console.WriteLine("Dropping table 'person'...");
client.DropTable("person");
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Create-Table
Console.WriteLine("Creating table 'person'...");
List <Column> columns = new List <Column>();
columns.Add(new Column("id", true, DataType.Int, 11, null, false));
columns.Add(new Column("firstName", false, DataType.Nvarchar, 30, null, false));
columns.Add(new Column("lastName", false, DataType.Nvarchar, 30, null, false));
columns.Add(new Column("age", false, DataType.Int, 11, null, true));
columns.Add(new Column("value", false, DataType.Long, 12, null, true));
columns.Add(new Column("birthday", false, DataType.DateTime, null, null, true));
columns.Add(new Column("hourly", false, DataType.Decimal, 18, 2, true));
client.CreateTable("person", columns);
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Check-Existence-and-Describe
Console.WriteLine("Table 'person' exists: " + client.TableExists("person"));
Console.WriteLine("Table 'person' configuration:");
columns = client.DescribeTable("person");
foreach (Column col in columns)
{
Console.WriteLine(col.ToString());
}
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Load-Update-Retrieve-Delete
Console.WriteLine("Loading rows...");
LoadRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
Console.WriteLine("Updating rows...");
UpdateRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
Console.WriteLine("Retrieving rows...");
RetrieveRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
Console.WriteLine("Retrieving rows by index...");
RetrieveRowsByIndex();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
Console.WriteLine("Deleting rows...");
DeleteRows();
Console.WriteLine("Press ENTER to continue");
Console.ReadLine();
#endregion
#region Drop-Table
Console.WriteLine("Dropping table...");
client.DropTable("person");
Console.ReadLine();
#endregion
}
catch (Exception e)
{
ExceptionConsole("Main", "Outer exception", e);
}
}
static void Main(string[] args)
{
try
{
#region Select-Database-Type
/*
*
*
* Create the database 'test' before proceeding if using mssql, mysql, or pgsql
*
*
*/
Console.Write("DB type [sqlserver|mysql|postgresql|sqlite]: ");
string dbType = Console.ReadLine();
if (String.IsNullOrEmpty(dbType))
{
return;
}
dbType = dbType.ToLower();
if (dbType.Equals("sqlserver") || dbType.Equals("mysql") || dbType.Equals("postgresql"))
{
Console.Write("User: "******"Password: "******"sqlserver":
_Settings = new DatabaseSettings("localhost", 1433, user, pass, null, "test");
_Database = new DatabaseClient(_Settings);
break;
case "mysql":
_Settings = new DatabaseSettings(DbTypes.Mysql, "localhost", 3306, user, pass, "test");
_Database = new DatabaseClient(_Settings);
break;
case "postgresql":
_Settings = new DatabaseSettings(DbTypes.Postgresql, "localhost", 5432, user, pass, "test");
_Database = new DatabaseClient(_Settings);
break;
default:
return;
}
}
else if (dbType.Equals("sqlite"))
{
Console.Write("Filename: ");
string filename = Console.ReadLine();
if (String.IsNullOrEmpty(filename))
{
return;
}
_Settings = new DatabaseSettings(filename);
_Database = new DatabaseClient(_Settings);
}
else
{
Console.WriteLine("Invalid database type.");
return;
}
_Database.Logger = Logger;
_Database.LogQueries = true;
_Database.LogResults = true;
#endregion
#region Drop-Table
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Dropping table 'person'...");
_Database.DropTable("person");
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Create-Table
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Creating table 'person'...");
List <Column> columns = new List <Column>();
columns.Add(new Column("id", true, DataType.Int, 11, null, false));
columns.Add(new Column("firstName", false, DataType.Nvarchar, 30, null, false));
columns.Add(new Column("lastName", false, DataType.Nvarchar, 30, null, false));
columns.Add(new Column("age", false, DataType.Int, 11, null, true));
columns.Add(new Column("value", false, DataType.Long, 12, null, true));
columns.Add(new Column("birthday", false, DataType.DateTime, null, null, true));
columns.Add(new Column("hourly", false, DataType.Decimal, 18, 2, true));
_Database.CreateTable("person", columns);
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Check-Existence-and-Describe
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Table 'person' exists: " + _Database.TableExists("person"));
Console.WriteLine("Table 'person' configuration:");
columns = _Database.DescribeTable("person");
foreach (Column col in columns)
{
Console.WriteLine(col.ToString());
}
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
#endregion
#region Load-Update-Retrieve-Delete
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Loading rows...");
LoadRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Updating rows...");
UpdateRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving rows...");
RetrieveRows();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving rows by index...");
RetrieveRowsByIndex();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Retrieving rows by between...");
RetrieveRowsByBetween();
Console.WriteLine("Press ENTER to continue...");
Console.ReadLine();
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Deleting rows...");
DeleteRows();
Console.WriteLine("Press ENTER to continue");
Console.ReadLine();
#endregion
#region Drop-Table
for (int i = 0; i < 24; i++)
{
Console.WriteLine("");
}
Console.WriteLine("Dropping table...");
_Database.DropTable("person");
Console.ReadLine();
#endregion
}
catch (Exception e)
{
ExceptionConsole("Main", "Outer exception", e);
}
}