Connecting to a SQL Database in Bottle Using SQLAlchemy

In this video, I'll show you how to connect to a MySQL database using Bottle-SQLAlchemy.

[miguelsarmiento]

wow never I think what has it something best that django, awasome

[farrenzoroqueez]

Do you have a video where pyodbc sends data from MSSQL to an html table with a bottle app?

[mvpontoy]

Hello there, Im using Bash on windows and setup python and pip over there, and I'm trying to connect to mysql database using xampp... how can I do this? thanks in advance

[Nami-rthd]

Hey can you make a login system using bottle and store session ? I know how to make the login. I just can't get the session ? any insight anyone?

[wetellstories]

I installed mysql for python in my windows...now where to create the table...you are accessing the db from internet ?

[looser]

is there a reason you're using @app.get ? instead of @app.route ?

[Robertjebakumar]

When I run this error I receive this error "ImportError: cannot import name login" how to install Login

[muhammadmazhar]

Dear, i am following your tutorial and have stuck at a point here :
i have a table in mysql "user_2"(having 5 columns) and the primary key is " user_2_id "

class user_2(Base):
__tablename__="user_2"
id=column(Integer, primary_key=True) <= at this line
name=column(String)

The error is "TypeError: column has an unexpected keyword argument primary key "

and if i delete this argument (primary key), then the error is " sqlalchemy.exc.ArgumentError : Mapper mapper 'user_2' could not assemble any primary key columns for mapped table user_2"

kindly help me, i have tried almost all the solutions on different websites but all in vain ..