Exemple #1
0
def getRows(database, table, q):
	dbModule = getattr(models, database, None)
	if dbModule:
		tableObj = getattr(dbModule , table.capitalize())
		return tableObj.objects.select_related().filter(makeQ(q, (('transition' if table == 'lineprof' else table),)))
	else:
		return []
Exemple #2
0
def getRows(database, table, q):
    LOG(q)
    dbModule = getattr(models, database, None)
    if dbModule:
        tableObj = getattr(dbModule, table.capitalize())
        tableDigestObj = getattr(dbModule, table.capitalize() + "Digest")
        table = "transition" if table == "lineprof" else table
        dsID = "id_%s_ds" % table
        exQ = Q(
            **{dsID + "__in": tableDigestObj.objects.filter(line_count__gt=settings.LIMIT).values_list(dsID, flat=True)}
        )
        return tableObj.objects.select_related().exclude(exQ).filter(makeQ(q, (table,)))
    else:
        return EmptyQuerySet()
Exemple #3
0
def getRows(database, table, q):
    LOG(q)
    dbModule = getattr(models, database, None)
    if dbModule:
        tableObj = getattr(dbModule, table.capitalize())
        tableDigestObj = getattr(dbModule, table.capitalize() + 'Digest')
        table = 'transition' if table == 'lineprof' else table
        dsID = 'id_%s_ds' % table
        exQ = Q(
            **{
                dsID + '__in':
                tableDigestObj.objects.filter(
                    line_count__gt=settings.LIMIT).values_list(dsID, flat=True)
            })
        return tableObj.objects.select_related().exclude(exQ).filter(
            makeQ(q, (table, )))
    else:
        return EmptyQuerySet()