C# Класс Nekobot.SQL

Показать файл Открыть проект Примеры использования класса

Приватные методы

Метод Описание
AddOrUpdate ( string row, string table, ulong id, string field, string newval ) : void
AddOrUpdateAsync ( string row, string table, ulong id, string field, string newval ) : System.Threading.Tasks.Task
AddOrUpdateCommand ( string row, string table, ulong id, string field, string newval ) : string
AddOrUpdateCommand ( string row, string table, ulong id, string field, string newval, bool in_table ) : string
AddOrUpdateFlag ( ulong id, string field, string newval ) : void
AddOrUpdateFlagAsync ( ulong id, string field, string newval ) : System.Threading.Tasks.Task
AddOrUpdateServer ( ulong id, string field, string newval ) : void
AddOrUpdateUserAsync ( ulong id, string field, string newval ) : System.Threading.Tasks.Task
CloseAndDispose ( ) : void
Command ( string sql ) : SQLiteCommand
CreateField ( string table, string field ) : void
CreateTable ( string table ) : void
ExecuteNonQuery ( string sql ) : void
ExecuteNonQueryAsync ( string sql ) : System.Threading.Tasks.Task
ExecuteReader ( string sql ) : SQLiteDataReader
ExecuteReader ( string value, string table, string condition ) : SQLiteDataReader
ExecuteScalarPos ( string sql ) : bool
InTable ( string row, string table, ulong id ) : bool
InsertData ( string table, string field, string newval ) : string
LoadDB ( ) : void
ReadBool ( string data, bool ifnull = false ) : bool
ReadChannel ( ulong id, string value ) : string
ReadChannels ( string condition, string value = "channel" ) : SQLiteDataReader
ReadInt ( string data ) : int
ReadRoles ( string condition, string value = "role" ) : SQLiteDataReader
ReadServer ( ulong id, string value ) : string
ReadServers ( string condition, string value = "server" ) : SQLiteDataReader
ReadSingle ( string row, string table, ulong id, string value ) : string
ReadUser ( ulong id, string value ) : string
ReadUsers ( string condition, string value = "user" ) : SQLiteDataReader