File size: 4,067 Bytes
ef9f319
 
c41b2ce
ef9f319
 
a15639e
ef9f319
c0d20e2
ef9f319
c0d20e2
 
 
d216220
a15639e
d216220
 
a15639e
c0d20e2
a15639e
 
 
c0d20e2
a15639e
 
 
 
 
 
 
 
 
 
ef9f319
c41b2ce
ef9f319
 
 
a15639e
 
ef9f319
 
 
 
a15639e
ef9f319
 
a15639e
ef9f319
 
c41b2ce
ef9f319
 
 
a15639e
ef9f319
 
 
 
c41b2ce
 
ef9f319
c41b2ce
ef9f319
 
 
c41b2ce
ef9f319
 
c41b2ce
 
 
 
 
 
 
a15639e
 
c41b2ce
 
 
 
a15639e
ef9f319
c41b2ce
 
 
 
 
 
ef9f319
 
 
a15639e
ef9f319
 
 
 
a15639e
c41b2ce
 
 
 
ef9f319
 
 
 
 
 
c41b2ce
ef9f319
 
c41b2ce
ef9f319
 
 
c41b2ce
ef9f319
 
 
 
 
 
c41b2ce
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
from flask import Flask, request, jsonify
from pymongo import MongoClient
import os
import requests
from bs4 import BeautifulSoup
import urllib.parse

app = Flask(__name__)

# πŸ” Load MongoDB Credentials
MONGO_USER = os.getenv("MONGO_USER", "Ravi")  # Default "Ravi" if not set
MONGO_PASS = os.getenv("MONGO_PASS")  # Password from environment variables
MONGO_CLUSTER = "ravi.btpy9.mongodb.net"  # Fixed cluster name

if not MONGO_PASS:
    raise ValueError("❌ MongoDB password is missing in environment variables!")

# βœ… URL-Encode Credentials
encoded_user = urllib.parse.quote_plus(MONGO_USER)
encoded_pass = urllib.parse.quote_plus(MONGO_PASS)

# πŸ”— MongoDB Connection URI
MONGO_URI = f"mongodb+srv://{encoded_user}:{encoded_pass}@{MONGO_CLUSTER}/?retryWrites=true&w=majority"

# πŸ“Œ Connect to MongoDB
try:
    client = MongoClient(MONGO_URI)
    db = client["Ravi"]
    collection = db["qna"]
    print("βœ… Connected to MongoDB successfully!")
except Exception as e:
    print(f"❌ MongoDB Connection Error: {e}")

# πŸ“Œ Add a Question-Answer Pair
@app.route('/add_qna', methods=['POST'])
def add_qna():
    data = request.json
    question = data.get("question", "").strip().lower()
    answer = data.get("answer", "").strip()

    if not question or not answer:
        return jsonify({"error": "Both question and answer are required"}), 400

    if collection.find_one({"question": question}):
        return jsonify({"error": "Question already exists"}), 409

    collection.insert_one({"question": question, "answer": answer})
    return jsonify({"message": "QnA added successfully!"}), 201

# πŸ“Œ Ask a Question (Retrieve Answer)
@app.route('/ask', methods=['POST'])
def ask():
    data = request.json
    question = data.get("question", "").strip().lower()

    if not question:
        return jsonify({"error": "Question is required"}), 400

    result = collection.find_one({"question": question})
    
    if result:
        return jsonify({"answer": result["answer"]})  # Return stored answer
    else:
        return jsonify({"answer": web_scrape_answer(question)})  # Fetch from web

# πŸ“Œ List All Stored Questions & Answers
@app.route('/list_qna', methods=['GET'])
def list_qna():
    qna_list = list(collection.find({}, {"_id": 0}))  # Exclude MongoDB `_id`
    return jsonify({"qna_list": qna_list})

# πŸ“Œ Update an Existing QnA
@app.route('/update_qna', methods=['PUT'])
def update_qna():
    data = request.json
    question = data.get("question", "").strip().lower()
    new_answer = data.get("answer", "").strip()

    if not question or not new_answer:
        return jsonify({"error": "Both question and new answer are required"}), 400

    result = collection.update_one({"question": question}, {"$set": {"answer": new_answer}})

    if result.matched_count == 0:
        return jsonify({"error": "Question not found"}), 404

    return jsonify({"message": "QnA updated successfully!"})

# πŸ“Œ Delete a QnA Entry
@app.route('/delete_qna', methods=['DELETE'])
def delete_qna():
    data = request.json
    question = data.get("question", "").strip().lower()

    if not question:
        return jsonify({"error": "Question is required"}), 400

    result = collection.delete_one({"question": question})

    if result.deleted_count == 0:
        return jsonify({"error": "Question not found"}), 404

    return jsonify({"message": "QnA deleted successfully!"})

# πŸ“Œ Web Scraping Function (GeeksforGeeks)
def web_scrape_answer(question):
    search_query = question.replace(" ", "+")
    url = f"https://www.geeksforgeeks.org/?s={search_query}"

    headers = {"User-Agent": "Mozilla/5.0"}
    response = requests.get(url, headers=headers)

    if response.status_code == 200:
        soup = BeautifulSoup(response.text, "html.parser")
        first_result = soup.find("div", class_="entry-content")

        if first_result:
            return first_result.text.strip()

    return "I couldn't find an answer. Try rephrasing the question."

if __name__ == '__main__':
    app.run(host="0.0.0.0", port=7860, debug=True)