class TestReplicationMaster(unittest.TestCase): def setUp(self): self.db = DBConnection() def test_create_new_data(self): # create new table self.db.conn.autocommit = True with self.db.cursor() as c: c.execute(""" CREATE TABLE IF NOT EXISTS test_replication_table ( id integer not null constraint pkey primary key, geom geometry(Point, 4326), name varchar(30), alias varchar(30), description varchar(255) ); """) c.execute(""" INSERT INTO test_replication_table (id, geom, name, alias, description) VALUES ( 1, st_setsrid(st_point(107.6097, 6.9120), 4326), 'Bandung', 'Paris van Java', 'Asia-Africa conference was held here' ) ON CONFLICT DO NOTHING; """)
class TestReplicationNode(unittest.TestCase): def setUp(self): self.db = DBConnection() def test_read_data(self): # create new table self.db.conn.autocommit = True with self.db.cursor() as c: c.execute(""" SELECT * FROM test_replication_table; """) rows = c.fetchall() self.assertEqual(len(rows), 1)
def setUp(self): self.db = DBConnection()
from os import environ from tkinter import Tk from dotenv import load_dotenv from patenteSQL import ExamRawData from gui.gui import Patente from utils.utils import Consts from utils.utils import ( DBConnection, ) load_dotenv() db = DBConnection( host=environ.get("HOST"), db_name=environ.get("DATABASE_NAME"), user=environ.get("MYSQL_USER"), password=environ.get("PASSWORD"), ) if __name__ == "__main__": erd = ExamRawData(db, Consts) df = erd.df root = Tk() gui = Patente(root, df) root.mainloop() # ls | grep -P "^[0-9]+.png" | xargs -d"\n" rm
from os import environ from dotenv import load_dotenv from utils.utils import DBConnection load_dotenv() db = DBConnection( host=environ.get("HOST"), db_name=environ.get("DATABASE_NAME"), user=environ.get("MYSQL_USER"), password=environ.get("PASSWORD"), ) db.create_connection() db.delete_db("test_db") db.close_connection()