def run(self):
"""
Run the database seeds.
"""
categories = [
"Art", "Biography", "Business", "Children's", "Mystery", "Manga",
"Science", "Self Help", "Spirituality", "Travel", "Thriller"
]
for category in categories:
Category.create(title=category)
def populate():
Role.insert_roles()
user = Account(password='******', email='*****@*****.**', confirmed=True)
user2 = Account(password='******', email='*****@*****.**', confirmed=True)
new_category = Category(name='Kategoria1')
new_category2 = Category(name='Kategoria2')
new_product = Product(name='Produkt1', description='Opis1',
weight=1.99, price=12.99, category=new_category, seller=user)
new_product2 = Product(name='Produkt2', description='Opis2',
weight=20, price=100, category=new_category2, seller=user2)
db.session.add_all([user, user2, new_product, new_product2, new_category, new_category2])
db.session.commit()
def modifyCategory(fs):
""" modify fs to be properly consumed by Category() """
# check for the existence of subcategory
c = None
if fs['id'] in ["deleteCategory", 'renameCategory', 'adoptCategory']:
""" deactivates Category """
c = Category(fs).updateCategory()
elif fs['id'] == "createCategory":
""" Creates new Category """
c = Category(fs).newCategory()
returnJson(c)
def setUpClass(cls):
super(ProductModelTestCase, cls).setUpClass()
cls.new_category = Category(name='Kategoria1')
cls.new_category2 = Category(name='Kategoria2')
cls.new_product = Product(name='Produkt1',
description='Opis1',
weight=1.99,
price=12.99,
category=cls.new_category,
seller=cls.acc)
cls.new_product2 = Product(name='Produkt2',
description='Opis2',
weight=20,
price=100,
category=cls.new_category2,
seller=cls.acc)
def test_category_create(self):
c = Category.create("Cheezy movies")
db.session.add(c)
db.session.commit()
cs = Category.query.filter_by(name="Cheezy movies").all()
assert len(cs) == 1
assert cs[0].name == "Cheezy movies"
def new_category():
form = CategoryForm()
if form.validate_on_submit():
name = form.name.data
category = Category(name=name)
db.session.add(category)
db.session.commit()
flash('已创建分类', 'success')
return redirect(url_for('.manage_category'))
return render_template('admin/new_category.html', form=form)
def test_creating_Post(db_init):
admin = User(username='******', email='*****@*****.**')
category = Category(name='Python')
post = Post(
title='New Python Book', body='New Book released!!',
category=category, user=admin
)
db.session.add(category)
db.session.add(admin)
db.session.commit()
assert Post.query.filter_by(title='New Python Book').first().category == category
assert Post.query.filter_by(title='New Python Book').first().user == admin
assert Category.query.first().posts[0] == post
assert User.query.first().posts[0] == post
def fill_db():
with open('delivery_categories.csv', encoding='utf-8') as cat:
categories = csv.DictReader(cat)
for category in categories:
categ = Category(title=category['title'])
db.session.add(categ)
db.session.commit()
with open('delivery_items.csv', encoding='utf-8') as f:
items = csv.DictReader(f)
for item in items:
category = db.session.query(Category).filter(
Category.id == int(item['category_id'])).first()
meal = Meal(title=item['title'],
price=int(item['price']),
description=item['description'],
picture=item['picture'],
categories=category)
db.session.add(meal)
db.session.commit()
def parse_listing(_listing):
locality = _listing.find('div', {'class': 'locality'})
if not locality:
return None
business_name = _listing.find('a', {'class': 'business-name'})
website = _listing.find('a', {'class': 'track-visit-website'})
street_address = _listing.find('div', {'class': 'street-address'})
phones = _listing.find('div', {'class': 'phones'})
categories = _listing.find('div', {'class': 'categories'})
_parsed_listing = {}
_parsed_listing['keywords'] = [Keyword(name=search_term)]
_parsed_listing['url'] = business_name['href'].split('?')[0]
_parsed_listing['id'] = _parsed_listing['url'].split('-')[-1]
_parsed_listing['categories'] = []
if categories:
for category in _listing.find('div', {'class': 'categories'}):
_parsed_listing['categories'].append(
Category(id=slugify(category.text), name=category.text))
_parsed_listing['business_name'] = business_name.text
_parsed_listing['address'] = street_address.text if street_address else ''
_parsed_listing['locality'] = locality.text
*city, _parsed_listing['state'], _parsed_listing[
'zipcode'] = _parsed_listing['locality'].split(' ')
_parsed_listing['city'] = ' '.join(city).strip(',')
_parsed_listing['zipcode'] = _parsed_listing['locality'].split(
)[-1] if locality else ''
if website:
_parsed_listing['website'] = website['href']
_parsed_listing['domain_id'] = urlparse(
_parsed_listing['website']).netloc
else:
_parsed_listing['website'] = ''
_parsed_listing['domain_id'] = ''
_parsed_listing['phone'] = phones.text if phones else ''
return _parsed_listing
#!/usr/bin/env python3
# -*- coding:utf-8 -*-
from app import db, File, Category
# 创建所有表
db.create_all()
# 在类别表中插入数据
cate1 = Category('Java')
cate2 = Category('Python')
db.session.add(cate1)
db.session.add(cate2)
db.session.commit()
# 在文件表中插入数据
file1 = File('Hello Java', cate1, 'File Content - Java is cool!')
file2 = File('Hello Python', cate2, 'File Cntent - Python is cool!')
db.session.add(file1)
db.session.add(file2)
db.session.commit()
file1.add_tag('tech')
file1.add_tag('java')
file1.add_tag('linux')
file2.add_tag('tech')
file2.add_tag('python')
import pandas as pd
import os
import csv
from app import app, db, Category, Meal
t = pd.read_csv('meals.csv', sep=';')
t.dropna(inplace=True)
print(t.shape)
print(t.iloc[0])
for index, meal in t.iterrows():
print(meal["title"], meal["price"])
meal_add = Meal(id=meal['id'],
title=meal['title'],
price=meal['price'],
description=meal['description'],
picture=meal['picture'],
category_id=meal['category_id'])
db.session.add(meal_add)
db.session.commit()
t = pd.read_csv('Categories.csv', sep=';')
t.dropna(inplace=True)
print(t.shape)
print(t.iloc[0])
for index, cat in t.iterrows():
print(cat["title"], cat["id"])
cat_add = Category(id=cat['id'], title=cat['title'])
db.session.add(cat_add)
db.session.commit()
from app import db, Reader, User, Category
db.drop_all()
db.create_all()
reader = Reader(name="Mike")
author = User(name="Arthur")
category = Category(name="News")
db.session.add(reader)
db.session.add(author)
db.session.add(category)
db.session.commit()
### In a client such as postman
### Available Routes
# CRUD on Blogs
## /blogs and /blogs/<id> method Get, POST, PUT, Delete Create a Blog
### params
# title
# subtitle
# user
# category
# Create and Read Users
## /users and /user/<id> methods GET and POST
### params
# name
# Categories CRUD
def main():
db.create_all()
ho = Category(title="hobby")
ps = Category(title="psychologia")
co = Category(title="programowanie")
rr = Category(title="związki")
lm = Category(title="muzyka")
st = Category(title="live stream")
ev1 = Event(
title="Zarządzanie sobą w kryzysie tożsamości",
host_name="prof. Henryk Sienkiewicz",
url="https://www.youtube.com/watch?v=J53UK_bul5Y",
categories=[ps],
planned_start=datetime(2020, 10, 12, 17, 30),
estimated_duration=2,
description="Lorem ipsum dolor sit amet, consectetur adipisicing \
elit, sed do eiusmod tempor incididunt ut labore et dolore magna \
aliqua. Ut enim ad minim veniam, quis nostrud exercitation \
ullamco laboris nisi ut aliquip ex ea commodo consequat.",
)
ev2 = Event(
title="Python w terrarium, czyli o wirtualnych środowiskach",
host_name="Jakub Wężowy",
url="https://www.youtube.com/watch?v=J53UK_bul5Y",
categories=[co],
planned_start=datetime(2020, 10, 13, 17, 30),
estimated_duration=1,
description="Lorem ipsum dolor sit amet, consectetur adipisicing \
elit, sed do eiusmod tempor incididunt ut labore et dolore magna \
aliqua. Ut enim ad minim veniam, quis nostrud exercitation \
ullamco laboris nisi ut aliquip ex ea commodo consequat.",
)
ev3 = Event(
title="Z szydełkowaniem na przeciw COVID-19",
host_name="Grażka Szydełkowa",
url="https://www.youtube.com/watch?v=J53UK_bul5Y",
categories=[ho],
planned_start=datetime(2020, 10, 16, 17, 30),
estimated_duration=2,
description="Lorem ipsum dolor sit amet, consectetur adipisicing \
elit, sed do eiusmod tempor incididunt ut labore et dolore magna \
aliqua. Ut enim ad minim veniam, quis nostrud exercitation \
ullamco laboris nisi ut aliquip ex ea commodo consequat.",
)
ev4 = Event(
title="Programowanie ludzkiego mózgu z wykorzystaniem pakietu numpy \
i anaconda",
host_name="Jakub Wężowy",
url="https://www.youtube.com/watch?v=J53UK_bul5Y",
categories=[ho, co],
planned_start=datetime(2020, 10, 22, 18, 00),
estimated_duration=3,
description="Lorem ipsum dolor sit amet, consectetur adipisicing \
elit, sed do eiusmod tempor incididunt ut labore et dolore magna \
aliqua. Ut enim ad minim veniam, quis nostrud exercitation \
ullamco laboris nisi ut aliquip ex ea commodo consequat.",
)
ev5 = Event(
title="Szukanie w stogu siana, czyli miłość w czasie zarazy",
host_name="Agnieszka Buchałka",
url="https://www.youtube.com/watch?v=J53UK_bul5Y",
categories=[rr],
planned_start=datetime(2020, 10, 22, 14, 30),
estimated_duration=2,
description="Lorem ipsum dolor sit amet, consectetur adipisicing \
elit, sed do eiusmod tempor incididunt ut labore et dolore magna \
aliqua. Ut enim ad minim veniam, quis nostrud exercitation \
ullamco laboris nisi ut aliquip ex ea commodo consequat.",
)
ev6 = Event(
title="PsyTrans TECHNO Party ELO320",
host_name="DJ Kolbas",
url="https://www.youtube.com/watch?v=J53UK_bul5Y",
categories=[lm, st],
planned_start=datetime(2020, 10, 30, 20, 00),
estimated_duration=5,
description="Lorem ipsum dolor sit amet, consectetur adipisicing \
elit, sed do eiusmod tempor incididunt ut labore et dolore magna \
aliqua. Ut enim ad minim veniam, quis nostrud exercitation \
ullamco laboris nisi ut aliquip ex ea commodo consequat.",
)
categories = [
"joga",
"fitness",
"czytanie książek na głos",
"terapia grupowa",
"zajęcia teatralne",
"gotowanie",
]
obj_categories = [Category(title=cat) for cat in categories]
db.session.add_all([ho, ps, co, ev1, ev2, ev3, ev4, ev5, ev6])
db.session.add_all(obj_categories)
db.session.commit()
db.session.close()
import json
from app import db, Category, CatLink
db.drop_all()
db.create_all()
print("Migrating Categories...")
with open("ranked_cats.json") as jsonfile:
js = json.load(jsonfile)
db.session.add_all(Category(pageid=int(k), pagecount=v['page_count'])
for k, v in js.items())
print("Migrating CatLinks...")
with open("all_subcats.json") as jsonfile:
js = json.load(jsonfile)
db.session.add_all(CatLink(parent_id=int(k), child_id=int(c))
for k, v in js.items()
if k != 'None'
for c in set(v))
print("Committing...")
db.session.commit()
from app import db, Category, Food, Basket
db.drop_all()
db.create_all()
categories = []
categories.append(Category(name='Зелень'))
categories.append(Category(name='Овощи'))
categories.append(Category(name='Фрукты'))
foods = []
foods.append(
Food(
name='Зелёный лук',
cost=250,
category_id=1,
img_url=
'http://test.degreen.kz/media/filer_public/9a/11/9a11f0b2-0c4e-463f-80f0-4d1f26c77c30/zelenyi_luk.jpg',
description=
'В составе зелёного лука имеются витамины С, Е, К, необходимые для усиления иммунитета, ускорения роста волос и улучшения состояния кожных покровов, а также некоторые минеральные вещества, среди которых: кальций, магний, цинк, железо, сера, фтор, фосфор.'
))
foods.append(
Food(
name='Петрушка',
cost=170,
category_id=1,
img_url=
'http://test.degreen.kz/media/filer_public/c0/a1/c0a115ca-df4f-4809-894a-f91ef029c229/petrushka.jpg',
description=
'Петрушка обладает пряным запахом и сладковатым, терпким вкусом. В ней содержится эфирное масло, аскорбиновая кислота, каротин, тиамин, минеральные соли железа, фосфора, калия, кальция, магния, белки, пектиновые вещества и многое другое.'
))
foods.append(
import csv
from app import app, db, Dish, Category
with app.app_context():
with open("delivery_categories.csv", encoding='utf-8') as r_file:
csv_categories = csv.reader(r_file, delimiter=',')
for csv_line in list(csv_categories)[1:]:
category = Category(csv_id=int(csv_line[0]), title=csv_line[1])
print(category.csv_id, type(category.csv_id), category.title,
len(category.title))
db.session.add(category)
with open("delivery_items.csv", encoding='utf-8') as r_file:
csv_items = csv.reader(r_file, delimiter=',')
for csv_line in list(csv_items)[1:]:
db.session.add(
Dish(
title=csv_line[1],
price=float(csv_line[2]),
description=csv_line[3],
picture=csv_line[4],
category=db.session.query(Category).filter(
Category.csv_id == csv_line[5]).scalar(),
))
db.session.commit()
t2 = Teacher("Teacher2", "*****@*****.**", "password", "0987654321",
"teacher")
db.session.add(t2)
s1 = Student("Shafeeq K", "*****@*****.**", "password", "1234567890",
"student")
db.session.add(s1)
s2 = Student("Ashwin Jayakumar", "*****@*****.**", "password",
"1234567890", "student")
db.session.add(s2)
s3 = Student("Hanzal Salim", "*****@*****.**", "password",
"1234567890", "student")
db.session.add(s3)
s4 = Student("Bharadhwaj CN", "*****@*****.**", "password",
"1234567890", "student")
db.session.add(s4)
c = Category("General")
db.session.add(c)
c1 = Category("Embedded Systems")
db.session.add(c1)
c2 = Category("Compiler Design")
db.session.add(c2)
c3 = Category("Computer Networks")
db.session.add(c3)
c4 = Category("Database Management Systems")
db.session.add(c4)
c5 = Category("Computer Graphics")
db.session.add(c5)
c6 = Category("Information Security")
db.session.add(c6)
c7 = Category("Systems Lab")
db.session.add(c7)
def getCategories():
""" gathers all categories """
returnJson({"categories": Category().getAllCategories()})
Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) # A DBSession() instance establishes all conversations with the database # and represents a "staging zone" for all the objects loaded into the # database session object. Any change made against the objects in the # session won't be persisted into the database until you call # session.commit(). If you're not happy about the changes, you can # revert all of them back to the last commit by calling # session.rollback() session = DBSession() # Create item categories categoryEntry = Category(name="Soccer") session.add(categoryEntry) session.commit() categoryEntry = Category(name="Basketball") session.add(categoryEntry) session.commit() categoryEntry = Category(name="Baseball") session.add(categoryEntry) session.commit() categoryEntry = Category(name="Frisbee") session.add(categoryEntry) session.commit()
def test_user_behaviour(client):
mock_category = Category(name='Men', mapping='Men clothes')
# categories endpoint
categories_url = '/categories'
response = client.get(categories_url)
assert '200 OK' == response.status
assert [] == response.json
response = client.post(categories_url,
data=json.dumps({
'name': mock_category.name,
'mapping': mock_category.mapping
}),
content_type='application/json')
assert '200 OK' == response.status
assert 'id' in response.json
# category endpoint
category_url = f'{categories_url}/{response.json["id"]}'
response = client.get(category_url)
assert '200 OK' == response.status
assert mock_category.name == response.json['name']
assert mock_category.mapping == response.json['mapping']
response = client.put(category_url,
data=json.dumps({
'name': 'test_name',
'mapping': 'test_mapping'
}),
content_type='application/json')
assert '204 NO CONTENT' == response.status
response = client.get(category_url)
assert '200 OK' == response.status
assert 'test_name' == response.json['name']
assert 'test_mapping' == response.json['mapping']
response = client.delete(category_url)
assert '204 NO CONTENT' == response.status
response = client.get(categories_url)
assert '200 OK' == response.status
assert [] == response.json
# batch processing
response = client.post(categories_url,
data=json.dumps([{
'name': 'Name1',
'mapping': 'Mapping1'
}, {
'name': 'Name2',
'mapping': 'Mapping2'
}, {
'name': 'Name3',
'mapping': 'Mapping3'
}]),
content_type='application/json')
assert '202 ACCEPTED' == response.status
assert 'process_id' in response.json
response = client.get(f'/processes/{response.json["process_id"]}')
assert '200 OK' == response.status
assert 'state' in response.json
import random
from sqlalchemy.sql import func
from app import db, Category, Video
db.drop_all()
db.create_all()
for i in range(1, 11):
c = Category(name='Category %s' % i)
db.session.add(c)
for i in range(1, 101):
v = Video(title='Title %s' % i)
db.session.add(v)
db.session.commit()
for i in Video.query.all():
for c in Category.query.order_by(func.random())[:random.randint(1, 5)]:
i.categories.append(c)
db.session.commit()
from datetime import datetime
# sudo service mysql start
# sudo pip3 install flask_sqlalchemy, mysqlclient
# sudo pip3 install pymongo
# mysql -u root
# create database news;
# mongo
# use news;
# ./inti_test_data.py
db.create_all()
# # ?? MySQL ????
java = Category('Java')
python = Category('Python')
post1 = Post('Hello Java', java, 'File Content - Java is cool!',
datetime.utcnow())
post2 = Post('Hello Python', python, 'File Content - Python is cool!',
datetime.utcnow())
db.session.add(java)
db.session.add(python)
db.session.add(post1)
db.session.add(post2)
db.session.commit()
# ?? MongoDB ????
# client = MongoClient('127.0.0.1', 27017)
# mdb = client.news
post1.add_tag('tech')
import csv
from app import db, Category
with open('csv/categories.csv') as f:
i = 0
reader = csv.reader(f)
for row in reader:
"""if i == 0:
i += 1
continue"""
category = Category(title=row[1], category_id=row[0])
db.session.add(category)
db.session.commit()
