Em Andamento

Write a Python GUI program which executes MS-SQL commands and posts it to a PHP webpage

Please author a program which can be downloaded from my website and run on a Windows computer which completes these functions. The below is a summarized list, a completed spreadsheet of requirements will be sent upon acceptance of the project job.

[PHP]

1. “if Post is Empty”, display instructions to user to download [EXE] and run it. (Text instructions will be provided by me.)

2. “if Post is not Empty and firsttime=yes”, send an email to <useremail> with text “Your report is submitted; review it by clicking this link http://...php?method=post&firsttime=no&name=name&etc=etc”

3. “if Post is not Empty and firsttime=yes”, also save the displayed webpage to a file ~/<useremail><datetime>.txt

4. “if Post is not Empty”, display an HTML report <see Command List> which looks similar to:

<table>

<tr><td>User Name</td><td>$name</td></tr>

<tr><td>User Email</td><td>$email</td></tr>

<tr><td>SQL Version</td><td>$sqlver</td></tr>

<tr><td>Count of Documents</td><td>$doc_cnt</td></tr>

<tr><td>Text1</td><td>$var1</td></tr>

<tr><td>Text2</td><td>$var2</td></tr>

etc…

[EXE]

1. This will be written in Python then made “standalone” using PyInstaller

2. Upon running, program will display a UI which receives input from user for some information: Name, EmailAddress, MS-SQL Server Name, MS-SQL Username, MS-SQL Password.

3. The UI has an "Console" which displays results and errors during running. If a command fails, the console/log will display an error message and pause (e.g. "Failed to log in to SQL Server: Username/Password Incorrect")

4. The UI has a button “Read List of Databases” which can be clicked by the user.

5. When user clicks “Read List of Databases”, program will attempt to connect to SQL and read this SQL command: Select Dbname From Vaultlist

6. Upon success, the UI will display a list of <Dbname> and allow the user to select One Single Dbname. The list may require a vertical scroll depending on quantity displayed.

7. The UI has a button “Generate Report from Selected Database” which can be clicked by the user after user has selected One Single Dbname

8. The program will connect to the SQL server. The program will use a specific database (Use <Dbname>). The program will then execute approximately 40 SQL commands and store the results <see Command List>

9. The program will generate a HTTP Post URL to the [PHP] based on the results of the SQL commands.

10. The UI Console will display the HTTP URL. The UI Console will display “Loading Default Web Browser…”

11. The program will attempt to open a Default Web Browser and launch the HTTP Post URL to the [PHP].

12. The UI has a button "Close Program". When the user clicks this button, the program closes.

[Command List]

You will be provided a list in Excel format which has approximately 40 rows and these columns:

DISPLAY TEXT, VARIABLE NAME, SQL COMMAND

User Name, name, N/A (Manual User Entry)

User Email, email, N/A (Manual User Entry)

SQL Version, sqlver, SELECT @@VERSION

Count of Files, doc_cnt, SELECT COUNT(*) FROM FILES

Text1, var1, SELECT COUNT(*) FROM TABLE

Text2, var2, SELECT AVG(*) FROM TABLE2

etc.

Habilidades: Microsoft SQL Server , Python, PHP

Veja mais: sms gateway program net framework sql freelance program, visual basic changing gui program, run sql commands perl script simple, java gui program, python gui commands, java write gui program java, write simple gui program, write java program convery xml sql, input data ms sql asp mysql php, write basic mathematical program gui, write code invoice number invoice number ms sql vb net, python gui sql, write a short program python, how to write a roulette program in python, calculator program in python gui, python django ms sql server, scientific calculator program in python gui, write python program that asks user to input their name along with age and store data in a text file

Acerca do Empregador:
( 2 comentários ) San Jose, United States

ID do Projeto: #31929171

Concedido a:

(77 Comentários)
6.3

33 freelancers estão ofertando em média $584 nesse trabalho

sapnathakur14

Hello, Warm Greetings! Upon checking your project, I am pretty sure I can produce high-quality and perfect results for your project. By using Python, I used to make AI engines, BOT, Web Scraping Tools, and so on. PHP, Mais

$600 USD in 7 dias
(83 Comentários)
7.5
Lightcanon

Hello. I am Python expert developer with +6 years of experience in desktop apps development in Qt (PyQt5). I have wrote many product-grade GUI applications in PyQt5 (including packaging them in Pyinstaller). Therefore, Mais

$750 USD in 4 dias
(120 Comentários)
6.7
DeveloperDaut

***Python Specialist*** Hello, how are you? I've read your project description carefully. You want to write a Python GUI program which executes MS-SQL commands and posts it to a PHP webpage. As a senior python develope Mais

$700 USD in 5 dias
(24 Comentários)
6.2
(24 Comentários)
6.4
(31 Comentários)
5.9
badarmadni927

I'm an experienced data scientist with hands-on experience in building recommendation system and personalization model. I hold an MS.c in software engineering majoring in AI. I'm also a seasoned developer with over 5 y Mais

$800 USD in 23 dias
(28 Comentários)
6.0
(52 Comentários)
5.8
sergeykolesniko3

Hi, there. I am a Python developer with 5+ years of experience Skills: PyQt, PySide/PyQt,Scrapy, BeautifulSoup 4, Pillow, Matplotlib, Xml, json, and csv modules. Let me do this job for you now just to prove my expertis Mais

$630 USD in 20 dias
(25 Comentários)
5.4
johnfidel98

Hi there, I have just read your project description... i can develop the python gui app using wxpython gui module or tkinter (whichever you prefer) You mentioned 40 commands... pls send list and ui design for the GUI

$600 USD in 10 dias
(64 Comentários)
5.7
loyidandrews

Hi, How are you? Very happy to bid your project because my skills are fitted in your project. I have 12 years experience in Python ,PHP, SQL. I will do my best to provide the results you are looking for. If you send th Mais

$500 USD in 7 dias
(13 Comentários)
5.1
(5 Comentários)
5.1
(8 Comentários)
5.1
(12 Comentários)
5.0
mlobovic

Hi Nice to meet you. I have read your job carefully and I'm very confident about your job. As a talented application developer, I have much experience with Python and MySQL for more than 10+ years. If you give me a cha Mais

$500 USD in 4 dias
(13 Comentários)
4.7
hayteekeys

helllo, I have worked both full time and part time as a Windowsac desktop/embedded C/C++(MT4, 5)/C#/PYTHON/JAVA developer for over 7 years now, I have done many simple and complex projects with Visual Studio and C++, A Mais

$400 USD in 2 dias
(15 Comentários)
5.2
pksaini1990

Hi, We have worked on many Python and PHP projects. We can help you in this project. We have team of expert and experienced full stack developers for this project. We will provide solution as per your requirements. Can Mais

$550 USD in 30 dias
(10 Comentários)
5.3
opensysknw

Hello, I have gone through the requirements mentioned by you for your project - Write a Python GUI program which executes MS-SQL commands and posts it to a PHP webpage. Let us chat on - [login to view URL] in deta Mais

$500 USD in 7 dias
(24 Comentários)
4.7
(6 Comentários)
4.2
nenadudovicic111

Hello? I have read your description. I can provide the great result that you are asking for as I have rich experience in here. Could you please open your chat box for me? Let's get a great result together. Thanks.

$555 USD in 3 dias
(6 Comentários)
3.9
devroma

Hi, Dear I`ve read your project post very carefully and I`m really interest in your project. I`ve rich 6+years of experience and knowledge in this field. If you hire me, I can start right now and I`ll provide you wit Mais

$630 USD in 7 dias
(3 Comentários)
4.1