<commit_before># Aquifers app

## Django app under the `gwells` project

This is a distinct app under the GWELLS project, created using the Django command:
`python manage.py startapp aquifers`, and included under this entry in the [settings.py](../gwells/settings/__init__.py#L102) file.  Sub-folders follow the standard Django setup.

## Test data fixture

To facilitate the CodeWithUs effort, we have a sample set of data available in a
[aquifers-sample file](./fixtures/aquifers-sample.json).  It is a subset of the full dataset, and has been sanitized (personal names have been deleted; in fact the entire registries_persons table is not inclued).

'''
python manage.py loaddata aquifers-sample.json 
'''

Output from the above command should be:
```
Installed 35299 object(s) from 1 fixture(s)
```

The following database tables should have these number of rows:
```
psql -d $POSTGRESQL_DATABASE -U $POSTGRESQL_USER

gwells=> select count(*) from well;
 count 
-------
  1010
(1 row)

gwells=> select count(*) from hydraulic_property ;
 count 
-------
    60
(1 row)
<commit_msg>Fixed typo.<commit_after># Aquifers app

## Django app under the `gwells` project

This is a distinct app under the GWELLS project, created using the Django command:
`python manage.py startapp aquifers`, and included under this entry in the [settings.py](../gwells/settings/__init__.py#L102) file.  Sub-folders follow the standard Django setup.

## Test data fixture

To facilitate the CodeWithUs effort, we have a sample set of data available in a
[aquifers-sample file](./fixtures/aquifers-sample.json).  It is a subset of the full dataset, and has been sanitized (personal names have been deleted; in fact the entire registries_persons table is not included).
```
python manage.py loaddata aquifers-sample.json 
```

Output from the above command should be:
```
Installed 35299 object(s) from 1 fixture(s)
```

The following database tables should have these number of rows:
```
psql -d $POSTGRESQL_DATABASE -U $POSTGRESQL_USER

gwells=> select count(*) from well;
 count 
-------
  1010
(1 row)

gwells=> select count(*) from hydraulic_property ;
 count 
-------
    60
(1 row)

{'fraction_non_alphanumeric': 0.09833795013850416, 'fraction_numerical': 0.01569713758079409, 'mean_word_length': 4.184210526315789, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 7, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1184162', 'n_tokens_mistral': 699, 'n_tokens_neox': 652, 'n_words': 277}