<jupyter_start><jupyter_text>Add the path of modules of the project to sys<jupyter_code>import os
import sys

module_path = os.path.abspath(os.path.join('..'))
if module_path not in sys.path:
    sys.path.append(module_path)<jupyter_output><empty_output><jupyter_text>Import necessary libraries<jupyter_code>import pathlib

from Formats.REPFile import REPFile
from Store.DataStoreModule import DataStore
from Resolvers.CommandLineResolver import CommandLineResolver<jupyter_output><empty_output><jupyter_text>Declaring global variables<jupyter_code>RESOURCES_PATH = os.path.join('..', 'Resources')

data_store = DataStore("", "", "", 0, "sqlite_datastore.db", db_type='sqlite',
                      missing_data_resolver=CommandLineResolver())

file_path = os.path.join(RESOURCES_PATH, "missing_platform.rep")
rep = REPFile(str(file_path))
with data_store.session_scope() as session:
    datafile = session.addToDatafilesFromREPL(rep.getDatafileName(), rep.getDatafileType())
    for repLine in rep.getLines():
        platform = session.addToPlatformsFromREPL(repLine.getPlatform())
        sensor = session.addToSensors("GPS", platform)
        session.addToStatesFromREPL(repLine.getTimestamp(), datafile, sensor, repLine.getLatitude(), repLine.getLongitude(), repLine.getHeading(), repLine.getSpeed())<jupyter_output>Ok, please provide classification for table 'Datafiles': 
   1) Add a new classification
   2) Cancel import
1
Please type name of new classification: Private
Platform 'SUBJECT' not found. Do you wish to: 
   1) Add a new platform, titled 'SUBJECT'
   2) Cancel import
1
Ok, adding new platform.
Please provide nationality: 
   1) Add a new nationality
   2) Cancel import
1
Please type name of new nationality: FRANCE
Ok, please provide class: 
   1) Add a new class
   2) Cancel import
1
Please type name of new class: Swan
No sensors found for that class. Skipping Sensor add
Ok, please provide classification for this platform: 
   1) Private
   2) Add a new classification
   3) Cancel import
1
Input complete. About to create this platform:
Name: SUBJECT
Nationality: FRANCE
Class: Swan
Sensors: None
Classification: Private
Create this platform?: 
   1) Yes
   2) No, make further edits
   3) Cancel import
1
Sensor 'GPS' not found. Do you wish to: 
   1) Add a new sensor, titled 'GPS'
   2) [...]
{'fraction_non_alphanumeric': 0.09153416415986249, 'fraction_numerical': 0.009883970777825527, 'mean_word_length': 4.791044776119403, 'pattern_counts': {'":': 0, '<': 12, '<?xml version=': 0, '>': 12, '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}}
{'chain_length': '3', 'dir': 'jupyter-structured-clean-dedup', 'id': '190869', 'license': 'Apache-2.0', 'n_tokens_mistral': 734, 'n_tokens_neox': 714, 'n_words': 232, 'path': 'jupyter/DataStore_sqliteExperiment.ipynb', 'repo_name': 'debrief/python-import-library', 'size': '2327'}