from flask import Flask, render_template, request
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///students.db'
db = SQLAlchemy(app)
class Student(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50), nullable=False)
room_number = db.Column(db.String(10), nullable=False)
@app.route('/')
def index():
students = Student.query.all()
return render_template('index.html', students=students)
if __name__ == '__main__':
db.create_all()
app.run(debug=True)
]]>
@app.route('/add', methods=['GET', 'POST'])
def add_student():
if request.method == 'POST':
new_student = Student(name=request.form['name'], room_number=request.form['room_number'])
db.session.add(new_student)
db.session.commit()
return redirect('/')
return render_template('add.html')
]]>
from moviepy.editor import VideoFileClip, concatenate_videoclips
clip1 = VideoFileClip("dorm_video1.mp4")
clip2 = VideoFileClip("dorm_video2.mp4")
final_clip = concatenate_videoclips([clip1, clip2])
final_clip.write_videofile("student_dorm.mp4", fps=24)
]]>