import pandas as pd
import mysql.connector
from datetime import datetime

def print_infos(name, df):
    print("================================================", name)
    print(df.shape)
    print(df.head())
    print(df.info())

def chercher_data_dans_base() :
    my_connect = mysql.connector.connect(
      host="185.124.202.119",
      user="djamchid",
      passwd="Diampark ss 2020",
      database="admin_typing"
    )

    ####### end of connection ####
    my_data = pd.read_sql("SELECT * FROM `DiamPark_Appli_Android`",my_connect)
    '''
    for i in range (len(my_data["Fichier_de_sortie"])) :
        my_data["Fichier_de_sortie"][i]=my_data["Fichier_de_sortie"][i][:64] 
    '''
    my_data["Fichier_de_sortie"] = my_data["Fichier_de_sortie"].apply(lambda x:x[:64])
    print_infos("table DiamPark_Appli_Android", my_data)
    date_time = datetime.now().strftime("%m-%d-%Y") # current date and time
    print("DiamPark_Appli_Android"+date_time+".csv")
    my_data.to_csv("DiamPark_Appli_Android_tronquee-"+date_time+".csv", index=None)

chercher_data_dans_base()