def guild_get_by_id(gid) -> Optional[DbGuild]:
c.execute("SELECT * FROM guilds WHERE id=?", (gid, ))
g = c.fetchone()
return DbGuild(*g) if g else None
def guild_get_by_faction_name(name) -> Optional[DbGuild]:
c.execute("SELECT * FROM guilds WHERE faction_name=?", (name, ))
g = c.fetchone()
return DbGuild(*g) if g else None
def guild_get_all_factions() -> List[DbGuild]:
c.execute(
"SELECT * FROM guilds WHERE faction_name IS NOT NULL ORDER BY faction_name"
)
return [DbGuild(*g) for g in c.fetchall()]
def guild_get_by_faction_alias(alias) -> Optional[DbGuild]:
c.execute("SELECT * FROM guilds WHERE faction_alias=?", (alias, ))
g = c.fetchone()
return DbGuild(*g) if g else None
def guild_get_all() -> List[DbGuild]:
c.execute("SELECT * FROM guilds")
return [DbGuild(*g) for g in c.fetchall()]