python/etc/giga.p.py

   1 #!/usr/bin/env python3
   2
   3 import os, sys, bz2, csv, re, json, sqlite3
   4
   5 conn = sqlite3.connect('giga.authors.sqlite')
   6
   7 for row in conn.execute("SELECT * FROM PubDat"):
   8     #print(row)
   9     auther=json.loads(row[3])
  10     print('DOI:%s\nTitle:%s\nType:%s\nRef:{%s}\nAuthers:'%(row[0],row[1],row[2],row[4]))
  11     print(auther)
  12