def setUp(self): app = Flask(__name__) app.config['CASSANDRA_HOSTS'] = ['127.0.0.1'] app.config['CASSANDRA_KEYSPACE'] = "test1" db = CQLAlchemy(app) self.User = make_user_model(db) create_keyspace_simple("test1", 1) self.app = app self.db = db
import uuid from flask import Flask from flask_cqlalchemy import CQLAlchemy app = Flask(__name__) app.config['CASSANDRA_HOSTS'] = ['127.0.0.1'] app.config['CASSANDRA_KEYSPACE'] = "cqlengine" app.config['CASSANDRA_SETUP_KWARGS'] = {'protocol_version': 3} db = CQLAlchemy(app) class address(db.UserType): street = db.columns.Text() zipcode = db.columns.Integer() class users(db.Model): __keyspace__ = 'cqlengine' name = db.columns.Text(primary_key=True) addr = db.columns.UserDefinedType(address)
from alpha_vantage.timeseries import TimeSeries from flask import Flask, jsonify, request from flask_cqlalchemy import CQLAlchemy #Flask setup app = Flask(__name__) app.config['CASSANDRA_HOSTS'] = ['cassandra'] app.config['CASSANDRA_KEYSPACE'] = "stocks" app.config['CQLENG_ALLOW_SCHEMA_MANAGEMENT'] = True db = CQLAlchemy(app) class Equity(db.Model): equity_name = db.columns.Text(primary_key=True, required=True) equity_timestamp = db.columns.List(db.columns.Text, required=False) equity_open = db.columns.List(db.columns.Text, required=False) equity_high = db.columns.List(db.columns.Text, required=False) equity_low = db.columns.List(db.columns.Text, required=False) equity_close = db.columns.List(db.columns.Text, required=False) equity_volume = db.columns.List(db.columns.Text, required=False) db.sync_db() @app.route('/', methods=['GET']) def get_all_equity_names(): q = Equity.all() count = len(q) name = [] for i in range(count):
from flask import Flask from flask_sqlalchemy import SQLAlchemy from flask_mongoalchemy import MongoAlchemy from flask_cqlalchemy import CQLAlchemy from flask_bcrypt import Bcrypt from flask_login import LoginManager from flask_migrate import Migrate app = Flask(__name__) app.config['SECRET_KEY'] = '5791628bb0b13ce0c676dfde280ba245' app.config[ 'SQLALCHEMY_DATABASE_URI'] = 'mysql+pymysql://root:mysql@db-mysql:3306/rumi' app.config['MONGOALCHEMY_DATABASE'] = 'rumi' app.config['MONGOALCHEMY_SERVER'] = 'db-mongo' app.config['MONGOALCHEMY_PORT'] = '27017' app.config['MONGOALCHEMY_SAFE_SESSION'] = 'true' app.config['CASSANDRA_HOSTS'] = ['db-cassandra'] app.config['CASSANDRA_KEYSPACE'] = "rumi" db = SQLAlchemy(app) db2 = MongoAlchemy(app) db3 = CQLAlchemy(app) migrate = Migrate(app, db) bcrypt = Bcrypt(app) login_manager = LoginManager(app) login_manager.login_view = 'login' login_manager.login_message_category = 'info' from rumi_jokes import routes
from flask_cqlalchemy import CQLAlchemy from cassandra.cqlengine.management import (create_keyspace_simple) db = CQLAlchemy() def init_app(app): db.init_app(app) create_keyspace_simple( app.config['CASSANDRA_KEYSPACE'], replication_factor=app.config['CASSANDRA_REPLICATION_FACTOR']) db.sync_db()
############## DnD App File for Initialisation Author: Benjamin Smith Last Edited: 15/04/2020 App Description: 1. Take Users to Registration Page to Sign up to App service 2. Save details in Cassandra Cloud Database and call them to Login 3. Sent User through to Library Page where they can make dynamic requests to external API: http://www.dnd5eapi.co/ 4. Allow users to create Characters which are then saved to the database 5. Users can check character creations and edit them throughout the campaign ############### ''' from flask import Flask from flask_bcrypt import Bcrypt from flask_login import LoginManager from flask_cqlalchemy import CQLAlchemy # Initialise app app = Flask(__name__) app.config[ 'SECRET_KEY'] = '756ba24325dfc559acf36854910afc59' # Secret Key for security purposes: (CSRF, {{form.hidden_tag()}}) & Login app.config['CASSANDRA_HOSTS'] = ['127.0.0.1'] app.config['CASSANDRA_KEYSPACE'] = "main" # Set database keyspace bcrypt = Bcrypt(app) # Initialise hashing framework login = LoginManager(app) # Create Login Manager Instances login.login_view = 'Login' database = CQLAlchemy(app) # Create instance of CQLAlchemy database for app from dndApp import routes
from cassandra.cluster import Cluster from flask import Flask from flask_cqlalchemy import CQLAlchemy cluster = Cluster() #C app = Flask(__name__) app.config['CASSANDRA_HOSTS'] = ['127.0.0.1'] app.config['CASSANDRA_KEYSPACE'] = "main" database = CQLAlchemy(app) ''' session.execute("CREATE KEYSPACE main WITH REPLICATION = {'class' : 'SimpleStrategy', 'replication_factor' : 1}") session.set_keyspace('main') session.execute("CREATE TABLE user(email text PRIMARY KEY, first_name text, last_name text, password text)") email = '*****@*****.**' first_name = 'ben' last_name = 'smith' password = '******' session.execute("INSERT INTO user(email, first_name, last_name, password) VALUES(%s, %s, %s, %s)", (email, first_name, last_name, password)) user = session.execute( "SELECT email FROM user WHERE (email=%s)", (email.data)) print(user) ''' class User(database.Model):
#Imports the python wrapper for Genius Song Lyrics API and authorizes the object with the access token import lyricsgenius as genius access_token = 'L1lXyP9PHgtXsIzTM63zqlupMdMZt-LyBwDQ_J1e3CMU4iqsjOxpTSbNpp8gmxx2' #This is to create and authorized object to make api calls api = genius.Genius(access_token) from flask import Flask, jsonify, request from flask_cqlalchemy import CQLAlchemy #Flask setup app = Flask(__name__) app.config['CASSANDRA_HOSTS'] = ['cassandra'] app.config['CASSANDRA_KEYSPACE'] = "genius" app.config['CQLENG_ALLOW_SCHEMA_MANAGEMENT'] = True db = CQLAlchemy(app) #instance created #Model definition for the database class Records(db.Model): artists = db.columns.Text(primary_key=True, required=True) songs = db.columns.List(db.columns.Text, required=False) #lyrics = db.columns.List(db.columns.Text,required=False) db.sync_db() #brings everything to the code from db #Method to get a list of all artists in database @app.route('/', methods=['GET'])
from flask_cqlalchemy import CQLAlchemy import uuid db = CQLAlchemy() # create a CQLAlchemy wrapper [uses cassandra-driver] class PII(db.Model): uid = db.columns.UUID(primary_key=True, required=True) first_name = db.columns.Text(required=True) last_name = db.columns.Text(required=True) email = db.columns.Text(required=True) address = db.columns.Text(required=True) mobile = db.columns.Text(required=True) class User(db.Model): uid = db.columns.UUID(primary_key=True, default=uuid.uuid4) username = db.columns.Text(partition_key=True, required=True) password = db.columns.Text(required=True) otp_secret = db.columns.Text() otp_enabled = db.columns.Boolean(default=False) # boolean for two_way_login confirmation tw_login = db.columns.Boolean(default=False) # sessions established session_estd = db.columns.Boolean(default=False) # utype can be internal-A, internal-B, internal-C, external-A, or # external-B utype = db.columns.Text(required=True, default='external-A')