def initialize_db():
db.connect() #connect to db
#print 'opened db!'
db.create_tables([Location, Customer],
safe=True) #create tables if not present
build_queues() #build the queue
atexit.register(closedb) #register exit handler to close db on exit
def init_db(database=None):
if not database:
database = app.config["DATABASE"]
db.init(database)
db.connect()
db.create_tables([Author, Content])
Author.create(id=1, name="author")
db.close()
def createtables_db():
# Connect to our database.
db.connect()
# Create the tables.
db.create_tables([Contribution, File])
print "Created tables"
def deploy():
"""Run deployment tasks."""
tables = []
db.drop_tables(tables)
db.create_tables(tables)
from app.core.models import mock_all_models
mock_all_models()
def migrate():
database_module = importlib.import_module('database')
if should_refresh:
db.drop_tables([
database_module.__dict__[table]
for table in reversed(database_module.__all__)
])
db.create_tables(
[database_module.__dict__[table] for table in database_module.__all__])
logger.info('tables migrated successfuly')
def create_demo_data():
with db:
print("Creating DB")
db.create_tables([Project, PageView])
uuid = get_uuid()
project_name = "getnimo.app"
print("Creating Project:")
print("\tProject Name: {0}".format(project_name))
print("\tProject ID: {0}".format(uuid))
project = Project.create(uuid=uuid, name=project_name)
project.save()
d1 = datetime.strptime('1/1/2019 1:30 PM', '%m/%d/%Y %I:%M %p')
d2 = datetime.strptime('6/1/2020 4:50 AM', '%m/%d/%Y %I:%M %p')
routes = [
'/', '/', '/', '/', '/blog/v8', '/projects/frappe', '/projects/charts',
'/projects/nimo', '/blog/hello'
]
referrer = [
'https://twitter.com', 'https://duckduckgo.com', 'https://github.com',
'https://google.com', 'https://google.com', 'https://google.com'
]
broswer = [
'Chrome', 'Chrome', 'Chrome', 'Chrome', 'Firefox', 'Opera', 'Safari'
]
timezones = [
'Asia/Kolkata', 'Asia/Kolkata', 'Asia/Kolkata', 'Europe/London',
'America/Chicago', 'America/New_York', 'Pacific/Honolulu',
'America/Denver', 'Europe/Istanbul'
]
print("Creating 15000 Entries")
for ii in range(15000):
rdate = random_date(d1, d2)
pageview = PageView.create(
project_id=uuid,
creation=rdate,
modified=rdate + timedelta(seconds=random.randint(100, 900)),
path=random.choice(routes),
is_unique=random.choice([True, True, False]),
referrer=random.choice(referrer),
timezone=random.choice(timezones),
browser_name=random.choice(broswer),
browser_version='71')
pageview.save()
print("Demo Data Created")
print("Go Make Some Noise!")
def create_tables():
# Create table for each model if it does not exist.
# Use the underlying peewee database object instead of the
# flask-peewee database wrapper:
tables = [
Doctor,
DoctorSpecialty,
Graduate,
GraduateRecord,
Proxy,
Vehicle,
RRLL,
TelephoneLine,
]
db.create_tables(tables, safe=True)
def init_db():
'''Initial database'''
db.connect()
print('Creating tables ...')
db.create_tables(tables)
print('Tables have been created.')
print('Writing default configurations ...')
Config.create(name='site_name', value=app.config['DEFAULT_SITE_NAME'])
Config.create(name='site_url', value=app.config['DEFAULT_SITE_URL'])
Config.create(name='count_topic',
value=app.config['DEFAULT_TOPICS_PER_PAGE'])
Config.create(name='count_post',
value=app.config['DEFAULT_POSTS_PER_PAGE'])
Config.create(name='count_list_item',
value=app.config['DEFAULT_LIST_ITEM_PER_PAGE'])
# Config.create(name='count_subpost', value=app.config['DEFAULT_SUBPOSTS_PER_PAGE'])
print('Default configurations have been written into database.')
db.close()
import sys
from app import app, db
from os.path import abspath, dirname, join
base_path = dirname(abspath(__file__))
sys.path.insert(1, sys.path[0])
sys.path.insert(1, join(base_path, 'lib'))
sys.path.insert(1, join(base_path, 'models'))
import views
from tag import Tag # a Peewee DB model
if __name__ == '__main__':
db.create_tables([Tag], safe=True)
app.run()
def __init__(self, args):
self.app = QApplication([])
self.debug = args['--debug']
signal(SIGINT, SIG_DFL)
create_tables()
# main.py
from app import db
from app import app as application
from models import Track, Statistic, Tag
import views
if __name__ == '__main__':
db.connect()
db.create_tables([Track, Statistic, Tag])
db.close()
application.run()
def create_tables():
with db:
db.create_tables(MODELS)
def init_db():
db.create_tables([Role, User, Post, Point, RoleUser])
init_data()
logger.info("Init data successful.")
return JsonResult()
from app import app, db
from routes import *
from models import *
if __name__ == '__main__':
db.create_tables([User, Group, Link, UserToGroup], safe=True)
app.run()
# coding :utf-8
from app import myapp, db
from models import ClassRoom
import view
db.create_tables([ClassRoom], safe=True)
if __name__ == '__main__':
myapp.run('0.0.0.0')
def initialize():
"""Create tables."""
db.connect()
db.create_tables([Category, Project, Post, Media, User], safe=True)
db.close()
def init_db_command():
# with db:
db.create_tables(models_list)
click.echo('Initialized the database.')
from pony.orm import db_session
from app import db
from models.User import User, UserSchema
from models.Landmark import Landmark
from models.Story import Story
# We delete all tables in our database
db.drop_all_tables(with_all_data=True)
db.create_tables() # We create tables in our database
with db_session():
schema = UserSchema()
alikurtulus = User(
username='******',
email='*****@*****.**',
password_hash=schema.generate_hash('sda')
)
Story(
cityname='Lisbon',
title='Lisbon was great holiday',
user=alikurtulus,
description="Lisbon is, in my opinion, one of the best cities to spend a weekend and a perfect place to experience one of Europe’s smaller capitals – but don’t let the word ‘smaller’ fool you! Lisbon packs a hefty punch with great places to see, eat and places to totally ‘let your hair down’…",
date='12.08.2018',
image='https://handluggageonly.co.uk/wp-content/uploads/2015/09/DSC02292.jpg'
)
Story(
cityname='Madrid',
title='Madrid was dream holiday',
user=alikurtulus,
def initialize():
db.connect()
db.create_tables([Match, MatchPlayer, Player], safe=True)
db.close()
from app import app, db
from models import Link, DailyStats
import handlers
if __name__ == '__main__':
db.create_tables([Link, DailyStats])
app.run(host="0.0.0.0")
def setup_tables():
import models
model_list = reversed(p.sort_models_topologically(models.BaseModel.__subclasses__()))
db.create_tables(model_list, safe=True)
def create_tables():
with db:
db.create_tables([Order])
def create_tables():
db.create_tables([Business, Customer, Appointment, Conversation])
business = Business.create(name="Math Tutoring Inc.", phone="+19158000459")
def draw_pastell(nx=900, ny=1600, CL=180, rshift=3):
nz = 3
mid = nx // 2
dCL = 50
#---- start the coloring ----------
A = np.ones((nx, ny, nz)) * CL # initialize the image matrix
#np.random.seed(1234) # initialize RNG
#---- initialize the lower part ----
ix = slice(0, mid - 1)
iz = slice(0, nz) # color the left boundary
A[ix, 0, iz] = CL + np.cumsum(
np.random.randint(-rshift, rshift + 1, size=(mid - 1, nz)), axis=0)
#---- initialize the upper part ----
ix = slice(mid, nx)
iz = slice(0, nz) # color the left boundary
A[ix, 0, iz] = CL - dCL + np.cumsum(
np.random.randint(-rshift, rshift + 1, size=(nx - mid, nz)), axis=0)
#---- march to the right boundary -------------
ix = slice(1, nx - 1)
ixm = slice(0, nx - 2)
ixp = slice(2, nx)
for jy in range(1, ny): # smear the color to the right boundary
A[ix, jy, iz] = 0.3333 * (A[ixm, jy - 1, iz] + A[ix, jy - 1, iz] +
A[ixp, jy - 1, iz]) + np.random.randint(
-rshift, rshift + 1, size=(nx - 2, nz))
#---- show&save grafics ---------
im1 = Image.fromarray(A.astype(np.uint8)).convert('RGBA')
draw1 = ImageDraw.Draw(im1, "RGBA")
r = random.randint(0, 255)
g = random.randint(0, 255)
b = random.randint(0, 255)
for i in range(randint(0, 10)):
draw1.rectangle(((randint(0, 6000), randint(0, 6000)),
(randint(0, 100), randint(0, 100))),
fill=tuple(np.random.randint(256, size=3)) + (60, ))
im1 = im1.filter(ImageFilter.CONTOUR)
im1 = im1.filter(ImageFilter.EMBOSS)
for i in range(randint(0, 500)):
im1 = im1.filter(ImageFilter.BLUR)
for i in range(randint(0, 500)):
im1 = im1.filter(ImageFilter.EDGE_ENHANCE_MORE)
for i in range(randint(0, 500)):
im1 = im1.filter(ImageFilter.CONTOUR)
for i in range(randint(0, 500)):
im1 = im1.filter(ImageFilter.EDGE_ENHANCE_MORE)
for i in range(randint(0, 500)):
im1 = im1.filter(ImageFilter.BLUR)
for i in range(randint(0, 1000)):
im1 = im1.filter(ImageFilter.EDGE_ENHANCE_MORE)
buf = io.BytesIO()
im1.save(buf, format='PNG')
thing = buf.getvalue()
db.drop_all_tables(with_all_data=True)
db.create_tables()
with db_session():
Work(dat=str(base64.b64encode(buf.getvalue()))),
db.commit()
# models.py
import datetime
from peewee import *
from app import db, retry_db
class ClassyFireEntity(Model):
inchikey = TextField(unique=True, index=True)
responsetext = TextField()
status = TextField()
class Meta:
database = db
class FailCaseDB(Model):
fullstructure = TextField(unique=True,index=True)
status = TextField()
class Meta:
database = retry_db
#Creating the Tables
db.create_tables([ClassyFireEntity], safe=True)
retry_db.create_tables([FailCaseDB], safe=True)
from app import app, db
from routes import *
from models import *
if __name__ == '__main__':
db.create_tables( [ User, Group, Link, UserToGroup ], safe = True )
app.run()
from pony.orm import db_session
from app import db
from models.Category import Category
from models.Listing import Listing
from models.User import User, UserSchema
from models.CartItem import CartItem
db.drop_all_tables(with_all_data=True)
db.create_tables()
with db_session():
user_schema = UserSchema()
user1 = User(username='******',
email='*****@*****.**',
password_hash=user_schema.generate_hash('pass'))
user2 = User(username='******',
email='*****@*****.**',
password_hash=user_schema.generate_hash('pass'))
user3 = User(username='******',
email='*****@*****.**',
password_hash=user_schema.generate_hash('pass'))
user4 = User(username='******',
email='*****@*****.**',
password_hash=user_schema.generate_hash('pass'))
user5 = User(username='******',
def create_tables(): with db: db.create_tables([Project, PageView, User])
def deploy():
db.create_tables(app)
print('deploy success.')
def create_tables():
db.create_tables([VideoHistory], safe=True)
