def add_author():
form = AuthorForm(request.form)
if request.method == 'POST' and form.validate():
author = Author(form.name.data)
session.add(author)
session.commit()
return redirect(url_for('index'))
return render_template('author_form.html', form=form, action="/author/add")
def op_create():
session.add(Users(name="alex0", extra='sb'))
session.add_all([
Users(name="alex1", extra='sb'),
Users(name="alex2", extra='sb'),
])
session.commit() # 这里需要commit，不然不提交数据
def add_book():
form = BookForm(request.form)
if request.method == 'POST' and form.validate():
book = Book(form.title.data, form.authors.data)
session.add(book)
session.commit()
return redirect(url_for('index'))
return render_template('book_form.html', form=form, action="/book/add")
def add_book():
form = BookForm(request.form)
if request.method == 'POST' and form.validate():
book = Book(form.title.data, form.author.data)
session.add(book)
session.commit()
return redirect(url_for('index'))
return render_template('book_form.html',
form=form,
action="/book/add",
user_name=current_user.name,
user_picture=current_user.picture,
if_administrator=verify_administrator())
def add_author():
form = AuthorForm(request.form)
if request.method == 'POST' and form.validate():
author = Author(form.name.data)
session.add(author)
session.commit()
return redirect(url_for('index'))
return render_template('author_form.html',
form=form,
action="/author/add",
user_name=current_user.name,
user_picture=current_user.picture,
if_administrator=verify_administrator())
def add_customers():
form = CustomerForm(request.form)
error = None
if form.validate():
customer = Customer(form.first_name.data, form.last_name.data,
form.email.data, form.age.data)
flash('You sucessfully added a new customer!')
session.add(customer)
session.commit()
return redirect(url_for('customers'))
else:
error = "Fields are not filled correctly!"
return render_template('customer_form.html',
form=form,
method="POST",
action="/add",
error=error,
submit_text="Save")
def add_numbers():
form = TargetForm(request.form)
error = None
result = None
if request.method == 'POST':
if form.validate():
target = Target(form.tgt_name.data, form.value_x.data,
form.value_y.data, form.value_z.data)
flash('You sucessfully added a new target!')
session.add(target)
session.commit()
return redirect(url_for('index'))
else:
error = "Fields are not filled correctly!"
return render_template('target_form.html',
form=form,
method="POST",
action="/add",
error=error,
submit_text="Save",
title="ADD NEW")
if msg is None: # No packets on queue sleep(10) else: # Get packet id from the queue packet_id = None try: packet_id = int(msg.get_body()) print "Packet id:", str(packet_id) except: # If the message doesn't contain an integer (i.e someone put something on the queue that doesnt belong there) print "Erroneous msg" delMsg(msg) continue # Get that packet from the database try: packet = session.query(Packet).filter(Packet.id == packet_id).one() except: # Packet has been removed from db since it was added to the queue delMsg(msg) continue # Check if cartype has been added since the packet was enqueued (i.e packet.cartype != None) if packet.cartype is None: # Calculate cartype ctype = packet.getCarType() # if ctype is None that means the data was corrupt and the packet was deleted from db by the call to getCarType() if ctype is not None: session.add(packet) session.commit() delMsg(msg)
def create(**kwargs): kwargs['depart'] = create_date(kwargs['depart']) kwargs['arrive'] = create_date(kwargs['arrive']) r = Route(**kwargs) session.add(r)
