Creating and using more than 1 database dynamically using peewee

Hi,

This is what I want to do:

1. I want to create three database
2. Add data to this databases (making sure that data is added to correct database).
3. Retrive data from these databases.

Here's what I've done so far.

from peewee import *

database_proxy = Proxy() # Create a proxy for our db.

class BaseModel(Model): class Meta: db = database_proxy # Use proxy for our DB.

class Overview(BaseModel): date = DateTimeField(unique=True) auto_total = CharField() .... ... ..

def initialize(loc): """ Initialising database based on the some condition""" if "Performance" in loc: db = SqliteDatabase('Performance.db', threadlocals=True) elif "Snapchat" in loc: db = SqliteDatabase('Snapchat.db', threadlocals=True) elif "Intelligence" in loc: db = SqliteDatabase('Intelligence.db', threadlocals=True) database_proxy.initialize(db) db.connect() db.create_tables([Overview], safe=True)

def add_data(test_date, time_duration, auto, manual, total): """ adding data to database""" try: Overview.create(date=test_date, auto_total=auto[1], auto_pass=auto[2], auto_fail=auto[3], .... ... .. print("New Row Added") except IntegrityError: update_results = Overview.get(date=test_date) update_results.auto_total = auto[1] update_results.auto_pass = auto[2] ..... .... ..

def get_rows(): cursor = Overview.select().order_by(Overview.date.desc()) print(cursor)

for test in cursor:
    print()

I's able to create three data bases at run time. But I,m not sure

1. How to add data to the correct database?
2. How to retrieve data from the correct database?

Any suggestions will be really helpful.

Thanks Santosh