Python PunditDBUtil Exemples

Exemple #1

 def test_processTracerouteSequenceIncremental(self):
     cnx = PunditDBUtil.createConnection()
     PunditDBUtil.resetDB()
     import_sql("../../../tests/db/tracerouteSequence/traceroute.1.sql")
     PunditDBUtil.processTracerouteStaging(cnx)
     import_sql("../../../tests/db/tracerouteSequence/traceroute.2.sql")
     PunditDBUtil.processTracerouteStaging(cnx)
     import_sql("../../../tests/db/tracerouteSequence/traceroute.3.sql")
     PunditDBUtil.processTracerouteStaging(cnx)
     cnx.close
     self.assertEqual(True, True)

Exemple #2

Fichier : TestTracerouteProcessing.py Projet : pundit-project/pundit

 def test_processTracerouteSequenceIncremental(self):
     cnx = PunditDBUtil.createConnection()
     PunditDBUtil.resetDB()
     import_sql("../../../tests/db/tracerouteSequence/traceroute.1.sql")
     PunditDBUtil.processTracerouteStaging(cnx)
     import_sql("../../../tests/db/tracerouteSequence/traceroute.2.sql")
     PunditDBUtil.processTracerouteStaging(cnx)
     import_sql("../../../tests/db/tracerouteSequence/traceroute.3.sql")
     PunditDBUtil.processTracerouteStaging(cnx)
     cnx.close
     self.assertEqual(True, True)

Exemple #3

Fichier : importFromPreviousDB.py Projet : pundit-project/pundit

#!/usr/bin/python

import mysql.connector
import time
from utility import PunditDBUtil

cnx = PunditDBUtil.createConnection()

cursor = cnx.cursor(buffered=True)

importStatusEntries = """INSERT INTO pythia_new.statusStaging SELECT * FROM pythia.status;"""

importTracerouteEntries = """INSERT INTO pythia_new.tracerouteStaging SELECT * FROM pythia.traceroutes;"""

importLocalizationEventEntries = """INSERT INTO pythia_new.localizationEventStaging SELECT * FROM pythia.localization_events;"""

start = time.time();
print "Importing status entries"
cursor.execute("TRUNCATE TABLE pythia_new.statusStaging");
cursor.execute(importStatusEntries);
print "Importing traceroutes entries"
cursor.execute("TRUNCATE TABLE pythia_new.tracerouteStaging");
cursor.execute(importTracerouteEntries);
print "Importing localization_events entries"
cursor.execute("TRUNCATE TABLE pythia_new.localizationEventStaging");
cursor.execute(importLocalizationEventEntries);
cnx.commit();
end = time.time();
print "Done in %s s" %(str(end-start));

Exemple #4

#!/usr/bin/python

import mysql.connector
import time
from utility import PunditDBUtil

cnx = PunditDBUtil.createConnection()

cursor = cnx.cursor(buffered=True)

importStatusEntries = """INSERT INTO pythia_new.statusStaging SELECT * FROM pythia.status;"""

importTracerouteEntries = """INSERT INTO pythia_new.tracerouteStaging SELECT * FROM pythia.traceroutes;"""

importLocalizationEventEntries = """INSERT INTO pythia_new.localizationEventStaging SELECT * FROM pythia.localization_events;"""

start = time.time()
print "Importing status entries"
cursor.execute("TRUNCATE TABLE pythia_new.statusStaging")
cursor.execute(importStatusEntries)
print "Importing traceroutes entries"
cursor.execute("TRUNCATE TABLE pythia_new.tracerouteStaging")
cursor.execute(importTracerouteEntries)
print "Importing localization_events entries"
cursor.execute("TRUNCATE TABLE pythia_new.localizationEventStaging")
cursor.execute(importLocalizationEventEntries)
cnx.commit()
end = time.time()
print "Done in %s s" % (str(end - start))

Exemple #5

#!/usr/bin/python

from utility import PunditDBUtil

cnx = PunditDBUtil.createConnection()
PunditDBUtil.processStatusStaging(cnx)
cnx.commit()

Exemple #6

Fichier : truncateDB.py Projet : pundit-project/pundit

#!/usr/bin/python

import mysql.connector
from utility import PunditDBUtil

cnx = PunditDBUtil.createConnection()
PunditDBUtil.truncateDB(cnx)

Exemple #7

import os
import sys

sys.path.insert(0, '../../lib/PuNDIT/db')
import unittest
import subprocess
from utility import PunditDBUtil
os.chdir('../../lib/PuNDIT/db')

cnx = PunditDBUtil.createConnection()
dbConf = PunditDBUtil.readDBConfiguration()


def import_sql(filename):
    mysqlCommand = "mysql -u " + dbConf["user"]
    if dbConf["password"]:
        mysqlCommand += " -p " + dbConf["password"]
    mysqlCommand += " " + dbConf["database"] + " < "
    mysqlCommand += filename
    subprocess.call(mysqlCommand, shell=True)


class MyTestCase(unittest.TestCase):
    # def test_processTracerouteSequenceAll(self):
    #     cnx = PunditDBUtil.createConnection()
    #     PunditDBUtil.resetDB()
    #     import_sql("../../../tests/db/tracerouteSequence/traceroute.1.sql")
    #     import_sql("../../../tests/db/tracerouteSequence/traceroute.2.sql")
    #     import_sql("../../../tests/db/tracerouteSequence/traceroute.3.sql")
    #     PunditDBUtil.processTracerouteStaging(cnx)
    #     cnx.close

Exemple #8

Fichier : processLocalizationEventStaging.py Projet : pundit-project/pundit

#!/usr/bin/python

import mysql.connector
import time
from utility import PunditDBUtil

cnx = PunditDBUtil.createConnection()
PunditDBUtil.processLocalizationEventStaging(cnx)
cnx.commit()

Exemple #9

#!/usr/bin/python

from utility import PunditDBUtil

cnx = PunditDBUtil.createDB()

Exemple #10

Fichier : TestStatusProcessing.py Projet : pundit-project/pundit

 def test_processStatusSequenceIncremental(self):
     cnx = PunditDBUtil.createConnection()
     PunditDBUtil.resetDB()
     import_sql("../../../tests/db/statusSequence/status.1.sql")
     PunditDBUtil.processStatusStaging(cnx)
     import_sql("../../../tests/db/statusSequence/status.2.sql")
     PunditDBUtil.processStatusStaging(cnx)
     import_sql("../../../tests/db/statusSequence/status.3.sql")
     PunditDBUtil.processStatusStaging(cnx)
     import_sql("../../../tests/db/statusSequence/status.4.sql")
     PunditDBUtil.processStatusStaging(cnx)
     import_sql("../../../tests/db/statusSequence/status.5.sql")
     PunditDBUtil.processStatusStaging(cnx)
     import_sql("../../../tests/db/statusSequence/status.6.sql")
     PunditDBUtil.processStatusStaging(cnx)
     import_sql("../../../tests/db/statusSequence/status.7.sql")
     PunditDBUtil.processStatusStaging(cnx)
     cnx.close
     self.assertEqual(True, True)

Exemple #11

Fichier : TestStatusProcessing.py Projet : pundit-project/pundit

import os
import sys

sys.path.insert(0, '../../lib/PuNDIT/db')
import unittest
import subprocess
from utility import PunditDBUtil
os.chdir('../../lib/PuNDIT/db')

cnx = PunditDBUtil.createConnection()
dbConf = PunditDBUtil.readDBConfiguration()


def import_sql(filename):
    mysqlCommand = "mysql -u " + dbConf["user"]
    if dbConf["password"]:
        mysqlCommand += " -p " + dbConf["password"]
    mysqlCommand += " " + dbConf["database"] + " < "
    mysqlCommand += filename
    subprocess.call(mysqlCommand, shell=True)

class MyTestCase(unittest.TestCase):
    # def test_processStatusSequenceAll(self):
    #     cnx = PunditDBUtil.createConnection()
    #     PunditDBUtil.truncateDB(cnx)
    #     import_sql("../../../tests/db/statusSequence/status.1.sql")
    #     import_sql("../../../tests/db/statusSequence/status.2.sql")
    #     import_sql("../../../tests/db/statusSequence/status.3.sql")
    #     import_sql("../../../tests/db/statusSequence/status.4.sql")
    #     import_sql("../../../tests/db/statusSequence/status.5.sql")
    #     import_sql("../../../tests/db/statusSequence/status.6.sql")

Exemple #12

#!/usr/bin/python

from utility import PunditDBUtil

cnx = PunditDBUtil.createConnection()
PunditDBUtil.processTracerouteStaging(cnx)
cnx.commit()

Exemple #13

#!/usr/bin/python

import mysql.connector
from utility import PunditDBUtil

cnx = PunditDBUtil.createConnection()
PunditDBUtil.regenerateTraceroutePeriod(cnx)
cnx.close

Exemple #14

Fichier : TestStatusProcessing.py Projet : pundit-project/pundit

 def test_processStatusSequenceIncremental(self):
     cnx = PunditDBUtil.createConnection()
     PunditDBUtil.resetDB()
     import_sql("../../../tests/db/statusSequence/status.1.sql")
     PunditDBUtil.processStatusStaging(cnx)
     import_sql("../../../tests/db/statusSequence/status.2.sql")
     PunditDBUtil.processStatusStaging(cnx)
     import_sql("../../../tests/db/statusSequence/status.3.sql")
     PunditDBUtil.processStatusStaging(cnx)
     import_sql("../../../tests/db/statusSequence/status.4.sql")
     PunditDBUtil.processStatusStaging(cnx)
     import_sql("../../../tests/db/statusSequence/status.5.sql")
     PunditDBUtil.processStatusStaging(cnx)
     import_sql("../../../tests/db/statusSequence/status.6.sql")
     PunditDBUtil.processStatusStaging(cnx)
     import_sql("../../../tests/db/statusSequence/status.7.sql")
     PunditDBUtil.processStatusStaging(cnx)
     cnx.close
     self.assertEqual(True, True)