setHost(region: IRegion, host: IHost, port: number): Promise<IRegion> {
   let address: string = host ? host.address : '';
   return this.db.query('UPDATE regions SET httpPort=?, slaveAddress=? WHERE uuid=?', [port, address, region.uuid]).then(() => {
     region.node = address;
     return region;
   });
 }

 setXY(region: IRegion, x: number, y: number): Promise<IRegion> {
   return this.db.query('UPDATE regions SET locX=?, locY=? WHERE uuid=?', [x, y, region.uuid]).then(() => {
     region.x = x;
     region.y = y;
     return region;
   });
 }

 getByID(id: number): Promise<IJob> {
   return this.db.query('SELECT * FROM jobs WHERE id=?', id).then((rows: job_row[]) => {
     if (rows.length !== 1)
       throw new Error('Job ' + id + ' does not exist');
     return rows[0];
   });
 }

 getByName(name: string): Promise<IPendingUser> {
   return this.db.query('SELECT * FROM users WHERE name=?', name).then((rows: pending_user_row[]) => {
     if (rows.length !== 1)
       throw new Error('Pending User ' + name + ' does not exist');
     return rows[0];
   });
 }

 return Promise.all(rows.map((r: inventoryItem) => {
   let v: inventoryItem = {
     assetID: r.assetType == 24 ? uuidMap[r.assetID] : r.assetID,  // type 24 is a link
     assetType: r.assetType,
     inventoryName: r.inventoryName,
     inventoryDescription: r.inventoryDescription,
     inventoryNextPermissions: r.inventoryNextPermissions,
     inventoryCurrentPermissions: r.inventoryCurrentPermissions,
     invType: r.invType,
     creatorID: r.creatorID,
     inventoryBasePermissions: r.inventoryBasePermissions,
     inventoryEveryOnePermissions: r.inventoryEveryOnePermissions,
     salePrice: r.salePrice,
     saleType: r.saleType,
     creationDate: r.creationDate,
     groupID: r.groupID,
     groupOwned: r.groupOwned,
     flags: r.flags,
     inventoryID: invMap[r.inventoryID],
     avatarID: target.UUID,
     parentFolderID: uuidMap[r.parentFolderID],
     inventoryGroupPermissions: r.inventoryGroupPermissions
   }
   return db.query('INSERT INTO inventoryitems SET ?', v);
 }))

 getByAddress(address: string): Promise<IHost> {
   return this.db.query('SELECT * FROM hosts WHERE address=?', [address]).then((rows: hosts_row[]) => {
     if (rows.length == 0)
       throw new Error('Host ' + address + ' does not exist');
     return rows[0];
   });
 }

 create(address: string): Promise<IHost> {
   let host: hosts_row = {
     address: address,
     port: 0,
     name: '',
     slots: 0
   }
   return this.db.query('INSERT INTO hosts SET ?', host).then((result) => {
     host.id = result.insertId;
     return host;
   });
 }

 create(type: string, user: IUser, data: string): Promise<IJob> {
   let job: job_row = {
     timestamp: new Date(),
     type: type,
     user: user.UUID,
     data: data
   }
   return this.db.query('INSERT INTO jobs SET ?', job).then((result) => {
     job.id = result.insertId;
     return job;
   });
 }