DeveelDB  20151217
complete SQL database system, primarly developed for .NET/Mono frameworks
•All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Properties Pages
Classes | Static Public Member Functions | Public Attributes | Static Public Attributes | Static Package Attributes | Static Private Member Functions | List of all members
Deveel.Data.SystemSchema Class Reference

Provides utilities and properties for handling the SYSTEN schema of a database. More...

Classes

class  OpenSessionsTable
 
class  PrivilegesTable
 
class  ProductInfoTable
 
class  SessionInfoTable
 
class  SqlTypesTable
 
class  StatisticsTable
 
class  TableColumnsTable
 
class  TableInfoTable
 
class  VariablesTable
 

Static Public Member Functions

static void CreateTables (IQuery context)
 
static void GrantToPublic (IQuery context)
 
static void Setup (ITransaction transaction)
 
static ITable GetTableInfoTable (ITransaction transaction)
 
static ITable GetTableColumnsTable (ITransaction transaction)
 
static ITable GetSqlTypesTable (ITransaction transaction)
 
static ITable GetProductInfoTable (ITransaction transaction)
 
static ITable GetOpenSessionsTable (ITransaction transaction)
 
static ITable GetVariablesTable (ITransaction transaction)
 
static ITable GetPrivilegesTable (ITransaction transaction)
 
static ITable GetSessionInfoTable (IQuery context)
 
static ITable GetStatisticsTable (ITransaction transaction)
 

Public Attributes

const string Name = "SYSTEM"
 The name of the system schema that contains tables referring to system information. More...
 

Static Public Attributes

static readonly ObjectName SchemaName = new ObjectName(Name)
 The name of the system schema as ObjectName. More...
 
static readonly ObjectName SchemaInfoTableName = new ObjectName(SchemaName, "schema_info")
 
static readonly ObjectName TableInfoTableName = new ObjectName(SchemaName, "table_info")
 
static readonly ObjectName TableColumnsTableName = new ObjectName(SchemaName, "table_cols")
 
static readonly ObjectName ViewTableName = new ObjectName(SchemaName, "view")
 
static readonly ObjectName RoutineTableName = new ObjectName(SchemaName, "routine")
 
static readonly ObjectName TriggerTableName = new ObjectName(SchemaName, "trigger")
 
static readonly ObjectName RoutineParameterTableName = new ObjectName(SchemaName, "routine_params")
 
static readonly ObjectName VariablesTableName = new ObjectName(SchemaName, "vars")
 
static readonly ObjectName ProductInfoTableName = new ObjectName(SchemaName, "product_info")
 
static readonly ObjectName StatisticsTableName = new ObjectName(SchemaName, "stats")
 
static readonly ObjectName SequenceInfoTableName = new ObjectName(SchemaName, "sequence_info")
 
static readonly ObjectName SequenceTableName = new ObjectName(SchemaName, "sequence")
 
static readonly ObjectName PrimaryKeyInfoTableName = new ObjectName(SchemaName, "pkey_info")
 
static readonly ObjectName PrimaryKeyColumnsTableName = new ObjectName(SchemaName, "pkey_cols")
 
static readonly ObjectName ForeignKeyInfoTableName = new ObjectName(SchemaName, "fkey_info")
 
static readonly ObjectName ForeignKeyColumnsTableName = new ObjectName(SchemaName, "fkey_cols")
 
static readonly ObjectName UniqueKeyInfoTableName = new ObjectName(SchemaName, "unique_info")
 
static readonly ObjectName UniqueKeyColumnsTableName = new ObjectName(SchemaName, "unique_cols")
 
static readonly ObjectName CheckInfoTableName = new ObjectName(SchemaName, "check_info")
 
static readonly ObjectName OldTriggerTableName = new ObjectName(SchemaName, "OLD")
 
static readonly ObjectName NewTriggerTableName = new ObjectName(SchemaName, "NEW")
 
static readonly ObjectName SqlTypesTableName = new ObjectName(SchemaName, "sql_types")
 
static readonly ObjectName SessionInfoTableName = new ObjectName(SchemaName, "session_info")
 
static readonly ObjectName OpenSessionsTableName = new ObjectName(SchemaName, "open_sessions")
 
static readonly ObjectName PrivilegesTableName = new ObjectName(SchemaName, "privs")
 
static readonly ObjectName UserTableName = new ObjectName(SchemaName, "user")
 Gets the fully qualified name of the user table. More...
 
static readonly ObjectName PasswordTableName = new ObjectName(SchemaName, "password")
 
static readonly ObjectName GroupsTableName = new ObjectName(SchemaName, "group")
 
static readonly ObjectName UserGroupTableName = new ObjectName(SchemaName, "user_group")
 
static readonly ObjectName UserGrantsTableName = new ObjectName(SchemaName, "grants")
 
static readonly ObjectName GroupGrantsTable = new ObjectName(SchemaName, "group_grants")
 

Static Package Attributes

static readonly TableInfo TableInfoTableInfo
 
static readonly TableInfo TableColumnsTableInfo
 
static readonly TableInfo SqlTypesTableInfo
 
static readonly TableInfo VariablesTableInfo
 
static readonly TableInfo ProductInfoTableInfo
 
static readonly TableInfo StatisticsTableInfo
 
static readonly TableInfo SessionInfoTableInfo
 
static readonly TableInfo OpenSessionsTableInfo
 
static readonly TableInfo PrivilegesTableInfo
 

Static Private Member Functions

static SystemSchema ()
 
static void CreateSecurityTables (IQuery context)
 

Detailed Description

Provides utilities and properties for handling the SYSTEN schema of a database.

The SYSTEM schema holds all the core tables and views for making a database system to be able to work.

Definition at line 37 of file SystemSchema.cs.

Constructor & Destructor Documentation

static Deveel.Data.SystemSchema.SystemSchema ( )
inlinestaticprivate

Definition at line 38 of file SystemSchema.cs.

38  {
39  // SYSTEM.TABLE_INFO
40  TableInfoTableInfo = new TableInfo(TableInfoTableName);
41  TableInfoTableInfo.AddColumn("catalog", PrimitiveTypes.String());
42  TableInfoTableInfo.AddColumn("schema", PrimitiveTypes.String());
43  TableInfoTableInfo.AddColumn("name", PrimitiveTypes.String());
44  TableInfoTableInfo.AddColumn("type", PrimitiveTypes.String());
45  TableInfoTableInfo.AddColumn("other", PrimitiveTypes.String());
46  TableInfoTableInfo = TableInfoTableInfo.AsReadOnly();
47 
48  // SYSTEM.TABLE_COLUMNS
49  TableColumnsTableInfo = new TableInfo(TableColumnsTableName);
50  TableColumnsTableInfo.AddColumn("schema", PrimitiveTypes.String());
51  TableColumnsTableInfo.AddColumn("table", PrimitiveTypes.String());
52  TableColumnsTableInfo.AddColumn("column", PrimitiveTypes.String());
53  TableColumnsTableInfo.AddColumn("sql_type", PrimitiveTypes.Numeric());
54  TableColumnsTableInfo.AddColumn("type_desc", PrimitiveTypes.String());
55  TableColumnsTableInfo.AddColumn("size", PrimitiveTypes.Numeric());
56  TableColumnsTableInfo.AddColumn("scale", PrimitiveTypes.Numeric());
57  TableColumnsTableInfo.AddColumn("not_null", PrimitiveTypes.Boolean());
58  TableColumnsTableInfo.AddColumn("default", PrimitiveTypes.String());
59  TableColumnsTableInfo.AddColumn("index_str", PrimitiveTypes.String());
60  TableColumnsTableInfo.AddColumn("seq_no", PrimitiveTypes.Numeric());
61  TableColumnsTableInfo = TableColumnsTableInfo.AsReadOnly();
62 
63  // SYSTEM.VARIABLES
64  VariablesTableInfo = new TableInfo(VariablesTableName);
65  VariablesTableInfo.AddColumn("var", PrimitiveTypes.String());
66  VariablesTableInfo.AddColumn("type", PrimitiveTypes.String());
67  VariablesTableInfo.AddColumn("value", PrimitiveTypes.String());
68  VariablesTableInfo.AddColumn("constant", PrimitiveTypes.Boolean());
69  VariablesTableInfo.AddColumn("not_null", PrimitiveTypes.Boolean());
70  VariablesTableInfo.AddColumn("is_set", PrimitiveTypes.Boolean());
71  VariablesTableInfo = VariablesTableInfo.AsReadOnly();
72 
73  // SYSTEM.PRODUCT_INFO
74  ProductInfoTableInfo = new TableInfo(ProductInfoTableName);
75  ProductInfoTableInfo.AddColumn("var", PrimitiveTypes.String());
76  ProductInfoTableInfo.AddColumn("value", PrimitiveTypes.String());
77  ProductInfoTableInfo = ProductInfoTableInfo.AsReadOnly();
78 
79  // SYSTEM.STATS
80  StatisticsTableInfo = new TableInfo(StatisticsTableName);
81  StatisticsTableInfo.AddColumn("stat_name", PrimitiveTypes.String());
82  StatisticsTableInfo.AddColumn("value", PrimitiveTypes.String());
83  StatisticsTableInfo = StatisticsTableInfo.AsReadOnly();
84 
85  // SYSTEM.SQL_TYPES
86  SqlTypesTableInfo = new TableInfo(SqlTypesTableName);
87  SqlTypesTableInfo.AddColumn("TYPE_NAME", PrimitiveTypes.String());
88  SqlTypesTableInfo.AddColumn("DATA_TYPE", PrimitiveTypes.Numeric());
89  SqlTypesTableInfo.AddColumn("PRECISION", PrimitiveTypes.Numeric());
90  SqlTypesTableInfo.AddColumn("LITERAL_PREFIX", PrimitiveTypes.String());
91  SqlTypesTableInfo.AddColumn("LITERAL_SUFFIX", PrimitiveTypes.String());
92  SqlTypesTableInfo.AddColumn("CREATE_PARAMS", PrimitiveTypes.String());
93  SqlTypesTableInfo.AddColumn("NULLABLE", PrimitiveTypes.Numeric());
94  SqlTypesTableInfo.AddColumn("CASE_SENSITIVE", PrimitiveTypes.Boolean());
95  SqlTypesTableInfo.AddColumn("SEARCHABLE", PrimitiveTypes.Numeric());
96  SqlTypesTableInfo.AddColumn("UNSIGNED_ATTRIBUTE", PrimitiveTypes.Boolean());
97  SqlTypesTableInfo.AddColumn("FIXED_PREC_SCALE", PrimitiveTypes.Boolean());
98  SqlTypesTableInfo.AddColumn("AUTO_INCREMENT", PrimitiveTypes.Boolean());
99  SqlTypesTableInfo.AddColumn("LOCAL_TYPE_NAME", PrimitiveTypes.String());
100  SqlTypesTableInfo.AddColumn("MINIMUM_SCALE", PrimitiveTypes.Numeric());
101  SqlTypesTableInfo.AddColumn("MAXIMUM_SCALE", PrimitiveTypes.Numeric());
102  SqlTypesTableInfo.AddColumn("SQL_DATA_TYPE", PrimitiveTypes.String());
103  SqlTypesTableInfo.AddColumn("SQL_DATETIME_SUB", PrimitiveTypes.String());
104  SqlTypesTableInfo.AddColumn("NUM_PREC_RADIX", PrimitiveTypes.Numeric());
105  SqlTypesTableInfo = SqlTypesTableInfo.AsReadOnly();
106 
107  // SYSTEM.OPEN_SESSIONS
108  OpenSessionsTableInfo = new TableInfo(OpenSessionsTableName);
109  OpenSessionsTableInfo.AddColumn("username", PrimitiveTypes.String());
110  OpenSessionsTableInfo.AddColumn("host_string", PrimitiveTypes.String());
111  OpenSessionsTableInfo.AddColumn("last_command", PrimitiveTypes.DateTime());
112  OpenSessionsTableInfo.AddColumn("time_connected", PrimitiveTypes.DateTime());
113  OpenSessionsTableInfo = OpenSessionsTableInfo.AsReadOnly();
114 
115  // SYSTEM.SESSION_INFO
116  SessionInfoTableInfo = new TableInfo(SessionInfoTableName);
117  SessionInfoTableInfo.AddColumn("var", PrimitiveTypes.String());
118  SessionInfoTableInfo.AddColumn("value", PrimitiveTypes.String());
119  SessionInfoTableInfo = SessionInfoTableInfo.AsReadOnly();
120 
121  // SYSTEM.PRIVS
122  PrivilegesTableInfo = new TableInfo(PrivilegesTableName);
123  PrivilegesTableInfo.AddColumn("priv_bit", PrimitiveTypes.Numeric());
124  PrivilegesTableInfo.AddColumn("description", PrimitiveTypes.String());
125  PrivilegesTableInfo = PrivilegesTableInfo.AsReadOnly();
126  }
Deveel.Data.Types.PrimitiveTypes
Provides some helper functions for resolving and creating SqlType instances that are primitive to the...
Definition: PrimitiveTypes.cs:29
Deveel.Data.SystemSchema.SqlTypesTableInfo
static readonly TableInfo SqlTypesTableInfo
Definition: SystemSchema.cs:222
Deveel.Data.SystemSchema.TableColumnsTableName
static readonly ObjectName TableColumnsTableName
Definition: SystemSchema.cs:145
Deveel.Data.SystemSchema.ProductInfoTableName
static readonly ObjectName ProductInfoTableName
Definition: SystemSchema.cs:157
Deveel.Data.Types.PrimitiveTypes.Boolean
static BooleanType Boolean()
Definition: PrimitiveTypes.cs:30
Deveel.Data.SystemSchema.TableInfoTableInfo
static readonly TableInfo TableInfoTableInfo
Definition: SystemSchema.cs:218
Deveel.Data.SystemSchema.PrivilegesTableName
static readonly ObjectName PrivilegesTableName
Definition: SystemSchema.cs:194
Deveel.Data.SystemSchema.TableColumnsTableInfo
static readonly TableInfo TableColumnsTableInfo
Definition: SystemSchema.cs:220
Deveel.Data.SystemSchema.StatisticsTableName
static readonly ObjectName StatisticsTableName
Definition: SystemSchema.cs:159
Deveel.Data.SystemSchema.PrivilegesTableInfo
static readonly TableInfo PrivilegesTableInfo
Definition: SystemSchema.cs:234
Deveel.Data.SystemSchema.SessionInfoTableName
static readonly ObjectName SessionInfoTableName
Definition: SystemSchema.cs:190
Deveel.Data.SystemSchema.ProductInfoTableInfo
static readonly TableInfo ProductInfoTableInfo
Definition: SystemSchema.cs:226
Deveel.Data.Sql.Tables.TableInfo.AddColumn
void AddColumn(ColumnInfo column)
Adds a new column to the table at the last position of the columns list in the table metadata...
Definition: TableInfo.cs:230
Deveel.Data.SystemSchema.VariablesTableName
static readonly ObjectName VariablesTableName
Definition: SystemSchema.cs:155
Deveel.Data.Types.PrimitiveTypes.Numeric
static NumericType Numeric()
Definition: PrimitiveTypes.cs:78
Deveel.Data.SystemSchema.StatisticsTableInfo
static readonly TableInfo StatisticsTableInfo
Definition: SystemSchema.cs:228
Deveel.Data.Sql.Tables.TableInfo.AsReadOnly
TableInfo AsReadOnly()
Creates a new instance of TableInfo as an immutable copy of this table metadata.
Definition: TableInfo.cs:342
Deveel.Data.SystemSchema.VariablesTableInfo
static readonly TableInfo VariablesTableInfo
Definition: SystemSchema.cs:224
Deveel.Data.SystemSchema.OpenSessionsTableInfo
static readonly TableInfo OpenSessionsTableInfo
Definition: SystemSchema.cs:232
Deveel.Data.SystemSchema.OpenSessionsTableName
static readonly ObjectName OpenSessionsTableName
Definition: SystemSchema.cs:192
Deveel.Data.SystemSchema.SqlTypesTableName
static readonly ObjectName SqlTypesTableName
Definition: SystemSchema.cs:188
Deveel.Data.SystemSchema.TableInfoTableName
static readonly ObjectName TableInfoTableName
Definition: SystemSchema.cs:143
Deveel.Data.Sql.Tables.TableInfo
Defines the metadata properties of a table existing within a database.
Definition: TableInfo.cs:41
Deveel.Data.SystemSchema.SessionInfoTableInfo
static readonly TableInfo SessionInfoTableInfo
Definition: SystemSchema.cs:230

Member Function Documentation

static void Deveel.Data.SystemSchema.CreateSecurityTables ( IQuery  context)
inlinestaticprivate

Definition at line 238 of file SystemSchema.cs.

238  {
239  var tableInfo = new TableInfo(UserTableName);
240  tableInfo.AddColumn("name", PrimitiveTypes.String());
241  // TODO: User table must be completed ...
242  tableInfo = tableInfo.AsReadOnly();
243  context.CreateSystemTable(tableInfo);
244 
245  context.AddPrimaryKey(UserTableName, new []{"name"}, "SYSTEM_USER_PK");
246 
247  tableInfo = new TableInfo(PasswordTableName);
248  tableInfo.AddColumn("user", PrimitiveTypes.String());
249  tableInfo.AddColumn("method", PrimitiveTypes.String());
250  tableInfo.AddColumn("method_args", PrimitiveTypes.Binary());
251  tableInfo.AddColumn("identifier", PrimitiveTypes.String());
252  tableInfo = tableInfo.AsReadOnly();
253  context.CreateSystemTable(tableInfo);
254 
255  tableInfo = new TableInfo(UserGroupTableName);
256  tableInfo.AddColumn("user", PrimitiveTypes.String());
257  tableInfo.AddColumn("group", PrimitiveTypes.String());
258  tableInfo.AddColumn("admin", PrimitiveTypes.Boolean());
259  tableInfo = tableInfo.AsReadOnly();
260  context.CreateSystemTable(tableInfo);
261 
262  tableInfo = new TableInfo(GroupsTableName);
263  tableInfo.AddColumn("name", PrimitiveTypes.String(), true);
264  tableInfo = tableInfo.AsReadOnly();
265  context.CreateSystemTable(tableInfo);
266 
267  context.AddPrimaryKey(GroupsTableName, new[] { "name" }, "SYSTEM_GROUP_PK");
268 
269  tableInfo = new TableInfo(UserGrantsTableName);
270  tableInfo.AddColumn("priv_bit", PrimitiveTypes.Numeric());
271  tableInfo.AddColumn("object", PrimitiveTypes.Numeric());
272  tableInfo.AddColumn("name", PrimitiveTypes.String());
273  tableInfo.AddColumn("user", PrimitiveTypes.String());
274  tableInfo.AddColumn("grant_option", PrimitiveTypes.Boolean());
275  tableInfo.AddColumn("granter", PrimitiveTypes.String());
276  tableInfo = tableInfo.AsReadOnly();
277  context.CreateSystemTable(tableInfo);
278 
279  tableInfo = new TableInfo(GroupGrantsTable);
280  tableInfo.AddColumn("priv_bit", PrimitiveTypes.Numeric());
281  tableInfo.AddColumn("object", PrimitiveTypes.Numeric());
282  tableInfo.AddColumn("name", PrimitiveTypes.String());
283  tableInfo.AddColumn("group", PrimitiveTypes.String());
284  tableInfo.AddColumn("grant_option", PrimitiveTypes.Boolean());
285  tableInfo.AddColumn("granter", PrimitiveTypes.String());
286 
287  var fkCol = new[] {"user"};
288  var gfkCol = new[] {"group"};
289  var refCol = new[] {"name"};
290  const ForeignKeyAction onUpdate = ForeignKeyAction.NoAction;
291  const ForeignKeyAction onDelete = ForeignKeyAction.Cascade;
292  context.AddForeignKey(PasswordTableName, fkCol, UserTableName, refCol, onDelete, onUpdate, "USER_PASSWORD_FK");
293  context.AddForeignKey(UserGroupTableName, fkCol, UserTableName, refCol, onDelete, onUpdate, "USER_PRIV_FK");
294  context.AddForeignKey(UserGroupTableName, gfkCol, GroupsTableName, refCol, onDelete, onUpdate, "USER_GROUP_FK");
295  context.AddForeignKey(UserGrantsTableName, fkCol, UserTableName, refCol, onDelete, onUpdate, "USER_GRANTS_FK");
296  context.AddForeignKey(GroupGrantsTable, gfkCol, GroupsTableName, refCol, onDelete, onUpdate, "GROUP_GRANTS_FK");
297  }
Deveel.Data.Types.PrimitiveTypes
Provides some helper functions for resolving and creating SqlType instances that are primitive to the...
Definition: PrimitiveTypes.cs:29
Deveel.Data.Types.PrimitiveTypes.Boolean
static BooleanType Boolean()
Definition: PrimitiveTypes.cs:30
Deveel.Data.SystemSchema.GroupGrantsTable
static readonly ObjectName GroupGrantsTable
Definition: SystemSchema.cs:212
Deveel.Data.SystemSchema.UserTableName
static readonly ObjectName UserTableName
Gets the fully qualified name of the user table.
Definition: SystemSchema.cs:200
Deveel.Data.Types.PrimitiveTypes.Binary
static BinaryType Binary(int maxSize)
Definition: PrimitiveTypes.cs:162
Deveel.Data.Sql.Tables.ForeignKeyAction
ForeignKeyAction
Enumerates the foreign key referential trigger actions.
Definition: ForeignKeyAction.cs:23
Deveel.Data.SystemSchema.UserGroupTableName
static readonly ObjectName UserGroupTableName
Definition: SystemSchema.cs:208
Deveel.Data.Types.PrimitiveTypes.Numeric
static NumericType Numeric()
Definition: PrimitiveTypes.cs:78
Deveel.Data.SystemSchema.GroupsTableName
static readonly ObjectName GroupsTableName
Definition: SystemSchema.cs:206
Deveel.Data.SystemSchema.UserGrantsTableName
static readonly ObjectName UserGrantsTableName
Definition: SystemSchema.cs:210
Deveel.Data.Sql.Tables.TableInfo
Defines the metadata properties of a table existing within a database.
Definition: TableInfo.cs:41
Deveel.Data.SystemSchema.PasswordTableName
static readonly ObjectName PasswordTableName
Definition: SystemSchema.cs:202
static void Deveel.Data.SystemSchema.CreateTables ( IQuery  context)
inlinestatic

Definition at line 329 of file SystemSchema.cs.

329  {
330  CreateSecurityTables(context);
331  //CreateRoutineTables(context);
332  }
Deveel.Data.SystemSchema.CreateSecurityTables
static void CreateSecurityTables(IQuery context)
Definition: SystemSchema.cs:238
static ITable Deveel.Data.SystemSchema.GetOpenSessionsTable ( ITransaction  transaction)
inlinestatic

Definition at line 409 of file SystemSchema.cs.

409  {
410  return new OpenSessionsTable(transaction);
411  }
static ITable Deveel.Data.SystemSchema.GetPrivilegesTable ( ITransaction  transaction)
inlinestatic

Definition at line 417 of file SystemSchema.cs.

417  {
418  return new PrivilegesTable(transaction);
419  }
static ITable Deveel.Data.SystemSchema.GetProductInfoTable ( ITransaction  transaction)
inlinestatic

Definition at line 405 of file SystemSchema.cs.

405  {
406  return new ProductInfoTable(transaction);
407  }
static ITable Deveel.Data.SystemSchema.GetSessionInfoTable ( IQuery  context)
inlinestatic

Definition at line 421 of file SystemSchema.cs.

421  {
422  return new SessionInfoTable(context.Session);
423  }
static ITable Deveel.Data.SystemSchema.GetSqlTypesTable ( ITransaction  transaction)
inlinestatic

Definition at line 401 of file SystemSchema.cs.

401  {
402  return new SqlTypesTable(transaction);
403  }
static ITable Deveel.Data.SystemSchema.GetStatisticsTable ( ITransaction  transaction)
inlinestatic

Definition at line 425 of file SystemSchema.cs.

425  {
426  return new StatisticsTable(transaction);
427  }
static ITable Deveel.Data.SystemSchema.GetTableColumnsTable ( ITransaction  transaction)
inlinestatic

Definition at line 397 of file SystemSchema.cs.

397  {
398  return new TableColumnsTable(transaction);
399  }
static ITable Deveel.Data.SystemSchema.GetTableInfoTable ( ITransaction  transaction)
inlinestatic

Definition at line 393 of file SystemSchema.cs.

393  {
394  return new TableInfoTable(transaction);
395  }
static ITable Deveel.Data.SystemSchema.GetVariablesTable ( ITransaction  transaction)
inlinestatic

Definition at line 413 of file SystemSchema.cs.

413  {
414  return new VariablesTable(transaction);
415  }
static void Deveel.Data.SystemSchema.GrantToPublic ( IQuery  context)
inlinestatic

Definition at line 334 of file SystemSchema.cs.

334  {
335  context.GrantToUserOnTable(ProductInfoTableName, User.PublicName, Privileges.TableRead);
336  context.GrantToUserOnTable(SqlTypesTableName, User.PublicName, Privileges.TableRead);
337  context.GrantToUserOnTable(PrivilegesTableName, User.PublicName, Privileges.TableRead);
338  context.GrantToUserOnTable(StatisticsTableName, User.PublicName, Privileges.TableRead);
339  context.GrantToUserOnTable(VariablesTableName, User.PublicName, Privileges.TableRead);
340  context.GrantToUserOnTable(RoutineTableName, User.PublicName, Privileges.TableRead);
341  context.GrantToUserOnTable(RoutineParameterTableName, User.PublicName, Privileges.TableRead);
342  context.GrantToUserOnTable(SessionInfoTableName, User.PublicName, Privileges.TableRead);
343  }
Deveel.Data.SystemSchema.ProductInfoTableName
static readonly ObjectName ProductInfoTableName
Definition: SystemSchema.cs:157
Deveel.Data.Security.User.PublicName
const string PublicName
The name of the PUBLIC special user.
Definition: User.cs:47
Deveel.Data.SystemSchema.PrivilegesTableName
static readonly ObjectName PrivilegesTableName
Definition: SystemSchema.cs:194
Deveel.Data.SystemSchema.StatisticsTableName
static readonly ObjectName StatisticsTableName
Definition: SystemSchema.cs:159
Deveel.Data.SystemSchema.SessionInfoTableName
static readonly ObjectName SessionInfoTableName
Definition: SystemSchema.cs:190
Deveel.Data.SystemSchema.RoutineTableName
static readonly ObjectName RoutineTableName
Definition: SystemSchema.cs:149
Deveel.Data.SystemSchema.VariablesTableName
static readonly ObjectName VariablesTableName
Definition: SystemSchema.cs:155
Deveel.Data.SystemSchema.SqlTypesTableName
static readonly ObjectName SqlTypesTableName
Definition: SystemSchema.cs:188
Deveel.Data.Security.User
Provides the information for a user in a database system
Definition: User.cs:27
Deveel.Data.SystemSchema.RoutineParameterTableName
static readonly ObjectName RoutineParameterTableName
Definition: SystemSchema.cs:153
static void Deveel.Data.SystemSchema.Setup ( ITransaction  transaction)
inlinestatic

Definition at line 345 of file SystemSchema.cs.

345  {
346  // -- Primary Keys --
347  // The 'id' columns are primary keys on all the system tables,
348  var idCol = new[] { "id" };
349  transaction.AddPrimaryKey(PrimaryKeyInfoTableName, idCol, "SYSTEM_PK_PK");
350  transaction.AddPrimaryKey(ForeignKeyInfoTableName, idCol, "SYSTEM_FK_PK");
351  transaction.AddPrimaryKey(UniqueKeyInfoTableName, idCol, "SYSTEM_UNIQUE_PK");
352  transaction.AddPrimaryKey(CheckInfoTableName, idCol, "SYSTEM_CHECK_PK");
353  transaction.AddPrimaryKey(SchemaInfoTableName, idCol, "SYSTEM_SCHEMA_PK");
354 
355  // -- Foreign Keys --
356  // Create the foreign key references,
357  var fkCol = new string[1];
358  var fkRefCol = new[] { "id" };
359 
360  fkCol[0] = "pk_id";
361  transaction.AddForeignKey(PrimaryKeyColumnsTableName, fkCol, PrimaryKeyInfoTableName, fkRefCol, "SYSTEM_PK_FK");
362 
363  fkCol[0] = "fk_id";
364  transaction.AddForeignKey(ForeignKeyColumnsTableName, fkCol, ForeignKeyInfoTableName, fkRefCol, "SYSTEM_FK_FK");
365 
366  fkCol[0] = "un_id";
367  transaction.AddForeignKey(UniqueKeyColumnsTableName, fkCol, UniqueKeyInfoTableName, fkRefCol, "SYSTEM_UNIQUE_FK");
368 
369  // pkey_info 'schema', 'table' column is a unique set,
370  // (You are only allowed one primary key per table).
371  var columns = new[] { "schema", "table" };
372  transaction.AddUniqueKey(PrimaryKeyInfoTableName, columns, "SYSTEM_PKEY_ST_UNIQUE");
373 
374  // schema_info 'name' column is a unique column,
375  columns = new String[] { "name" };
376  transaction.AddUniqueKey(SchemaInfoTableName, columns, "SYSTEM_SCHEMA_UNIQUE");
377 
378  // columns = new String[] { "name" };
379  columns = new String[] { "name", "schema" };
380  // pkey_info 'name' column is a unique column,
381  transaction.AddUniqueKey(PrimaryKeyInfoTableName, columns, "SYSTEM_PKEY_UNIQUE");
382 
383  // fkey_info 'name' column is a unique column,
384  transaction.AddUniqueKey(ForeignKeyInfoTableName, columns, "SYSTEM_FKEY_UNIQUE");
385 
386  // unique_info 'name' column is a unique column,
387  transaction.AddUniqueKey(UniqueKeyInfoTableName, columns, "SYSTEM_UNIQUE_UNIQUE");
388 
389  // check_info 'name' column is a unique column,
390  transaction.AddUniqueKey(CheckInfoTableName, columns, "SYSTEM_CHECK_UNIQUE");
391  }
Deveel.Data.Types.SqlTypeCode.String
A long string in the system.
Deveel.Data.SystemSchema.CheckInfoTableName
static readonly ObjectName CheckInfoTableName
Definition: SystemSchema.cs:182
Deveel.Data.SystemSchema.PrimaryKeyInfoTableName
static readonly ObjectName PrimaryKeyInfoTableName
Definition: SystemSchema.cs:170
Deveel.Data.SystemSchema.UniqueKeyInfoTableName
static readonly ObjectName UniqueKeyInfoTableName
Definition: SystemSchema.cs:178
Deveel.Data.SystemSchema.SchemaInfoTableName
static readonly ObjectName SchemaInfoTableName
Definition: SystemSchema.cs:141
Deveel.Data.SystemSchema.UniqueKeyColumnsTableName
static readonly ObjectName UniqueKeyColumnsTableName
Definition: SystemSchema.cs:180
Deveel.Data.SystemSchema.ForeignKeyInfoTableName
static readonly ObjectName ForeignKeyInfoTableName
Definition: SystemSchema.cs:174
Deveel.Data.SystemSchema.ForeignKeyColumnsTableName
static readonly ObjectName ForeignKeyColumnsTableName
Definition: SystemSchema.cs:176
Deveel.Data.SystemSchema.PrimaryKeyColumnsTableName
static readonly ObjectName PrimaryKeyColumnsTableName
Definition: SystemSchema.cs:172

Member Data Documentation

readonly ObjectName Deveel.Data.SystemSchema.CheckInfoTableName = new ObjectName(SchemaName, "check_info")
static

Definition at line 182 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.ForeignKeyColumnsTableName = new ObjectName(SchemaName, "fkey_cols")
static

Definition at line 176 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.ForeignKeyInfoTableName = new ObjectName(SchemaName, "fkey_info")
static

Definition at line 174 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.GroupGrantsTable = new ObjectName(SchemaName, "group_grants")
static

Definition at line 212 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.GroupsTableName = new ObjectName(SchemaName, "group")
static

Definition at line 206 of file SystemSchema.cs.

const string Deveel.Data.SystemSchema.Name = "SYSTEM"

The name of the system schema that contains tables referring to system information.

Definition at line 132 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.NewTriggerTableName = new ObjectName(SchemaName, "NEW")
static

Definition at line 186 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.OldTriggerTableName = new ObjectName(SchemaName, "OLD")
static

Definition at line 184 of file SystemSchema.cs.

readonly TableInfo Deveel.Data.SystemSchema.OpenSessionsTableInfo
staticpackage

Definition at line 232 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.OpenSessionsTableName = new ObjectName(SchemaName, "open_sessions")
static

Definition at line 192 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.PasswordTableName = new ObjectName(SchemaName, "password")
static

Definition at line 202 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.PrimaryKeyColumnsTableName = new ObjectName(SchemaName, "pkey_cols")
static

Definition at line 172 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.PrimaryKeyInfoTableName = new ObjectName(SchemaName, "pkey_info")
static

Definition at line 170 of file SystemSchema.cs.

readonly TableInfo Deveel.Data.SystemSchema.PrivilegesTableInfo
staticpackage

Definition at line 234 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.PrivilegesTableName = new ObjectName(SchemaName, "privs")
static

Definition at line 194 of file SystemSchema.cs.

readonly TableInfo Deveel.Data.SystemSchema.ProductInfoTableInfo
staticpackage

Definition at line 226 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.ProductInfoTableName = new ObjectName(SchemaName, "product_info")
static

Definition at line 157 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.RoutineParameterTableName = new ObjectName(SchemaName, "routine_params")
static

Definition at line 153 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.RoutineTableName = new ObjectName(SchemaName, "routine")
static

Definition at line 149 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.SchemaInfoTableName = new ObjectName(SchemaName, "schema_info")
static

Definition at line 141 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.SchemaName = new ObjectName(Name)
static

The name of the system schema as ObjectName.

Definition at line 137 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.SequenceInfoTableName = new ObjectName(SchemaName, "sequence_info")
static

summary> /summary>

Definition at line 164 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.SequenceTableName = new ObjectName(SchemaName, "sequence")
static

Definition at line 168 of file SystemSchema.cs.

readonly TableInfo Deveel.Data.SystemSchema.SessionInfoTableInfo
staticpackage

Definition at line 230 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.SessionInfoTableName = new ObjectName(SchemaName, "session_info")
static

Definition at line 190 of file SystemSchema.cs.

readonly TableInfo Deveel.Data.SystemSchema.SqlTypesTableInfo
staticpackage

Definition at line 222 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.SqlTypesTableName = new ObjectName(SchemaName, "sql_types")
static

Definition at line 188 of file SystemSchema.cs.

readonly TableInfo Deveel.Data.SystemSchema.StatisticsTableInfo
staticpackage

Definition at line 228 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.StatisticsTableName = new ObjectName(SchemaName, "stats")
static

summary>

/summary>

Definition at line 159 of file SystemSchema.cs.

readonly TableInfo Deveel.Data.SystemSchema.TableColumnsTableInfo
staticpackage

Definition at line 220 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.TableColumnsTableName = new ObjectName(SchemaName, "table_cols")
static

Definition at line 145 of file SystemSchema.cs.

readonly TableInfo Deveel.Data.SystemSchema.TableInfoTableInfo
staticpackage

Definition at line 218 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.TableInfoTableName = new ObjectName(SchemaName, "table_info")
static

Definition at line 143 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.TriggerTableName = new ObjectName(SchemaName, "trigger")
static

Definition at line 151 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.UniqueKeyColumnsTableName = new ObjectName(SchemaName, "unique_cols")
static

Definition at line 180 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.UniqueKeyInfoTableName = new ObjectName(SchemaName, "unique_info")
static

Definition at line 178 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.UserGrantsTableName = new ObjectName(SchemaName, "grants")
static

Definition at line 210 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.UserGroupTableName = new ObjectName(SchemaName, "user_group")
static

Definition at line 208 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.UserTableName = new ObjectName(SchemaName, "user")
static

Gets the fully qualified name of the user table.

Definition at line 200 of file SystemSchema.cs.

readonly TableInfo Deveel.Data.SystemSchema.VariablesTableInfo
staticpackage

Definition at line 224 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.VariablesTableName = new ObjectName(SchemaName, "vars")
static

Definition at line 155 of file SystemSchema.cs.

readonly ObjectName Deveel.Data.SystemSchema.ViewTableName = new ObjectName(SchemaName, "view")
static

Definition at line 147 of file SystemSchema.cs.

The documentation for this class was generated from the following file:
Generated by   doxygen 1.8.10