def __btn_callback(self, btn):
if btn == "Entrar":
# db_controller = DBController(host="ds133856.mlab.com", port=33856, db_name="pooptbank", db_user="******",
# db_pass="******")
db_controller = DBController(host="localhost", port=27017, db_name="pooptbank", db_user="",
db_pass="")
username = self.get_app_gui().getEntry("Username")
password = self.get_app_gui().getEntry("Password")
data = db_controller.select_data_single('users', {'username': username, 'password': password})
if data is not None and data['username'] == username and data['password'] == password:
home_view = HomeView(View.get_app_gui(self), "Home", data['username'], str(data['balance']))
home_view.show("Home")
else:
error_view = ErrorView(View.get_app_gui(self), "Erro")
error_view.show("Erro")
elif btn == "Sair":
View.get_app_gui(self).stop()
elif btn == "Cadastrar":
signup_view = None
try:
signup_view = Signup(View.get_app_gui(self), btn)
signup_view.show(btn)
except ItemLookupError:
signup_view.show(btn)
elif btn == "Configurar":
config_view = Configuration(View.get_app_gui(self), btn)
config_view.show(btn)
def __init__(self, is_desktop):
"""
생성자
is_desktop : 서버환경에서 실행시키는지, 데크스탑환경(GUI)에서 실행시키는지\
(true, false)
"""
# config.ini파일의 변수 가져오기
config = configparser.ConfigParser()
config.read('config.ini')
self.apk_directory = config.get('Setting','APK_DIRECTORY')
self.is_desktop = is_desktop
# 서버모드로 실행시켰다면 가상디스플레이 실행
if(not is_desktop):
self.display = Display(visible=0, size=(800, 600))
self.display.start()
# 크롬 드라이버 실행
self.chrome = webdriver.Chrome(config.get('Setting',\
'CHROME_DRIVER_DIRECTORY'))
# 크롤링할 디렉토리 리스트 저장
self.category_list = config.items('PlayStoreURL')
# 데이터를 저장하고 제어할 DBController객체 생성
self.db_connector = DBController(config.get('Setting','DB_DIRECTORY'))
# 메타데이터가 저장될 SQLite 테이블 생성
self.db_connector.create_table()
def __init__(self, is_desktop):
"""
생성자
is_desktop : 서버환경에서 실행시키는지, 데크스탑환경(GUI)에서 실행시키는지\
(true, false)
"""
# config.ini파일의 변수 가져오기
config = configparser.ConfigParser()
config.read('config.ini')
self.apk_directory = config.get('Setting', 'APK_DIRECTORY')
os.makedirs(self.apk_directory, exist_ok=True)
self.is_desktop = is_desktop
# 서버모드로 실행시켰다면 가상디스플레이 실행
chrome_options = webdriver.ChromeOptions()
if (not is_desktop):
self.display = Display(visible=0, size=(1024, 768))
self.display.start()
chrome_options.add_argument('--headless')
# 크롬 드라이버 실행
self.chrome = webdriver.Chrome(config.get('Setting',
'CHROME_DRIVER_DIRECTORY'),
chrome_options=chrome_options)
self.chrome.set_window_size(1024, 768)
#self.chrome.set_page_load_timeout(30)
# 크롤링할 디렉토리 리스트 저장
self.category_list = config.items('PlayStoreURL')
# 데이터를 저장하고 제어할 DBController객체 생성
self.db_connector = DBController(config.get('Setting', 'DB_DIRECTORY'))
# 메타데이터가 저장될 SQLite 테이블 생성
self.db_connector.create_table()
def setUp(self):
self.database = mongomock.MongoClient().db
post1 = {
"_id": "393",
"name": "software",
"email_address": "*****@*****.**",
"password": "******"
}
self.collection_admin = self.database.create_collection(
"Administrator")
self.collection_admin.insert_one(post1)
post2 = {
"_id": "123",
"name": "Terry",
"email_address": "*****@*****.**",
"password": "******"
}
self.collection_member = self.database.create_collection("Member")
self.collection_member.insert_one(post2)
post3 = {
"_id": "888",
"name": "meeting",
"start_time": "Apr10",
"end_time": "Apr11",
"location": "case"
}
self.collection_activity = self.database.create_collection("Activity")
self.collection_activity.insert_one(post3)
self.db = DBController(self.collection_member, self.collection_admin,
self.collection_activity)
def initialize_pool(self):
#todo:需要另一队列来监控正在使用的connection
self.pool = Queue.Queue(maxsize=self.max_pool_size)
if self.conn_at_start:
for _ in range(0, self.max_pool_size):
self.pool.put_nowait(
DBController(host=self.conf["host"],
db_name=self.conf["db_name"],
db_user_name=self.conf["db_user_name"],
psd=self.conf["db_psw"],
port=self.conf["port"]))
self.current_conn_size += 1
def __init__(self, is_desktop):
config = configparser.ConfigParser()
config.read('config.ini')
self.apk_directory = config.get('Setting', 'APK_DIRECTORY')
self.is_desktop = is_desktop
if (not is_desktop):
self.display = Display(visible=0, size=(800, 600))
self.display.start()
self.chrome = webdriver.Chrome(config.get('Setting',\
'CHROME_DRIVER_DIRECTORY'))
self.category_list = config.items('PlayStoreURL')
self.db_connector = DBController(config.get('Setting', 'DB_DIRECTORY'))
self.db_connector.create_table()
def execute(self):
try:
db_controller = DBController()
user1_balance = db_controller.select_data_single(
"users", {"username": self.__user1})['balance']
user2_balance = db_controller.select_data_single(
"users", {"username": self.__user2})['balance']
db_controller.update_data(
"users", {'username': self.__user1},
{'balance': user1_balance - self.get_valor()})
db_controller.update_data(
"users", {'username': self.__user2},
{'balance': user2_balance + self.get_valor()})
return True
except:
return False
def get_dbc(self):
# returns a db instance when one is available else waits until one is
if not self.conn_at_start and self.current_conn_size < self.max_pool_size:
dbc = DBController(host=self.conf["host"],
db_name=self.conf["db_name"],
db_user_name=self.conf["db_user_name"],
psd=self.conf["db_psw"],
port=self.conf["port"])
if not dbc:
print "cannot generate dbccontroller"
return None
self.current_conn_size += 1
dbc.new_cur()
return dbc
dbc = self.pool.get(True)
dbc.new_cur()
return dbc
def save(self):
try:
db_controller = DBController()
address = BaseUser.get_address(self)
query = db_controller.insert_data(
'users', {
'username': BaseUser.get_name(self),
'password': BaseUser.get_password(self),
'address': address.get_street(),
'cpf': BaseUser.get_cpf(self),
'admin': False,
'balance': 0
})
if query is None:
return False
else:
return True
except:
return False
def __init__(self, app, title, user, balance):
SubWindow.__init__(self, app, title)
SubWindow.set_size(self, "500x400")
SubWindow.add_label(self, "Bem vindo," + user + " .")
SubWindow.add_btns(
self,
["Historico", "Trocas", "Transferencias", "Deposito", "Logout"],
self.__btn_callback)
SubWindow.add_label(self, "Seu saldo é " + balance)
SubWindow.add_label(self, "Sua ultima transação foi ...")
db_controller = DBController()
all_users = db_controller.select_data("users")
all_users_array = []
for obj in all_users:
all_users_array.append(obj['username'])
self.historicoView = HistoricoView(SubWindow.get_app_gui(self),
"Historico")
self.trocasView = TrocasView(SubWindow.get_app_gui(self), "Trocas")
self.transferenciasView = TransferenciasView(
SubWindow.get_app_gui(self), "Transferencias", all_users_array,
user)
self.depositoView = DepositoView(SubWindow.get_app_gui(self),
"Deposito")
def __init__(self, bot):
self.state = 0
self.bot = bot
self.db = DBController()
self.mainTemplate = ""
def __init__(self, title="Poopt Bank", size="500x400"):
View.__init__(self, title, size)
View.set_btn_callback(self, self.__btn_callback)
db_controller = DBController("localhost", "pooptbank")
def __init__(self):
self.__dbController = DBController('localhost', 27017)
from DBController import DBController
from pymongo import MongoClient
from Member import Member
from Administrator import Administrator
from Activity import Activity
cluster = MongoClient(
"mongodb+srv://wz:1999314Zwh%[email protected]/test?retryWrites=true&w"
"=majority")
db = cluster["AMS"]
collection_member = db["Member"]
collection_admin = db["Administrator"]
collection_activity = db["Activity"]
db_controller = DBController(collection_member, collection_admin,
collection_activity)
# for i in range (0, 100):
# member = Member(str(i), str(i), "*****@*****.**", "member")
# db_controller.add_member(member)
# for i in range (0 ,100):
# member = Member("updated name", str(i), "updated email", "updated password")
# db_controller.update_member(member)
# for i in range (0 ,100):
# db_controller.retrieve_member(str(i))
# for i in range (0 ,100):
# db_controller.delete_member(str(i))
# Author: jun10000 (https://github.com/jun10000)
#
import os
import signal
import sys
import time
from collections import deque
from RPi import GPIO
import settings
import JunLib
import wave_signal
from DBController import DBController
db_controller = DBController()
def initialise():
GPIO.setmode(GPIO.BCM)
GPIO.setup(settings.INPUT_PIN, GPIO.IN)
global db_controller
db_controller.connect()
buffer = deque()
# noinspection PyUnusedLocal
def loop(signal_num, frame):
def main():
dbc = DBController()
#adbc = "jhfjsd"
users = scrapeRFD(dbc)
mailAll(users)
def confirm_callback(self, btn):
db_controller = DBController()
