使用元类编写一个简单的ORM框架

本文介绍了一种利用Python元类实现的简单ORM框架。通过定义字段类和元类,可以将Python对象直接映射为数据库表。示例中创建了一个User模型并演示了如何保存数据到数据库。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

使用元类编写一个简单的ORM框架

# -*- coding : utf-8 -*-
class Field(object):
    '''filed'''

    def __init__(self, name, column_type):
        self.name = name
        self.column_type = column_type

    def __str__(self):
        return '<%s:%s>' % (self.__class__.__name__, self.name)

# ------------------


class StringField(Field):
    '''String Field'''

    def __init__(self, name):
        super().__init__(name, 'varchar(100)')

# ------------------


class IntegerField(Field):
    '''Integer Field'''

    def __init__(self, name):
        super().__init__(name, 'bigint')

# ------------------


class ModelMetaclass(type):
    '''meta class'''
    def __new__(cls, name, bases, attrs):
        if name == 'Model':
            return type.__new__(cls, name, bases, attrs)
        print('Found Model: %s' % name)
        mappings = dict()
        for k, v in attrs.items():
            if isinstance(v, Field):
                print('Found mapping: %s ==> %s' % (k, v))
                mappings[k] = v
        for k in mappings.keys():
            attrs.pop(k)
        attrs['__mappings__'] = mappings
        attrs['__table__'] = name
        return type.__new__(cls, name, bases, attrs)
# ------------------


class Model(dict, metaclass=ModelMetaclass):
    '''model'''

    def __init__(self, **kw):
        super().__init__(**kw)

    def __getattr__(self, key):
        try:
            return self[key]
        except KeyError:
            raise AttributeError(r"'Model' object has no attribute '%s'" % key)

    def __setattr__(self, key, value):
        self[key] = value

    def save(self):
        fields = []
        params = []
        args = []
        for k, v in self.__mappings__.items():
            fields.append(v.name)
            params.append('?')
            args.append(getattr(self, k, None))
        sql = 'insert into %s (%s) values (%s)' % (
            self.__table__, ', '.join(fields), ', '.join(params))
        print('sql: %s' % sql)
        print('args: %s' % str(args))
# ------------------


class User(Model):
    '''user'''
    id = IntegerField('id')
    name = StringField('name')
    email = StringField('email')
    password = StringField('password')


# ------------------
if __name__ == '__main__':
    USER = User(id=123, name='Michael',
                email='michael@gmail.com', password='my-pwd')
    USER.save()

输出结果

[Running] python "d:\git\pythonStudy\hello_world.py"
Found Model: User
Found mapping: id ==> <IntegerField:id>
Found mapping: name ==> <StringField:name>
Found mapping: email ==> <StringField:email>
Found mapping: password ==> <StringField:password>
sql: insert into User (id, name, email, password) values (?, ?, ?, ?)
args: [123, 'Michael', 'michael@gmail.com', 'my-pwd']

[Done] exited with code=0 in 0.243 seconds

原文:廖雪峰的Python教程

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值