databse name add tabel filed tha error not show data

See also questions close to this topic

• Sequelize how to return result as a 2D array instead of array of objects?

  I am using Sequelize query() method as follows:

  const sequelize = new Sequelize(...);
  ...
  // IMPORTANT: No changed allowed on this query
  const queryFromUser = "SELECT table1.colname, table2.colname FROM table1 JOIN table2 ON/*...*/";
  const result = await sequelize.query(queryFromUser);
  

  Because I am selecting two columns with identical names (colname), in the result, I am getting something like:

  [{ "colname": "val1" }, { "colname": "val2" }...], and this array contains values only from the column table2.colname, as it is overwriting the table1.colname values.

  I know that there is an option to use aliases in the SQL query with AS, but I don't have control over this query.

  I think it would solve the issue, if there was a way to return the result as a 2D array, instead of the array of objects? Are there any ways to configure the Sequelize query that way?
• sequelize migration throws ERROR: function uuid_generate_v4() does not exist

  I enabled uuid extension with CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

  Then ran same query generated by sequelize for migration and it worked,

  create table if not exists "MY_SCHEMA"."Users" ("id" UUID not null default uuid_generate_v4() ,
  "phone" VARCHAR(10) not null,
  "password" VARCHAR(50) not null,
  "isDeleted" BOOLEAN default false,
  "role" "MY_SCHEMA"."enum_Users_role" default 'Student',
  "createdAt" TIMESTAMP with TIME zone not null,
  "updatedAt" TIMESTAMP with TIME zone not null,
  primary key ("id"));
  

  But, sequelize throws below error,

  ERROR: function uuid_generate_v4() does not exist
  

  Here is the migration file,

  const SCHEMA = 'MY_SCHEMA';
  const TABLE_WITH_SCHEMA = { tableName: 'Users', schema: SCHEMA };
  
  module.exports = {
    async up(queryInterface, Sequelize) {
      await queryInterface.createTable(TABLE_WITH_SCHEMA, {
        id: {
          allowNull: false,
          primaryKey: true,
          defaultValue: Sequelize.literal('uuid_generate_v4()'),
          type: Sequelize.UUID
        },
        phone: {
          type: Sequelize.STRING(10),
          allowNull: false
        },
        password: {
          type: Sequelize.STRING(50),
          allowNull: false
        },
        isDeleted: {
          type: Sequelize.BOOLEAN,
          defaultValue: false
        },
        role: {
          type: Sequelize.ENUM('Admin', 'Teacher', 'Student'),
          defaultValue: 'Student'
        },
        createdAt: {
          allowNull: false,
          type: Sequelize.DATE
        },
        updatedAt: {
          allowNull: false,
          type: Sequelize.DATE
        }
      });
      await queryInterface.addIndex(TABLE_WITH_SCHEMA, ['phone'], {
        indicesType: 'UNIQUE'
      });
    },
    async down(queryInterface) {
      await queryInterface.dropTable(TABLE_WITH_SCHEMA);
    }
  };
  
• Sequelize transaction with optimistic locking is locking the whole db

  I have an API coded with Node.js and I use a SQLite database with Sequelize.

  When I make updates, I use a transaction to rollback if something failed during the process.

  The code look like this:

  return sequelize.transaction(transaction => {
      return tableA.update(DataToUpdateA, {transaction})
          .then(() => {
              return UpdateValueInTableB(DataToUpdateB, {transaction});
          })
          .then(() => {
               // Do some complexe process that can take a while...
              return SomeComplexeProcess();
          })
          .catch(error => {
              // Log the error
          }); 
  });
  

  Sometimes the request take times because in SomeComplexeProcess I'm applying NTFS rights on the File System. And I need to roll back value in the database if something went wrong.

  The problem is as long as the transaction is not completed the whole database is locked.

  So I wanted to implement Optimistic Locking to avoid locking the whole database.

  When I update something, the version field is well increment but my whole database still locked during the process.

  Here is the configuration of Sequelize:

  new Sequelize(username, password, dbName {
      define: {
          freezeTableName: true,
          version: true // Optimistic locking
      },
      host: ...,
      ....
  }
  

  Did I do something wrong with my configuration ?
• npm shows vulnerabilities when installing firebase tools
  • I already installed node js and when I try to run npm install -g firebase-tools, it shows me this error, and it says run npm audit fix

  [#########.........] | reify:setimmediate: timing reifyNode:node_modules/firebase-tools/node_modules/@gar/pronpm WARN deprecated har-validator@5.1.3: this library is no longer supported npm WARN deprecated debug@4.1.0: Debug versions >=3.2.0 <3.2.7 || >=4 <4.3.1 have a low-severity ReDos regression when used in a Node.js environment. It is recommended you upgrade to 3.2.7 or 4.3.1. (https://github.com/visionmedia/debug/issues/797) npm WARN deprecated debug@4.1.1: Debug versions >=3.2.0 <3.2.7 || >=4 <4.3.1 have a low-severity ReDos regression when used in a Node.js environment. It is recommended you upgrade to 3.2.7 or 4.3.1. (https://github.com/visionmedia/debug/issues/797) npm WARN deprecated uuid@3.4.0: Please upgrade to version 7 or higher. Older versions may use Math.random() in certain circumstances, which is known to be problematic. See https://v8.dev/blog/math-random for details. npm WARN deprecated request@2.88.2: request has been deprecated, see https://github.com/request/request/issues/3142

  changed 637 packages, and audited 638 packages in 59s

  34 packages are looking for funding run npm fund for details

  21 vulnerabilities (15 moderate, 6 high)

  To address all issues, run: npm audit fix

  Run npm audit for details.

  • This is the result when I run npm audit fix

  up to date, audited 1 package in 456ms

  found 0 vulnerabilities
• How to delete all commits from private repository in github?

  I want to add gitignore with 2 files( node_module,another one) in a private repository which is given by github classroom. But I already git pushed for several times on that repository. Now I want to add gitignore, but after adding gitnore. the previous commited files (node_module, another one) are still in that repository. Now how I can remove all previous commits and git init again on that private repo?
• How does one import a third party library to an Angular project?

  I've got a project that needs to use a third-party custom library that was given for the project. How does one correctly use/integrate it? Do you have to import it to "package.json" like any other dependency?

  "dependencies": {
    "custom-lib": "^1.0.0",
    // other deps
  }
  

  When I try to do so, it kind of works but its assets do not load for example (404 (Not Found))...Does one need to add some references in "angular.json" too? Describe the proper way of configuring this, please. Any advice is appreciated.

  Edit: Plus when running npm install, the library disappears from node_modules
• Xml Serialization and Deserialization problem of DatabindingList of Objects

  I try to serialize and deserialize an xml file. The code in C# works perfectly well on Widows. But when I try to do it on ubuntu with mono, It fails for DataBindingList of Objects. The process was working 6 mouths ago. It doesn't seem like it is a ubuntu or a mono version problem since I used both the most recent versions of them and 3 years ago versions. I use the "Oracle WM VirtualBox 6.0" on Windows 10.

  During the serialization items of the BindingList are not regonized (and not writen on the xml file). And the deserialization crash at the line where is the first item of the BindingDataList with the error: "System.UriFormatException: Invalid URI: The format of the URI could not be determined."

  It could be a binding problem or a problem of high level xml mark. Maybe the xml is too nested.

  Here What I want to serialize/deserialize:

      [Serializable, XmlInclude(typeof(WeatherFileFormat)), Bindable(true)]
      public class WeatherFile : Child<string>, IWithPath
      {
          private string relativeFileName;
  
          [XmlAttribute(AttributeName = "file")]
          [Editor(typeof(FileNameEditor), typeof(UITypeEditor))]
          public string File
          {
              get {
  
                   return "../MyFile.txt"; 
              }
              set
              {
                 relativeFileName=newRelativeFileName="../MyFile.txt"
  
              }
          }
       }
  
  
      [Serializable, XmlInclude(typeof(WeatherFile)),XmlInclude(typeof(WeatherFileFormat)),   XmlInclude(typeof(BaseBindingList<WeatherFile>))]
      public class SiteItem : ProjectDataFileItem1Child<WeatherFile, string, WeatherFileGenerator>, IWithPath
      {
      
  
  
         [XmlElement("WeatherFiles",typeof(BaseBindingList<WeatherFile>))]
          public BaseBindingList<WeatherFile> WeatherFiles { get { return BindingItems1; }}
  
  }
  
  
  

  This is what I obtain during serialization:

  <?xml version="1.0">
    <SiteItem xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XML-instance" name="" format="YearJdayMinMaxRainRad">
     <WeatherFiles />
    </SiteItem>
  

  For the sake of simplycity I sum up the code and the xml. For example "name" and "format" are attribute of "SiteItem" which are not represented in this post but which are well taken into account.

  Here is what I try to deserialize:

  <?xml version="1.0">
    <SiteItem xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XML-instance" name="MyName" format="YearJdayMinMaxRainRad">
  <ItemArray>
     <WeatherFiles>
       <WeatherFile file=""../MyFile.txt"" />
     </WeatherFiles>
  </ItemArray>
    </SiteItem>
  

  It crashes at the line were appears the mark WeatherFile

  Does anyone has an idea?
• Add a new item to a nested array and update the existing elements according to the inserted item

  {
      "_id": {
          "$oid": "6200c86d083ef16be6dae5b1"
      },
      "type": "Hair_Length",
      "values": [
          {
              "name": "Bald / Clean Shaven",
              "value": "bald",
              "default": "yes"
          },
          {
              "name": "Crew Cut",
              "value": "crewcut"
          },
          {
              "name": "Short",
              "value": "Short"
          },
          {
              "name": "Medium",
              "value": "Medium"
          },
          {
              "name": "Long",
              "value": "Long"
          },
          {
              "name": "Chin Length",
              "value": "ChinLength"
          },
          {
              "name": "Shoulder Length",
              "value": "ShoulderLength"
          },
          {
              "name": "Dreadlocks",
              "value": "Dreadlocks"
          }
      ]
  }

  Good day guys! if I get name and value as json object then only I will update or add to this doc if incase we get "default":"yes" in addition to name and value then we need to update and delete if default is already exist I hope you got point

  appreciate it guys tq