Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Removal of the user from the bonnet database

G
gionna last edited by
Good day, morning, night.
I'm working a telebot telegram. I've been dealing with a problem where a bot doesn't send out to all users if one of them stopped the bot.
I've got a database (Text file with ID) that adds users after the bot has been launched, and it's written off without repetition, all of which.
```
@bot.message_handler(commands=['start'])
def welcome(message):
    if not message.chat.id in joinUser:
        join = open("join.txt", "a")
        join.write(str(message.chat.id) + "\n")
        joinUser.add(message.chat.id)
        join.close()
```
After which, I want to send out to all the signatories, open a file with ID and send a message to everyone on the order of this file, and there's a problem if a person's resigned, his ID from the base is not removed and the bot will hang over the message and send it to no one.
```
bot.message_handler(commands=["rs"])
def mess(message):
    if ADMIN == message.chat.id:
        for user in joinUser:
            bot.send_message(user,message.text[message.text.find(" "):])
```
Therefore, how can we verify that the user stopped the bean and removed it from the OBD system?
Reply Quote 0
1 Reply Last reply
G
guilherme last edited by

I recommend using mysql for this. In fact, when a man cuts off from a bet, you get an apdite that you can say and remove the bean from your bud.
Reply Quote 0
1 Reply Last reply

2
Posts

0
Views

Suggested Topics

D

int object is not iterable
Software Programming • python • • Duquan

2

0
Votes

2
Posts

0
Views

alpha_numThe definition is "list". (This is the reason)printI think you can see from the display by)As a result, the 9th line of code means adding an integer value to the list, such an error occurs.Maybe you wanted to do like this:alpha_numWhat do you think?alpha_num = [0 for l in range(len(alpha))]
R

database not removed
Software Programming • java android database sqlite • • Rossere

2

0
Votes

2
Posts

0
Views

I couldn't figure out where my mistake was. In documentation for method delete specified: delete(String table, String whereClause, String[] whereArgs)♪ The only way to remove the notes was to: mDatabase.delete(FAVORITE_TABLE_NAME, MOVIE_ID + " = " + movie.getId(), null);
Comparison of the first pillar element (Series) consisting of lists
Software Programming • python list pandas numpy data analysis • • Mystic

2

0
Votes

2
Posts

0
Views

Reply to the amended question:The conditions for comparing whole single and double-digits should be set. natural chips from different columns for several parameters: grad, buoy, =, grad=, grad= and indicate the difference between the values of the different columns as the conditions of comparison ((['1st'].str[0] - ['2st'].str[0]) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .It's interesting to have mathematical transactions over different values. Poles, as a condition for sorting the table.In [130]: d["1st"].str[0].astype(int) - d["2st"].str[0].astype(int) Out[130]: 0 0 1 2 2 0 3 -29 4 -37 5 -12 6 -7 7 4 8 -7 9 -3 dtype: int32 NOTE: Pandas are optimized to work with tabular data - when each cell of the table is polar. If you keep complex structures in the cells (lists, arts, dictionaries), you'll be very uncomfortable and most of the Pandas' built-in methods won't work properly with such data. Transform your data so that a flat table can be obtained or use three-dimensional structures - for example numpy or xarray♪
In order to migrate the postgre database to dynamodb in json, I would like to remove it in json format first.
Software Programming • json postgre amazon dynamodb • • Mystic

2

0
Votes

2
Posts

0
Views

N

There are two problems with SQL that can be written in.If an error still occurs even if it corresponds to this two points, along with the error message displayed Post a new question.Before the condition WHERE not writtenThe date format (format) of the condition is incorrect When specifying the date and time, space is required betweenI think that SQL after modification is as follows.SELECT to_json(table_100) FROM table_100 WHERE date(timestamp) BETWEEN '19870705 0010' AND '20200705 2400'; More date() I think that the time specification is almost meaningful because it is used. '20200705 2400' For 2020-07-06 data cannot be obtained.2020-07-06 When data is also acquired, conditions are '2020-07-06' Home '20200706' Please change. ('2020-07-05' If there is no problem with the data above, there is no need to fix it)For an example of a date format that can be used in PostgreSQL, see the documentation. https://www.postgresql.jp/document/12/html/datatype-datetime.html#DATATYPE-DATETIME-DATE-TABLE
E

Removal from the pressurization database
Software Programming • javascript php mysql web programming • • elysha

2

0
Votes

2
Posts

0
Views

First, I've made some changes to the HTML code, because I think the meaning of the optimon should reflect its meaning. Accordingly, if category 1, the optimon must be one, not two, like you. Besides, I have some doubts about the adequacy of the architecture of your application, but nonetheless. Simple example without using JS.HTML:<form action="your_script.php" class="d-md-flex justify-content-between"> <select name="category"> <option value="0">Все категории</option> <option value="1">Категория 1</option> <option value="2">Категория 2</option> <option value="3">Категория 3</option> <option value="4">Категория 4</option> <option value="5">Категория 5</option> <option value="6">Категория 6</option> <option value="7">Категория 7</option> <option value="8">Категория 8</option> <option value="9">Категория 9</option> </select> <button type="submit" class="template-btn">Найти</button> </form> PHP:<?php /* Приведённый ниже пример подключения к БД взят из оф. доков PHP Но в реальной жизни мало кто реализует такое подключение к БД. Чаще всего либо делают свою надстройку над классом mysqli, либо используют PDO. */ $database = new mysqli("db_host", "db_user", "db_password", "db_name", "db_port"); if ($database->connect_errno) { exit("Failed to connect to MySQL: (" . $database->connect_errno . ") " . $database->connect_error); } // Получаем данные из нашей HTML-формы $category = $_REQUEST['category']; // Ниже произведена простейшая проверка на корректность полученных данных if(!is_numeric($category)) exit("Category not select!"); /* Так как в вашем примере используется числовое значение номера категории, то для обеспечения безопасности достаточно проверки на числовой тип. Однако в случае с текстовыми данными не забывайте обезопасить себя от SQL-инъекций. =) */ $result = $database->query("SELECT * FROM your_table_$category;"); /* Здесь вы выполняете какие-либо действия с полученным результатом, например, вывод данных на страницу. Всё зависит от того, что вам нужно. / while($row = $result->fetch_assoc()) { / Выполняем необходимую нам работу */ } // После завершения работы с результатом запроса, не забудьте очистить память $result->close(); Though I don't know what different tables are for. If, for example, it is an Internet store, one table could be used for different categories of goods, adding a category number column. In this case, the request for OBD would look like:$result = $database->query("SELECT * FROM your_table WHERE cat_id = $category;"); Why is that? And because, in selecting all categories, it would be a little difficult to draft a sample of several tables. In my example. <option value="0"> It's all categories. Accordingly:/* Не забываем подключиться к БД и получить данные от формы */ /* Если выбрана НЕ нулевая категория, то заполняем условие выборки по категории иначе оставляем условие пустым */ $sql_where = $category != 0 ? " WHERE cat_id = $category" : ''; /* Здесь мы ВСЕГДА добавляем значение переменной $sql_where Если она пустая, то будет произведена выбора ВСЕХ значений из таблицы. Если была указана категория, отличная от 1, то переменная будет содержать условие WHERE и данный запрос осуществит выборку указанной категории. */ $result = $database->query("SELECT * FROM your_table$sql_where;"); /* Действия с результатом */ I refer below to the PHP files on which you should be consulted. And the SQL injections would be nice to read more than PHP docks than googling articles in other sources.Useful references: http://docs.php.net/manual/en/mysqli.quickstart.php http://docs.php.net/manual/en/mysqli.query.php http://docs.php.net/manual/en/class.mysqli-result.php https://www.php.net/manual/en/security.database.sql-injection.php
K

How to Validate TensorFlow
Software Programming • python • • Kadir

2

0
Votes

2
Posts

0
Views

If train_data is only repeated to increase learning and accuracy,If the data in the train_data is still 100% accurate,In fact, it is necessary to ensure the accuracy of the model studied with data other than train_data.What questioners should do validation?I realized that I should look atcuracy other than the data used for learning.For this reason, it is possible to realize the meaning that using other data from train_data with the following code# Output cost and accuracytrain_loss, train_acc = sess.run([loss, accuracy], feed_dict={ph_data:test_data, ph_labels:test_labels})valid_datafeed valid_data to loss andcuracy like test_data.By using valid_data, you can see the loss andcuracy of data that is different from the time of study. (Also test_data is the same as test_data)Parameter adjustment by valid_datavalid_data is used to verify the correct accuracy even if it is not train_data.Parameter adjustment is not done automatically.There is no mechanism that automatically performs the shape of the current model and the so-called hyperparameter.For example: https://cloud.google.com/ml-engine/docs/how-tos/using-hyperparameter-tuning has a function to tune the hyperparameter.However, I’m trying various hyperparameters in b。 processing instead of “w。 is it?” )※If you want to support over-learning, you can change the model such as putting the drop-out layer,I think that the dropout rate will be coping with the above hyperparameter tuning.
User Defined Table Types between different databases
Software Programming • sql server • • briley

2

0
Votes

2
Posts

0
Views

B

The message Operand Type Clashmeans that you have declared both types in different databases and they have some difference between them that makes the database get lost. http://technet.microsoft.com/en-us/library/ms178069(v=sql.105).aspx where Microsoft clarifies how this works, as well as recommends a number of precautions when dealing with User Defined Types.
N

How to run a Python script using PHP in window?
Software Programming • php python codeigniter • • Nykeriab

2

0
Votes

2
Posts

0
Views

G

To run it you must use PHP: exec http://php.net/manual/es/function.exec.php And have the python interpreter at the Terminal (speaking of Linux) or the Windows Command line.So you can do something like<?php exec('C:\Python27\python.exe C:\Users\Username\Desktop\my_python_script.py') Maybe it doesn't work because windows is very latent with that. In case you handle Linux, or Mac<?php exec('python my_python_script.py')
I can't make a bot telegram that removes an early number and adds it to the python aiogram database.
Software Programming • python telegram bot emergency numbers aiogram peewee • • Mystic

2

0
Votes

2
Posts

0
Views

Apparently, the problem is, cmnd.py Unanimity of variables rndm and sm♪ These functions should be triggered and variables initiated at each user ' s call.I'm guessing we should do this somehow:@dp.message_handler(commands="test") async def cmd_test(message: types.Message): import random # так при каждом вызове будет генерироваться новое число rndm = str(random.randint(1, 10)) # и будет выполняться запрос к бд для получения свежих данных u = User.get(User.tg_id = message.from_user.id) sm = str(u.test_sm) # потом обновляем данные пользователя User.update(tg_id=message.from_user.id, test_sm=rndm).execute() # возвращаем ответ пользователю await message.reply("Твоя на " + rndm + " см. Теперь твоя " + sm + " см. Поздравляю!")
C

Create user with access only to database views in MySQL
Software Programming • mysql • • charlenef

2

0
Votes

2
Posts

0
Views

Hi.I believe that if you use the following structure, you will grant permissions only the desired viewGRANT priv [(colunas)] [, priv [(colunas)]] ... ON {*.* | db.* | db.sua_view} TO usuario [IDENTIFIED BY 'senha'] [, usuario [IDENTIFIED BY 'senha']] ... [WITH [GRANT OPTION | Give a check on this link: http://www.devmedia.com.br/gerenciamento-de-usuarios-e-controle-de-acessos-do-mysql/1898
O

How do you fill the database with a user response through a telegram?
Software Programming • python sqlite3 telebot • • Oba22

2

0
Votes

2
Posts

0
Views

A

import sqlite3 con = sqlite3.connect('путь к бд') cur = con.cursor() cur.execute('UPDATE {имя таблицы} SET {имя столбца} = {данные} WHERE {столбец с идентификацией пользователя, например id} = {значение}') con.commit() cur.close() con.close() This is provided that the table in the database is already in place. If not,cur.execute("CREATE TABLE название_таблицы (название_столбца тип, название тип);") con.commit() con.close() cur.close() Read SQL requests, sqlite documentation. As you get the data from the user, I hope you know.
Split codes into .py files
Software Programming • python • • Marcee

2

0
Votes

2
Posts

0
Views

A

Using the "import":You must import the modules using the import. There are several ways to import a module, see below:import module # Importa o módulo com todos os seus dados import module as otherModuleName # Importa o módulo e troca o nome dele from module import * # Importa todos os dados do módulo from module import data1, data2, data3 # Importa dados específicos do módulo from module import data as otherDataName # Importa dados específicos e troca o nome deles What import does is run the module (script .py) and import into your program the data of this module (variables, functions and classes). See this example below:records. ♪url = "www.siteExemplo.com" name = input("Digite seu nome: ") password = input("Digite sua senha: ") validateProfile(name,password) # Função para verificar se os dados estão corretos. website. ♪import registra print("Obrigado %s por se registrar em nosso site!"%registra.name) print("Você pode fazer login clicando neste link: %s/login"%registra.url) Note that in this example, the file code records. ♪ is executed normally and his data is passed to the code being executed.Another important detail we can note is that we use the point (.) to ask for the module data. If you do not always want to use point to use the data, you can import them from the module using the asterisk (import all module data), or then importing specific data. Example:from registra import * # Importa todos os dados do módulo print("Obrigado %s por se registrar em nosso site!"%name) print("Você pode fazer login clicando neste link: %s/login"%url) Python Packages:To maintain a well-organized code, you may want to split your modules into packages. Example:Jogo Jogo/Jogador/ Jogo/Carro/Itens Jogo/Cenario/ In Python, you can import modules that are in other directories through packages. The idea of importing is the same as you saw, only before the module name is imported, you should pass the folder name followed by a point. Example:from Jogo.Jogador import Personagem from Jogo.Carro.Itens import Roda, Volante from Jogo.Cenario.Arvores import * To learn more, read the documentation https://docs.python.org/3/reference/import.html .
S

WebMaster Tools search query data CSV download using Google Data APIs Python Client Library
Software Programming • python • • Saumya

2

0
Votes

2
Posts

0
Views

S

It is not until the operation confirmation, so please refer to it. HomeFirst,example-simple-download.py Home DoDownload in the call start_date, end_date Add (Range specification)diff -Nurb -i --strip-trailing-cr -Nur a/example-simple-download.py b/example-simple-download.py --- a/example-simple-download.py 1979-12-31 00:00:00.000000000 +0900 +++ b/example-simple-download.py 2015-01-07 12:55:22.000000000 +0900 @@ -23,6 +23,7 @@ Import the downloader from downloader import Downloader +from datetime import date Email address and password used to sign-in to Webmaster Tools email = 'user@example.com' @@ -31,9 +32,12 @@ website = 'http://www.example.com/' selected_downloads = ['TOP_QUERIES'] +start_date = date(2014,12,1) +end_date = date(2015,1,1) + Instantiate the downloader object downloader = Downloader() Authenticate with your Webmaster Tools sign-in info downloader.LogIn(email, password) Initiate the download -downloader.DoDownload(website, selected_downloads) +downloader.DoDownload(website, selected_downloads, start_date, end_date) Nextdownloader.py Home(Revised)Specify the range to the URL of the data (site_json) obtained by LIST_PATH. to existing processing. Home URLrating URL LIST_PATH Home &db=%s&de=%s AddDoDownload and called from there _GetDownloadList argument start_date, end_date Increase the number of URLs with specified period parameters, and then to the existing processing. Homediff -Nurb -i --strip-trailing-cr a/downloader.py b/downloader.py --- a/downloader.py 1979-12-31 00:00:00.000000000 +0900 +++ b/downloader.py 2015-01-08 18:26:51.000000000 +0900 @@ -72,7 +72,7 @@ self._logged_in = True def DoDownload(self, site, tables_to_download): def DoDownload(self, site, tables_to_download, start_date, end_date): """Download CSV files and write them to disk. Downloader must be logged in before this method can be called, otherwise @@ -93,6 +93,7 @@ for key in tables_to_download: url = sites_json.get(key) url = url + '&db=' + start_date.strftime("%Y%m%d") + '&de=' + end_date.strftime("%Y%m%d") if url: self._DownloadFile(url)
A

How do you figure out what kind of load the VC?
Software Programming • python vkontakte api bot incontact • • Anderson

2

0
Votes

2
Posts

0
Views

E

What do you mean by maximum load? When does the bot start to answer slowly? The problem of a non-asynchronous/slight longpoll is that it handles requests consistently. And sqlite in his treatment, blocks the entire file (although it would only be a problem with asynchronicity/multilateral, or callback).Accordingly, you can measure how much your bot handles the events. And then the simulation. For example, the code is executed for 0.1 s, the bot extracts a pack of 10 events from the server. The first phaser will have a delay in the 0.1s response, 10-1s. While the bot was processing a pack of 10 seconds, the cat was able to write another 10 people, for example.I mean, the more people write in a second, the slower the bot will answer.
E

List Sort depending on another Python list
Software Programming • python • • emerson

2

0
Votes

2
Posts

0
Views

B

A very simple way is to create a list of the size of the original, and use as an index to assign each element, the order list. Something like that:lista = ['a', 'b', 'c'] orden = [1, 2, 0] lista_ordenada = [None] * len(lista) for i, o in enumerate(orden): lista_ordenada[o] = lista[i] print(lista_ordenada) ['c', 'a', 'b']

Removal of the user from the bonnet database

Suggested Topics

int object is not iterable Software Programming • python • • Duquan

database not removed Software Programming • java android database sqlite • • Rossere

Comparison of the first pillar element (Series) consisting of lists Software Programming • python list pandas numpy data analysis • • Mystic

In order to migrate the postgre database to dynamodb in json, I would like to remove it in json format first. Software Programming • json postgre amazon dynamodb • • Mystic

Removal from the pressurization database Software Programming • javascript php mysql web programming • • elysha

How to Validate TensorFlow Software Programming • python • • Kadir

User Defined Table Types between different databases Software Programming • sql server • • briley

How to run a Python script using PHP in window? Software Programming • php python codeigniter • • Nykeriab

I can't make a bot telegram that removes an early number and adds it to the python aiogram database. Software Programming • python telegram bot emergency numbers aiogram peewee • • Mystic

Create user with access only to database views in MySQL Software Programming • mysql • • charlenef

How do you fill the database with a user response through a telegram? Software Programming • python sqlite3 telebot • • Oba22

Split codes into .py files Software Programming • python • • Marcee

WebMaster Tools search query data CSV download using Google Data APIs Python Client Library Software Programming • python • • Saumya

How do you figure out what kind of load the VC? Software Programming • python vkontakte api bot incontact • • Anderson

List Sort depending on another Python list Software Programming • python • • emerson

int object is not iterable
Software Programming • python • • Duquan

database not removed
Software Programming • java android database sqlite • • Rossere

Comparison of the first pillar element (Series) consisting of lists
Software Programming • python list pandas numpy data analysis • • Mystic

In order to migrate the postgre database to dynamodb in json, I would like to remove it in json format first.
Software Programming • json postgre amazon dynamodb • • Mystic

Removal from the pressurization database
Software Programming • javascript php mysql web programming • • elysha

How to Validate TensorFlow
Software Programming • python • • Kadir

User Defined Table Types between different databases
Software Programming • sql server • • briley

How to run a Python script using PHP in window?
Software Programming • php python codeigniter • • Nykeriab

I can't make a bot telegram that removes an early number and adds it to the python aiogram database.
Software Programming • python telegram bot emergency numbers aiogram peewee • • Mystic

Create user with access only to database views in MySQL
Software Programming • mysql • • charlenef

How do you fill the database with a user response through a telegram?
Software Programming • python sqlite3 telebot • • Oba22

Split codes into .py files
Software Programming • python • • Marcee

WebMaster Tools search query data CSV download using Google Data APIs Python Client Library
Software Programming • python • • Saumya

How do you figure out what kind of load the VC?
Software Programming • python vkontakte api bot incontact • • Anderson

List Sort depending on another Python list
Software Programming • python • • emerson