Sample Application

tutorial

Discover how to program interactions with the Couchbase Server via the data, query, and search services — using the Travel Sample Application with the built-in Travel Sample data Bucket. This version demonstrates various features of Couchbase, including the Collections feature new in Server 7.0.

Quick Start

Fetch the Couchbase Python SDK travel-sample Application REST Backend from github:

git clone https://github.com/couchbaselabs/try-cb-python.git
cd try-cb-python

With Docker installed, you should now be able to run a bare-bones copy of Couchbase Server, load the travel-sample, add indexes, install the sample-application and its frontend, all by running a single command:

docker-compose up

Running the code against your own development Couchbase server.

For Couchbase Server 7.1, make sure that you have at least one node each of data; query; index; and search. For a development box, mixing more than one of these on a single node (given enough memory resources) is perfectly acceptable.

If you have yet to install Couchbase Server in your development environment start here.

Then load up the Travel Sample Bucket, using either the Web interface or the command line. You will also need to create a Search Index — Query indexes are taken care of by the Sample Bucket.

See the README at https://github.com/couchbaselabs/try-cb-python for full details of how to run and tweak the Python SDK travel-sample app.

Using the Sample App

Give yourself a username and password and click Register.

Now try out a few queries, and see Search in action for the hotel finder feature.

Sample App Backend

The backend code shows Couchbase Python SDK in action with Query and Search, but also how to plug together all of the elements and build an application with Couchbase Server and the Python SDK.

Here’s the airport search code, which checks to see whether the search term for the query string is a three or four letter FAA or ICAO abbreviation, and if not searches for it as an airport name:

def findall(self):
    """Returns list of matching airports and the source query"""
    querystr = request.args['search']
    queryprep = "SELECT airportname FROM `travel-sample` WHERE "
    sameCase = querystr == querystr.lower() or querystr == querystr.upper()
    if sameCase and len(querystr) == 3:
        queryprep += "faa=$1"
        queryargs = [querystr.upper()]
    elif sameCase and len(querystr) == 4:
        queryprep += "icao=$1"
        queryargs = [querystr.upper()]
    else:
        queryprep += "POSITION(LOWER(airportname), $1) = 0"
        queryargs = [querystr.lower()]

    res = cluster.query(queryprep, *queryargs)
    airportslist = [x for x in res]
    context = [queryprep]
    response = make_response(
        jsonify({"data": airportslist, "context": context}))
    return response

The travel.py file also contains the functions for handling users, registration, and SQL++ queries.

Data Model

See the Travel App Data Model reference page for more information about the sample data set used.

REST API

You can explore the REST API here in read-only mode, or once you are running the application, at the /apidocs endpoint.