Skip to content

Data Managers

Orieus edited this page Sep 2, 2020 · 1 revision

Module Data management contains set of classes for interaction with databases. Its classes are:

  • BaseDMsql (taken from the dbManager project). A base class providing methods to connect and interact with a mySQL or a SQLite database. Includes read and write methods to and from Pandas Dataframes.
  • DMsql (taken from the dbManager project). A minor extension of BaseDMsql providing a method to print an overall view of a mySQL or a SQLite database.
  • BaseDMneo4j. A base class providing methods to import and export graph data from and to a Neo4J graph database.
  • DMneo4j. A minor extension of BaseDMneo4j providing a method to print an overall view of a graph database.
  • DataManager. A class in charge of data management for the PTL project. It contains methods to read specific data for this project. It uses DMsqjl and DMnew4j objects to interact with the project databases.
  • Statement. A class used by DMneo4j objects for a Neo4j statement.
  • DataLoadingStatement. It extends Statement with methods to load data from csv files into Neo4J.
  • LoadTable. It extends DataLoadingStatement with a method to load a table from a csv file.
  • LoadAttributesTable. It extends DataLoadingStatement with a method to load data from a csv file representing an "attributes" table.
  • LoadJoinTable. It extends DataLoadingStatement with a method to load data from a csv file representing a "join" table.
  • MakeRelationship. It extends DataLoadingStatement with a method to load data from a csv file representing a "relationship" table.
  • UpdateTable. It extends DataLoadingStatement with a method to update an existing table using data from a csv file.

The attributes and methods for these classes (reease v1.0) are shown below. More details can be found in the sphinx-generated documentation.

Clone this wiki locally