{"id":60,"date":"2023-08-05T18:23:32","date_gmt":"2023-08-05T18:23:32","guid":{"rendered":"https:\/\/gsitlibrary.com\/docwebapi\/docs\/web-api-gsit-library\/database\/"},"modified":"2023-08-09T06:42:13","modified_gmt":"2023-08-09T06:42:13","slug":"database-60","status":"publish","type":"docs","link":"https:\/\/gsitlibrary.com\/docwebapi\/docs\/web-api-gsit-library\/database-60\/","title":{"rendered":"Database"},"content":{"rendered":"\n<p>The database used in the GSIT-Library is Postgres SQL.<br>The source file to restore the database is in<br>..\\GSITWPF\\databases\\gsit_database.sql<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Login to your database server instance<\/li>\n\n\n\n<li>Create a database named crm<\/li>\n\n\n\n<li>Perform a restore with a command more or less like this:<br>psql -h 127.0.0.1 -U postgres -d crm-f &#8230;\\GSITWPF\\databases\\gsit_database.sql<\/li>\n\n\n\n<li>Change the value of the connection parameter in the file: <code>appsettings.json:<\/code><br><br><code>\"ConnectionStrings\": {<br>\"ConnStr\": \"Server=127.0.0.1;Port=5432;Database=<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-palette-color-2-color\">crm<\/mark>;User Id=postgres;Password=<mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-palette-color-2-color\">yourpassword<\/mark>;CommandTimeout=20;\"<br>},<\/code><br><br>change the database name and password.<\/li>\n\n\n\n<li>We do database testing together with <a href=\"https:\/\/gsitlibrary.com\/docwebapi\/docs\/web-api-gsit-library\/web-api-testing-137\/\">Web Api Testing<\/a>.<\/li>\n\n\n\n<li>This article below describe schemas in databases: public and tenant owned schemas.<\/li>\n<\/ol>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The database used in the GSIT-Library is Postgres SQL.The source file to restore the database is in..\\GSITWPF\\databases\\gsit_database.sql<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":6,"menu_order":2,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-60","docs","type-docs","status-publish","hentry"],"blocksy_meta":"","_links":{"self":[{"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/docs\/60","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/comments?post=60"}],"version-history":[{"count":21,"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/docs\/60\/revisions"}],"predecessor-version":[{"id":236,"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/docs\/60\/revisions\/236"}],"up":[{"embeddable":true,"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/docs\/6"}],"wp:attachment":[{"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/media?parent=60"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/gsitlibrary.com\/docwebapi\/wp-json\/wp\/v2\/doc_tag?post=60"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}