logging.info("** starting new OMS migration: "+str(datetime.datetime.now())+" **")
""" establish multiple database connections (for old and new handbook db)
(loosely) following recipe at: http://elixir.ematia.de/trac/wiki/Recipes/MultipleDatabases
"""
old_engine = create_engine("mysql://*****:*****@localhost:3306/dbo")
old_session = scoped_session(sessionmaker(autoflush=True, bind=old_engine))
old_metadata = metadata
old_metadata.bind = old_engine
new_engine = create_engine("mysql://*****:*****@localhost:3306/newhandbook")
new_session = scoped_session(sessionmaker(autoflush=True, bind=new_engine))
new_metadata = ThreadLocalMetaData()
new_metadata.bind = new_engine
""" MODEL DATA """
# old
class Distributorship(Entity):
""" dbo/distributorship """
using_options(metadata=old_metadata, session=old_session, tablename="distributorship", autoload=True)
class DistributorshipUserInRole(Entity):
""" dbo/distributorshipuserinrole """
using_options(metadata=old_metadata, session=old_session, tablename="distributorshipuserinrole", autoload=True)
class DistributorshipZipCode(Entity):
""" dbo/distributorzipcode """
using_options(metadata=old_metadata, session=old_session, tablename="distributorshipzipcode", autoload=True)
precdir = os.path.realpath(os.curdir)
os.chdir(os.path.dirname(__file__))
import ConfigParser
config = ConfigParser.RawConfigParser()
config.optionxform = str
config.read("../../etc/bgp-ranking.conf")
login = config.get('mysql','login')
password = config.get('mysql','password')
host = config.get('mysql','hostname')
dbname = config.get('mysql','dbname_ranking')
os.chdir(precdir)
ranking_engine = create_engine( 'mysql://' + login + ':' + password + '@' + host + '/' + dbname, pool_size = 50, pool_recycle=3600, max_overflow=30 )
RankingSession = scoped_session(sessionmaker(bind=ranking_engine))
ranking_metadata = ThreadLocalMetaData()
ranking_metadata.bind = ranking_engine
import datetime
INET6_ADDRSTRLEN = 46
class IPs(Entity):
"""
Table which contains the IPs
"""
ip = Field(Unicode(INET6_ADDRSTRLEN), primary_key=True)
ip_descriptions = OneToMany('IPsDescriptions')
using_options(metadata=ranking_metadata, session=RankingSession, tablename='IPs')
def __repr__(self):
return 'IP: "%s"' % (self.ip)
precdir = os.path.realpath(os.curdir)
os.chdir(os.path.dirname(__file__))
import ConfigParser
config = ConfigParser.RawConfigParser()
config.optionxform = str
config.read("../../etc/bgp-ranking.conf")
login = config.get('mysql','login')
password = config.get('mysql','password')
host = config.get('mysql','hostname')
dbname = config.get('mysql','dbname_whois')
os.chdir(precdir)
whois_engine = create_engine( 'mysql://' + login + ':' + password + '@' + host + '/' + dbname )
WhoisSession = scoped_session(sessionmaker(bind=whois_engine))
whois_metadata = ThreadLocalMetaData()
whois_metadata.bind = whois_engine
import re
INET6_ADDRSTRLEN = 46
class Assignations(Entity):
"""
Ip assignations
"""
block = Field(Unicode(INET6_ADDRSTRLEN), default=unicode(''))
whois = Field(UnicodeText, required=True)
pre_options = Field(UnicodeText, default=unicode(''))
post_options = Field(UnicodeText, default=unicode(''))
keepalive_options = Field(UnicodeText, default=unicode(''))
port = Field(Integer, default=43)
using_options(metadata=whois_metadata, session=WhoisSession, tablename='Assignations')
db_user = '******'
db_pass = '******'
db_name = 'quran'
db_prefix = 'db_'
db_mysql_path = 'mysql://%s:%s@%s/%s' %(db_user, db_pass, db_server, db_name)
db_sqlite_path = "sqlite:///"+os.path.expanduser("~/python-modules/quran_quize/db.db")
b_engine = create_engine(db_mysql_path)
b_session = scoped_session(sessionmaker(autoflush=True))
b_metadata = ThreadLocalMetaData()
__metadata__ = b_metadata
__session__ = b_session
b_metadata.bind = b_engine
b_session.bind = b_engine
class users(Entity):
using_options(tablename = db_prefix+'users')
fb_id = Field(Unicode(100))
fb_user_name = Field(UnicodeText)
fb_full_name = Field(UnicodeText)
fb_gender = Field(Unicode(10))
fb_locale = Field(Unicode(5))
access_token = Field(UnicodeText)
expires = Field(DateTime)
class rounds(Entity):
using_options(tablename = db_prefix+'rounds')
user = ManyToOne('users')
