eelke/pgLab
1
0
Fork 0
Code Issues 28 Pull requests Projects Releases 1 Packages Wiki Activity Actions
pgLab/pglablib/catalog/PgAttribute.cpp

74 lines
2.1 KiB
C++
Raw Permalink Normal View History

PgAttribute loading + ColummnTableModel Required enchancement to PgContainer to make multifield key work.
2017-12-12 20:13:53 +01:00
#include "PgAttribute.h"
New column page Shows SQL for columns ALTER TABLE ... [ADD|DROP] COLUMN combines a selection of multiple columns into a single alter table. Show collation in list of columns. (order of columns isn't what is should be but that should maybe be fixed by a generic column selection and ordering mechanism that knows what the default sort should be)
2018-11-29 20:21:36 +01:00
#include "QStringBuilder"
#include "SqlFormattingUtils.h"
#include "PgClass.h"
#include "PgDatabaseCatalog.h"
#include "PgTypeContainer.h"
#include "PgCollation.h"
#include "PgCollationContainer.h"
Use (BIG)SERIAL in generated SQL when this was used when column originally defined. This is recognized by the fact that the column has a dependency on a sequence. For columns that happen to have a default which uses a pre exising sequence the dependency is the other way around.
2019-12-01 06:40:11 +01:00
#include "Pgsql_oids.h"
New column page Shows SQL for columns ALTER TABLE ... [ADD|DROP] COLUMN combines a selection of multiple columns into a single alter table. Show collation in list of columns. (order of columns isn't what is should be but that should maybe be fixed by a generic column selection and ordering mechanism that knows what the default sort should be)
2018-11-29 20:21:36 +01:00
QString PgAttribute::columnDefinition(const PgDatabaseCatalog &cat) const
{
// create: column_name data_type [ COLLATE collation ] [ column_constraint [ ... ]
// alter: column_name data_type [ COLLATE collation ] [ column_constraint [ ... ]
// constraints NULL/NOT NULL, DEFAULT, GENERATED other constraints will be ignored here a
Use (BIG)SERIAL in generated SQL when this was used when column originally defined. This is recognized by the fact that the column has a dependency on a sequence. For columns that happen to have a default which uses a pre exising sequence the dependency is the other way around.
2019-12-01 06:40:11 +01:00
QString type_str;
if (isSerial()) {
if (typid == Pgsql::int4_oid)
type_str = "SERIAL";
else if (typid == Pgsql::int8_oid)
type_str = "BIGSERIAL";
}
else {
fix missing typmod in generated sql ie the max length of a varchar or the scale and precision of a numeric closes #66
2020-10-15 19:21:44 +02:00
type_str = getTypeDisplayString(cat, typid, typmod);
Use (BIG)SERIAL in generated SQL when this was used when column originally defined. This is recognized by the fact that the column has a dependency on a sequence. For columns that happen to have a default which uses a pre exising sequence the dependency is the other way around.
2019-12-01 06:40:11 +01:00
}
New column page Shows SQL for columns ALTER TABLE ... [ADD|DROP] COLUMN combines a selection of multiple columns into a single alter table. Show collation in list of columns. (order of columns isn't what is should be but that should maybe be fixed by a generic column selection and ordering mechanism that knows what the default sort should be)
2018-11-29 20:21:36 +01:00
Use (BIG)SERIAL in generated SQL when this was used when column originally defined. This is recognized by the fact that the column has a dependency on a sequence. For columns that happen to have a default which uses a pre exising sequence the dependency is the other way around.
2019-12-01 06:40:11 +01:00
QString sql = quoteIdent(name) % " " % type_str;
New column page Shows SQL for columns ALTER TABLE ... [ADD|DROP] COLUMN combines a selection of multiple columns into a single alter table. Show collation in list of columns. (order of columns isn't what is should be but that should maybe be fixed by a generic column selection and ordering mechanism that knows what the default sort should be)
2018-11-29 20:21:36 +01:00
if (collation != InvalidOid) {
auto&& col = cat.collations()->getByKey(collation);
QString oname = col->objectName();
if (oname != "default")
sql += " COLLATE " % quoteIdent(oname);
}
if (notnull)
sql += " NOT NULL";
Use (BIG)SERIAL in generated SQL when this was used when column originally defined. This is recognized by the fact that the column has a dependency on a sequence. For columns that happen to have a default which uses a pre exising sequence the dependency is the other way around.
2019-12-01 06:40:11 +01:00
if (hasdef && !isSerial())
New column page Shows SQL for columns ALTER TABLE ... [ADD|DROP] COLUMN combines a selection of multiple columns into a single alter table. Show collation in list of columns. (order of columns isn't what is should be but that should maybe be fixed by a generic column selection and ordering mechanism that knows what the default sort should be)
2018-11-29 20:21:36 +01:00
sql += " DEFAULT " % defaultValue;
Fix incorrect ALTER TABLE statement for columns in the instepctor. Was caused by incorrect condition for determining the use of IDENTITY.
2019-08-19 19:44:07 +02:00
if (identity != '\0') {
New column page Shows SQL for columns ALTER TABLE ... [ADD|DROP] COLUMN combines a selection of multiple columns into a single alter table. Show collation in list of columns. (order of columns isn't what is should be but that should maybe be fixed by a generic column selection and ordering mechanism that knows what the default sort should be)
2018-11-29 20:21:36 +01:00
sql += " GENERATED ";
if (identity == 'a') sql += "ALWAYS";
else if (identity == 'd') sql += "BY DEFAULT";
sql += " AS IDENTITY";
}
// TODO sequence options might be missing
return sql;
}
QString PgAttribute::alterTableAddColumn(const PgDatabaseCatalog &cat, const PgClass &table) const
{
QString sql = "ALTER TABLE " % table.fullyQualifiedQuotedObjectName()
% " ADD COLUMN " % columnDefinition(cat) % ";";
return sql;
}
QString PgAttribute::alterTableDropColumn(const PgDatabaseCatalog &cat, const PgClass &table) const
{
QString sql = "ALTER TABLE " % table.fullyQualifiedQuotedObjectName()
% " DROP COLUMN " % quoteIdent(name) % ";";
return sql;
}
Generate COMMENT IS statements for columns
2021-07-02 20:42:32 +02:00
QString PgAttribute::commentStatement(const PgDatabaseCatalog &cat, const PgClass &table) const
{
if (description.isEmpty())
return {};
PgAttribute loading + ColummnTableModel Required enchancement to PgContainer to make multifield key work.
2017-12-12 20:13:53 +01:00
Generate COMMENT IS statements for columns
2021-07-02 20:42:32 +02:00
return "COMMENT ON COLUMN " % table.fullyQualifiedQuotedObjectName() % "."
% quoteIdent(name) % " IS " % escapeLiteral(description) % ";";
}
Reference in a new issue Copy permalink