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()