def onRevisionActivated(self, rev):
"""
Callback called when a revision is double-clicked in the revisions table
"""
if self.repoviewer is None:
# prevent recursive import
from workbench import Workbench
self.repoviewer = Workbench()
self.repoviewer.show()
self.repoviewer.activateWindow()
self.repoviewer.raise_()
self.repoviewer.showRepo(hglib.tounicode(self.repo.root))
self.repoviewer.goto(self.repo.root, rev)
class _AbstractFileDialog(QMainWindow):
def __init__(self, repo, filename, repoviewer=None):
QMainWindow.__init__(self)
self.repo = repo
self.setupUi(self)
self.setRepoViewer(repoviewer)
self._show_rev = None
if isinstance(filename, (unicode, QString)):
filename = hglib.fromunicode(filename)
self.filename = filename
self.createActions()
self.setupToolbars()
self.setupViews()
self.setupModels()
def setRepoViewer(self, repoviewer=None):
self.repoviewer = repoviewer
if repoviewer:
repoviewer.finished.connect(lambda x: self.setRepoViewer(None))
def reload(self):
'Reload toolbar action handler'
self.repo.thginvalidate()
self.setupModels()
def onRevisionActivated(self, rev):
"""
Callback called when a revision is double-clicked in the revisions table
"""
if self.repoviewer is None:
# prevent recursive import
from workbench import Workbench
self.repoviewer = Workbench()
self.repoviewer.show()
self.repoviewer.activateWindow()
self.repoviewer.raise_()
self.repoviewer.showRepo(hglib.tounicode(self.repo.root))
self.repoviewer.goto(self.repo.root, rev)
class _AbstractFileDialog(QMainWindow):
def __init__(self, repo, filename, repoviewer=None):
QMainWindow.__init__(self)
self.repo = repo
self.setupUi(self)
self.setRepoViewer(repoviewer)
self._show_rev = None
if isinstance(filename, (unicode, QString)):
filename = hglib.fromunicode(filename)
self.filename = filename
self.createActions()
self.setupToolbars()
self.setupViews()
self.setupModels()
def setRepoViewer(self, repoviewer=None):
self.repoviewer = repoviewer
if repoviewer:
repoviewer.finished.connect(lambda x: self.setRepoViewer(None))
def reload(self):
'Reload toolbar action handler'
self.repo.thginvalidate()
self.setupModels()
def onRevisionActivated(self, rev):
"""
Callback called when a revision is double-clicked in the revisions table
"""
if self.repoviewer is None:
# prevent recursive import
from workbench import Workbench
self.repoviewer = Workbench()
self.repoviewer.show()
self.repoviewer.activateWindow()
self.repoviewer.raise_()
self.repoviewer.showRepo(hglib.tounicode(self.repo.root))
self.repoviewer.goto(self.repo.root, rev)
def onRevisionActivated(self, rev):
"""
Callback called when a revision is double-clicked in the revisions table
"""
if self.repoviewer is None:
# prevent recursive import
from workbench import Workbench
self.repoviewer = Workbench()
self.repoviewer.show()
self.repoviewer.activateWindow()
self.repoviewer.raise_()
self.repoviewer.showRepo(hglib.tounicode(self.repo.root))
self.repoviewer.goto(self.repo.root, rev)
def sellerHome():
if 'email' in session:
user = session['email']
firstname = session['firstname']
db = Workbench('minProj', password=mysql_pwd)
uid = session['userID']
productdetails = db.select_from('supplierdet',
where_clause={'supplierID': uid})
productlist = [
db.select_from('products', where_clause={'prodID': x['prodID']})[0]
for x in productdetails
]
# print(productlist[0])
else:
return redirect(url_for('index'))
return render_template('sellerHome.html',
user=user,
firstname=firstname,
productdetails=productdetails,
productlist=productlist,
login_status=True)
def objective(trial):
common_hyperparameters(trial, data)
data['datagen_config']['dataset'] = get_task(trial, key_model)
data['train']['epochs'] = EPOCHS
data['model']['model_config_path'] = selected_model
data['datagen_config']['dataset_train_len'] = dataset_train_len
data['datagen_config']['dataset_test_len'] = dataset_test_len
data['datagen_config']['dataset_validation_len'] = dataset_validation_len
exp = Workbench(data)
exp.run_optuna()
exp.save_model("optuna", name="optuna_{}_{}".format(key_model, trial._trial_id))
trial.set_user_attr("train_accuracy", exp.train_accuracy)
trial.set_user_attr("evaluation_accuracy", exp.evaluation_accuracy)
trial.set_user_attr("dA_train", exp.dA_train)
trial.set_user_attr("dA_eval", exp.dA_eval)
return exp.test_accuracy
def train(gpu, args):
exp = Workbench(args.config_yaml, ddp=True)
exp.run()
def home(page=1):
if 'email' in session:
perPage = 20
startAt = perPage * page - perPage
user = session['email']
firstname = session['firstname']
db = Workbench('minProj', password=mysql_pwd)
if request.method == 'POST' and request.form:
payload = request.form
# print(payload)
query = 'SELECT * FROM products'
filters = []
if (len(payload) >= 1
and 'price' not in payload) or len(payload) > 1:
categoryIDs = []
for k, v in payload.items():
if k != 'price':
categoryIDs.append(v)
print(categoryIDs)
cat = ['categoryID = ' + x for x in categoryIDs]
cat = '(' + ' OR '.join(cat) + ')'
filters.append(cat)
if ('price' in payload):
priceconstraint = '(minPrice'
if payload['price'] == '1':
priceconstraint += '< 1000)'
elif payload['price'] == '2':
priceconstraint += '>= 1000 AND minPrice<= 5000)'
elif payload['price'] == '3':
priceconstraint += '>= 5000 AND minPrice<= 10000)'
elif payload['price'] == '4':
priceconstraint += '>= 10000 AND minPrice<= 20000)'
else:
priceconstraint += '> 20000)'
filters.append(priceconstraint)
filters = ' AND '.join(filters)
filters += ';'
query = ' WHERE '.join([query, filters])
print(query)
products = db.select_from_custom(query)
filter = True
return render_template('home.html',
user=user,
firstname=firstname,
products=products,
page=page,
filter=filter,
login_status=True)
else:
products = db.select_from('products')
global allproducts
allproducts = products
totalPages = len(products) // 20 + 1
# print(totalPages)
products = products[startAt:startAt + perPage]
filter = False
return render_template('home.html',
user=user,
firstname=firstname,
products=products,
page=page,
totalPages=totalPages,
filter=filter,
login_status=True)
else:
return redirect(url_for('index'))
def sellerProfile():
if 'email' in session:
login_status = True
db = Workbench(database='minProj', password=mysql_pwd)
print(session)
session['paymentdetailID'] = db.select_from(
"suppliers",
attributes=['paymentID'],
where_clause={'supplierID': session['userID']})[0]['paymentID']
if request.method == 'POST':
payload = request.form
card = ['cardName', 'bankName', 'cardNum', 'cvv', 'expDate']
payloads = dict([
x for x in payload.items()
if x[0] not in card and x[0] != 'upiID'
])
cardinfo = dict(
[x for x in payload.items() if x[0] in card and x[1] != ''])
upiinfo = dict(
[x for x in payload.items() if x[0] == 'upiID' and x[1] != ''])
def dataenter():
if session['paymentdetailID'] is None:
payinfo = dict()
payinfo['paymentdetailID'] = 'Pay-' + str(
randint(1, 9999999) + randint(1, 999999))
if bool(cardinfo) != False:
cardinfo['carddetailID'] = 'Ca-' + str(
randint(1, 9999999) + randint(1, 999999))
payinfo['carddetailID'] = cardinfo['carddetailID']
try:
db.insert_into("carddet", values=cardinfo)
except Error as e:
print(e)
return 'carddet.CardNum'
if bool(upiinfo) != False:
upiinfo['upidetailID'] = 'U-' + str(
randint(1, 9999999) + randint(1, 999999))
payinfo['upidetailID'] = upiinfo['upidetailID']
try:
db.insert_into("upidet", values=upiinfo)
except Error as e:
print(e)
return 'upidet.upiID'
if 'upidetailID' in payinfo or 'carddetailID' in payinfo:
session['paymentdetailID'] = payinfo['paymentdetailID']
payloads['paymentID'] = payinfo['paymentdetailID']
db.insert_into("paymentdet", values=payinfo)
else:
print(session)
payinfo = db.select_from("paymentdet",
where_clause={
'paymentdetailID':
session['paymentdetailID']
})
print(payinfo)
if payinfo[0]['carddetailID'] != None:
if bool(cardinfo) != False:
try:
db.update_table("carddet",
updates=cardinfo,
where_clause={
'carddetailID':
payinfo[0]['carddetailID']
})
except Error as e:
print(e)
return 'carddet.CardNum'
else:
db.delete_from("carddet",
where_clause={
'carddetailID':
payinfo[0]['carddetailID']
})
elif bool(cardinfo) != False:
cardinfo['carddetailID'] = 'Ca-' + str(
randint(1, 9999999) + randint(1, 999999))
payinfo[0]['carddetailID'] = cardinfo['carddetailID']
try:
db.insert_into("carddet", values=cardinfo)
except Error as e:
print(e)
return 'carddet.CardNum'
try:
db.update_table("paymentdet",
updates=payinfo[0],
where_clause={
'paymentdetailID':
session['paymentdetailID']
})
except Error as e:
print(e)
return
if payinfo[0]['upidetailID'] != None:
if bool(upiinfo) != False:
try:
db.update_table("upidet",
updates=upiinfo,
where_clause={
'upidetailID':
payinfo[0]['upidetailID']
})
except Error as e:
print(e)
return 'upidet.upiID'
else:
try:
db.delete_from("upidet",
where_clause={
'upidetailID':
payinfo[0]['upidetailID']
})
except Error as e:
print(e)
return
elif bool(upiinfo) != False:
upiinfo['upidetailID'] = 'U-' + str(
randint(1, 9999999) + randint(1, 999999))
payinfo[0]['upidetailID'] = upiinfo['upidetailID']
try:
db.insert_into("upidet", values=upiinfo)
except Error as e:
print(e)
return 'upidet.upiID'
try:
db.update_table("paymentdet",
updates=payinfo[0],
where_clause={
'paymentdetailID':
session['paymentdetailID']
})
except Error as e:
print(e)
return
login_status = dataenter()
try:
db.update_table("suppliers",
updates=payloads,
where_clause={'supplierID': session['userID']})
except Error as e:
if 'suppliers.pno_UNIQUE' in str(e):
print(e)
login_status = 'suppliers.pno_UNIQUE'
if 'suppliers.email_UNIQUE' in str(e):
print(e)
login_status = 'suppliers.email_UNIQUE'
else:
print(e)
userinfo = db.select_from(
"suppliers", where_clause={'supplierID': session['userID']})
result = None
print(session)
if session['paymentdetailID'] is not None:
paymentdet = db.select_from(
"paymentdet",
where_clause={'paymentdetailID':
session['paymentdetailID']})[0]
if paymentdet['carddetailID'] is not None:
result = db.select_from(
"carddet",
where_clause={'carddetailID':
paymentdet['carddetailID']})[0]
if paymentdet['upidetailID'] is not None:
if result is not None:
print(result)
print(paymentdet)
result.update(
db.select_from("upidet",
where_clause={
'upidetailID':
paymentdet['upidetailID']
})[0])
else:
result = db.select_from("upidet",
where_clause={
'upidetailID':
paymentdet['upidetailID']
})[0]
else:
return redirect(url_for('index'))
return render_template('sellerprofile.html',
user=userinfo,
firstname=userinfo[0]['firstname'],
payinfo=result,
login_status=login_status)
def index():
login_status = None
if request.method == 'POST':
payload = request.form
print(payload)
payload = payload.copy()
if payload['user'] == 'customer':
tableName = "customers"
idName = 'custID'
idPrefix = 'C-'
if 'orgname' in payload:
payload.pop('orgname')
else:
tableName = 'suppliers'
idName = 'supplierID'
idPrefix = 'S-'
payload.pop('user')
dB = Workbench(database='minProj', password=mysql_pwd)
if 'login' in payload:
whereClause = dict(
[x for x in payload.items() if 'login' not in x])
# print(userDat)
userData = dB.select_from(tableName, where_clause=whereClause)
# print(userData)
if userData:
login_status = True
if payload['email'] not in session:
session['email'] = payload['email']
session['firstname'] = userData[0]['firstname']
session['userID'] = userData[0][idName]
if idPrefix == 'C-':
return redirect(url_for('home'))
else:
return redirect(url_for('sellerHome'))
else:
login_status = False
return render_template("index.html", login_status=login_status)
else:
print(payload)
values = dict([x for x in payload.items() if 'signup' not in x])
# print(values)
values[idName] = idPrefix + str(
randint(1, 9999999) + randint(1, 999999))
values['joinDate'] = str(date.today())
try:
dB.insert_into(tableName, values)
if payload['email'] not in session:
session['email'] = payload['email']
session['firstname'] = payload['firstName']
session['userID'] = payload[idName]
if idPrefix == 'C-':
return redirect(url_for('home'))
else:
return redirect(url_for('sellerHome'))
else:
return redirect(url_for('home'))
except Error as e:
if 'Duplicate entry' in str(e):
print(e)
login_status = 'Already Exists'
return render_template('index.html',
login_status=login_status)
else:
return render_template("index.html")
from workbench import Workbench w = Workbench() w.testing_run()
denom = ScalarE3(sqrt(2 + (a % b)))
R = numer / denom
return R
arrowF = ArrowBuilder().scale(magnitude(f)).attitude(
attitude(f)).color("red").build()
scene.add(arrowF)
arrowF.position.set(f.x / 2.0, f.y / 2.0, 0.0)
arrowH = ArrowBuilder().scale(magnitude(h)).attitude(
attitude(h)).color("magenta").build()
scene.add(arrowH)
arrowH.position.set(h.x / 2, h.y / 2, 0)
workbench = Workbench(scene.renderer, scene.camera)
def tick(t):
scene.render()
def terminate(t):
done = t > 16
return done
def setUp():
workbench.setUp()
from workbench import Workbench
from dotenv import load_dotenv
import os
load_dotenv()
myobject = Workbench('Sample',
user='******',
password=os.getenv('mySQL_muleyashutosh_password'))
print('MYSQL VERSION: ', myobject.conn.get_server_info())
attributes = []
tablename = 'student'
myobject.create_table(tablename)
from workbench import Workbench
if __name__ == '__main__':
exp = Workbench("config/config.yaml")
exp.run()
