Leaks2db3
Simple python parser for 2021/04 facebook leaks csv files to sqlite3 databases
Install / Use
/learn @synth3sis/Leaks2db3README
leaks2sqlite3
leaks2sqlite3 is a simple python3 parser to import 03/04/2021 published facebook leaks, from a csv to a SQLite3 DB. <br> The script automatically goes past the malformed csv lines and creates indexes for phone numbers, names, surnames, facebook_id.
<br>REQUIREMENTS
- python3
- sqlite3
apt install -y python3
apt install -y sqlite3
RUN
Change the informations in the first 2 assignment and simply run
./leakrecord.py
IMPORTANT
Before you run leakrecord.py you must adjust the csv file because is full of "12:00:00" strings which are inteded to represent time, while the csv delimiter is the character ":". <br>
Proved replace method:
sed -i 's^12:00:00^12.00.00^g' your_filelist.csv
PoC
With bash grep:
<br>
<br>
<br>
<br>
With sqlite3 query:
<br>
<br>
