Python create_table示例

示例#1

文件： futures.py 项目： mookie-blaylocks/OI_2

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)

示例#2

文件： options.py 项目： mookie-blaylocks/OI_2

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)