擅长:python、mysql、java
<p><code>fetch</code>在asyncpg中,返回一个可下标的记录对象,我们可以简单地使用列表理解将其转换为字符串</p>
<pre class="lang-py prettyprint-override"><code>names = await self.client.db.fetch("SELECT trigger FROM tags WHERE guild_id = $1", ctx.guild.id)
names = [x['trigger'] for x in names]
await ctx.send(names)
#names will be ['ikr', 'guild', 'ew'] in your case
</code></pre>
<h2>参考资料:</h2>
<ul>
<li><a href="https://magicstack.github.io/asyncpg/current/api/index.html?highlight=fetch#asyncpg.connection.Connection.fetch" rel="nofollow noreferrer">asyncpg.fetch</a></li>
<li><a href="https://magicstack.github.io/asyncpg/current/api/index.html?highlight=fetch#asyncpg.Record" rel="nofollow noreferrer">Record objects</a></li>
</ul>
<p>注意:如果您想对所有回迁使用相同的东西,我建议查看连接或回迁的<code>record_class</code>参数</p>