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()