def __init__(self, user):
self.query_manager_instance = QueryManager()
# Method map corresponding to the input type. It can be scaled in this way.
self.method_map = {
"hi": "say_hi",
"!google": "search_google",
"!recent": "get_recent_searches"
}
self.user = user
def example_query_manager():
config = {
'db': 'test.db',
'fields': [],
'filters': [],
'table': 'Customers',
'max_export_rows': 500000,
'max_display_rows': 1000,
'order_by': ''
}
return QueryManager(config)
def datasheet_view(fields, filters):
config = {
'db': 'test.db',
'fields': fields,
'filters': filters,
'table': 'Customers',
'max_export_rows': 500000,
'max_display_rows': 1000,
'order_by': ''
}
return QueryManager(config)
def __init__(self):
super(QueryManagerMachine, self).__init__()
self.config = {
'db': 'test.db',
'fields': [],
'filters': [],
'table': 'Customers',
'max_export_rows': 500000,
'max_display_rows': 1000,
'order_by': ''
}
self.query_manager = QueryManager(self.config)
def __init__(self, table: Table):
super(AbstractModel, self).__init__()
self.query_manager = QueryManager(table=table)
self.original_data = []
self.modified_data = []
self.visible_data = []
# variables needed for pagination
self.rows_per_page = 50
self.rows_loaded = 50
# Connect Signals
self.query_manager.query_results_signal.connect(self.update_view)
def query_manager():
fields = [
Field('CustomerID', 'int'),
Field('ProductID', 'int'),
Field('CustomerName', 'str'),
Field('OrderDate', 'date'),
Field('ShippingDate', 'date'),
Field('ShippingAddress', 'str'),
Field('SalesAmount', 'float')
]
config = {
'db': 'test.db',
'fields': fields,
'filters': [],
'table': 'Customers',
'max_export_rows': 500000,
'max_display_rows': 1000,
'order_by': ''
}
return QueryManager(config)
def test_table_with_query_provided(tmpdir):
sql = tmpdir.mkdir('test_config').join('test.sql')
sql.write("SELECT * FROM test")
qm = QueryManager(config={'table': str(sql)})
assert qm.table == "(SELECT * FROM test)"
def test_table_with_tablename_provided():
qm = QueryManager(config={'table': 'test'})
assert qm.table == 'test'
def __init__(self, config_path, train_set_size=0.7):
if config_path is not None:
self.qm = QueryManager(config_path, train_set_size)
self.categories = None
self.log = None
