Comments (11)
I'm separated DB Trigger, DDL Trigger and Trigger, but can't generate script for DDL Trigger because rdb$types not defined this rdb$trigger_types
See https://github.com/Jdochoa/flamerobin/tree/FB3
from flamerobin.
Just to congrat @Jdochoa
It's looking great!
from flamerobin.
My suggestions is:
- Rename FunctionSQLs for just Functions
- Rename Global temporary tables for just Global Temporaries
- Hide System tables and System domains
- Add Indexes node
- Rename Generators to Sequences (in the future with this issue #54)
Here the full list:
- Database Triggers
- DDL Triggers
- Domains
- Exceptions
- Functions
- Global Temporaries
- Indexes
- Packages
- Procedures
- Roles
- Sequences
- Tables
- Triggers
- UDFs
- Views
Here is the Red Expert as reference:
from flamerobin.
* Hide **System tables** and **System domains**
- Why would that be good to anyone?
- How would you check / set field-domains in a <1.5 version DB without them?
- How could you learn / analyse how the FB system works?
from flamerobin.
* Rename _Generators_ to **Sequences**
After 20 years of working with FireBird > It would be a pain looking for "Generators" in the list, but not finding them.
But maybe it would be OK, to enhance it:
GENERATORS / SEQUENCES or:
GENERATORS (SEQUENCES)
Maybe later there would be an option at the global-settings of FlameRobin:
[ x ] "Use the word "sequence" instead of generator.
if someone is checking that >> everything would be replaced visually. But that would also create lot's of problems. (Like: opening an old DB, or someone is trying to write "create sequence ...", also the auto-script system...)
from flamerobin.
* Add **Indexes** node
That's a great idea! 👍
from flamerobin.
I'm separated DB Trigger, DDL Trigger and Trigger...
@Jdochoa
Why not putting them in a SUB-tree folder ? (And create +1 folder in the 1. place to show ALL.)
[-] Triggers
[-] ALL Triggers
CONN1_TR
...
[+] Database Triggers
[+] DDL Triggers
[+] Table Triggers
So everyone would see ALL, making it easy to find one by name in ABC order.
- That would also maintain similar view with older users who are used to this program.
- What if later a NEW type appears in FB5 which does not fit to any category? ("ALL Triggers" would still show it!)
Separating them so "far from each other" makes much more difficult to find ONE trigger by name!
(Also, at first sight nobody can see there are more folders that would normally need somehow "stick together".)
By default > if you click [+] sign next to the Main folder >> the "ALL Triggers" sub-tree should auto-open to show ALL.
If it's too difficult to make sub-sub tree-folders, at least rename them, so these be sorted after each other:
TRIGGERS - ALL
TRIGGERS for Database
...
from flamerobin.
Just my thoughts:
I liked this idea:
[-] Triggers
[-] ALL Triggers
CONN1_TR
...
[+] Database Triggers
[+] DDL Triggers
[+] Table Triggers
Maybe I would just change the subfolder pattern, you don't need to reinforce that "All" , "Database", "DDL" and "Table" refers to triggers, they are already inside triggers, doesn't change a lot, but "less is more" ;)
[-] Triggers
[-] ALL
CONN1_TR
...
[+] Database
[+] DDL
[+] Table
I agree with Rename FunctionSQLs for just Functions
, but maybe for now, keep like this because "Functions" where used for UDFs and this kind of changes goes easy for a bug/miss-renaming or something like that if you don't take care enough
System Tables exists from along time, I disagree with removing it
... for now, it's it :)
Thanks for your effort helping Flamerobin
from flamerobin.
Hi all
- Hide System tables and System domains: This is configurable in preferences database.
- Add Indexes node: It's a good idea, I'll work on it
- Rename FunctionSQLs for just Functions: I agree.
- Put them in a SUB-tree folder: I agree.
- Rename Global temporary tables for just Global Temporaries: I agree, i change it.
- Rename Generators to Sequences: I'm not sure. I'm think we should keep backward compatibility with FB and FR.
from flamerobin.
Hi @PizzaProgram , @arvanus and @Jdochoa
Let's leave GENERATORS for now instead of SEQUENCES.
We think better about this change in the bug #54
For a better organization of the triggers we can do as PizzaProgram suggested:
[-] Triggers
[+] Database
[+] DDL
[+] Table
Best Regards,
Luciano
from flamerobin.
Retest result on FlameRobin 0.9.3.8 Snapshot: Passed!
Thank you very much for the fix!
from flamerobin.
Related Issues (20)
- Advanced Metadata Search HOT 2
- Collation of fields are not extracted properly HOT 5
- Extract database doesn't return default collation
- Restore Screen Button
- Replace Collation with Collations HOT 7
- COMMENT ON PARAMETER HOT 1
- Fb4+, Fr truncates field names with more than 32 char HOT 3
- Miss It field in Advanced MetaData Search....
- Current Build/Make instructions for Linux HOT 1
- Data Type Unknown in RDB$BACKUP_HISTORY HOT 4
- Documentation needs to be available for Preferences dialog HOT 2
- Bug, when I need to see the property of a field. HOT 5
- Problem with "Browse data" functionality: space is translated to a linebreak HOT 12
- Linux Builds do not support TZ datatypes HOT 6
- Dependencies not working for Global Temporary Tables
- Support for Firebird 1.0.3 HOT 2
- Source code issue in src/sql/SqlStatement.cpp HOT 1
- Restore Database dialog HOT 1
- Memory leaks HOT 4
- Suggestion. HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from flamerobin.