from astrapy import DataAPIClient
import datetime<\/p>\n\n\n\n
def add_comic(collection):
print(“Add a new comic to your collection:”)
title = input(“Title: “)
issue_number = input(“Issue Number: “)
publisher = input(“Publisher: “)
publication_date = input(“Publication Date (YYYY-MM-DD): “)<\/p>\n\n\n\n
# Validate publication date format\ntry:\n publication_date = datetime.datetime.strptime(publication_date, '%Y-%m-%d').date()\nexcept ValueError:\n print(\"Invalid date format. Please use YYYY-MM-DD.\")\n return\n\ncomic = {\n \"title\": title,\n \"issue_number\": issue_number,\n \"publisher\": publisher,\n \"publication_date\": publication_date.strftime('%Y-%m-%d')\n}\n\n# Save comic to AstraDB\ndb.comics.insert_one(comic)\n\ncollection.append(comic)\nprint(\"Comic added successfully!\\n\")<\/code><\/pre>\n\n\n\ndef edit_comic(collection):
if not collection:
print(“No comics in collection. Add comics first.”)
return<\/p>\n\n\n\n
print(\"\\nEdit a comic in your collection:\")\nview_collection(collection)\ncomic_index = int(input(\"Enter the index of the comic you want to edit: \")) - 1\n\nif comic_index < 0 or comic_index >= len(collection):\n print(\"Invalid comic index.\")\n return\n\ncomic = collection[comic_index]\nprint(\"Enter new details (leave blank to keep existing):\")\ntitle = input(f\"Title ({comic['title']}): \") or comic['title']\nissue_number = input(f\"Issue Number ({comic['issue_number']}): \") or comic['issue_number']\npublisher = input(f\"Publisher ({comic['publisher']}): \") or comic['publisher']\npublication_date = input(f\"Publication Date ({comic['publication_date']}): \") or comic['publication_date']\n\n# Validate publication date format\ntry:\n publication_date = datetime.datetime.strptime(publication_date, '%Y-%m-%d').date()\nexcept ValueError:\n print(\"Invalid date format. Please use YYYY-MM-DD.\")\n return\n\nupdated_comic = {\n \"title\": title,\n \"issue_number\": issue_number,\n \"publisher\": publisher,\n \"publication_date\": publication_date.strftime('%Y-%m-%d')\n}\n\n# Update comic in AstraDB\ndb.comics.update_one({\"_id\": comic[\"_id\"]}, {\"$set\": updated_comic})\n\ncollection[comic_index] = updated_comic\nprint(\"Comic edited successfully!\\n\")<\/code><\/pre>\n\n\n\ndef delete_comic(collection):
if not collection:
print(“No comics in collection. Add comics first.”)
return<\/p>\n\n\n\n
print(\"\\nDelete a comic from your collection:\")\nview_collection(collection)\ncomic_index = int(input(\"Enter the index of the comic you want to delete: \")) - 1\n\nif comic_index < 0 or comic_index >= len(collection):\n print(\"Invalid comic index.\")\n return\n\ndeleted_comic = collection.pop(comic_index)\n\n# Delete comic from AstraDB\ndb.comics.delete_one({\"_id\": deleted_comic[\"_id\"]})\n\nprint(f\"Deleted comic: {deleted_comic.get('title', 'N\/A')} - Issue #{deleted_comic.get('issue_number', 'N\/A')}\")\nprint(\"Comic deleted successfully!\\n\")<\/code><\/pre>\n\n\n\ndef view_collection(collection):
comics = db.comics.find({})
print(“\\nYour Comic Collection:”)
for index, comic in enumerate(comics, start=1):
title = comic.get(‘title’, ‘N\/A’)
issue_number = comic.get(‘issue_number’, ‘N\/A’)
publisher = comic.get(‘publisher’, ‘N\/A’)
publication_date = comic.get(‘publication_date’, ‘N\/A’)
print(f”{index}. {title} – Issue #{issue_number} ({publisher}, {publication_date})”)
print()<\/p>\n\n\n\n
def search_comic(collection):
search_query = input(“Enter the title, issue number, or publisher of the comic you want to search for: “)
found_comics = []
for comic in collection:
if search_query.lower() in comic.get(‘title’, ”).lower() or \\
search_query.lower() in str(comic.get(‘issue_number’, ”)).lower() or \\
search_query.lower() in comic.get(‘publisher’, ”).lower():
found_comics.append(comic)<\/p>\n\n\n\n
if found_comics:\n print(f\"\\nFound {len(found_comics)} matching comic(s):\")\n for index, comic in enumerate(found_comics, start=1):\n title = comic.get('title', 'N\/A')\n issue_number = comic.get('issue_number', 'N\/A')\n publisher = comic.get('publisher', 'N\/A')\n publication_date = comic.get('publication_date', 'N\/A')\n print(f\"{index}. {title} - Issue #{issue_number} ({publisher}, {publication_date})\")\nelse:\n print(\"No matching comics found.\")<\/code><\/pre>\n\n\n\ndef load_collection_from_astrapy():
# Initialize the DataAPIClient with your token
client = DataAPIClient(“AstraCS:BZNarYEaGJmjqzFztwRotkgj:5472c1a0b3c6d1e6c11f6651b0a7c8a0f183b278535c6766f69d48203b3b7599”)<\/p>\n\n\n\n
# Get the database by API endpoint\ndb = client.get_database_by_api_endpoint(\"https:\/\/b3b75450-24a9-4865-8f6b-22c18fca27e5-us-east1.apps.astra.datastax.com\")\n\nprint(f\"Connected to Astra DB: {db.list_collection_names()}\")\n\nreturn db<\/code><\/pre>\n\n\n\ndef main():
global db
db = load_collection_from_astrapy()
comic_collection = []<\/p>\n\n\n\n
while True:\n print(\"1. Add a new comic\")\n print(\"2. View comic collection\")\n print(\"3. Search for a comic\")\n print(\"4. Edit a comic\")\n print(\"5. Delete a comic\")\n print(\"6. Exit\")\n choice = input(\"Enter your choice: \")\n\n if choice == '1':\n add_comic(comic_collection)\n elif choice == '2':\n view_collection(comic_collection)\n elif choice == '3':\n search_comic(comic_collection)\n elif choice == '4':\n edit_comic(comic_collection)\n elif choice == '5':\n delete_comic(comic_collection)\n elif choice == '6':\n print(\"Exiting...\")\n break\n else:\n print(\"Invalid choice. Please try again.\\n\")<\/code><\/pre>\n\n\n\nif name<\/strong> == “main<\/strong>“:
main()<\/p>\n","protected":false},"excerpt":{"rendered":"Justin Christopherson CYSE – 250 This program will prompt the user to enter the details for a comic book and then add them to a database on my datastax.com server. from astrapy import DataAPIClientimport datetime def add_comic(collection):print(“Add a new comic to your collection:”)title = input(“Title: “)issue_number = input(“Issue Number: “)publisher = input(“Publisher: “)publication_date = input(“Publication … Continue reading Final-Project<\/span><\/a><\/p>\n","protected":false},"author":26825,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","wds_primary_category":0},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/sites.wp.odu.edu\/jchris82\/wp-json\/wp\/v2\/posts\/427"}],"collection":[{"href":"https:\/\/sites.wp.odu.edu\/jchris82\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sites.wp.odu.edu\/jchris82\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sites.wp.odu.edu\/jchris82\/wp-json\/wp\/v2\/users\/26825"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.wp.odu.edu\/jchris82\/wp-json\/wp\/v2\/comments?post=427"}],"version-history":[{"count":1,"href":"https:\/\/sites.wp.odu.edu\/jchris82\/wp-json\/wp\/v2\/posts\/427\/revisions"}],"predecessor-version":[{"id":428,"href":"https:\/\/sites.wp.odu.edu\/jchris82\/wp-json\/wp\/v2\/posts\/427\/revisions\/428"}],"wp:attachment":[{"href":"https:\/\/sites.wp.odu.edu\/jchris82\/wp-json\/wp\/v2\/media?parent=427"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sites.wp.odu.edu\/jchris82\/wp-json\/wp\/v2\/categories?post=427"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sites.wp.odu.edu\/jchris82\/wp-json\/wp\/v2\/tags?post=427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}