コード例 #1
0
        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();
        }