48 lines
1.0 KiB
Python
Executable File
48 lines
1.0 KiB
Python
Executable File
#!/usr/bin/python3
|
|
|
|
import os
|
|
import sys
|
|
sys.path.insert(0, os.path.abspath(os.path.dirname(__file__) + '/' + '..'))
|
|
|
|
from ffmap.mysqltools import FreifunkMySQL
|
|
|
|
import pymongo
|
|
from bson.json_util import dumps as bson2json
|
|
from bson.objectid import ObjectId
|
|
import base64
|
|
import datetime
|
|
|
|
import csv
|
|
|
|
targetfile = "/data/fff/users.txt"
|
|
|
|
mysql = FreifunkMySQL()
|
|
data = []
|
|
with open(targetfile, newline='') as csvfile:
|
|
spamreader = csv.reader(csvfile, delimiter=';')
|
|
for row in spamreader:
|
|
if row[5]=="None":
|
|
row[5]=None
|
|
if row[1]=="None":
|
|
row[1]=None
|
|
if row[1]=="None":
|
|
row[1]=None
|
|
if row[2]=="None":
|
|
row[2]=None
|
|
if row[3]=="None":
|
|
row[3]=None
|
|
if row[4]=="True":
|
|
row[4]=1
|
|
else:
|
|
row[4]=0
|
|
row[3] = datetime.datetime.strptime(''.join(row[3].rsplit(':', 1)),"%Y-%m-%d %H:%M:%S.%f%z").strftime('%Y-%m-%d %H:%M:%S')
|
|
|
|
data.append((row[0],row[5],row[1],row[2],row[3],row[4],))
|
|
|
|
mysql.executemany("""
|
|
INSERT INTO users (nickname, password, token, email, created, admin)
|
|
VALUES (%s, %s, %s, %s, %s, %s)
|
|
""",data)
|
|
mysql.commit()
|
|
mysql.close()
|