Python Forum
learning Python + SQL - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: learning Python + SQL (/thread-27983.html)

learning Python + SQL - ABVSVL - Jun-30-2020

Started learning Python + SQL.
Experience 0 = ((
There is a TXT file local. How can I make requests in it? How to import TXT into SQL?

RE: learning Python + SQL - DPaul - Jun-30-2020

You give us very little information. Not knowing what the text file looks like,
the first reaction would be that in order to make requests, you don't need sql.
Simple string operations can do a lot.

paul

RE: learning Python + SQL - ABVSVL - Jun-30-2020

id |color |number |deleted|year|
-----|-----------|------------|-------|----|
21542|black |В 031 ВХ 138|true |2014|
15694|black |С053КН163 |true |2014|

in the task it is precisely necessary to use SQL queries for data selection.[Image: 4a7a3c32c76215dd8ffdec8025ae1ac5-full.png]

RE: learning Python + SQL - jefsummers - Jun-30-2020

I would read the data using Pandas, and either do the manipulations there or then loop through the Pandas dataframe and post the records into the database. Using the Pandas function read_csv with sep set to '|' and setting header should give you a start.

When you say it is necessary to use SQL, is this homework? Or are you needing the save the data for long term?

RE: learning Python + SQL - ABVSVL - Jun-30-2020

I need to upload data from. txt to sql base and make sql queries

RE: learning Python + SQL - jefsummers - Jun-30-2020

OK, I explained how I would do it.

Knowing why can be helpful as we try to help you. There may be methods you hadn't thought of. If this is homework where you have been told this must be done with SQL then that's different.

RE: learning Python + SQL - ibreeden - Jun-30-2020 

insert into cars
(id, color, number, deleted, year)
values
(21542, 'black', 'В 031 ВХ 138', 'true', 2014);
... and so on.