<commit_before>--DDL


create table events (
    ts long,
    message varchar,
    username varchar,
    primary key (ts)
);

create table xevents_user (
    id identity,
    username varchar unique,
    password varchar not null,
    firstName varchar not null,
    lastName varchar not null,
    primary key (id)
 );


--DATA
insert into xevents_user (username, password, firstName, lastName) values ('stnevex', 'test', 'Ben', 'G');

insert into events (ts,message,username) values ('1','eventTest','tester');
insert into events (ts,message,username) values ('1301464284372','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer rutrum suscipit sem, eu blandit urna porta eu. Phasellus fringilla eleifend accumsan.','stnevex');
insert into events (ts,message,username) values ('1301464284373','Nullam posuere elit vel justo facilisis volutpat. Vestibulum id nisi at erat semper venenatis. Duis at ultrices velit. Nam mollis, ante id cursus accumsan','stnevex');
insert into events (ts,message,username) values ('1301464284374','Nullam ut blandit mauris. Mauris vitae porttitor tellus. Maecenas rutrum nunc bibendum arcu convallis tincidunt. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus eleifend blandit ultrices','stnevex');
insert into events (ts,message,username) values ('1301464284375','Proin consectetur justo ut nunc aliquet commodo. Nam suscipit risus sit amet mi pulvinar mollis. Praesent quis accumsan nisl. Suspendisse accumsan posuere tempor. Sed eget ligula et diam sollicitudin laoreet ut at quam. In tristique accumsan tempus. Nulla porta purus eu orci mollis tristique. Lorem ipsum dolor sit amet, consectetur adipiscing elit','stnevex');
insert into events (ts,message,username) values ('1301464284376','Mauris posuere molestie ante vel eleifend. Cras erat nulla, malesuada nec laoreet sit amet, lacinia et ante. Morbi dictum lacus ac lectus posuere ut egestas lacus euismod. Aliquam erat volutpat. Morbi laoreet, lectus eu vehicula vehicula, nisl nisi sollicitudin erat, ut iaculis est velit sed leo. Praesent ornare rhoncus mi, ac blandit ante commodo ac','stnevex');

<commit_msg>Add stnevex twitter connection into sql load file <commit_after>--DDL


create table events (
    ts long,
    message varchar,
    username varchar,
    primary key (ts)
);

create table xevents_user (
    id identity,
    username varchar unique,
    password varchar not null,
    firstName varchar not null,
    lastName varchar not null,
    primary key (id)
 );


--DATA
insert into xevents_user (username, password, firstName, lastName) values ('stnevex', 'test', 'Ben', 'G');

insert into events (ts,message,username) values ('1','eventTest','tester');
insert into events (ts,message,username) values ('1301464284372','Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer rutrum suscipit sem, eu blandit urna porta eu. Phasellus fringilla eleifend accumsan.','stnevex');
insert into events (ts,message,username) values ('1301464284373','Nullam posuere elit vel justo facilisis volutpat. Vestibulum id nisi at erat semper venenatis. Duis at ultrices velit. Nam mollis, ante id cursus accumsan','stnevex');
insert into events (ts,message,username) values ('1301464284374','Nullam ut blandit mauris. Mauris vitae porttitor tellus. Maecenas rutrum nunc bibendum arcu convallis tincidunt. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus eleifend blandit ultrices','stnevex');
insert into events (ts,message,username) values ('1301464284375','Proin consectetur justo ut nunc aliquet commodo. Nam suscipit risus sit amet mi pulvinar mollis. Praesent quis accumsan nisl. Suspendisse accumsan posuere tempor. Sed eget ligula et diam sollicitudin laoreet ut at quam. In tristique accumsan tempus. Nulla porta purus eu orci mollis tristique. Lorem ipsum dolor sit amet, consectetur adipiscing elit','stnevex');
insert into events (ts,message,username) values ('1301464284376','Mauris posuere molestie ante vel eleifend. Cras erat nulla, malesuada nec laoreet sit amet, lacinia et ante. Morbi dictum lacus ac lectus posuere ut egestas lacus euismod. Aliquam erat volutpat. Morbi laoreet, lectus eu vehicula vehicula, nisl nisi sollicitudin erat, ut iaculis est velit sed leo. Praesent ornare rhoncus mi, ac blandit ante commodo ac','stnevex');

insert into UserConnection (userId,providerId,providerUserId,rank,displayName,profileUrl,imageUrl,accessToken,secret,refreshToken,expireTime) values ('stnevex','twitter','293724331',1,'@stnevex','http://twitter.com/stnevex','http://a0.twimg.com/sticky/default_profile_images/default_profile_5_normal.png','293724331-R8wyHN0CXBZ5BNDri3OrblT4ntYHXi976bLJ0IRm',' zkSBVq9MV7Slp4ArUDn6lTTH4etvvbY1S7FOAxNoiGo',null,null);




{'fraction_non_alphanumeric': 0.08278636459877196, 'fraction_numerical': 0.03578234173195003, 'mean_word_length': 5.691218130311615, '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': 6, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2973127', 'n_tokens_mistral': 1721, 'n_tokens_neox': 1548, 'n_words': 533}