<commit_before>from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, Float, String, Text, ForeignKey, Table
from sqlalchemy.orm import relationship, backref
from troll_interconnector import Base

tweets_hashtags_table = Table('association', Base.metadata,
                              Column('tweets_id', Integer, ForeignKey('tweets.id')),
                              Column('hashtags_id', Integer, ForeignKey('hashtags.id'))
                              )

class Tweet(Base):
    __tablename__ = 'tweets'

    id = Column(Integer, primary_key=True, autoincrement=True)
    content = Column(Text)
    author = Column(Integer, ForeignKey('twitteruser.id'))
    hashtags = relationship("Hashtag", secondary=tweets_hashtags_table, backref="tweets")

class TwitterUser(Base):
    __tablename__ = 'twitter_users'

    id = Column(Integer, primary_key=True, autoincrement=True)
    name = Column(String)
    tweets = relationship("Tweet", backref="twitter_user")
    troll_score = Column(Float)

class Hashtag(Base):
    __tablename__ = 'hashtags'

    id = Column(Integer, primary_key=True, autoincrement=True)
    name = Column(String)

class Mention(Base):
    __tablename__ = 'mentions'
    <commit_msg>switched twitter tweet ID to bigint because holy cow twitter needs that<commit_after>from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, BigInteger, Float, String, Text, ForeignKey, Table
from sqlalchemy.orm import relationship, backref
from troll_interconnector import Base

tweets_hashtags_table = Table('association', Base.metadata,
                              Column('tweets_id', Integer, ForeignKey('tweets.id')),
                              Column('hashtags_id', Integer, ForeignKey('hashtags.id'))
                              )

class Tweet(Base):
    __tablename__ = 'tweets'

    id = Column(BigInteger, primary_key=True)
    content = Column(Text)
    author = Column(BigInteger, ForeignKey('twitteruser.id'))
    hashtags = relationship("Hashtag", secondary=tweets_hashtags_table, backref="tweets")
    reply_to_id = Column(BigInteger)
    reply_to_user_id = Column(BigInteger)

class TwitterUser(Base):
    __tablename__ = 'twitter_users'

    id = Column(Integer, primary_key=True, autoincrement=True)
    name = Column(String)
    tweets = relationship("Tweet", backref="twitter_user")
    troll_score = Column(Float)

class Hashtag(Base):
    __tablename__ = 'hashtags'

    id = Column(Integer, primary_key=True, autoincrement=True)
    name = Column(String)

class Mention(Base):
    __tablename__ = 'mentions'
    
{'fraction_non_alphanumeric': 0.100798782807151, 'fraction_numerical': 0.0, 'mean_word_length': 3.8345588235294117, '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': '2512954', 'n_tokens_mistral': 814, 'n_tokens_neox': 798, 'n_words': 171}