def setUp(self):
self.app = create_app('testing')
self.app_context = self.app.app_context()
self.app_context.push()
db.create_all()
Tag.insert_test_tags()
Corso.insert_test_corsi()
Serata.insert_test_serate()
self.client = self.app.test_client()
def setUp(self):
self.app = create_app('testing')
self.app_context = self.app.app_context()
self.app_context.push()
db.create_all()
Tag.insert_test_tags()
self.client = self.app.test_client()
#self.client = self.app.test_client(use_cookies=True)
'''
def setUp(self):
db.create_all()
user1 = User("Elie", "Schoppik")
user2 = User("Tim", "Garcia")
user3 = User("Matt", "Lane")
db.session.add_all([user1, user2, user3])
message1 = Message("Hello Elie!!", 1)
message2 = Message("Goodbye Elie!!", 1)
message3 = Message("Hello Tim!!", 2)
message4 = Message("Goodbye Tim!!", 2)
db.session.add_all([message1, message2, message3, message4])
tag1 = Tag("Greeting")
tag2 = Tag("Valediction")
db.session.add_all([tag1, tag2])
message1.tags.extend([tag1])
message2.tags.extend([tag2])
message3.tags.extend([tag1])
message4.tags.extend([tag2])
db.session.commit()
def tags():
if request.method == "POST":
form = TagForm(request.form)
if form.validate():
new_tag = Tag(request.form["name"])
db.session.add(new_tag)
db.session.commit()
flash("Tag Created!")
else:
flash("Form Error: Tag Not Created")
return render_template('tags/new.html', form=form)
return render_template('tags/index.html', tags=Tag.query.all())
def tags():
# Ordinamento alfabetico ascendente per "name"
lista_tags = Tag.query.order_by(asc(Tag.name)).all()
'''
Crea nuovo tag
'''
form = TagForm()
if form.validate_on_submit():
tag_name = form.name.data
n_tag = Tag(tag_name)
db.session.add(n_tag)
form.name.data = ""
try:
db.session.commit()
flash('Tag creato correttamente', 'success')
return redirect(url_for('tags.tags'))
except Exception as e:
db.session.rollback()
flash("Errore durante la creazione del tag: %s" % str(e), 'danger')
return render_template('tags_lista.html', form=form, lista_tags=lista_tags)
def create_test_db():
print("Start creating test db")
FLASK_CONFIG = os.getenv("FLASK_CONFIG", "None")
app = create_app(FLASK_CONFIG)
app_context = app.app_context()
app_context.push()
from project.serate.models import Serata
from project.corsi.models import Corso
from project.tags.models import Tag
from project.ruoli.models import Ruolo
from project.utenti.models import Utente
from project.blog.models import Post
from project.commenti.models import Comment
from random import randint
from faker import Faker
try:
user_list = Utente.query.all()
course_list = Corso.query.all()
post_list = Post.query.all()
comment_list = Comment.query.all()
post_list = Post.query.all()
ruolo_list = Ruolo.query.all()
print("DB Tables already exists")
except Exception as message:
print(f"No db data exist, inserting them:")
def users(count=100):
fake = Faker("it_IT")
i = 0
while i < count:
u = Utente(
email=fake.email(),
username=fake.user_name(),
password="******",
confirmed=True,
name=fake.name(),
location=fake.city(),
about_me=fake.text(),
member_since=fake.past_date(),
)
db.session.add(u)
try:
db.session.commit()
i += 1
except IntegrityError:
db.session.rollback()
def posts(count=100):
fake = Faker("it_IT")
user_count = Utente.query.count()
for i in range(count):
u = Utente.query.offset(randint(0, user_count - 1)).first()
p = Post(body=fake.text(),
timestamp=fake.past_date(),
author=u)
db.session.add(p)
db.session.commit()
def comments(count=100):
fake = Faker("it_IT")
user_count = Utente.query.count()
post_count = Post.query.count()
for i in range(count):
u = Utente.query.offset(randint(0, user_count - 1)).first()
p = Post.query.offset(randint(0, post_count - 1)).first()
c = Comment(body=fake.text(),
timestamp=fake.past_date(),
post=p,
author=u)
db.session.add(c)
db.session.commit()
print("Creating structure")
db.create_all()
db.session.commit()
print("Creating roles")
Ruolo.insert_roles()
print("Creating fake users")
users(2)
print("Creating test users")
Utente.insert_test_users()
print("Creating tags")
Tag.insert_test_tags()
print("Creating corsi")
Corso.insert_test_corsi()
print("Creating serate")
Serata.insert_test_serate()
print("Creating posts fake")
posts(3)
print("Creating commenti fake")
comments(3)
print("\nDB Dummy data inserted succesfully")
db.session.remove()
app_context.pop()
app_context = app.app_context()
app_context.push()
print("Creating structure")
db.create_all()
print("Creating roles")
Ruolo.insert_roles()
print("Creating fake users")
users(20)
print("Creating test users")
Utente.insert_test_users()
print("Creating tags")
Tag.insert_test_tags()
print("Creating corsi")
Corso.insert_test_corsi()
print("Creating serate")
Serata.insert_test_serate()
print("Creating posts fake")
posts()
print("Creating commenti fake")
comments()
###DEBUGS
print("\n#### DATA DEBUG ####\n")
import os
CREATE_ALL = True
#db.metadata.clear()
if CREATE_ALL:
# Create entities
db.create_all()
print("Start creating structure")
#################################################
####### 1. Create tags #######
print("Start creating tags")
t1 = Tag("Python")
t2 = Tag("Flask")
t3 = Tag("Pygame")
t4 = Tag("SqlAlchemy")
t5 = Tag("Web Development")
t6 = Tag("Graphics")
t7 = Tag("NumPy")
t8 = Tag("Pandas")
tags = [t1, t2, t3, t4, t5, t6, t7, t8]
for t in tags:
try:
db.session.add(t)
db.session.commit()
except Exception as e:
