Search Postgresql Archives

Re: FTS trigger works 1 at a time, but fails with bulk insert script

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 10/8/18 1:58 PM, Malik Rumi wrote:
So what is the script you used to do the bulk INSERT?

There's actually three, but they are all basically the same. The differences have to do with the source material being inserted:

# usr/local/bin/python3.6
# coding: utf-8

from os import environ
environ['DJANGO_SETTINGS_MODULE'] = 'chronicle.settings'
import django
django.setup()
from ktab.models import Entry, Tag

So I am going to assume Entry and Tag map to the tables ktab_entry and public.ktab_entry_tags respectively.

from django.utils.text import slugify
import csv


filename = '/home/malikarumi/Projects/Progress_Logs/edit_blogpost.csv'

with open(filename, 'rt') as text:
     reader = csv.DictReader(text, delimiter=',')
     # next(reader, None)
     for row in reader:
         my_entry = Entry.objects.create(
            title=row['title'], slug=row['slug'], chron_date=row['created'],
             clock=row['clock'], content=row['content'])
         my_entry.tags.add(row['tag'])

I thought that you needed to pass a model object to add(). If I am following the above it is just a csv field value.

Assuming log_statement = 'mod', I would tail the postgresql.conf file to see what is actually hitting the database.



*/“None of you has faith until he loves for his brother or his neighbor what he loves for himself.”/*





--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux