mergeTriviaQueues.py

from app import app, db
from app.models import Queue

questions = Queue.query.get(15).images.all()
answers = Queue.query.get(16).images.all()

print("# of questions: {}".format(len(questions)))
print("# of answers: {}".format(len(answers)))

trivia = Queue("trivia")
db.session.add(trivia)
db.session.commit()

both = []
for image in questions:
  both.append(image)
for image in answers:
  both.append(image)

count = 0

for image in both:
  image.queue_id = trivia.id
  image.position = count
  db.session.add(image)
  count += 1

db.session.commit()
print("new trivia queue created")