def test_view(capsys, view_id, view_dataset_id, source_table_id, source_dataset_id): override_values = { "view_id": view_id, "source_id": source_table_id, } got = view.create_view(override_values) assert source_table_id in got.view_query out, _ = capsys.readouterr() assert view_id in out got = view.get_view(override_values) assert source_table_id in got.view_query assert "'W%'" in got.view_query out, _ = capsys.readouterr() assert view_id in out assert source_table_id in out assert "'W%'" in out got = view.update_view(override_values) assert source_table_id in got.view_query assert "'M%'" in got.view_query out, _ = capsys.readouterr() assert view_id in out project_id, dataset_id, table_id = view_id.split(".") override_values = { "analyst_group_email": "*****@*****.**", "view_dataset_id": view_dataset_id, "source_dataset_id": source_dataset_id, "view_reference": { "projectId": project_id, "datasetId": dataset_id, "tableId": table_id, }, } view_dataset, source_dataset = view.grant_access(override_values) assert len(view_dataset.access_entries) != 0 assert len(source_dataset.access_entries) != 0 out, _ = capsys.readouterr() assert "*****@*****.**" in out assert table_id in out
def OnInit(self): if USE_INSPECTOR: self.Init() # Check version if wx.VERSION[:3] < MinWxVersion: wx.LogWarning('''\ This version of XRCed may not work correctly on your version of wxWidgets. \ Please upgrade wxWidgets to %d.%d.%d or higher.''' % MinWxVersion) g.undoMan = undo.UndoManager() Manager.init() parser = OptionParser(prog=progname, version='%s version %s' % (ProgName, version), usage='%prog [options] [XRC file]') parser.add_option('-d', '--debug', action='store_true', help='add Debug command to Help menu') parser.add_option('-m', '--meta', action='store_true', dest='meta', help='activate meta-components') parser.add_option('-v', '--verbose', action='store_true', help='verbose messages') # Process command-line arguments options, args = parser.parse_args() if options.debug: set_debug(True) if options.verbose: set_verbose(True) if options.meta: g.useMeta = True import meta Manager.register(meta.Component) Manager.setMenu(meta.Component, 'TOP_LEVEL', 'component', 'component plugin') self.SetAppName(progname) self.ReadConfig() # Add handlers wx.FileSystem.AddHandler(wx.MemoryFSHandler()) self.toolArtProvider = view.ToolArtProvider() wx.ArtProvider.Push(self.toolArtProvider) # Load standard plugins first plugin.load_plugins(os.path.join(g.basePath, 'plugins')) # ... and then from user-defined dirs plugin.load_plugins_from_dirs() # Setup MVP view.create_view() Presenter.init() Listener.Install(view.frame, view.tree, view.panel, view.toolFrame, view.testWin) if args: path = args[0] # Change current directory dir = os.path.dirname(path) if dir: os.chdir(dir) path = os.path.basename(path) if os.path.isfile(path): Presenter.open(path) else: # Future name Presenter.path = path # Force update title Presenter.setModified(False) view.frame.Show() if not g.useAUI: if not g.conf.embedPanel: view.frame.miniFrame.Show() if g.conf.showToolPanel: Listener.toolFrame.Show() return True
from db import get_db from sqlalchemy import create_engine, MetaData, Table from sqlalchemy.orm import sessionmaker from sqlalchemy_views import CreateView, DropView import sqlparse # ------------------------------------------ Database Connection Establishing ------------------------------------------ db_verity = get_db('news') # assert db_verity == 149168128, "Database is corrupted." conn = sqlite3.connect('app/news.db') conn.create_function('REGEXP', 2, lambda x, y: 1 if re.search(x, y) else 0) c = conn.cursor() create_view('app/news.db', 'data') engine = create_engine('sqlite:///app/news.db') metadata = MetaData(bind=engine) Session = sessionmaker(bind=engine) session = Session() data = Table("data", metadata, autoload=True) # ---------------------------------------------------- TODO Section ---------------------------------------------------- # починить даты V # починить фильтры V # починить рубрики V # Починить излишнее количество строк из-за джойнов V # Починить чтение бд V
def OnInit(self): # Check version if wx.VERSION[:3] < MinWxVersion: wx.LogWarning('''\ This version of XRCed may not work correctly on your version of wxWidgets. \ Please upgrade wxWidgets to %d.%d.%d or higher.''' % MinWxVersion) g.undoMan = undo.UndoManager() Manager.init() parser = OptionParser(prog=progname, version='%s version %s' % (ProgName, version), usage='%prog [options] [XRC file]') parser.add_option('-d', '--debug', action='store_true', help='add Debug command to Help menu') parser.add_option('-m', '--meta', action='store_true', dest = 'meta', help='activate meta-components') parser.add_option('-v', '--verbose', action='store_true', help='verbose messages') # Process command-line arguments options, args = parser.parse_args() if options.debug: set_debug(True) if options.verbose: set_verbose(True) if options.meta: g.useMeta = True import meta Manager.register(meta.Component) Manager.setMenu(meta.Component, 'TOP_LEVEL', 'component', 'component plugin') self.SetAppName(progname) self.ReadConfig() # Add handlers wx.FileSystem.AddHandler(wx.MemoryFSHandler()) self.toolArtProvider = view.ToolArtProvider() wx.ArtProvider.Push(self.toolArtProvider) # Load standard plugins first plugin.load_plugins(os.path.join(g.basePath, 'plugins')) # ... and then from user-defined dirs plugin.load_plugins_from_dirs() # Setup MVP view.create_view() Presenter.init() Listener.Install(view.frame, view.tree, view.panel, view.toolFrame, view.testWin) if args: path = args[0] # Change current directory dir = os.path.dirname(path) if dir: os.chdir(dir) path = os.path.basename(path) if os.path.isfile(path): Presenter.open(path) else: # Future name Presenter.path = path # Force update title Presenter.setModified(False) view.frame.Show() if not g.useAUI: if not g.conf.embedPanel: view.frame.miniFrame.Show() if g.conf.showToolPanel: Listener.toolFrame.Show() return True
add_users_queue.put(True, msg.sender) username += "" if counter == 1 else str(counter) return username if len(sys.argv) > 1: username = sys.argv[1] else: username = "******" send_queue = queue.Queue() receive_queue = queue.Queue() add_users_queue = queue.Queue() running_queue = queue.Queue() # like in server running_queue.put(42) view = create_view(send_queue, receive_queue, add_users_queue, running_queue) senderThread = SenderThread(send_queue, running_queue) receiverThread = ReceiverThread(receive_queue, add_users_queue, running_queue) sock = socket(AF_INET, SOCK_STREAM) # utworzenie gniazda sock.connect((ADDRESS, PORT)) # nawiazanie polaczenia username = connect_to_server(username, add_users_queue) senderThread.start() receiverThread.start() view.start_update_loop() view.main_loop()