Metadata-Version: 2.1
Name: acondbs
Version: 0.2.0
Summary: A GraphQL server for product DB
Home-page: https://github.com/simonsobs/acondbs
Author: Simons Observatory
Author-email: so_software@simonsobservatory.org
License: UNKNOWN
Platform: UNKNOWN
Classifier: Development Status :: 3 - Alpha
Classifier: Intended Audience :: Science/Research
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python :: 3.6
Classifier: Programming Language :: Python :: 3.7
Classifier: Programming Language :: Python :: 3.8
Description-Content-Type: text/markdown
Requires-Dist: Flask (>=1.1)
Requires-Dist: Flask-Cors (>=3.0)
Requires-Dist: Flask-GraphQL (>=2.0)
Requires-Dist: Flask-Migrate (>=2.5)
Requires-Dist: Flask-SQLAlchemy (>=2.4)
Requires-Dist: graphene-sqlalchemy (>=2.2)
Requires-Dist: gitpython (>=3.1)
Provides-Extra: tests
Requires-Dist: pytest (>-5.4) ; extra == 'tests'
Requires-Dist: pytest-cov (>=2.8) ; extra == 'tests'
Requires-Dist: snapshottest (>0.5) ; extra == 'tests'

[![PyPI version](https://badge.fury.io/py/acondbs.svg)](https://badge.fury.io/py/acondbs) [![Build Status](https://travis-ci.org/simonsobs/acondbs.svg?branch=master)](https://travis-ci.org/simonsobs/acondbs) [![codecov](https://codecov.io/gh/simonsobs/acondbs/branch/master/graph/badge.svg)](https://codecov.io/gh/simonsobs/acondbs)

# Acondbs

A GraphQL server for product DB

## How to check out and run (for developers)

### Check out

Check out Acondbs from GitHub, create and enter a virtual environment, and install Acondbs in the editable mode.

```bash
git clone git@github.com:simonsobs/acondbs.git
cd acondbs
python -m venv venv
source venv/bin/activate
pip install --upgrade pip
pip install -e  '.[tests]'
```

### Create an instance folder

Create an instance folder of Flask, where the config file and the SQLite DB file are stored. Check out an example instance folder from GitHub

```bash
git clone git@github.com:TaiSakuma/acondbs-instance-example.git instance
```

### Set environmental variables

```bash
export FLASK_APP="acondbs:create_app('$PWD/instance/config.py')"
export FLASK_ENV=development
```

### Initialize database

```bash
flask init-db
```

An SQLite DB file has been created in the instance folder (`instance/product.sqlite3`). Tables were defined (The tables were empty. Only fields were defined. No data were inserted in the tables).

### Load sample data to DB (optional)

(Optional) Load sample data to the dababase.

```bash
flask import-csv tests/sample/csv/
```

### Run

Run with the Flask built-in server for the development. (Deployment options for proudction are descriped in the [Flask documentation](https://flask.palletsprojects.com/en/1.1.x/deploying/).)

```bash
flask run
```

The above command starts the built-in server that only allows accress from localhost. It starts the server at the default TCP port, usually `5000`.

To allow the access from outside, use `--host=0.0.0.0` option. The TCP port can be specified by `--port` option. For example:

```bash
flask run --host=0.0.0.0 --port=5000
```

#### Access to the server with cURL

Now, you can send GraphQL requests to the server, for example, as follows.

```bash
curl -d "query={allMaps { edges { node { name mapper } } }}" localhost:5000/graphql
```

#### Access to the server with a web browser

If you access to the server with a web browser, it will show a graphical user interface *GraphiQL*: <http://localhost:5000/graphql>

### Unit test

Run the unit tests

```bash
pytest
```

Run the unit tests with coverage

```bash
pytest --cov
```

Generate the coverage report

```bash
coverage html
```

The report can be found at `coverage_html_report/index.html`.


