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 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 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_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 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 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 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 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_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_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
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 index():
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"))
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__,
'fieldprobe',
FieldProbe,
serializer=FieldProbeSerializer,
url_prefix='probes')
scans = app.rest_module(__name__,
'scan',
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
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)
db.commit()
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)
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
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
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
@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()
def get_qparam():
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'
app.use_extension(Assets)
app.use_extension(BS3)
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")
@service.json
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")
}
validation = {
'id': {
'presence': True
},
}
fields_rw = {'user': False, 'date': False}
class Comment(Model):
belongs_to('user', 'image')
text = Field('text')
date = Field('datetime')
default_values = {
'user': lambda: session.auth.user.id,
'date': lambda: now
}
validation = {'text': {'presence': True}}
fields_rw = {'user': False, 'image': False, 'date': False}
db = Database(app, auto_migrate=True)
auth = Auth(app, db, user_model=User)
db.define_models(Image, Comment)
if __name__ == "__main__":
app.run()
hello()
'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")
# add user to admins group
auth.add_membership(admins, user.id)
@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()
def get_qparam():
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)
@app.route('/', methods=["get"], template='pages/index.html')
def index():
response.meta.title = 'Bazinga Issue Tracker System'
return dict(user={})