Das deutsche Python-Forum

Code: Alles auswählen

File "x.py", line 17, in my_function
    return Roomtype.get(Roomtype.id == 1).roomtype_de
NameError: global name 'Roomtype' is not defined

Code: Alles auswählen

from bottle import Bottle, route, get, post, request, run, template
from bottle_peewee import PeeweePlugin

app = Bottle()
db = PeeweePlugin('sqlite:///x.db')

@route('/my_function')
def my_function():
	return Roomtype.get(Roomtype.id == 1).roomtype_de

app.install(db)

Code: Alles auswählen

app = Bottle()
db = PeeweePlugin('sqlite:///x.db')

global db

@route('/my_function')
def my_function():
	return db.database.Roomtype.get(Roomtype.id == 1).roomtype_de

app.install(db)

Code: Alles auswählen

import os, sys
from bottle import Bottle
from bottle_peewee import PeeweePlugin
from peewee import Model, ForeignKeyField, CharField, TextField, IntegerField, BooleanField, DateTimeField, DateField, TimeField
import datetime

app = Bottle()
db = PeeweePlugin('sqlite:///x.db')

class BaseModel(Model):
    class Meta:
        database = db.proxy

class Roomtype(BaseModel):
	roomtype_de = CharField(max_length=80)
	roomtype_en = CharField(max_length=80)
	hint_de = CharField(max_length=250)
	hint_en = CharField(max_length=250)

app.install(db)           # unklar: befähigt was?

db.database.create_tables([Roomtype])

roomtypes = [
    {'roomtype_de': 'bla'},
    {'roomtype_de': 'bla'},
]

with db.database.atomic():
    Roomtype.insert_many(roomtypes).execute()