|
| 1 | +#!/usr/bin/env python3 |
| 2 | +# -*- coding: utf-8 -*- |
| 3 | + |
| 4 | +' Simple ORM using metaclass ' |
| 5 | + |
| 6 | +class Field(object): |
| 7 | + |
| 8 | + def __init__(self, name, column_type): |
| 9 | + self.name = name |
| 10 | + self.column_type = column_type |
| 11 | + |
| 12 | + def __str__(self): |
| 13 | + return '<%s:%s>' % (self.__class__.__name__, self.name) |
| 14 | + |
| 15 | +class StringField(Field): |
| 16 | + |
| 17 | + def __init__(self, name): |
| 18 | + super(StringField, self).__init__(name, 'varchar(100)') |
| 19 | + |
| 20 | +class IntegerField(Field): |
| 21 | + |
| 22 | + def __init__(self, name): |
| 23 | + super(IntegerField, self).__init__(name, 'bigint') |
| 24 | + |
| 25 | +class ModelMetaclass(type): |
| 26 | + |
| 27 | + def __new__(cls, name, bases, attrs): |
| 28 | + if name=='Model': |
| 29 | + return type.__new__(cls, name, bases, attrs) |
| 30 | + print('Found model: %s' % name) |
| 31 | + mappings = dict() |
| 32 | + for k, v in attrs.items(): |
| 33 | + if isinstance(v, Field): |
| 34 | + print('Found mapping: %s ==> %s' % (k, v)) |
| 35 | + mappings[k] = v |
| 36 | + for k in mappings.keys(): |
| 37 | + attrs.pop(k) |
| 38 | + attrs['__mappings__'] = mappings # 保存属性和列的映射关系 |
| 39 | + attrs['__table__'] = name # 假设表名和类名一致 |
| 40 | + return type.__new__(cls, name, bases, attrs) |
| 41 | + |
| 42 | +class Model(dict, metaclass=ModelMetaclass): |
| 43 | + |
| 44 | + def __init__(self, **kw): |
| 45 | + super(Model, self).__init__(**kw) |
| 46 | + |
| 47 | + def __getattr__(self, key): |
| 48 | + try: |
| 49 | + return self[key] |
| 50 | + except KeyError: |
| 51 | + raise AttributeError(r"'Model' object has no attribute '%s'" % key) |
| 52 | + |
| 53 | + def __setattr__(self, key, value): |
| 54 | + self[key] = value |
| 55 | + |
| 56 | + def save(self): |
| 57 | + fields = [] |
| 58 | + params = [] |
| 59 | + args = [] |
| 60 | + for k, v in self.__mappings__.items(): |
| 61 | + fields.append(v.name) |
| 62 | + params.append('?') |
| 63 | + args.append(getattr(self, k, None)) |
| 64 | + sql = 'insert into %s (%s) values (%s)' % (self.__table__, ','.join(fields), ','.join(params)) |
| 65 | + print('SQL: %s' % sql) |
| 66 | + print('ARGS: %s' % str(args)) |
| 67 | + |
| 68 | +# testing code: |
| 69 | + |
| 70 | +class User(Model): |
| 71 | + id = IntegerField('id') |
| 72 | + name = StringField('username') |
| 73 | + email = StringField('email') |
| 74 | + password = StringField('password') |
| 75 | + |
| 76 | +u = User(id=12345, name='Michael', email='test@orm.org', password='my-pwd') |
| 77 | +u.save() |
0 commit comments