FacePager Modification to Insert in Mysql or MariaDB

Encerrado

Descrição

1) Change an existing Python script to connect to a different database (from SQLite to MySQL). The Python script is available here: [url removed, login to view]

and it currently uses the SQLAlquemy library to connect to a SQLite database.

So, I guess all that is needed is to change the SQLAlquemy database driver config from SQLite to MySQL.

2) Add a script that, every X hours, runs one of the already available templated queries:

<group>/members?order=date

The existing code is already executing this query when the Fetch button is pressed by the user. This query will return the last 25 members (1 page) which have been added to the group. Typically, out of those 25, the top 10 or 12 members will be new to us(ie we didnt get them in the last query we run X hours ago). The rest of the members, we already have in our GROUP_MEMBERS table.

If all of the 25 members returned by the query are new to us, then the script will run the query again to get the next 25 members and so on.

So, the input parameters into the script are:

a) the list of groups

b) X = number of hours

Habilidades: Python

Ver mais: mysql insert, php mysql insert form, secure mysql insert, bash script mysql insert, bash script mysql insert file, php mysql insert user data, mysql insert form, php mysql insert period, php mysql insert page, php mysql insert data, mysql insert statment maker, mysql insert today, php mysql insert date time, php mysql insert, php mysql insert success

ID do Projeto: #11736413

4 freelancers estão ofertando em média $35 para este trabalho

srinichal

Looking forward to discuss further details about the project and deliver the same to your specifications

$35 USD in 2 dias
(22 Comentários)
5.2
$25 USD in 2 dias
(3 Comentários)
2.5
Programmer59

Hello Sir..! I read your description I can complete your project on time and within your budget I am fully confident about your project. I will receive your best wishes. I am waiting your response thanks you so much Mais

$50 USD em 1 dia
(2 Comentários)
1.5
vinaysinghh

A proposal has not yet been provided

$30 USD em 1 dia
(0 Comentários)
0.0