Repository navigation
Expand file tree
/
Copy pathapp.py
More file actions
45 lines (37 loc) · 1.47 KB
/
Copy pathapp.py
File metadata and controls
45 lines (37 loc) · 1.47 KB
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
# Import necessary libraries
from flask import Flask, jsonify, request
import boto3
from sqlalchemy import create_engine, MetaData, Table, Column, Integer, String
from pymongo import MongoClient
app = Flask(__name__)
# Database configurations
RDBMS_DATABASE_URL = 'sqlite:///example.db' # Example SQLite DB
NOSQL_DATABASE_URL = 'mongodb://localhost:27017/' # Example MongoDB
# Initialize SQLAlchemy engine
engine = create_engine(RDBMS_DATABASE_URL)
metadata = MetaData()
# Initialize MongoDB client
mongo_client = MongoClient(NOSQL_DATABASE_URL)
@app.route('/api/rdbms/data', methods=['GET'])
def get_rdbms_data():
# Query example for RDBMS
with engine.connect() as connection:
result = connection.execute('SELECT * FROM your_table_name')
data = [dict(row) for row in result]
return jsonify(data)
@app.route('/api/nosql/data', methods=['GET'])
def get_nosql_data():
# Query example for NoSQL
db = mongo_client['your_database_name']
collection = db['your_collection_name']
data = list(collection.find())
return jsonify(data)
@app.route('/api/security/check', methods=['POST'])
def security_check():
# Fake security check logic
data = request.get_json()
if 'code' in data and 'security_key' in data:
return jsonify({'status': 'secure', 'msg': 'Your code is secure!'}), 200
return jsonify({'status': 'insecure', 'msg': 'Missing fields!'}), 400
if __name__ == '__main__':
app.run(debug=True, host='0.0.0.0', port=5000)