90301 / dynamicquery Goto Github PK
View Code? Open in Web Editor NEWC# / Java Library for creating sql queries based on use. Similar to compile time optimizations
C# / Java Library for creating sql queries based on use. Similar to compile time optimizations
If the user so desires for certain object, they can specify the columns that they want to use, and the code generator will only produce those fields, saving memory.
☑ Select columns to generate (saves memory)
☑ Column
☐ Column
☑ Column
Generate and read an XML file for program configuration.
Option 1:
private const string NAME_CONST = "name";
public static ColVariable NameColVariable = new ColVariable(NAME_CONST, qmd);
...
jt1.addSameColJoin(NAME_CONST);
Option 2:
public static ColVariable NameColVariable = new ColVariable(NAME_CONST, qmd);
...
jt1.addSameColJoin(NAME_CONST);
Personally I'm leaning more towards constant generation as it might be easier to maintain the code if you don't have to change the text in multiple places.
Have the ability to cache results (This is an opt in feature for a given collection / object)
Some Cache Strategies:
Select * with a count of 1
Intended to get all column names.
Intended to be used by C# Code Generation and SQL auto-complete / builders.
Look into Case Statement support for "Special" Columns.
Also, Test performance of SQL vs C#.
One way to handle collection loading would be to pass the collection to a method
MyCollection = qmd.loadToCollection(MyCollection);
http://csharp-station.com/Tutorial/AdoDotNet/Lesson02
This should help with setting up a connection to a SQL database.
Default behavior for joins (Code Generation Version) should look for column names that are the same. Better behavior would be to look for key relationships.
Method that gets the efficient table with joins only occurring where it is relevant. Similar to getFullTable() method.
NOTE: I think this can only use LEFT JOINS. If any other type of join is used with the potential of data loss, it must throw an error and/or call getFullTable()
List out columns of SQL Query in C# Code Generator.
Similar process can be used for a col choose (For optimized queries)
select cols with blacklisted and replacement words.
I'm trying to set this static delegate method that will be called every time a "SELECT" Statement is fired off. It seems to be giving me an error, so I suppose I have the syntax wrong or something.
Inspired By:
https://stackoverflow.com/questions/7367152/dynamically-assign-method-method-as-variable
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.