Python PunditDBUtil.createConnectionの例

コード例 #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)

コード例 #2

ファイル: TestTracerouteProcessing.py プロジェクト: 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)

コード例 #3

ファイル: TestStatusProcessing.py プロジェクト: 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)

コード例 #4

ファイル: TestStatusProcessing.py プロジェクト: 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)

コード例 #5

ファイル: importFromPreviousDB.py プロジェクト: 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));

コード例 #6

#!/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))