seed_db.py

import numpy

import sqlite3

def create_db():
    conn = sqlite3.connect('tickers.db')
    cursor = conn.cursor()
    cursor.execute('''
        CREATE TABLE IF NOT EXISTS tickers (
            id INTEGER PRIMARY KEY,
            ticker TEXT NOT NULL UNIQUE
        )
    ''')
    conn.commit()
    conn.close()

    
create_db()
    
ticker_list = [
    ("AVAX-USD",),
    ("ICP-USD",),
    ("WIF-USD",),
    ("GRT6719-USD",),
    ("ONDO-USD",),
    ("FET-USD",),
    ("VANRY-USD",),
    ("INJ-USD",),
    ("AI28846-USD",),
    ("QNT-USD",),
    ("LINK-USD",),
    ("MATIC-USD",),
    ("XRP-USD",),
    ('BTC-USD',),
    ('ETH-USD',),
    ('RNDR-USD',),
    ('SOL-USD',),
    ('TAO22974-USD',),
    ('AGIX-USD',),
    ('JUP-USD',),
    ('PENDLE-USD',),
    ('MANTA-USD',),
    ('TIA-USD',),
    ('LTC-USD',),
    ('BCH-USD',),
    ('ADA-USD',),
    ('DOT1-USD',),
    ('XLM-USD',),
    ('DOGE-USD',),
    ('BNB-USD',),
    ('LUNA-USD',),
    ('UNI-USD',),
    ('FIL-USD',),
    ('TRX-USD',),
    ('EOS-USD',),
    ('ALGO-USD',),
    ('ATOM-USD',),
    ('XTZ-USD',),
    ('VET-USD',),
    ('AAVE-USD',),
    ('XMR-USD',),
    ('NEO-USD',),
    ('DASH-USD',),
    ('IOTA-USD',),
    ('ETC-USD',),
    ('SHIB-USD',),
    ('COMP-USD',),
    ('MKR-USD',),
    ('USHI-USD',),
    ('ATIC-USD',),
    ('GRT-USD',),
    ('YFI-USD',),
    ('MANA-USD',),
    ('HBAR-USD',),
    ('BAT-USD',),
    ('ZRX-USD',),
    ('REN-USD',),
    ('SNX-USD',),
    ('CRV-USD',),
    ('CEL-USD',),
    ('QTUM-USD',),
    ('KSM-USD',),
    ('BSV-USD',),
    ('UST-USD',),
    ('FTM-USD',),
    ('ONE-USD',)
]

def insert_to_db():
    conn = sqlite3.connect('tickers.db')
    cursor = conn.cursor()
    
    cursor.executemany("INSERT INTO tickers (ticker) VALUES (?)", ticker_list)
    conn.commit()
    cursor.close()
    conn.close()
    

insert_to_db()

def fetch_all_tickers():
    conn = sqlite3.connect('tickers.db')
    cursor = conn.cursor()
    
    try:
        cursor.execute('SELECT id, ticker FROM tickers')
        tickers = cursor.fetchall()
        if tickers:
            return tickers
            #for user in users:
            #    print(f"ID: {user[0]}, Username: {user[1]}")
        else:
            print("No users found.")
    finally:
        conn.close()
        
#tickers = fetch_all_tickers()
#for user in users:
#    print(f"ID: {user[0]}, Username: {user[1]}")
    
#tickers = tuple(tickers)
#print(tickers)

#cnx = sqlite3.connect('tickers.db')

#df = pd.read_sql_query("SELECT * FROM table_name", cnx)