SQL Queries in Python

Cerrado Publicado hace 5 años Pagado a la entrega
Cerrado Pagado a la entrega

My website is a big data analytics tool, scanning over 100 Million lines of data for every query.

Now I want you to refine my search by adding further SQL commands.

The search is written in Python and based on Elastic Search.

The website is built on Symfony.

THE JOB IN DETAIL:

1. add premade navigation bar and link content

at page bottom, fixed, z-index above all website content link content of search bar

2. add pagination

10 search results per page. Enough pages to show all results. “<” and “>” jump two pages.

3. revise search process

Country Selection

If a country is selected, only show search results of shipments which list that country in

the column “Country”. If USA is selected, show all search results.

words from multiple columns

When searching for multiple words, like for example: “the north face” + “tent”, show all search results that have all words in the columns “Consignee Name”, “Shipper Name” and “Product Desc”. Allow the words to be found in different columns. In the example above “the north face” could be found in “Consignee Name”, and “tent” in “Product Desc”.

4. revise website

delete previous search field. Scale down the height of the top navigation’s background to just underlay the links.

Elasticsearch Python SQL Symfony PHP

Nº del proyecto: #17343408

Sobre el proyecto

3 propuestas Proyecto remoto Activo hace 5 años

3 freelancers están ofertando un promedio de $57 por este trabajo

DarkKnight2206

Hello! I am a python developer. I looked at your project and it seems interesting. I have all necessary skills required for this project. Ping me to discuss in detail.

$50 AUD en 2 días
(23 comentarios)
5.1
sunilmudunuri

I'm an experienced freelancer database and report design, development and optimization with more than 9 years of experience . Relevant Skills and Experience 1) Sql Server 2005/2008/2012 2) MYSQL, MS Access 3) Oracle ( Más

$61 AUD en 10 días
(0 comentarios)
0.0