public void CreateTable(TableDescriptor table) { try { OpenConnection(); QueryCreator.Validate(table, true); var createQuery = QueryCreator.CreateTableQuery<string>(table); var cmd = new SQLiteCommand(createQuery, _connection); cmd.ExecuteNonQuery(); } catch(Exception) { CloseConnection(); } }
public bool Verify(TableDescriptor tableDescriptor, bool throwOnError = false) { return true; }
public void CreateTable(TableDescriptor table) { throw new System.NotImplementedException(); }
private TableDescriptor CreateUsers(DatabaseService ds) { var kd = new KeyDescriptor("Id"); var td = new TableDescriptor("Users"); td.AddField("Id", ds.GetFieldDescriptor("guid")); td.AddField("Username", ds.GetFieldDescriptor("username")); td.AddField("Password", ds.GetFieldDescriptor("password")); td.AddField("Nickname", ds.GetFieldDescriptor("nickname")); td.SetPrimaryKey(kd); kd = new KeyDescriptor("Username"); kd.SetType(true, false, true); td.AddKey(kd); return td; }
private TableDescriptor CreateRoles(DatabaseService ds) { var kd = new KeyDescriptor("Id"); var td = new TableDescriptor("Roles"); td.AddField("Id", ds.GetFieldDescriptor("guid")); td.AddField("UsersId", ds.GetFieldDescriptor("guid")); td.AddField("Role", ds.GetFieldDescriptor("role")); td.SetPrimaryKey(kd); kd = new KeyDescriptor("UsersId"); kd.SetType(true, false, true); td.AddKey(kd); return td; }
private TableDescriptor CreateQueue(DatabaseService ds) { var kd = new KeyDescriptor("Id"); var td = new TableDescriptor("Queue"); td.AddField("Id", ds.GetFieldDescriptor("guid")); td.AddField("UsersId", ds.GetFieldDescriptor("guid")); td.AddField("Message", ds.GetFieldDescriptor("message")); td.AddField("MessageType", ds.GetFieldDescriptor("messagetype")); td.AddField("Destination", ds.GetFieldDescriptor("destination")); td.SetPrimaryKey(kd); kd = new KeyDescriptor("UsersId"); kd.SetType(true, false, true); td.AddKey(kd); kd = new KeyDescriptor("Destination"); kd.SetType(false, false, true); td.AddKey(kd); kd = new KeyDescriptor("MessageType"); kd.SetType(false, false, true); td.AddKey(kd); return td; }
private static void SetupFkFromUsersToRoles(TableDescriptor roles, TableDescriptor users) { var fk = new ForeignKeyDescriptor(roles); fk.SetFields("Id", "UsersId"); users.AddForeignKey(fk); }
public QueryTable(TableDescriptor tableDescriptor, string alias) : this(tableDescriptor.FullName, alias) { _tableDescriptor = tableDescriptor; }
public void AddForeignKey(TableDescriptor descriptor, ForeignKeyMultplicity multplicity = ForeignKeyMultplicity.OneToOne) { AddForeignKey(new ForeignKeyDescriptor(descriptor, multplicity)); }
public void RegisterTable(TableDescriptor tableDescriptor) { var tbname = tableDescriptor.FullName.ToLowerInvariant(); tableDescriptor.Parent = this; if (!_tableDescriptors.ContainsKey(tbname)) _tableDescriptors.Add(tbname, tableDescriptor); }
public bool Verify(TableDescriptor tableDescriptor, bool throwOnError = false) { return QueryCreator.Validate(tableDescriptor, throwOnError); }