<commit_before>from sqlalchemy import Table, Column, Integer, String, Float, DateTime
from sqlalchemy import create_engine

#|Load SQLAlchemy table into MetaData with option to 'create'
#|SQL table in database
def tables(meta, table_name):	
	if table_name == 'api':
		tbl = Table('tds', meta, Column('tid', Integer, primary_key=True),
			Column('price', Float), Column('amount', Float),
			Column('type', String(4)), Column('timestamp', Integer),
			Column('exchange', String(20)))
	if table_name == 'okcoin':
		tbl = Table(table_name, meta, Column('tid', Integer, primary_key=True),
			Column('price', Float), Column('amount', Float),
			Column('type', String(4)), Column('timestamp', Integer),
			Column('timestamp_ms', Integer), Column('exchange', String(20)))
	if table_name == 'bchart':
		tbl = Table(table_name, meta, Column('timestamp', Integer),
			Column('price', Float), Column('amount', Float),
			Column('exchange', String(20)))
	if table_name == 'price':
		tbl = Table(table_name, meta, 
			Column('timestamp', Integer, primary_key=True),
			Column('price', Float), Column('amount', Float),
			Column('open', Float), Column('high', Float),
			Column('low', Float),
			Column('freq', String(5), primary_key=True), 
			Column('exchange', String(20), primary_key=True),
			Column('source', String(3), primary_key=True))
	if table_name == 'last':
		tbl = Table(table_name, meta,
			Column('table', String(20), primary_key=True),
			Column('exchange', String(20), primary_keys=True),
			Column('column', String(20), primary_keys=True),
			Column('value', Float), Column('value2',Float))
	return tbl




<commit_msg>removed "last" SQL table<commit_after>from sqlalchemy import Table, Column, Integer, String, Float, DateTime
from sqlalchemy import create_engine

#|Load SQLAlchemy table into MetaData with option to 'create'
#|SQL table in database
def tables(meta, table_name):	
	if table_name == 'api':
		tbl = Table('tds', meta, Column('tid', Integer, primary_key=True),
			Column('price', Float), Column('amount', Float),
			Column('type', String(4)), Column('timestamp', Integer),
			Column('exchange', String(20)))
	if table_name == 'okcoin':
		tbl = Table(table_name, meta, Column('tid', Integer, primary_key=True),
			Column('price', Float), Column('amount', Float),
			Column('type', String(4)), Column('timestamp', Integer),
			Column('timestamp_ms', Integer), Column('exchange', String(20)))
	if table_name == 'bchart':
		tbl = Table(table_name, meta, Column('timestamp', Integer),
			Column('price', Float), Column('amount', Float),
			Column('exchange', String(20)))
	if table_name == 'price':
		tbl = Table(table_name, meta, 
			Column('timestamp', Integer, primary_key=True),
			Column('price', Float), Column('amount', Float),
			Column('open', Float), Column('high', Float),
			Column('low', Float),
			Column('freq', String(5), primary_key=True), 
			Column('exchange', String(20), primary_key=True),
			Column('source', String(3), primary_key=True))
	return tbl
{'fraction_non_alphanumeric': 0.178439906260462, 'fraction_numerical': 0.010378305992634751, 'mean_word_length': 6.323529411764706, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1959731', 'n_tokens_mistral': 1009, 'n_tokens_neox': 901, 'n_words': 247}