def __init__(self, data, cache):
QueryBase.__init__(self)
try:
name = data['connection_name']
conn = cache.connections.get(name)
# TODO simplify move parts to cache
from craft.db.parser import DBParser
from craft import model
from craft.db.connector import DBConnector
config = model.DBConfig(conn)
db = DBConnector(config)
parser = DBParser()
structure = parser.parsetables(db.get_metadata(), db.dbversion)
m = 'DatabaseStructure : %s' % name
self.out_success_green(self.serialize(structure), m, 5000)
except Exception, e:
self.out_error(e.message)
def __init__(self, data, cache):
QueryBase.__init__(self)
try:
name = data['connection_name']
query = data['query']
conn = cache.connections.get(name)
# TODO simplify move parts to cache
from craft import model
from craft.db.connector import DBConnector
config = model.DBConfig(conn)
db = DBConnector(config)
result = db.execute(query)
m = 'Query %s : %s' % (name, query)
out = {
'titles':result._metadata.keys,
'data':[],
}
for one in result:
out['data'].append(one._row)
self.out_success_green(out, m, 5000)
except Exception, e:
self.out_error(e.message)
def db_test(self):
data = json.loads(request.data)
config = model.DBConfig(data)
db = DBConnector(config)
db.create_session()
return json.dumps({'code': 0, 'msg': 'Connection ok', 'time': constraints.POPUP_TIMEOUT, 'data': None})
def start(conf):
db = DBConnector(conf)
db.create_session()
# reset database
Base.metadata.drop_all(db._engine)
Base.metadata.create_all(db._engine)