def main(app):
global TITLES, REDIRECTS
start = time.time()
print "Starting title server..."
options = define_options()
lb = LoadBalancer(options.dbconfig)
global_db = lb.get_db_by_name('wikicities')
(wiki_id, dbname) = get_local_db_from_options(options, global_db)
local_db = lb.get_db_by_name(dbname)
# store flat, unique dictionary
cursor = local_db.cursor()
cursor.execute("SELECT page_title FROM page WHERE page_namespace IN (%s)" %
", ".join(map(str, get_namespaces(global_db, wiki_id))))
TITLES = set(map(lambda x: preprocess(x[0]), cursor))
# relate preprocessed redirect title to canonical title
cursor = local_db.cursor()
cursor.execute(
"SELECT page_title, rd_title FROM redirect INNER JOIN page ON page_id = rd_from"
)
REDIRECTS = dict([map(preprocess, row) for row in cursor])
print "Title server ready in %s seconds" % str(time.time() - start)
app.run(debug=True, host='0.0.0.0', port=5001)
def initDb(self):
dbyml = os.environ.get('WIKIA_DB_YML', '/usr/wikia/conf/current/DB.yml')
lb = LoadBalancer(dbyml)
globalDb = lb.get_db_by_name('wikicities')
cursor = globalDb.cursor()
cursor.execute('SELECT city_dbname FROM city_list WHERE city_url = "%s"' % (self.host))
result = cursor.fetchone()
self.db = lb.get_db_by_name(result[0])
def getIterator(self):
lb = LoadBalancer(self.options.get('dbconf', '/usr/wikia/conf/current/DB.yml'))
globalDb = lb.get_db_by_name('wikicities')
cursor = globalDb.cursor()
self.results = cursor.execute(self.getQuery())
self.progress = 0
return cursor
def getIterator(self):
lb = LoadBalancer(
self.options.get('dbconf', '/usr/wikia/conf/current/DB.yml'))
globalDb = lb.get_db_by_name('wikicities')
cursor = globalDb.cursor()
self.results = cursor.execute(self.getQuery())
self.progress = 0
return cursor
def get_global_db(master=False):
"""
Accesses the wikia global db
:param master: whether we should use the writeable master db
:type master: bool
:return: database connection
"""
lb = LoadBalancer(get_config())
return lb.get_db_by_name('wikicities', master=master)
def get_global_db(master=False):
"""
Accesses the wikia global db
:param master: whether we should use the writeable master db
:type master: bool
:return: database connection
:rtype: MySQLdb.connections.Connection
"""
lb = LoadBalancer(get_config())
return lb.get_db_by_name('wikicities', master=master)
def main(app):
global TITLES, REDIRECTS
start = time.time()
print "Starting title server..."
options = define_options()
lb = LoadBalancer(options.dbconfig)
global_db = lb.get_db_by_name('wikicities')
(wiki_id, dbname) = get_local_db_from_options(options, global_db)
local_db = lb.get_db_by_name(dbname)
# store flat, unique dictionary
cursor = local_db.cursor()
cursor.execute("SELECT page_title FROM page WHERE page_namespace IN (%s)" % ", ".join(map(str, get_namespaces(global_db, wiki_id))))
TITLES = set(map(lambda x: preprocess(x[0]), cursor))
# relate preprocessed redirect title to canonical title
cursor = local_db.cursor()
cursor.execute("SELECT page_title, rd_title FROM redirect INNER JOIN page ON page_id = rd_from")
REDIRECTS = dict([map(preprocess, row) for row in cursor])
print "Title server ready in %s seconds" % str(time.time() - start)
app.run(debug=True, host='0.0.0.0', port=5001)
def get_global_db():
lb = LoadBalancer(get_config())
return lb.get_db_by_name('wikicities')
def get_global_db(master=False):
lb = LoadBalancer(get_config())
return lb.get_db_by_name('wikicities', master=master)
def get_global_db():
lb = LoadBalancer(get_config())
return lb.get_db_by_name('wikicities')