def load_db_params(self, gc):
self.databases = tuple(self.to_iter(gc["databases"]))
self.db_params = {}
if not self.databases:
return
dbm = db_manager.db_manager()
db_param_names = ("name", "db_host", "db_user", "db_pass", "pool_size", "max_overflow")
for db_name in self.databases:
conf_params = self.to_iter(gc[db_name + "_db"])
params = dict(zip(db_param_names, conf_params))
dbm.engines[db_name] = db_manager.get_engine(**params)
self.db_params[db_name] = params
dbm.type_db = dbm.engines[gc["type_db"]]
dbm.relation_type_db = dbm.engines[gc["rel_type_db"]]
prefix = "db_table_"
for k, v in gc.iteritems():
if k.startswith(prefix):
params = list(self.to_iter(v))
name = k[len(prefix) :]
kind = params[0]
if kind == "thing":
dbm.add_thing(name, [dbm.engines[n] for n in params[1:]])
elif kind == "relation":
dbm.add_relation(name, params[1], params[2], [dbm.engines[n] for n in params[3:]])
return dbm
def load_db_params(self, gc):
self.databases = tuple(self.to_iter(gc['databases']))
self.db_params = {}
if not self.databases:
return
dbm = db_manager.db_manager()
db_param_names = ('name', 'db_host', 'db_user', 'db_pass',
'pool_size', 'max_overflow')
for db_name in self.databases:
conf_params = self.to_iter(gc[db_name + '_db'])
params = dict(zip(db_param_names, conf_params))
dbm.engines[db_name] = db_manager.get_engine(**params)
self.db_params[db_name] = params
dbm.type_db = dbm.engines[gc['type_db']]
dbm.relation_type_db = dbm.engines[gc['rel_type_db']]
prefix = 'db_table_'
for k, v in gc.iteritems():
if k.startswith(prefix):
params = list(self.to_iter(v))
name = k[len(prefix):]
kind = params[0]
if kind == 'thing':
dbm.add_thing(name, [dbm.engines[n] for n in params[1:]])
elif kind == 'relation':
dbm.add_relation(name, params[1], params[2],
[dbm.engines[n] for n in params[3:]])
return dbm
def load_db_params(self, gc):
self.databases = tuple(self.to_iter(gc['databases']))
self.db_params = {}
if not self.databases:
return
dbm = db_manager.db_manager()
db_param_names = ('name', 'db_host', 'db_user', 'db_pass', 'pool_size',
'max_overflow')
for db_name in self.databases:
conf_params = self.to_iter(gc[db_name + '_db'])
params = dict(zip(db_param_names, conf_params))
dbm.engines[db_name] = db_manager.get_engine(**params)
self.db_params[db_name] = params
dbm.type_db = dbm.engines[gc['type_db']]
dbm.relation_type_db = dbm.engines[gc['rel_type_db']]
dbm.hardcache_db = dbm.engines[gc['hardcache_db']]
def split_flags(p):
return ([n for n in p if not n.startswith("!")],
dict((n.strip('!'), True) for n in p if n.startswith("!")))
prefix = 'db_table_'
for k, v in gc.iteritems():
if k.startswith(prefix):
params = list(self.to_iter(v))
name = k[len(prefix):]
kind = params[0]
if kind == 'thing':
engines, flags = split_flags(params[1:])
dbm.add_thing(name, [dbm.engines[n] for n in engines],
**flags)
elif kind == 'relation':
engines, flags = split_flags(params[3:])
dbm.add_relation(name, params[1], params[2],
[dbm.engines[n] for n in engines],
**flags)
return dbm
# CondeNet, Inc. All Rights Reserved.
################################################################################
from r2.lib.manager import db_manager
from pylons import g
try:
#TODO: move?
from r2admin.config.databases import *
except:
pass
tz = g.tz
dbm = db_manager.db_manager()
main_engine = db_manager.get_engine(g.main_db_name,
db_host = g.main_db_host,
db_user = g.main_db_user,
db_pass = g.main_db_pass)
comment_engine = db_manager.get_engine(g.comment_db_name,
db_host = g.comment_db_host,
db_user = g.comment_db_user,
db_pass = g.comment_db_pass)
vote_engine = db_manager.get_engine(g.vote_db_name,
db_host = g.vote_db_host,
db_user = g.vote_db_user,
db_pass = g.vote_db_pass)
change_engine = db_manager.get_engine(g.change_db_name,
db_host = g.change_db_host,
db_user = g.change_db_user,
# CondeNet, Inc. All Rights Reserved.
################################################################################
from r2.lib.manager import db_manager
from pylons import g
try:
#TODO: move?
from r2admin.config.databases import *
except:
pass
tz = g.tz
dbm = db_manager.db_manager()
main_engine = db_manager.get_engine(g.main_db_name,
db_host=g.main_db_host,
db_user=g.main_db_user,
db_pass=g.main_db_pass)
comment_engine = db_manager.get_engine(g.comment_db_name,
db_host=g.comment_db_host,
db_user=g.comment_db_user,
db_pass=g.comment_db_pass)
vote_engine = db_manager.get_engine(g.vote_db_name,
db_host=g.vote_db_host,
db_user=g.vote_db_user,
db_pass=g.vote_db_pass)
change_engine = db_manager.get_engine(g.change_db_name,
db_host=g.change_db_host,
db_user=g.change_db_user,