|
This my friends, is really neat.
With my GFX library:
template<size_t BitDepth>
using bgrx_pixel = gfx::pixel<
gfx::channel_traits<gfx::channel_name::B,(BitDepth/4)>,
gfx::channel_traits<gfx::channel_name::G,((BitDepth/4)+(BitDepth%4))>,
gfx::channel_traits<gfx::channel_name::R,(BitDepth/4)>,
gfx::channel_traits<gfx::channel_name::nop,(BitDepth/4),0,(1<<(BitDepth/4))-1,(1<<(BitDepth/4))-1>
>;
You can then do auto col = color<bgrx_pixel<32>>::purple and get a pixel back in the format of 0xBBGGRRFF (where RR GG and BB are each a byte and represent the red, green, and blue color channels, and FF is just a NOP channel - unused - and set to 0xFF). Purple would be like 0xFF00FFFF.
With this you can create bitmaps (bitmap<bgrx_pixel<32>>)in this format and feed them right to DirectX, which happily eats bitmaps with this pixel footprint.
The template code to make this work is pretty crazy. The fact that it's pretty easy to declare new pixel formats made it possible for me to port my code from IoT to DirectX on a PC so I can rapidly prototype without having to upload to a device each time.
I've never really used this feature in the wild. My color format is usually either 16-bit color, monochrome or grayscale.
It was confusing at first though because originally my nop channel was an alpha channel, and so it wasn't rendering (black screen) because DirectX is set to ignore that channel, and my GFX library assumed it would be respected.
Anyway, after I overcame that the rest was easy. Same code of mine works in Arduino, ESP-IDF, probably Zephyr, and now the PC.
Say what you want about C and C++ they truly run everywhere.
Check out my IoT graphics library here:
https://honeythecodewitch.com/gfx
And my IoT UI/User Experience library here:
https://honeythecodewitch.com/uix
|
|
|
|
|
Congratulations! That is worthy of a celebration, however you celebrate! Someday maybe I'll have time to master such code as well - it sounds fun!
|
|
|
|
|
What I find really amazing is that the compilers can actually deal with such source. You can probably guess that i have never written a compiler.
|
|
|
|
|
Nor me I leave that to the propeller heads 
In a closed society where everybody's guilty, the only crime is getting caught. In a world of thieves, the only final sin is stupidity. - Hunter S Thompson - RIP
|
|
|
|
|
C++ compilers are something else, even at that. Pure magic.
Check out my IoT graphics library here:
https://honeythecodewitch.com/gfx
And my IoT UI/User Experience library here:
https://honeythecodewitch.com/uix
|
|
|
|
|
"A little time, a little trouble, your better day"
Badfinger
|
|
|
|
|
I'm wondering how it will work in 32/64?
I mean at compile time, where you don't know what the target machine runs on.
|
|
|
|
|
I have some information about the target machine like endianness and word size. If I don't support the platform you can fill in the information with -D defines.
Check out my IoT graphics library here:
https://honeythecodewitch.com/gfx
And my IoT UI/User Experience library here:
https://honeythecodewitch.com/uix
|
|
|
|
|
I should add, this routinely runs on 32-bit machines. This code is now running on a 64-bit machine.
Check out my IoT graphics library here:
https://honeythecodewitch.com/gfx
And my IoT UI/User Experience library here:
https://honeythecodewitch.com/uix
|
|
|
|
|
Does 32 not run in 64?
The other way around I know that is not possible / so easy, but I thought 32 would not be a big deal in 64
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
You're thinking of the x86 platform. That might not apply to microcontrollers or SBCs.
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
true 
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
I have a need to write a small SQL parser and try to look for an example.
my SQL parser is very minimal: just need to extract all field names and tables that are used this SQL statements.
any good example to recommend?
my business need is to extract all field names and database names associated with these fields:
select a.var1,
a.var2,
b.var3,
b.var4
from db1 a left join db2 b
on a.var5=b.var5
;
my need is to put these vars into this form in Excel workbook:
db1 var1
db1 var2
db2 var3
db2 var4
thanks a million!
diligent hands rule....
modified 16-Sep-23 15:04pm.
|
|
|
|
|
GoldParser has a SQL Grammar for it. You might use that. Just google GoldParser. It's for .NET and I think old VB
Check out my IoT graphics library here:
https://honeythecodewitch.com/gfx
And my IoT UI/User Experience library here:
https://honeythecodewitch.com/uix
|
|
|
|
|
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
diligent hands rule....
|
|
|
|
|
For what purpose? What are you trying to do? It sounds like a bad idea.
|
|
|
|
|
my business need is to extract all field names and database names associated with these fields:
select a.var1,
a.var2,
b.var3,
b.var4
from db1 a left join db2 b
on a.var5=b.var5
;
my need is to put these vars into this form in Excel workbook:
db1 var1
db1 var2
db2 var3
db2 var4
diligent hands rule....
modified 16-Sep-23 15:03pm.
|
|
|
|
|
It's not something I would want to tackle. I suppose that handling the basics like you show could be doable, but things like subqueries and CTEs would be problematic.
Do you think you'll need to support things like
SELECT X + Y AS Z ... ?
And which flavor of SQL? PL/SQL, T-SQL, etc.
|
|
|
|
|
Probably something that I would enjoy doing but not sure I would attempt to say it was "small".
I agree with your examples.
Not to mention is the SQL only going to come from SQL scripts? Or also from other code bases.
|
|
|
|
|
|
thanks for the link. I prefer SQL datatable one.
diligent hands rule....
|
|
|
|
|
A good example no, sorry.
But next question I recommend you to write it in the proper section 
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
I just look for some thoughts here, not a specific language implementation.
I may need to implement my request by other scripting languages such as SAS.
diligent hands rule....
|
|
|
|
|
Sorry, for me looks like a question. Not a question about code, but a still a programming question.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Southmountain wrote: I may need to implement my request by other scripting languages such as SAS.
Huh?
You want to try to implement a SQL Parser using 'SAS' (whatever that is)?
Seems like a bad idea to me.
I have written interpreters. And one compiler.
I have been using Perl for 40 years and I have parsed SQL using that before. Multiple times.
I have also taken a class on compiler theory so I do know what goes into a parser.
And in my estimation with your general description you are setting yourself up for failure. Or for writing a lot more code than you expect.
Thing that can impact the actual project
1. How structured is the SQL? For example if this is dumped from a SQL database tool the form is exact, but if it is human created files then the form will be all over the place.
2. How much SQL exists? 1,000 lines? 10,000? 1 million? The more lines the more likely variations will exist.
3. How often will this need to happen. Every day? Every day for each customer? Only one time and never again?
Consider the following case
1. You are parsing some SQL script files. By that I mean that there is nothing in those files except SQL.
2. Those script files are in use. So you know absolutely that the SQL is valid.
3. This is one time project
4. The number of files are low (total number of lines are probably less than 10,000)
6. You can add a manual step in the process to deal with the more complex examples.
Given the above, and that I really know how to do the above in Perl, this would be a fairly easy project for me.
I however would NOT attempt to do it in Python. Because I have never used Python.
I would not choose to do it in C# nor Java even though I know those languages very well because I know that Perl is going to be better at doing the real work that is needed.
If the project was much bigger than what I suggested above then I would look at making a real parser. Probably in C# or Java. C++ is an option but since it has been so long since I used that I would prefer one of the others. I would do that even though I has been a long time since I made a real parser (versus just munging a solution.) But that is going to become a problem if I could not find an actual BNF type description of the SQL being targeted. There is no way I would attempt to write my own BNF for any of the major databases without vastly increasing the timeline for the work. (And I have written a BNF before and read others.)
Note also that if there are different types of SQL then one needs a parser for each regardless of how one implements it.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
