File size: 2,937 Bytes
0b4e916 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 |
from caesarsql import CaesarSQL
import pandas as pd
import os
import shutil
def insert_data():
# Insert Data into Table resume
for ind,candidate in enumerate(names):
data_exists = caesarsql.run_command(f"SELECT name FROM {table} WHERE name LIKE '{candidate}'",caesarsql.check_exists)
if not data_exists:
amarilogo = caesarsql.convert_to_blob(f"Logos/{logos[ind]}")
amaricv = caesarsql.convert_to_blob(f"Humans/{humans[ind]}")
resumetuple = (candidate,amarilogo,amaricv)
caesarsql.run_command(f"INSERT INTO {table} (name,photo,resume) VALUES (%s,%s,%s)",datatuple=resumetuple)
print("resume inserted.")
if __name__ == "__main__":
#allnames = pd.read_csv("brazilian-names.csv")
names = ['Issa', 'Midas', 'Adalvina', 'Euquenor', 'Celimena', 'Poguira', 'Munir', 'Corina', 'Vismara', 'Tristão', 'Baraúna', 'Pandora', 'Náiade', 'Salatiel', 'Jênie', 'Pasini', 'Acalântis', 'Platâo', 'Xanthe', 'Bretãs', 'Branka', 'Marina', 'Moke', 'Natacha', 'Saladino', 'Silvana', 'Libânia', 'Fedro', 'Tito', 'Bosco', 'Barac', 'Abdera', 'Daltivo', 'Elvira', 'Iodâmia', 'Jacina', 'Carmem', 'Osni', 'Metanira', 'Afrodísio', 'Lindoia', 'Abner', 'Samir', 'Ramão', 'Agabo', 'Norina', 'Inandê', 'Zebilon', 'Solveig', 'Telêmaco', 'Fauno', 'Aranha', 'Holda', 'Alan', 'Marisa', 'Apolínio', 'Alexandre', 'Keike', 'Haskel', 'Cinara', 'Sátiro', 'Vincent', 'Epicasta', 'Odélio', 'Karolina', 'Alex', 'Wolf', 'Arthur', 'Dona', 'Faros', 'Santoro', 'Nery', 'Fernandes', 'Partênope', 'Faetonte', 'Caron', 'Angerona', 'Fenaio', 'Mandi', 'Amapola', 'Kauê', 'Seth', 'Dimitre', 'Astêmio', 'Ira', 'Kanela', 'Onã', 'Almirante', 'Carol', 'Cezar', 'Adina', 'Beoto', 'Ida', 'Tecobiara', 'Urbano', 'Aritana', 'Solange', 'Górki', 'Apolline', 'Oberon']
logos = os.listdir("Logos")
humans = os.listdir("Humans")[:100]
db = "resumebase"
table = "resumes"
caesarsql = CaesarSQL()
# Create Database
db_exists = caesarsql.run_command(f"SHOW DATABASES LIKE '{db}';",caesarsql.check_exists)
if not db_exists:
caesarsql.run_command(f"CREATE DATABASE {db};")
caesarsql.run_command(f"USE {db};")
# Create Table resume
table_exists = caesarsql.run_command(f"SHOW TABLES LIKE '{table}';",caesarsql.check_exists)
if not table_exists:
caesarsql.run_command(f"CREATE TABLE {table} (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100), photo BLOB,resume MEDIUMBLOB)")
candidate = "Amari Lawal Again"
newcandidate = "Amari Lawal"
data_exists = caesarsql.run_command(f"SELECT name FROM {table} WHERE name LIKE '{newcandidate}'",caesarsql.check_exists)
if data_exists:
result = caesarsql.run_command(f"SELECT name from {table} WHERE name LIKE '{newcandidate}'",caesarsql.fetch)
print(result)
#caesarsql.run_command(f"UPDATE {table} SET name='{newcandidate}' WHERE name LIKE '{candidate}'")
#print("table update.")
|