[nagare-users:637] print out results to text box using sqlite3

[En Ware]

Does anyone have any examples how to print out records from a sqlite3
database to the nagare app?

[apoirier]

Hi,

To use a database with Nagare you need to activate the database in the
configuration file and define some SQLAlchemy entities in your code.


Here is an example of a persistent 'Counter'.

1. Install the database extension of Nagare

easy_install "nagare[database]"

2. Create the application structure

nagare-admin create-app counter
cd counter
python setup.py counter

3. Configure the database

In the 'conf/counter.cfg' file, set the 'activated' parameter of the
'[database]' section to 'on'.

You can see by default the database is a SQLLite one:

[application]
path = app counter
name = counter
debug = off

[database]
activated = on
uri = sqlite:///$here/../data/counter.db
metadata = counter.models:__metadata__
debug = off

4. Defined your SQLAlchemy entities in the 'counter/models.py' file. Here a
'Counter':

from elixir import *
from sqlalchemy import MetaData
from nagare import presentation

__metadata__ = MetaData()

class Counter(Entity):
name = Field(String)
value = Field(Integer)

def decrease(self):
self.value -= 1

def increase(self):
self.value += 1

@presentation.render_for(Counter)
def render_counter(self, h, *args):
h << h.div(self.value)
with h.div:
h << h.a('--').action(self.decrease)
h << ' | '
h << h.a('++').action(self.increase)

return h.root

5. In the 'counter/app.py' file, code the application to create the counter
with its initial value and to display it:

from nagare import presentation, component

from .models import Counter

class App(object):
def __init__(self):
counter = Counter.get_by(name='MyCounter') # Fetch the counter
if counter is None:
# Create the counter in database
counter = Counter(name='MyCounter', value=0)
counter.flush()

self.counter = component.Component(counter)

@presentation.render_for(App)
def render_app(self, h, *args):
h << h.h1('Counter in database')
h << self.counter

return h.root

app = App

6. Create the database structure. Nagare will discover your SQLAlchemy
entities and create the database tables:

nagare-admin create-db --drop --debug counter

7. Launch the application

nagare-admin serve --reload counter

8. Enjoy!

Post by En Ware
Does anyone have any examples how to print out records from a sqlite3
database to the nagare app?