Kapalı

Delphi SQL parser

Write or preferably enhance existing code to parse Oracle OR SqlServer SQL SELECT statements.

The goals are:

1) Parse out the selected "fields" in such a way that they can be used in populating a filter. This would also mean excluding constants from field list since filtering on COL4 if it is in select as 'ABC' as COL4 makes no sense. However, COL1 + ', ' + COL2 as CO4 would be valid.

2) Determine where in selected statement the filter is to go.

3) Locate where supplied parameters are to go (typically in where clauses) AND COL1 = :MyArg

Note the routine must be able to correctly parse very complex SQL containing functions, sub selects, unions, etc.

Thus, if ...,COL1,CASE WHEN [url removed, login to view] IS NOT NULL THEN FUNC1([url removed, login to view]) ELSE '' END AS COL2, ...

is part of select then filter would have label like "Col2" and if user specified Col2 should contain '12' the filter may look like

... AND (CASE WHEN [url removed, login to view] IS NOT NULL THEN FUNC1([url removed, login to view]) LIKE %12%) AND ...

and need to be placed in proper spot in a select that may or may not have a WHERE clause or may have several where clauses that are part of sub-selects, etc.

We have existing code that does a of this reasonably well, but still has issues. That could be used as starting point or some other existing open source or proprietary code could be suggested provided the licensing does no require releasing our code that makes used of it (GPL, etc.) Ideal solution would be a rules based lex type parser. GPL code can be considered if author is willing to grant us an alternate licence (perhaps for a fee) that is is more acceptable to us. We would need the source and would prefer it be in Delphi and be currently supported by author. If a fee to use code is required, we would have to agree to it, but would be willing to pay the fee.

You will be interfacing with another Delphi developer. We just have too many projects to focus on on this now and thought it would be a good thing to outsource.

General SQL Parser VCL version may be a good starting point or something based on a grammar like http://www.felix-colibri.com/papers/db/sql_parser/sql_parser.html. (However, I've had trouble reaching felix recently to work out licensing issues.)

Beceriler: Delphi

Daha fazlasını görün: sql parser delphi, sql open source projects, sql developer outsource, sql developer open source projects, sql developer open source, sql code oracle, outsource solution, oracle sql projects, oracle functions sql, Oracle Developer projects, open source sql, licensing solution, delphi projects open source, delphi for developer, delphi developer outsource, code developer outsource, by author, oracle sql with, write a grant, outsource oracle, oracle outsource, sql projects, oracle projects, Delphi developer, delphi filter

İşveren Hakkında:
( 8 değerlendirme ) United States

Proje NO: #6533048

14 freelancers are bidding on average $552 for this job

gyk

Hello, I am happy to create such a parser for you. I have been working with Delphi for more then 10 years...I also familiar with complex queries in Oracle, I am writing them too...

in 10 gün içinde555$ USD
(10 Değerlendirme)
5.2
winnet21

Dear friend , I have experience with delphi please reference programs that I done use delphi: [url removed, login to view] Look forward to working with you!! Best Regards Duc

in 20 gün içinde555$ USD
(15 Değerlendirme)
5.1
zakirahmouni

Aucune proposition n'a encore été fournie.

in 5 gün içinde388$ USD
(4 Değerlendirme)
2.5
pascalcoders

Hello sir, i am new at freelancer, i have experienced in Delphi programming since 1997, using many version of Delphi since Delphi 6 until Delphi XE3. has been experienced in Database Programming using MySQL, Inte Daha fazlası

in 7 gün içinde400$ USD
(1 Değerlendirme)
1.4
harshankn

I have 4+ years of experience in Delphi as well as in PL/SQL. I am working in a CMMI level 3 company in NCR India. I have worked on many support and enhancement projects in healthcare and retail domain. I have experien Daha fazlası

in 15 gün içinde722$ USD
(0 Değerlendirme)
0.0
Fabricioliver

A Fast development with the best Delphi programmer in [url removed, login to view] Best Regards Fabricio Taguatinga

in 3 gün içinde555$ USD
(0 Değerlendirme)
0.0
DavidLiu80

Hi, I am a full-time freelancer with over 13 years experience in web, desktop and mobile app developing. I have developed a lot of websites, desktop apps and mobiles apps and I have wonderful experience in freelancer's Daha fazlası

in 10 gün içinde736$ USD
(0 Değerlendirme)
0.0
centurion111

I'm quite experienced with Delphi and wrote tons of parsers in my career, including a small script language which is used to configure a map database test system (write algorithms to count amount of features that has t Daha fazlası

in 10 gün içinde444$ USD
(0 Değerlendirme)
0.0
yaradahlia

Good day. I am a programmer from Europe, Romania and I am willingly to take a shot at your parser if you trust my abilities. The way I will proceed is the following. Let's take an example: SELECT [url removed, login to view], [url removed, login to view] Daha fazlası

in 20 gün içinde250$ USD
(0 Değerlendirme)
0.0
yubor

hi. would be glad to help you with this great project. regards, yuri .

in 45 gün içinde555$ USD
(0 Değerlendirme)
0.0
ratike

Még nem kapott javaslatot

in 7 gün içinde555$ USD
(0 Değerlendirme)
0.0
UnrealEngine

you need SQL Builder in can do it for you , i have 9 years experience in delphi and such like applications , i make application like this for mysql database to help web programmer to generate code from database . T Daha fazlası

in 10 gün içinde555$ USD
(0 Değerlendirme)
0.0
twodogknight

Hi, I am actually an employer on Freelancer. I joined to hire some php programmers and graphic artist for my Adirondack Bucket List website. However, I am also a Delphi Developer - have been since 1995. I just saw your Daha fazlası

in 7 gün içinde500$ USD
(0 Değerlendirme)
0.0
rsen75

A proposal has not yet been provided

in 12 gün içinde736$ USD
(0 Değerlendirme)
0.0
vikasots

I have worked already SQL Parser. I have full source code of parser having all possibale conditions e.g like, where, between, select etc. I can provide you working source code for that. I am a Delphi developer From Daha fazlası

in 15 gün içinde722$ USD
(0 Değerlendirme)
0.0