◈ 'Bottle Sub application' 태그의 글 목록

My Link

지원이랑

Notice

Calender

« 2024/12 »
일	월	화	수	목	금	토
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

'Bottle Sub application'에 해당되는 글 1건

2016.03.11 Bottle-Sqlalchemy

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

저작자표시 비영리 변경금지

▲ 1 ▼

오늘도 행복하다.

Category

Recent Article

Recent comment

My Link

Notice

Tag Cloud

Calender

Archive

'Bottle Sub application'에 해당되는 글 1건

Bottle-Sqlalchemy

티스토리툴바