自定义rom

class ORM:
    # 定义一个超类
    def save(self):
        print('获取类名', type(self).__name__)  # 推荐使用这个获取类名 User
        print('获取类名', self.__class__.__name__)  # User
        print('获取自定义属性', self.__dict__)  # {'name': 'tony', 'grade': 6, 'age': 12, 'score': 99, 'aaa': None}
        tablename = (self.__class__.__name__).lower()  # 类名转小写 user
        columns = "("
        values = "("
        for column in self.__dict__:  # 遍历字典（属性与值）信息，组装成columns(字段名) and values(值)
            print('column', column)
            columns += (column + ",")
            print(columns)
            """
            获取值的三种方式
            a = self.__getattribute__(column)
            b = getattr(self, column)
            self.__dict__[column]
            """
            if isinstance(self.__dict__[column], str):  # 判断字段是不是string类型
                values += "'" + self.__dict__[column] + "',"
            else:
                values += str(self.__dict__[column]) + ","

        columns = columns[:len(columns) - 1] + ")"
        print(columns)  # (name,grade,age,score,aaa)
        values = values[:len(values) - 1] + ")"
        print(values)  # ('tony',6,12,99,None)
        sql = "insert into " + tablename + " " + columns + " value " + values
        print(sql)  # 如果是入库操作，在这里替换成db cursor来执行sql即可。


class User(ORM):
    # 继承之上面定义的类，可以在实例化后直接调用save()保存方法
    def __init__(self, name, grade, age, score):
        self.name = name
        self.grade = grade
        self.age = age
        self.score = score
        self.aaa = None

    def abc(self):
        return 'cc'

    def __repr__(self):
        return 'User obj'


if __name__ == '__main__':
    u1 = User("tony", 6, 12, 99)
    u1.save()
    print(u1)  # User obj