Skip to content

Instantly share code, notes, and snippets.

@tazarov
Created November 29, 2023 09:20
Show Gist options
  • Save tazarov/3c9301d22ab863dca0b6fb1e5e3511b1 to your computer and use it in GitHub Desktop.
Save tazarov/3c9301d22ab863dca0b6fb1e5e3511b1 to your computer and use it in GitHub Desktop.
Query collection with date filter
Display the source blob
Display the rendered blob
Raw
{
"cells": [
{
"cell_type": "code",
"execution_count": null,
"id": "initial_id",
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import uuid\n",
"import chromadb\n",
"\n",
"import datetime\n",
"import random\n",
"\n",
"now = datetime.datetime.now()\n",
"two_weeks_ago = now - datetime.timedelta(days=14)\n",
"\n",
"dates = [\n",
" two_weeks_ago + datetime.timedelta(days=random.randint(0, 14))\n",
" for _ in range(100)\n",
"]\n",
"dates = [int(date.timestamp()) for date in dates]\n",
"\n",
"# convert epoch seconds to iso format\n",
"\n",
"def iso_date(epoch_seconds): return datetime.datetime.fromtimestamp(\n",
" epoch_seconds).isoformat()\n",
"\n",
"client = chromadb.EphemeralClient()\n",
"\n",
"col = client.get_or_create_collection(\"test\")\n",
"\n",
"col.add(ids=[f\"{uuid.uuid4()}\" for _ in range(100)], documents=[\n",
" f\"document {i}\" for i in range(100)], metadatas=[{\"date\": date} for date in dates])\n",
"\n",
"res = col.get(where={\"date\": {\"$gt\": (now - datetime.timedelta(days=7)).timestamp()}})\n",
"\n",
"for i in res['metadatas']:\n",
" print(iso_date(i['date']))"
]
},
{
"cell_type": "code",
"execution_count": null,
"outputs": [],
"source": [],
"metadata": {
"collapsed": false
},
"id": "56eaaa556de8f723"
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 2
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython2",
"version": "2.7.6"
}
},
"nbformat": 4,
"nbformat_minor": 5
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment