Das deutsche Python-Forum

Code: Alles auswählen

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

app = Bottle()
# db = PeeweePlugin('sqlite:///test.db')
db = SqliteDatabase('sqlite:///test.db')

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

class Country(BaseModel):
	iso_code = CharField(max_length=3)
	name = CharField(max_length=100)

# Create an engine that stores data in the local directory's db file
app.install(db)

# db.database.create_tables([Country])
db.database.create_tables([Country])

Code: Alles auswählen

Traceback (most recent call last):
  File "x.py", line 105, in <module>
    app.install(db)
  File "/home/nuc/Dropbox/x/venv/lib/python2.7/site-packages/bottle.py", line 715, in install
    raise TypeError("Plugins must be callable or implement .apply()")
TypeError: Plugins must be callable or implement .apply()

Code: Alles auswählen

Traceback (most recent call last):
  File "x.py", line 108, in <module>
    db.database.create_tables([Country 
AttributeError: 'str' object has no attribute 'create_tables'

Code: Alles auswählen

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

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

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

class Country(BaseModel):
	iso_code = CharField(max_length=3)
	name = CharField(max_length=100)

# Create an engine that stores data in the local directory's db file
#app.install(db)
db.connect()

# db.database.create_tables([Country])
db.create_tables([Country])

Code: Alles auswählen

          #!/usr/bin/python
          # -*- coding: utf-8 -*-
          import os, sys

Code: Alles auswählen

#!/usr/bin/python
# -*- coding: utf-8 -*-
import os, sys

Code: Alles auswählen

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

@route('/test')
def test():
    for room in Roomtype.select():
        print room

app.install(db)

if __name__ == '__main__':
    run(host='localhost', port=8080, debug=True, reloader=True)