def test_step_two_create_table(app): db = Database(app, auto_migrate=False) db.define_models(StepTwoThing) ops = _make_ops(db) op = ops.ops[0] sql = _make_sql(db, op) assert sql == _step_two_sql
def db(): app = App(__name__) db = Database( app, config=sdict( uri='sqlite:memory', auto_migrate=True, auto_connect=True)) db.define_models(Register) return db
def test_step_two_create_table(app): db = Database(app, auto_migrate=False) db.define_models(StepTwoThing) ops = _make_ops(db) op = ops.ops[0] sql = _make_sql(db, op) assert sql == _step_two_sql
def db(): app = App(__name__) db = Database(app, config=sdict(uri='sqlite://validators.db')) db.define_models([ A, AA, AAA, B, Consist, Len, Inside, Num, Eq, Match, Anyone, Proc, Person, Thing, Allowed, Mixed ]) return db
def db(): app = App(__name__) db = Database(app, config=sdict(uri='sqlite:memory', auto_migrate=True, auto_connect=True)) db.define_models(Register) return db
def test_step_one_create_table(app): db = Database(app, auto_migrate=False) db.define_models(StepOneThing) ops = _make_ops(db) diffs = ops.as_diffs() assert len(diffs) == 1 and diffs[0][0] == "add_table" op = ops.ops[0] sql = _make_sql(db, op) assert sql == _step_one_sql
def db(): app = App(__name__) db = Database(app, config=sdict(uri='sqlite://dal.db')) db.define_models([ Stuff, Person, Thing, Feature, Price, Doctor, Patient, Appointment, User, Organization, Membership, House, Mouse, NeedSplit, Zoo, Animal, Elephant, Dog, Subscription ]) return db
def test_step_one_create_table(app): db = Database(app, auto_migrate=False) db.define_models(StepOneThing) ops = _make_ops(db) diffs = ops.as_diffs() assert len(diffs) == 1 and diffs[0][0] == "add_table" op = ops.ops[0] sql = _make_sql(db, op) assert sql == _step_one_sql
def db(): app = App(__name__) db = Database( app, config=sdict( uri='sqlite://validators.db', auto_connect=True, auto_migrate=True)) db.define_models([ A, AA, AAA, B, Consist, Len, Inside, Num, Eq, Match, Anyone, Proc, Person, Thing, Allowed, Mixed ]) return db
def db(): app = App(__name__) db = Database( app, config=sdict( uri='sqlite://dal.db', auto_connect=True, auto_migrate=True)) db.define_models([ Stuff, Person, Thing, Feature, Price, Doctor, Patient, Appointment, User, Organization, Membership, House, Mouse, NeedSplit, Zoo, Animal, Elephant, Dog, Subscription ]) return db
def _db(app): try: shutil.rmtree(os.path.join(app.root_path, 'databases')) except: pass db = Database(app) app.pipeline.append(db.pipe) return db
def test_step_three_drop_column(app): db = Database(app, auto_migrate=False) db.define_models(StepThreeThingTwo) ops = _make_ops(db) db2 = Database(app, auto_migrate=False) db2.define_models(StepThreeThingThree) ops2 = _make_ops(db2, ops) op = ops2.ops[0] sql = _make_sql(db, op) assert sql == _step_three_sql_drop
def test_step_four_alter_table(app): db = Database(app, auto_migrate=False) db.define_models(StepFourThing) ops = _make_ops(db) db2 = Database(app, auto_migrate=False) db2.define_models(StepFourThingEdit) ops2 = _make_ops(db2, ops) sql = [] for op in ops2.ops: sql.append(_make_sql(db2, op)) assert "\n".join(sql) == _step_four_sql
def test_step_one_drop_table(app): db = Database(app, auto_migrate=False) db.define_models(StepOneThing) ops = _make_ops(db) db2 = Database(app, auto_migrate=False) db2.define_models() ops2 = _make_ops(db2, ops) diffs = ops2.as_diffs() assert len(diffs) == 1 and diffs[0][0] == "remove_table" op = ops2.ops[0] sql = _make_sql(db2, op) assert sql == _step_one_sql_drop
def test_step_five_indexes(app): db = Database(app, auto_migrate=False) db.define_models(StepFiveThing) ops = _make_ops(db) index_ops = ops.ops[1:] for op in index_ops: sql = _make_sql(db, op) assert sql in _step_five_sql_before db2 = Database(app, auto_migrate=False) db2.define_models(StepFiveThingEdit) ops2 = _make_ops(db2, ops) for op in ops2.ops: sql = _make_sql(db, op) assert sql in _step_five_sql_after
def test_step_three_drop_column(app): db = Database(app, auto_migrate=False) db.define_models(StepThreeThingTwo) ops = _make_ops(db) db2 = Database(app, auto_migrate=False) db2.define_models(StepThreeThingThree) ops2 = _make_ops(db2, ops) op = ops2.ops[0] sql = _make_sql(db, op) assert sql == _step_three_sql_drop
def test_step_four_alter_table(app): db = Database(app, auto_migrate=False) db.define_models(StepFourThing) ops = _make_ops(db) db2 = Database(app, auto_migrate=False) db2.define_models(StepFourThingEdit) ops2 = _make_ops(db2, ops) sql = [] for op in ops2.ops: sql.append(_make_sql(db2, op)) assert "\n".join(sql) == _step_four_sql
def test_step_one_drop_table(app): db = Database(app, auto_migrate=False) db.define_models(StepOneThing) ops = _make_ops(db) db2 = Database(app, auto_migrate=False) db2.define_models() ops2 = _make_ops(db2, ops) diffs = ops2.as_diffs() assert len(diffs) == 1 and diffs[0][0] == "remove_table" op = ops2.ops[0] sql = _make_sql(db2, op) assert sql == _step_one_sql_drop
def test_step_five_indexes(app): db = Database(app, auto_migrate=False) db.define_models(StepFiveThing) ops = _make_ops(db) index_ops = ops.ops[1:] for op in index_ops: sql = _make_sql(db, op) assert sql in _step_five_sql_before db2 = Database(app, auto_migrate=False) db2.define_models(StepFiveThingEdit) ops2 = _make_ops(db2, ops) for op in ops2.ops: sql = _make_sql(db, op) assert sql in _step_five_sql_after
default_values = { 'user': lambda: session.auth.user.id, 'date': now } validation = { 'text': {'presence': True} } fields_rw = { 'user': False, 'post': False, 'date': False } #: init db and auth db = Database(app, auto_migrate=True) auth = Auth(app, db, user_model=User) db.define_models(Post, Comment) #: setup helping function def setup_admin(): # create the user user = User.create( email="*****@*****.**", first_name="Walter", last_name="Bishop", password="******" ) # create an admin group admins = auth.create_group("admin")
def initialize_database(): app = App('app') app.config_from_yaml('db.yml', 'db') db = Database(app) db.define_models(SpectrumAnalyzer, FieldProbe, Scan, ScanResult) return db
fields_rw = {'user': False, 'date': False} class Comment(Model): belongs_to('user', 'post') text = Field('text') date = Field('datetime') default_values = {'user': lambda: session.auth.user.id, 'date': now} validation = {'text': {'presence': True}} fields_rw = {'user': False, 'post': False, 'date': False} #: init db and auth db = Database(app) auth = Auth(app, db, user_model=User) db.define_models(Post, Comment) #: setup helping function def setup_admin(): # create the user user = User.create(email="*****@*****.**", first_name="Walter", last_name="Bishop", password="******") # create an admin group admins = auth.create_group("admin") # add user to admins group auth.add_membership(admins, user.id)
def db(): app = App(__name__) db = Database(app, config=sdict(uri='sqlite:memory')) auth = Auth(app, db, usermodel=User) db.define_models(Thing) return db
import json from weppy import App from weppy.orm import Database, Model, Field from weppy.tools import service from pymongo import MongoClient from load import generate_load class ExampleModel(Model): foo = Field.string() bar = Field.string() app = App(__name__) db = Database(app, auto_migrate=True) db.define_models(ExampleModel) app.pipeline = [db.pipe] client = MongoClient() db = client.test_database foos = db.foos # collection of foo objects @app.route("/") @service.json def simple_json(): return {'foo': 'bar'} @app.route("/model")
def test_step_one_no_diff_in_migration(app): db = Database(app, auto_migrate=False) db.define_models(StepOneThing) ops = _make_ops(db) ops2 = _make_ops(db, ops) assert len(ops2.as_diffs()) == 0
app.config.auth.single_template = True ## language settings app.languages = ['en', 'it'] app.language_default = 'en' app.language_force_on_url = True app.language_write = True ## init database and auth from models.user import User from models.campaign import Campaign from models.donation import Donation from models.cost import Cost ## init auth before passing db models due to dependencies ## on auth tables in the other models db = Database(app, auto_migrate=True) auth = Auth(app, db, user_model=User) # auth.settings.update(download_url='/download') db.define_models(Campaign, Donation, Cost) ## adding sessions and authorization handlers app.pipeline = [SessionManager.cookies('verySecretKey'), db.pipe, auth.pipe] ## add esxtensions from weppy_haml import Haml from weppy_assets import Assets from weppy_bs3 import BS3 app.config.Haml.set_as_default = True # app.config.Haml.auto_reload = True app.use_extension(Haml) app.config.Assets.out_folder = 'gen'
import json from weppy import App, abort from weppy.tools import service from weppy.orm import Database, Model, Field from weppy.sessions import SessionCookieManager from .build import build_all from .keys import DB_PIPE_KEY from .models import Character app = App(__name__) db = Database(app, auto_migrate=True) db.define_models(Character) @app.command('setup') def setup(): build_all(db) app.pipeline = [SessionCookieManager(DB_PIPE_KEY), db.pipe] @app.route('/') def there_is_always_one_truth(): return "真実はいつもひとつ!" @app.route('/character/<int:character_id>', methods="get")
app.config.auth.single_template = True ## language settings app.languages = ['en', 'it'] app.language_default = 'en' app.language_force_on_url = True app.language_write = True ## init database and auth from models.user import User from models.campaign import Campaign from models.donation import Donation from models.cost import Cost ## init auth before passing db models due to dependencies ## on auth tables in the other models db = Database(app, auto_migrate=True) auth = Auth(app, db, user_model=User) # auth.settings.update(download_url='/download') db.define_models(Campaign, Donation, Cost) ## adding sessions and authorization handlers app.pipeline = [ SessionManager.cookies('verySecretKey'), db.pipe, auth.pipe ] ## add esxtensions from weppy_haml import Haml from weppy_assets import Assets from weppy_bs3 import BS3
from weppy_bs3 import BS3 from weppy_rest import REST, serialize from logic.scanning import begin_scan, scan_finished_callback from serializers.hardware import SpectrumAnalyzerSerializer, FieldProbeSerializer from serializers.scanning import ScanSerializer, ResultSerializer, ScanResultMatSerializer from tasks import increase_progress from utils import CORS app = App(__name__) app.config.url_default_namespace = "main" app.use_extension(BS3) app.use_extension(REST) app.config_from_yaml('db.yml', 'db') db = Database(app, auto_migrate=True) app.pipeline = [db.pipe, CORS()] from models.hardware import SpectrumAnalyzer, FieldProbe from models.scanning import Scan, ScanResult, XResultRow, ScanResultMat db.define_models(SpectrumAnalyzer, FieldProbe, Scan, ScanResult, XResultRow, ScanResultMat) from controllers import main, hardware, scanning analyzers = app.rest_module(__name__, 'spectrumanalyzer', SpectrumAnalyzer, serializer=SpectrumAnalyzerSerializer, url_prefix='analyzers') probes = app.rest_module(__name__,
from redis import Redis app = App(__name__) app.config.static_version = '1.5.0' app.config.static_version_urls = True app.config.url_default_namespace = "main" app.config_from_yaml('redis.yml', 'redis') app.config_from_yaml('sentry.yml', 'Sentry') app.config.Haml.set_as_default = True app.use_extension(Haml) app.use_extension(Sentry) from .models import Version, Extension db = Database(app, auto_migrate=True) db.define_models(Version, Extension) redis = Redis(**app.config.redis) cache = Cache(redis=RedisCache(**app.config.redis)) app.pipeline = [db.pipe] from .controllers import main, docs, extensions from . import commands #: ensure 'docs' folder presence if not os.path.exists(os.path.join(app.root_path, "docs")): os.mkdir(os.path.join(app.root_path, "docs"))
@rowmethod('serialize') def _serialize(self, row): return {'id': row.id, 'message': row.message} app.config.handle_static = False app.config.db.adapter = 'postgres:psycopg2' \ if not _is_pypy else 'postgres:pg8000' app.config.db.host = DBHOSTNAME app.config.db.user = '******' app.config.db.password = '******' app.config.db.database = 'hello_world' app.config.db.pool_size = 100 db = Database(app, auto_migrate=False) db.define_models(World, Fortune) @app.route() @service.json def json(): return {'message': 'Hello, World!'} @app.route("/db", pipeline=[db.pipe]) @service.json def get_random_world(): return World.get(randint(1, 10000)).serialize()
temperature = Field.float() validation = { 'station_id': { 'presence': True }, 'date': { 'presence': True }, 'temperature': { 'presence': True } } db = Database(app, auto_migrate=False) db.define_models(Reading) app.pipeline = [db.pipe] @app.command('setup') def setup(): reading = Reading.create(station_id='XXX', date=time.asctime(), temperature=73.0) print(reading) db.commit() @app.route("/")
def test_step_one_no_diff_in_migration(app): db = Database(app, auto_migrate=False) db.define_models(StepOneThing) ops = _make_ops(db) ops2 = _make_ops(db, ops) assert len(ops2.as_diffs()) == 0
@rowmethod('serialize') def _serialize(self, row): return {'id': row.id, 'message': row.message} app.config.handle_static = False app.config.db.adapter = 'postgres:psycopg2' \ if not _is_pypy else 'postgres:pg8000' app.config.db.host = DBHOSTNAME app.config.db.user = '******' app.config.db.password = '******' app.config.db.database = 'hello_world' app.config.db.pool_size = 100 db = Database(app, auto_migrate=False) db.define_models(World, Fortune) @app.route() @service.json def json(): return {'message': 'Hello, World!'} @app.route("/db", pipeline=[db.pipe]) @service.json def get_random_world(): return World.get(randint(1, 10000)).serialize()
from weppy import App, session, redirect, url, response, request from weppy.sessions import SessionManager, current from weppy.tools import service from weppy.orm import Database from weppy.tools import Auth, requires from models.Models import User, Issue app = App(__name__) app.config.db.uri = 'postgres://*****:*****@localhost/bazinga' app.config.auth.single_template = True app.config.auth.registration_verification = False app.config.auth.hmac_key = "SomedayWholePeopleWillbeFucked" db = Database(app, auto_migrate=True) auth = Auth(app, db, user_model=User) app.pipeline = [ SessionManager.cookies('SomedayWholePeopleWillbeFucked'), db.pipe, auth.pipe ] db.define_models(User, Issue) auth_routes = auth.module(__name__) def not_authorized(): redirect(location='/system/login', status_code=302)