search

center-for-cyber-intelligence / CollectionOneProcessor

A Python script to process the data contained in the Collection #1 Dump
https://centerforcyberintelligence.org/collection-one-dump
1 stars 0 forks source link

Develop MySQL Connector #1

Open Azlirn opened 5 years ago

Azlirn commented 5 years ago

Currently this code lacks the ability to push the results of processing efforts into a MySQL database.

ankitjavalkar commented 5 years ago

Is it possible for you to describe the Tables Structure and Schema here? We can use an ORM such as SQLAlchemy to easily generate a DB, connect to it and carry out CRUD operations.

Azlirn commented 5 years ago

The current Table Structure and Schema is attached to this repo. Issue #3 addresses the need to update the current Table Structure and Schema to match the current code output. Our first iteration of this project used mysql.connector to handle connections and commands to the MySQL database. Feel free to use another library if that is what you are familiar with.