a python script - using pyparsing to scan MySql sql files.

Need a python 2.7 script - using pyparsing module to scan mysql source files.

Those Mysql files may containing multiple SQLs statements and comments.

The coding style can be different, the only assumption is that the developers of those scripts tried to make it compatible

with mysql ,

Pyparsing script needs to detect:

1. if there is more than one SQLs statement in the script.

2. find all ALTER table statements and parse those all

'alter table' statements

to detect a) database name ,

b) table name

c) and the the rest of the alter table statement, so it can be passed to percona online tool - hope you know what I am talking about. if not - google it.

IMPORTANT: parsing script must handle correctly:

- commented out statements , including multi-line comments - ignoring all commented out sqls .

- single quoted and double quoted scripts - potentially containing SQL delimiter chars - and do not stop/break

when a SQL delimiter char is in the comments or in the quoted stings

- handle different styles of specifying database , table , column names - with or without backtick qoutes and a mix of those naming styles in the same script

- detect delimiter change.

- detect missing delimiter at the end of the script and in case of multiple SQLs also detect missing delimiter in between SQls.

- handle well complex cases like when alter table sqls can have add column clause with comments on the column potentially containing characters which is a current delimiter

- I prefer to work with people who pays attention to small details , so I will ignore all bidders who will not copy/paste the phrase:

'I understood that I need to handle complex cases' as a first line in reply to me.

and I really mean it.

Here are several examples :



this should be ignored

alter table [url removed, login to view] add colum a int;


-- watch out for the semicol ";" char in the quoted string below:

alter table [url removed, login to view]


COMMENT '0 = non-cancelable; 1 = cancelable; 2 = flexible' AFTER cancellation_id;


alter table `testdb`.new_sales CHANGE IsDeleted IsDeleted tinyint(1) NOT NULL;

--------- WHAT”S NEXT: ———

Stretch goal (Phase II ) - which could be a part of this project

or filed and as a separated project assigned to the same bidder

after the above it done and accepted :

- 3 Detect if there is any syntax error mysql ( 5.6/5.7 grammar )

-4 classify if the script is DML only or a mix of DML, DDL , grants , etc

d) get the list of would be altered tables.

e)get the list of tables receiving inserts

f)get the list of tables receiving updates

g) get the list of tables receiving deletes

h) and estimate the number of affected records for DML without running DMLs

clarification: "in reply to me" means "in the proposal text"

Taidot: MySQL, Python

Näytä lisää: access exit status sql files python script, convert mysql script sql script using vbnet, mysql sql script cron, script update mysql sql, csv mysql python script, php script mysql 100k files upload finishes, python script parse csv files, user rating script using php mysql, rating script using asp mysql, mysql script using perl, vb6 login script using sql, php script mysql sql file, mysql sql files, upload script mysql, php script mysql quiz, python script text files, php script mysql drop menu, grabbing script mysql, video upload script mysql php, classified script mysql, read csv file using python script, script mysql postgresql, freeswitch script mysql, simple perl script mysql delete, script mysql dump tables

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #14738939

18 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$155 USD 3 päivässä
(23 arvostelua)
$250 USD 7 päivässä
(152 arvostelua)

Hi. I have review your job description carefully. I am a highly skilled developed with 6+ years experience in full stack web development, cross platform mobile app development like Ionic, Xamarin, Unity, Phonegap, Lisää

$222 USD 3 päivässä
(32 arvostelua)
$155 USD 3 päivässä
(19 arvostelua)

Hello. How are you today. I have read and understood this task. Relevant Skills and Experience I have strong knowledge in Database, Algorithms Design, And I'm expert in Python MySQL etc. Proposed Milestones $144 U Lisää

$144 USD 3 päivässä
(31 arvostelua)

Dear Project Owner We have 6+ years experience in Python development Relevant Skills and Experience [login to view URL] (Python/Django) [login to view URL] (Python/Django/AngularJS) [login to view URL] Lisää

$277 USD 5 päivässä
(5 arvostelua)
$155 USD 1 päivässä
(3 arvostelua)

Hi, looks like a cool idea to me. I can give it a try. and I can surely give you a demo. let's take this on chat and we can take it more and we can talk and work on this. Node.js developer and python developer here. Lisää

$220 USD 10 päivässä
(4 arvostelua)
$100 USD 3 päivässä
(3 arvostelua)

data extraction from sql database scripts Relevant Skills and Experience python sql machine learning data science software architecture algorithm Proposed Milestones $166 USD - final

$166 USD 3 päivässä
(6 arvostelua)

Hi, I am a python developer with coding experiece over 10 years for applications, tools and especially scripts like our project.. I am interested to bid for that. Relevant Skills and Experience Python, RE, Pyparsing, Lisää

$250 USD 14 päivässä
(1 arvostelu)

$133 USD 2 päivässä
(0 arvostelua)

a python script - using pyparsing to scan MySql sql files. Relevant Skills and Experience MySQL, Python Proposed Milestones $155 USD - a python script - using pyparsing to scan MySql sql files.

$155 USD 5 päivässä
(0 arvostelua)

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. I am a serious bidder here and I have already worked on a similar project Relevant Skills and Experience I have checked your requi Lisää

$99 USD 3 päivässä
(0 arvostelua)

I am a multimedia engineer and an experienced Python developer. I have worked on many python projects and would be happy to work on your project for you. Relevant Skills and Experience Python Proposed Milestones $155 Lisää

$155 USD 3 päivässä
(0 arvostelua)
$55 USD 2 päivässä
(0 arvostelua)

A proposal has not yet been provided

$150 USD 1 päivässä
(0 arvostelua)

Resulting parser will use pyparsing best-practices (results names, BNF, comments, out-of-order). As the author of pyparsing, I have more experience with this library than any other bidder. Relevant Skills and Experien Lisää

$555 USD 8 päivässä
(0 arvostelua)