class Database

• Database
• Reference
• Object

Defined in:

privateparlor/database.cr

Constructors

• .new(database : DB::Database)

  Create an instance of Database and create the appropriate schema in the SQLite database.

Instance Method Summary

• #add_user(id, username, realname, rank = 0) : User | Nil

  Inserts a user with the given id, username, and realname into the database.

• #db : DB::Database
• #ensure_schema : Nil

  Ensures that the DB schema is usable by the program.

• #expire_warnings(warn_expire_hours : Int32) : Nil

  Queries the database for warned users and removes warnings they have expired.

• #get_blacklisted_users : Array(User) | Nil

  Queries the database for blacklisted users who have been banned within the past 48 hours.

• #get_inactive_users(limit : Int32) : Array(User) | Nil
• #get_invalid_rank_users(values : Array(Int32)) : Array(User) | Nil
• #get_motd : String | Nil

  Retrieves the motd/rules from the database.

• #get_prioritized_users(user : User | Nil = nil) : Array(Int64)

  Queries the database for all user ids, ordered by highest ranking users first then most active users.

• #get_user(id) : User | Nil

  Queries the database for a user record with the given id.

• #get_user_by_arg(arg : String) : User | Nil
• #get_user_by_name(username) : User | Nil

  Queries the database for a user with a given username.

• #get_user_by_oid(oid : String) : User | Nil
• #get_user_counts : NamedTuple
• #get_warned_users : Array(User) | Nil

  Queries the database for all warned users that are in the chat.

• #modify_user(user : User) : Nil

  Updates a user record in the database with the current state of user.

• #no_users? : Bool

  Queries the database for any rows in the user table

• #set_motd(text : String) : Nil

  Sets the motd/rules to the given string.

Constructor Detail

Instance Method Detail