static void Main(string[] args)
{
SQLiteTable sqlt = new SQLiteTable("test_table")
{
eh = new c_ErrorHandler()
{
loggingLevel = logLevel.level_3
}
};
sqlt.addColumn(new SQLiteColumn {
columnName = "id", dataType = SQLiteDataType.INTEGER, pimaryKey = true, autoIncrement = true
});
sqlt.addColumn(new SQLiteColumn {
columnName = "artist_name", dataType = SQLiteDataType.TEXT
});
sqlt.addColumn(new SQLiteColumn {
columnName = "col1", dataType = SQLiteDataType.CHARACTER, dataLength = 50
});
sqlt.addColumn(new SQLiteColumn {
columnName = "col2", dataType = SQLiteDataType.DATE, foreignKey = true, foreignTable = "test_table_2", foreignColumn = "col44"
});
sqlt.addColumn(new SQLiteColumn {
columnName = "col3", dataType = SQLiteDataType.TINYINT
});
sqlt.addColumn(new SQLiteColumn {
columnName = "col4", dataType = SQLiteDataType.BOOLEAN, columnComment = "this is a boolean"
});
sqlt.addComment("test1");
sqlt.addComment("Test2");
sqlt.addComment("tEst3");
sqlt.addComment("teSt4");
sqlt.addComment("tesT5");
sqlt.listComments();
sqlt.removeComment(4);
sqlt.listComments();
sqlt.removeComment("test1");
sqlt.listComments();
sqlt.removeComment("test2");
sqlt.listComments();
sqlt.removeComment("test3", true);
sqlt.listComments();
Console.Read();
}
