Blakeinstein · January 11, 2023 19:50 · Blakeinstein · Jun 24, 2024 · Davecon11 · Jun 24, 2024
diff --git a/README.md b/README.md
diff --git a/collections_to_csv.py b/collections_to_csv.py
 import json
 import sqlite3
 import pandas as pd

 con = sqlite3.connect("./collectionsSQLite")
 cur = con.cursor()

 df = pd.read_sql_query(
  """
    SELECT i.title as title, c.title as folder, i.source as data, i.date_created as created
    FROM collections as c, items as i, collections_items_relationship as r
    WHERE r.item_id == i.id and r.parent_id == c.id
  """,
  con
 )

 def blob_to_json(col):
  my_json = col.decode('utf8')
  d = json.loads(my_json)
  return d["url"]

 df["description"] = ""
 df["tags"] = ""
 df["created"] = df["created"].astype(int)
 df["url"] = df["data"].apply(blob_to_json)

 df.to_csv(
  "out.csv",
  index=False,
  columns=["url", "folder", "title", "description", "tags", "created"]
 )
	import json
	import sqlite3
	import pandas as pd

	con = sqlite3.connect("./collectionsSQLite")
	cur = con.cursor()

	df = pd.read_sql_query(
	"""
	SELECT i.title as title, c.title as folder, i.source as data, i.date_created as created
	FROM collections as c, items as i, collections_items_relationship as r
	WHERE r.item_id == i.id and r.parent_id == c.id
	""",
	con
	)

	def blob_to_json(col):
	my_json = col.decode('utf8')
	d = json.loads(my_json)
	return d["url"]

	df["description"] = ""
	df["tags"] = ""
	df["created"] = df["created"].astype(int)
	df["url"] = df["data"].apply(blob_to_json)

	df.to_csv(
	"out.csv",
	index=False,
	columns=["url", "folder", "title", "description", "tags", "created"]
	)
No results found