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

On 10/8/18 3:54 PM, Adrian Klaver wrote:
> 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.

Aargh, meant tail the Postgres log file.

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


-- 
Adrian Klaver
adrian.klaver@aklaver.com