def del_table_query(table_name, year): """ Ejecuta la query sobre una BD para eliminar las tablas para el año dado """ # http://dev.mysql.com/doc/refman/5.0/en/delete.html query = "DROP TABLE IF EXISTS " + table_name + year exec_mysql_query(database, query)
def del_query(table_name):
"""
Ejecuta la query sobre una BD para eliminar los registros
de una tabla y fecha dada
"""
# http://dev.mysql.com/doc/refman/5.0/en/delete.html
query = "DELETE FROM " + table_name + i_date.strftime('%Y') + \
" WHERE day = '" + str(i_date) + "'"
exec_mysql_query(database, query)
def run():
DB_USER = getConfig().get_db_user()
DB_NAME = getConfig().get_db_name('squidlogs')
DB_HOST = getConfig().get_db_host()
query = "DROP DATABASE IF EXISTS " + DB_NAME + ";" + \
"CREATE DATABASE " + DB_NAME + " DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;" + \
"GRANT ALL PRIVILEGES ON `" + DB_NAME + "` . * " + \
"TO '" + DB_USER + "'@'" + DB_HOST + "' WITH GRANT OPTION ;" + \
"GRANT ALL PRIVILEGES ON `" + DB_NAME + "` . * " + \
"TO '" + DB_USER + "'@'%' WITH GRANT OPTION ;"
log_msg2("Limpiando B.D. squidlogs")
log_msg3("Creando BD..")
exec_mysql_query(DB_NAME, query=query)
log_msg_ok3()
log_msg3("Creando tablas..")
exec_mysql_query(DB_NAME, sql_file='squidlogs_tables.sql')
log_msg_ok3()
log_msg_ok2()
