def post(self, slug=None):
form = DashboardForm(self.request.arguments)
if not form.validate():
self.set_status(400)
self.write(form.errors)
data = form.data
data['slug'] = slugfy(data.get('name'))
get_bucket = [
b for b in MyAdminBucket.get('dashboard').data or []
if b['slug'] != data['slug']
]
if get_bucket is None:
get_bucket = []
get_bucket.append(data)
b1 = MyAdminBucket.new('dashboard', data=get_bucket)
"""
for k in data:
b1.add_index("{}_bin".format(k), data[k])
"""
b1.store()
self.redirect('/admin/dashboard')
def post(self, slug=None):
form = CubeForm(self.request.arguments)
if not form.validate():
self.set_status(400)
self.write(form.errors)
data = form.data
data['slug'] = slugfy(data.get('name'))
data['sql'] = data.get('sql').replace("\n", "").replace("\r", "")
data['sql'] = data.get('sql').replace("\t", " ")
get_bucket = [b for b in MyAdminBucket.get('cube').data or []
if b['slug'] != data['slug']]
if get_bucket is None:
get_bucket = []
get_bucket.append(data)
b1 = MyAdminBucket.new('cube', data=get_bucket)
b1.add_index("slug_bin", data['slug'])
b1.add_index("connection_bin", data['connection'])
b1.store()
Queue(connection=Redis()).enqueue_call(
func='bin.mining.run',
args=(slug,)
)
self.redirect('/admin/cube')
def post(self, slug=None):
form = CubeForm(self.request.arguments)
if not form.validate():
self.set_status(400)
self.write(form.errors)
data = form.data
data['slug'] = slugfy(data.get('name'))
data['sql'] = data.get('sql').replace("\n", "").replace("\r", "")
data['sql'] = data.get('sql').replace("\t", " ")
get_bucket = [
b for b in MyAdminBucket.get('cube').data or []
if b['slug'] != data['slug']
]
if get_bucket is None:
get_bucket = []
get_bucket.append(data)
b1 = MyAdminBucket.new('cube', data=get_bucket)
b1.add_index("slug_bin", data['slug'])
b1.add_index("connection_bin", data['connection'])
b1.store()
Queue(connection=Redis()).enqueue_call(func='bin.mining.run',
args=(slug, ))
self.redirect('/admin/cube')
def post(self, slug=None):
form = ElementForm(self.request.arguments)
if not form.validate():
self.set_status(400)
self.write(form.errors)
data = form.data
data['slug'] = slugfy(data.get('name'))
data['categories'] = self.request.arguments.get('categories')[0]
get_bucket = [
b for b in MyAdminBucket.get('element').data or []
if b['slug'] != data['slug']
]
if get_bucket is None:
get_bucket = []
get_bucket.append(data)
b1 = MyAdminBucket.new('element', data=get_bucket)
b1.add_index("slug_bin", data['slug'])
b1.add_index("type_bin", data['type'])
b1.add_index("cube_bin", data['cube'])
b1.store()
self.redirect('/admin/element')
def get(self, bucket, slug):
get_bucket = MyAdminBucket.get(bucket).data or []
value = None
for i in get_bucket:
if i.get(bucket) == slug:
value = i.get(bucket)
get_bucket = [b for b in get_bucket if b['slug'] != slug]
MyAdminBucket.new(bucket, data=get_bucket).store()
Queue(connection=Redis()).enqueue_call(
func='admin.tasks.related_delete', args=(bucket, slug, value))
self.redirect('/admin/{}'.format(bucket))
def get(self):
get_bucket = MyAdminBucket.get('dashboard').data
if get_bucket is None:
get_bucket = []
self.write(json.dumps(get_bucket))
self.finish()
def post(self):
post = json.loads(self.request.body)
MyClient = riak.RiakClient(protocol=RIAK_PROTOCOL,
http_port=RIAK_HTTP_PORT,
host=RIAK_HOST)
MyAdminBucket = MyClient.bucket(ADMIN_BUCKET_NAME)
connection = None
for c in MyAdminBucket.get('connection').data:
if c['slug'] == post.get('connection', None):
connection = c['connection']
sql = """SELECT * FROM ({}) AS CUBE LIMIT 10;""".format(
post.get('sql', None))
e = create_engine(connection)
connection = e.connect()
try:
resoverall = connection.execute(text(sql))
except:
self.write({'sql': '', 'msg': 'Error!'})
self.finish()
df = DataFrame(resoverall.fetchall())
if df.empty:
self.finish()
df.columns = resoverall.keys()
df.head()
self.write({'sql': df.to_json(orient='records'), 'msg': 'Success!'})
self.finish()
def post(self):
post = json.loads(self.request.body)
MyClient = riak.RiakClient(protocol=RIAK_PROTOCOL,
http_port=RIAK_HTTP_PORT,
host=RIAK_HOST)
MyAdminBucket = MyClient.bucket(ADMIN_BUCKET_NAME)
connection = None
for c in MyAdminBucket.get('connection').data:
if c['slug'] == post.get('connection', None):
connection = c['connection']
sql = """SELECT * FROM ({}) AS CUBE LIMIT 10;""".format(
post.get('sql', None))
e = create_engine(connection)
connection = e.connect()
try:
resoverall = connection.execute(text(sql))
except:
self.write({'sql': '', 'msg': 'Error!'})
self.finish()
df = DataFrame(resoverall.fetchall())
if df.empty:
self.finish()
df.columns = resoverall.keys()
df.head()
self.write({'sql': df.to_json(orient='records'), 'msg': 'Success!'})
self.finish()
def get(self):
get_bucket = MyAdminBucket.get('dashboard').data
if get_bucket is None:
get_bucket = []
self.write(json.dumps(get_bucket))
self.finish()
def get(self, bucket, slug):
get_bucket = MyAdminBucket.get(bucket).data or []
value = None
for i in get_bucket:
if i.get(bucket) == slug:
value = i.get(bucket)
get_bucket = [b for b in get_bucket if b['slug'] != slug]
MyAdminBucket.new(bucket, data=get_bucket).store()
Queue(connection=Redis()).enqueue_call(
func='admin.tasks.related_delete',
args=(bucket, slug, value)
)
self.redirect('/admin/{}'.format(bucket))
def post(self, slug=None):
form = ConnectionForm(self.request.arguments)
if not form.validate():
self.set_status(400)
self.write(form.errors)
data = form.data
data['slug'] = slugfy(data.get('name'))
get_bucket = MyAdminBucket.get('connection').data or []
get_bucket = [b for b in get_bucket if b['slug'] != data['slug']]
if get_bucket is None:
get_bucket = []
get_bucket.append(data)
b1 = MyAdminBucket.new('connection', data=get_bucket)
b1.store()
self.redirect('/admin/connection')
def post(self, slug=None):
form = ConnectionForm(self.request.arguments)
if not form.validate():
self.set_status(400)
self.write(form.errors)
data = form.data
data['slug'] = slugfy(data.get('name'))
get_bucket = MyAdminBucket.get('connection').data or []
get_bucket = [b for b in get_bucket if b['slug'] != data['slug']]
if get_bucket is None:
get_bucket = []
get_bucket.append(data)
b1 = MyAdminBucket.new('connection', data=get_bucket)
b1.store()
self.redirect('/admin/connection')
def get(self, slug=None):
form = CubeForm()
form.connection.choices = ObjGenerate('connection', 'slug', 'name')
get_bucket = MyAdminBucket.get('cube').data or []
for bload in get_bucket:
if bload['slug'] == slug:
for k in form._fields:
getattr(form, k).data = bload[k]
self.render('admin/cube.html', form=form, cube=get_bucket, slug=slug)
def get(self, slug=None):
form = ConnectionForm()
get_bucket = MyAdminBucket.get('connection').data or []
for bload in get_bucket:
if bload['slug'] == slug:
for k in form._fields:
getattr(form, k).data = bload[k]
self.render('admin/connection.html', form=form, slug=slug,
connection=get_bucket)
def get(self, slug=None):
form = CubeForm()
form.connection.choices = ObjGenerate('connection', 'slug', 'name')
get_bucket = MyAdminBucket.get('cube').data or []
for bload in get_bucket:
if bload['slug'] == slug:
for k in form._fields:
getattr(form, k).data = bload[k]
self.render('admin/cube.html', form=form, cube=get_bucket, slug=slug)
def get(self, slug=None):
form = CubeForm()
get_bucket = MyAdminBucket.get('cube').data
if get_bucket is None:
get_bucket = []
for bload in get_bucket:
if bload['slug'] == slug:
for k in form._fields:
getattr(form, k).data = bload[k]
self.render('admin/cube.html', form=form, cube=get_bucket, slug=slug)
def get(self, slug=None):
form = ConnectionForm()
get_bucket = MyAdminBucket.get('connection').data or []
for bload in get_bucket:
if bload['slug'] == slug:
for k in form._fields:
getattr(form, k).data = bload[k]
self.render('admin/connection.html',
form=form,
slug=slug,
connection=get_bucket)
def post(self, slug=None):
form = ElementForm(self.request.arguments)
if not form.validate():
self.set_status(400)
self.write(form.errors)
data = form.data
data['slug'] = slugfy(data.get('name'))
data['categories'] = self.request.arguments.get('categories')[0]
get_bucket = [b for b in MyAdminBucket.get('element').data or []
if b['slug'] != data['slug']]
if get_bucket is None:
get_bucket = []
get_bucket.append(data)
b1 = MyAdminBucket.new('element', data=get_bucket)
b1.add_index("slug_bin", data['slug'])
b1.add_index("type_bin", data['type'])
b1.add_index("cube_bin", data['cube'])
b1.store()
self.redirect('/admin/element')
def post(self, slug=None):
form = DashboardForm(self.request.arguments)
if not form.validate():
self.set_status(400)
self.write(form.errors)
data = form.data
data['slug'] = slugfy(data.get('name'))
get_bucket = [b for b in MyAdminBucket.get('dashboard').data or []
if b['slug'] != data['slug']]
if get_bucket is None:
get_bucket = []
get_bucket.append(data)
b1 = MyAdminBucket.new('dashboard', data=get_bucket)
"""
for k in data:
b1.add_index("{}_bin".format(k), data[k])
"""
b1.store()
self.redirect('/admin/dashboard')
def get(self, slug=None):
form = ElementForm()
get_bucket = MyAdminBucket.get('element').data
if get_bucket is None:
get_bucket = []
for bload in get_bucket:
if bload['slug'] == slug:
for k in form._fields:
getattr(form, k).data = bload[k]
self.render('admin/element.html',
form=form,
element=get_bucket,
slug=slug)
def get(self, slug=None):
form = DashboardForm()
form.element.choices = ObjGenerate('element', 'slug', 'name')
get_bucket = MyAdminBucket.get('dashboard').data
if get_bucket is None:
get_bucket = []
for bload in get_bucket:
if bload['slug'] == slug:
for k in form._fields:
getattr(form, k).data = bload[k]
self.render('admin/dashboard.html',
form=form,
dashboard=get_bucket,
slug=slug)
def get(self, slug=None):
form = DashboardForm()
form.element.choices = ObjGenerate('element', 'slug', 'name')
get_bucket = MyAdminBucket.get('dashboard').data
if get_bucket is None:
get_bucket = []
for bload in get_bucket:
if bload['slug'] == slug:
for k in form._fields:
getattr(form, k).data = bload[k]
self.render('admin/dashboard.html',
form=form,
dashboard=get_bucket,
slug=slug)
def get(self, slug=None):
form = ElementForm()
form.cube.choices = ObjGenerate('cube', 'slug', 'name')
get_bucket = MyAdminBucket.get('element').data
if get_bucket is None:
get_bucket = []
categorie = None
for bload in get_bucket:
if bload['slug'] == slug:
for k in form._fields:
getattr(form, k).data = bload[k]
categorie = bload.get('categories')
self.render('admin/element.html',
form=form,
element=get_bucket,
categorie=categorie,
slug=slug)
def get(self, slug=None):
form = ElementForm()
form.cube.choices = ObjGenerate('cube', 'slug', 'name')
get_bucket = MyAdminBucket.get('element').data
if get_bucket is None:
get_bucket = []
categorie = None
for bload in get_bucket:
if bload['slug'] == slug:
for k in form._fields:
getattr(form, k).data = bload[k]
categorie = bload.get('categories')
self.render('admin/element.html',
form=form,
element=get_bucket,
categorie=categorie,
slug=slug)
def get(self, slug):
data = MyAdminBucket.get(u'{}-columns'.format(slug)).data or '{}'
columns = json.loads(data)
self.write({'columns': columns})
self.finish()
