Mock objects not only for testing but caching that save your time!
- pandas
read_sql
monkeypatch
import sqlite3
import pandas as pd
from common.io import sql_cache
engine = sqlite3.connect(':memory:')
with sql_cache(force_update=False):
data = pd.read_sql('select * from user limit 1', engine, cache_name='test')
data2 = pd.read_sql('select * from user limit 2', engine, cache_name='test2')
...