Showing posts with label IntelliJ. Show all posts
New platform with IntelliJ Live Templates has been released! You can find it here IntelliJ Live Templates
Recently I had a desire to explore a little bit of how static websites are generated using modern stack like React. I choose at the time open-source framework called Gatsby
Gatsby has lots of advantages:
* Automatic routing based on your directory structure, so no extra code for configuring the router is needed
* Easily extensible by plugins
* Optimized for speed as only critical parts of your website are loaded
* Easy data integration with sources like CMSs, APIs, databases, file system (CSV, JSON, Markdown)
Using that technology I had created a simple project called IntelliJ Live Templates which provides listings of live templates ready to be used by developers in IntelliJ IDEA. Explanation of how live templates are used is placed on a project website under section About.
Data to fill out the website is taken from the repository placed on Github in the form of Markdown files
What steps will reproduce the problem?
When you create a new table with a constraint on column STATUS, it's difficult later on to amend that constraint as Oracle assigns a random name for it
CREATE TABLE MY_TABLE (
ID NUMERIC(19,0) NOT NULL,
STATUS NVARCHAR2(20) NOT NULL CHECK (STATUS IN ('OPEN', 'CLOSED'));
);
What is the expected result?
Getting a warning that it's better to create column constraint using a separate statement like
ALTER TABLE MY_TABLE ADD CONSTRAINT STATUS_VALIDATION CHECK (STATUS IN ('OPEN', 'CLOSED'));Link to a ticket - https://youtrack.jetbrains.com/issue/DBE-10549
