def make_futures_table(): # Each column is ready for SQL insertion # column_name: [DataType, TableConstraint] columns = { 'symbol': ['CHARACTER(4)', 'NOT NULL'], 'price': ['REAL', 'NOT NULL'], 'exp_date': ['CHARACTER(5)', 'NOT NULL'] } rest.create_table(table_name, columns)
def make_options_table(): columns = { "symbol": ["CHARACTER(4)", "NOT NULL"], "price": ["REAL", "NOT NULL"], "exp_date": ["CHARACTER(5)", "NOT NULL"], "call_or_put": ["CHARACTER(4)", "NOT NULL"], "strike": ["INTEGER", "NOT NULL"], } rest.create_table(TABLE_NAME, columns)