NFT Museum API

===

NFT Museum is a mobile first platform for art lovers to curate their favourite digital art.

What is NFT Museum?
Why NFT Museum?
User Flows
⛏️ Built Using
✍️ Authors
Setup

What is NFT Museum ?

NFT Museum is a mobile first platform authenticated by multiple Crypto Wallets including Valora for art lovers to curate their favourite digital art pieces as a collection and be shared to community. A curator ( user who creates collection) can add multiple NFTs from OpenSea and create a collection by theme, asthetics or free will, just like a Spotify playlists ! These collections are visible to everyone, searchable by Tags and number of likes.

Why NFT Museum?

With mind bogling numbers of NFT enabled digital art minted each day, it is harder and harder for collectors to find there next collection piece, NFT Museum helps you to discover the precious pearls from the "Open Sea". You can also save your favourite collections and NFTs to your librar in single tap which can be easily accessible anytime.

User flows

⛏️ Built Using

React JS - A JavaScript library for building user interfaces
Ant Design - A React UI library that has a plethora of easy-to-use components that are useful for building elegant user interfaces
Flask - A python based lightweight WSGI web application framework.
Open Sea APIs - Official APIs built on Open Sea
Valora - Crypto Mobile First Wallet based on Celo
Contractkit - SDK for helping wallet integration

Link for Frontend Repository

@nft-museum

Setup

Run the DB Initialization commands in your SQL Database
For local setup better to use Pycharm as IDE because even when creating virtual environment, flask run out of virtual environment.
After setting project up in Pycharm, open terminal within Pycharm and run pip install -r requirements.txt
Run export DB_URI=<DB_URI> or enter DB_URI in config.py
Run export FLASK_APP=app.py and export FLASK_DEBUG=1 in root directory of project from within the Pycharm terminal.

DB Initialization commands Setup

  "id" serial NOT NULL,
  "valora_id" varchar(255) NOT NULL UNIQUE,
  "name" varchar(255) NOT NULL,
  "created_at" TIMESTAMP NOT NULL,
  "updated_at" TIMESTAMP,
  "img_url" TEXT,
  "is_archived" BOOLEAN NOT NULL DEFAULT 'False',
  CONSTRAINT "users_pk" PRIMARY KEY ("id")
) WITH (
OIDS=FALSE
);



CREATE TABLE "collections" (
  "id" serial NOT NULL,
  "name" varchar(255) NOT NULL UNIQUE,
  "created_by" int NOT NULL,
  "description" TEXT,
  "no_of_saves" int,
  "is_archived" BOOLEAN NOT NULL DEFAULT 'False',
  "tags" varchar ARRAY[] NOT NULL,
  CONSTRAINT "collections_pk" PRIMARY KEY ("id")
) WITH (
OIDS=FALSE
);



CREATE TABLE "nfts" (
  "id" serial NOT NULL,
  "name" varchar(255) NOT NULL UNIQUE,
  "token_id" varchar(255) NOT NULL,
  "created_at" TIMESTAMP NOT NULL,
  "updated_at" TIMESTAMP,
  "img_url" TEXT,
  "perma_link" TEXT,
  CONSTRAINT "nfts_pk" PRIMARY KEY ("id")
) WITH (
OIDS=FALSE
);



CREATE TABLE "nft_to_ collection" (
  "nft_id" int NOT NULL,
  "collection_id" int NOT NULL,
  "nft_added_at" TIMESTAMP NOT NULL,
  "nft_updated_at" TIMESTAMP,
  "nft_archived" BOOLEAN NOT NULL DEFAULT 'False'
) WITH (
OIDS=FALSE
);



CREATE TABLE "saved_collections" (
  "user_id" int NOT NULL,
  "collection_id" int NOT NULL,
  "collection_added_at" TIMESTAMP NOT NULL,
  "collection_updated_at" TIMESTAMP,
  "is_archived" BOOLEAN NOT NULL DEFAULT 'False'
) WITH (
OIDS=FALSE
);



CREATE TABLE "saved_nfts" (
  "user_id" int NOT NULL,
  "nft_id" int NOT NULL,
  "nft_saved_at" TIMESTAMP NOT NULL,
  "nft_updated_at" TIMESTAMP,
  "is_archived" BOOLEAN NOT NULL DEFAULT 'False'
) WITH (
OIDS=FALSE
);




ALTER TABLE "collections" ADD CONSTRAINT "collections_fk0" FOREIGN KEY ("created_by") REFERENCES "users"("id");


ALTER TABLE "nft_to_ collection" ADD CONSTRAINT "nft_to_ collection_fk0" FOREIGN KEY ("nft_id") REFERENCES "nfts"("id");
ALTER TABLE "nft_to_ collection" ADD CONSTRAINT "nft_to_ collection_fk1" FOREIGN KEY ("collection_id") REFERENCES "collections"("id");

ALTER TABLE "saved_collections" ADD CONSTRAINT "saved_collections_fk0" FOREIGN KEY ("user_id") REFERENCES "users"("id");
ALTER TABLE "saved_collections" ADD CONSTRAINT "saved_collections_fk1" FOREIGN KEY ("collection_id") REFERENCES "collections"("id");

ALTER TABLE "saved_nfts" ADD CONSTRAINT "saved_nfts_fk0" FOREIGN KEY ("user_id") REFERENCES "users"("id");
ALTER TABLE "saved_nfts" ADD CONSTRAINT "saved_nfts_fk1" FOREIGN KEY ("nft_id") REFERENCES "nfts"("id");

brolag/nft-museum-api