Daily Weekly Monthly

Daily Shaarli

All links of one day in a single page.

February 19, 2019

Researchers Find Further Evidence That Schizophrenia is Connected to Our Guts - D-brief

Giving healthy mice gut bacteria from schizophrenic patients caused them to display symptoms of the disease.

Bulk inserting on table with foreign key field - Stack Overflow

Well, if you don't know ahead of time which servers are present in the DB it seems like your problem is the data-structure you're using. Keeping server_name -> member_names in a dict like that and trying to insert it all in one go is not how relational databases work.

Try this:

server_to_id = {}
for server_name in data:
if server_name not in server_to_id:
server = Server.create(name=server_name)
server_to_id[server_name] = server.id

for server_name, member_names in data.items():
server_id = server_to_id[server_name]
member_data = [{'name': name, 'server': server_id} for name in member_names]
Member.insert_many(member_data).execute()

Note: don't forget to call .execute() when using insert() or insert_many().