◈ 오늘도 행복하다.

« 2024/05 »
일	월	화	수	목	금	토
			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31

'전체 글'에 해당되는 글 1011건

2016.03.11 Bottle-Sqlalchemy
2016.03.08 Bottle-SQLite
2016.03.01 tail using Windows command
2015.09.02 2015 제주도 여행 - 최고의 여행
2015.07.17 Andrea Bocelli - MAI PIU' COSI LONTANO

Bottle-Sqlalchemy
日常茶飯事
2016. 3. 11. 21:12
Posted by pantarei

Bottle-Sqlalchemy

https://pypi.python.org/pypi/bottle-sqlalchemy/
https://github.com/iurisilvio/bottle-sqlalchemy

> pip install bottle-sqlalchemy
> python -c "import sqlalchemy; print(sqlalchemy.__version__)"
1.0.12

import bottle
from bottle import route, run, debug, install
from bottle.ext import sqlalchemy
from sqlalchemy import create_engine, Column, Integer, Sequence, String
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()
engine = create_engine('sqlite:///:memory:', echo=True)
plugin = sqlalchemy.Plugin(
    engine
    , Base.metadata
    , keyword='db'
    , create=True
    , commit=True
    , use_kwargs=False
)

#1install(plugin)
app = bottle.Bottle()
app.install(plugin)

class Entity(Base):
    __tablename__ = 'entity'
    id = Column(Integer, Sequence('id_seq'), primary_key=True)
    name = Column(String(50))

def __init__(self, name):
        self.name = name

def __repr__(self):
        return "Entity('%d', '%s')" % (self.id, self.name)

#1@route('/:name')
#2@app.route('/:name')
@app.get('/:name')
def show(name, db):
    print(db)
    entity = db.query(Entity).filter_by(name=name).first()
    if entity:
        return str(entity)
    return "404"

#1@route('/add/:name')
#2@app.route('/add/:name')
@app.get('/add/:name')
def add(name, db):
    entity = Entity(name)
    db.add(entity)
    return "Done"

#1run(debug=True)
app.run()

=-=>초기 데이터는 어떻게 넣나? 초기옵션을 잘 사용하면 될듯

=-=>잘못된 예제

http://www.blog.pythonlibrary.org/2013/07/23/bottle-adding-sqlalchemy-to-the-todo-list-web-app/

https://github.com/mcapielo/Todo-List-Bottle-SQLAlchemy-Bootstrap/blob/master/todo.py