mongo创建索引,查看索引,删除索引

def link_database():
       url = f'mongodb://username:password@host:port/database'
       client = motor.motor_asyncio.AsyncIOMotorClient(url)
       return client,client[database][collection]
    async def create_index(self, data, collection=None, database="finance", **kwargs):
创建索引
        client, db = self.link_database(collection, database)
        try:
            if isinstance(data, tuple):
                d = await db.create_index([], background=True)
                return d
        except Exception as e:
            print(e)
            return []
        finally:
            await self.close(client)

    async def create_indexs(self, data, collection=None, database="finance", **kwargs):
批量创建索引
        client, db = self.link_database(collection, database)
        try:
            if isinstance(data, list):
                d = await db.create_index(data, background=True)
                return d
        except Exception as e:
            print(e)
            return []
        finally:
            await self.close(client)

    async def create_unique_index(self, data, collection=None, database="finance", **kwargs):
创建唯一索引
        client, db = self.link_database(collection, database)
        try:
            if isinstance(data, tuple):
                e = await db.create_index([data], unique=True, background=True)
                return e
        except Exception:
            return []
        finally:
            await self.close(client)

    async def index_information(self, collection, database):
    查看索引
        client, db = self.link_database(collection, database)
        try:
            e = await db.index_information()
            return e
        except Exception:
            return []
        finally:
            await self.close(client)

    async def drop_indexs(self, collection, database):
    删除索引
        client, db =self.link_database(collection, database)
        try:
            await db.drop_indexes()
            return 1
        except Exception:
            return 0
        finally:
            await self.close(client)
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值