def top10_users(main_user):
database = DataBase()
like_users = main_user.like_users_get()
like_users_dict = dict()
like_users_photos = dict()
for user in like_users:
if database.check(user):
other_user = User(str(user))
other_user.data_user_get()
other_user.groups_get()
other_user.friends_get()
like_users_photos[user] = other_user.photos_get()
like_users_dict[user] = main_user.compare_user_with(other_user)
print('...')
else:
continue
like_users_dict = sorted(like_users_dict.items(),
key=lambda x: x[1],
reverse=True)
data_to_db = list()
for user in like_users_dict[0:10]:
top10_users_dict = dict()
user_photos = like_users_photos[user[0]]
photos_list = list()
for photo in user_photos:
photos_list.append(photo[0])
top10_users_dict['user_id'] = user[0]
top10_users_dict['user_page'] = 'https://vk.com/id' + str(user[0])
top10_users_dict['photos'] = photos_list
data_to_db.append(top10_users_dict)
database.add(data_to_db)
return data_to_db
def routine(channelid):
db = DataBase()
video_list = db.get_video_list(channelid)
video_list = np.array(video_list)
# video_list[:, 0]
yt = YouTubeComment(db, channelid, DEVELOPER_KEY_LIST)
for videoid in video_list[:, 0]:
print(videoid, end='|', flush=True)
yt.get_comments(videoid)
def printWithWellProdDate(self,wellID,prodDate,product):
db = DataBase(config.get_file_dir() + 'database.xlsx')
md = db.getMonthlyDataByWellProdMonthProduct(wellID,prodDate,product)
well = db.getWell(wellID)
royalty = db.getRoyaltyMaster(well.lease)
lease = db.getLease(well.lease)
calc = db.getCalcDataByWellProdMonthProduct(wellID,prodDate,product)
ws = RoyaltyWorksheet()
ws.printSaskOilRoyaltyRate(md,well,royalty,lease,calc)
async def app_factory(self):
try:
pool = await aiomysql.create_pool(
host=db_config["host"],
port=int(db_config["port"]),
user=db_config["user"],
password=db_config["password"],
db=db_config["db"],
minsize=int(db_config["minsize"]),
maxsize=int(db_config["maxsize"]),
loop=self.loop,
autocommit=True,
pool_recycle=7 * 3600)
self.db = DataBase(pool)
except Exception as e:
logging.error(e)
def report_it(e):
logger.error("产生了无法预知的错误")
logger.error("错误内容如下:")
error = form_report(e)
logger.error(error['string'])
logger.error('文件 %s' % error['file'])
logger.error('行号 %s' % error['line'])
logger.info('正在尝试反馈错误...')
logger.info('尝试发送bug报告邮件...')
send_report(error)
logger.info('发送bug报告邮件成功')
try:
logger.info('尝试把bug发送到远程数据库...')
from database.database import DataBase
_db = DataBase()
_db.error_report(error)
except Exception as e2:
logger.error('把bug发送到远程数据库失败')
send_report(e2)
logger.info('发送bug报告完成。')
sys.exit(1)
def top10(main_user):
database = DataBase()
data_from_db = database.data_record()
for user in data_from_db:
print(user['users_list'])
select_users = main_user.select_users_search()
select_users_dict = dict()
select_users_photos = dict()
for user in select_users:
if database.check(user):
other_user = VKuser(str(user))
other_user.select_user_info()
other_user.groups()
other_user.friends()
select_users_photos[user] = other_user.photos()
select_users_dict[user] = main_user.compare_user_with(other_user)
print('...')
else:
continue
select_users_dict = sorted(select_users_dict.items(),
key=lambda x: x[1],
reverse=True)
data_to_db = list()
for user in select_users_dict[0:10]:
top10_users_dict = dict()
user_photos = select_users_photos[user[0]]
photos_list = list()
for photo in user_photos:
photos_list.append(photo[0])
top10_users_dict['user_id'] = user[0]
top10_users_dict['user_page'] = 'https://vk.com/id' + str(user[0])
top10_users_dict['photos'] = photos_list
data_to_db.append(top10_users_dict)
database.add(data_to_db)
return data_to_db
def register_user():
database = DataBase()
database.register_adherent(request.form)
return redirect(url_for('register'))
def register():
database = DataBase()
adherent_inputs = database.get_all_columns_of_table("adherent")
types_of_adherent = database.find_all("type_of_adherent")
return render_template('register.html', adherent_inputs=adherent_inputs,
types_of_adherent=types_of_adherent)
def index():
database = DataBase()
return render_template('index.html', users=database.find_all("adherent"),
columns=database.get_all_columns_of_table("adherent"))
def test_getMonthlyDataByWellProdMonthProduct(self):
db = DataBase(config.get_file_dir() + 'database new.xlsx')
md = db.getMonthlyDataByWellProdMonthProduct(6, 201501, 'Oil')
self.assertRaises(AppError, db.getMonthlyDataByWellProdMonthProduct,
99999, 201512, 'Oil')
global args
args = parser.parse_args()
logging.basicConfig(level=logging.INFO)
logger = logging.getLogger(__file__)
logger.info(pformat(args))
# load model and tokenizer
global model
global tokenizer
model, tokenizer = load_model_tokenizer(args)
# # sample personality
global personality
personality = sample_personality(tokenizer, args)
logger.info("Selected personality: %s",
tokenizer.decode(chain(*personality)))
# instantiate db connection
global db
db = DataBase()
personality_decoded = [tokenizer.decode(x) for x in personality]
db.push_personality(personality_decoded)
# clear history collection in db
db.clear_history()
# generate_from_seed(args, model=model, tokenizer=tokenizer, personality=personality, db=db)
# launch app
run_with_ngrok(app)
app.run()
def __init__(self, **kwargs):
super(VectorLogicAdapter, self).__init__(**kwargs)
self.db = DataBase()
self.stemmer = Stemmer()
def create_index_search(field_name):
db = DataBase()
db.create_indexes_search(field_name)
def __init__(self, sim_threshold=0.3, user=None, post=None, num_of_recommend_post=None):
self.database = DataBase()
self.user = user
self.post = post
self.num_of_recommend_post = num_of_recommend_post
self.SIM_THRESHOLD = sim_threshold
from database.database import DataBase database = DataBase() database.create_tables()
