Question

I m试图利用flask和sqlite开发一个网页。使用<代码>sqlalchemy与db I m通信。

在我下面的《守则》中,我制定了全球教育体系方法,将所有数据检索到一个具体表格中,以便:

from flask import Flask, g, Response, request, jsonify, abort
from flask_restful import Resource, Api
from sqlalchemy import create_engine
from flask.ext.restless import APIManager
from flask.ext.sqlalchemy import SQLAlchemy
from json import dumps
import sqlite3
import json


app = Flask(__name__)
app.config["SQLALCHEMY_DATABASE_URI"] = "sqlite:///climb.db"
db = SQLAlchemy(app)

class falesie(db.Model):
    __tablename__ =  falesie 
    id = db.Column(db.Integer, primary_key=True)
    regione = db.Column(db.String(20))
    citta = db.Column(db.String(20))
    n_settori = db.Column(db.Integer)
    lat = db.Column(db.Float)
    lon = db.Column(db.Float)

    def __init__(self, regione, citta, n_settori, lat, lon):
      self.regione = regione
      self.citta = citta
      self.n_settori= n_settori
      self.lat = lat
      self.lon = lon

@app.route( /dev , methods = [ GET ])
def get_falesie():
    Falesie = falesie.query.all()
    formatted_falesie = []
    for f in Falesie:
        formatted_falesie.append({
         id : f.id,
         regione : f.regione,
         citta : f.citta,
         n_settori : f.n_settori,
         lat : f.lat,
         lon : f.lon})
    return json.dumps({ Falesie : formatted_falesie}), 200, { Content-  Type :  application/json }


if __name__ == "__main__":
    db.create_all()
    app.run(debug=True)

我愿建立<代码>GET方法,以检索具有特定价值的具体记录,例如:

@app.route( dev/<string:name> )
def get_data(name):

我不知道如何检索单一记录。任何帮助?

Answer 1

这将有助于取得<代码>falesie的单一结果:

try:
    user = session.query(falesie).filter(name=name).one()  # filter on name
except MultipleResultsFound, e:
    print e
    # Deal with it
except NoResultFound, e:
    print e
    # Deal with that as well

session 具体如下:

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker

# an Engine, which the Session will use for connection resources
engine = create_engine( sqlite:///climb.db )

# create a configured "Session" class
Session = sessionmaker(bind=engine)

# create a Session
session = Session()

见rel=“noreferer”>SQLAlchemy。

Answer 2

If you read the tutorial, you ll see that you can filter your query. Something like this should be what you want:

falesie.query().filter_by(id=name).first()

Answer 3

问题很老,但另一种技术可以帮助有问题的其他人。

def load_user(id):
    falesie.query.get(int(id))

Answer 4

For those now here looking for a way with SQLAlchemy 2.0--you can use this method (get_one()):

from sqlalchemy.orm import Session
from sqlalchemy.orm.exc import NoResultFound

# create your session

try:
    obj = session.get_one(YourDbModel, pk_id)
except NoResultFound:
    # handle

友情链接