example of class define

users_class.py

In [8]: # %load users_class.py
   ...: class User:
   ...:
   ...:     def __init__(self, *nargs, **kwargs):
   ...:         self.data = dict(*nargs, **kwargs)
   ...:         self.id: int = self.data['id']
   ...:         self.name: str = self.data['name']
   ...:         self.age: int = self.data['age']
   ...:         self.belongs: str = self.data['belongs']
   ...:
   ...:     def __repr__(self):
   ...:         return(f'User(id={self.id}, '
   ...:                f'name="{self.name}", '
   ...:                f'age={self.age}, '
   ...:                f'belongs="{self.belongs}")' )
   ...:
   ...:

In [9]: users = io.read_contents('sqlite:///users.sqlite#users',row_type=User)

In [10]: users
Out[10]:
[User(id=1, name="David Coverdale", age=71, belongs="Whitesnake"),
 User(id=2, name="Neal Schon ", age=68, belongs="Journey"),
 User(id=3, name="Tom Scholz", age=75, belongs="Boston"),
 User(id=4, name="David Gilmour", age=75, belongs="Pink Floyd"),
 User(id=5, name="Ann Wilson", age=71, belongs="Heart"),
 User(id=6, name="Nacy Wilson", age=67, belongs="Heart")]

In [11]: users[0].name
Out[11]: 'David Coverdale'

In [12]: