DB Web-Component Demo Page

• Print content of table "island", database "mondial"
• Additional condition that match the "Ostfriesische Inseln".
• print all columns of table island
• Result sorted by column "Area"

    <script type="module" src="http://localhost/dbwc/db.js">
    </script>
    <db-connection url="http://localhost/dbwc"
               database="mondial">
    </db-connection> 
    <db-table table="island" 
              filter="Islands=Ostfriesische Inseln" 
              order="Area">
    </db-table>

• table component rereads database every 10 sec.

    <script type="module" src="http://localhost/dbwc/db.js">
    </script>
    <db-connection url="http://localhost/dbwc"
               database="mondial">
    </db-connection> 
    <db-table table="country" 
              filter="Population>40000000" 
              refresh-rate="10"
              order="Population">
    </db-table>

• Print content of table "country", database "mondial"
• Projection of columns "Name", "Code", "Capital" amd "Population".
• Table can be seached by formulating restrictions on columns
  (ie. for column Population: < 10000)
• table can be sorted by clicking on the column headers

    <script type="module" src="http://localhost/dbwc/db.js">
    </script>
    <db-connection url="http://localhost/dbwc"
               database="mondial">
    </db-connection> 
    <db-table table="country" 
              actions="sort,filter" 
              attribute-list="Name,Code,Capital,Population">
    </db-table>

• Print content of table "country", database "mondial"
• Fixed page size (30 rows)
• pagewise scrolling
• inline edit (double click on field content)
• Projection of columns "Name" and "Population".
• search and sort functionality as before ...
• Inline edit: Please only edit non key fields and single attribute foreign-keys

    <script type="module" src="http://localhost/dbwc/db.js">
    </script>
    <db-connection url="http://localhost/dbwc"
                   database="mondial">
    </db-connection> 
    <db-table table="country" 
              actions="sort,filter,paging,inline" 
              pagesize="30"
              attribute-list="Name,Population,Capital">
    </db-table>

• table with additional columns to edit/delete datasets

    <script type="module" src="http://localhost/dbwc/db.js">
    </script>
    <db-connection url="http://localhost/dbwc"
               database="mondial">
    </db-connection> 
    <db-table table="island" 
              actions="edit,delete,sort,paging" 
              pagesize="20">
    </db-table>

• Edit France with foreign key resolution of capital
• Bug, when changing capital

    <script type="module" src="http://localhost/dbwc/db.js">
    </script>
    <db-connection url="http://localhost/dbwc" 
                   database="mondial-key">
    </db-connection> 
    <db-edit table-name="country" 
             display-key="on" 
             key="70">
	</db-edit>

• requieres login information
• credentials: test/apitest

    <script type="module" src="http://localhost/dbwc/db.js">
    </script>
    <db-connection url="http://localhost/dbwc"
                   database="mondial-login">
    </db-connection>
    <db-table table="city" xfilter="Country=D" attribute-list="Country, Name, Population, Longitude, Latitude"  actions="edit,delete">
</form>
  </body>
</html>

• creation of a new city dataset
• requieres login information
• credentials: test/apitest

    <script type="module" src="http://localhost/dbwc/db.js">
    </script>
    <db-connection url="http://localhost/dbwc"
                   database="mondial-key-login">
    </db-connection>
    <db-create table="city"