<commit_before># DBMS_Parser_Insert

This is a DBMS project that creates DataTable objects based on standard SQL CREATE and INSERT queries.

![demo00](/images/demo02.gif)

## Usage

Just run the project in Visual Studio. The main form will then appear.

![mainform](/images/pic00.png)

In this form you will see three main buttons:
1. **Load sample queries:** This button loads a set of sample queries that show how to use this DBMS.
2. **Execute queries:** This button executes whatever query is in the main window, and displays the result at the bottom.
3. **Clear main window:** This button clears all the instructions in the main window.

## SQL code example

You can use standard SQL *CREATE* and *INSERT* instructions in the main window, as
```sql
create table user1 (userId int, name varchar, userLocation varchar);
create table tweets (twid int, tweet varchar, utcDate varchar, city varchar, userId int);

INSERT INTO user1 VALUES (811883,'regisb','Paris France') ;
INSERT INTO user1 VALUES (8055532,'goodevilgenius','Rockville MD USA') ;
INSERT INTO user1 VALUES (8229592,'minoic','Spain') ;

INSERT INTO tweets VALUES (185437272,'Damn its incredibl','Aug  3 2007 10:50PM','Hsinchu' ,811883) ;
INSERT INTO tweets VALUES (203133822,'Im trying NOT to pr','Aug 13 2007  9:44AM','Hsinchu' ,811883) ;
INSERT INTO tweets VALUES (278146952,'wondering what big p','Sep 19 2007  2:58AM','Hsinchu' ,8055532) ;
```
or just click the **Load sample queries** button to load a list of queries already preloaded in the project.

![demo01](/images/gif_01.gif)<commit_msg>Read me update<commit_after># DBMS_Parser_Insert

This is a DBMS project that creates DataTable objects based on standard SQL CREATE and INSERT queries.

![demo00](/images/demo02.gif)

## Usage

Just run the project in Visual Studio. The main form will then appear.

![mainform](/images/pic00.png)

In this form you will see three main buttons:
1. **Load sample queries:** This button loads a set of sample queries that show how to use this DBMS.
2. **Execute queries:** This button executes whatever query is in the main window, and displays the result at the bottom.
3. **Clear main window:** This button clears all the instructions in the main window.

## SQL code example

You can use standard SQL *CREATE* and *INSERT* instructions in the main window, as
```sql
create table user1 (userId int, name varchar, userLocation varchar);
create table tweets (twid int, tweet varchar, utcDate varchar, city varchar, userId int);

INSERT INTO user1 VALUES (811883,'regisb','Paris France') ;
INSERT INTO user1 VALUES (8055532,'goodevilgenius','Rockville MD USA') ;
INSERT INTO user1 VALUES (8229592,'minoic','Spain') ;

INSERT INTO tweets VALUES (185437272,'Damn its incredibl','Aug  3 2007 10:50PM','Hsinchu' ,811883) ;
INSERT INTO tweets VALUES (203133822,'Im trying NOT to pr','Aug 13 2007  9:44AM','Hsinchu' ,811883) ;
INSERT INTO tweets VALUES (278146952,'wondering what big p','Sep 19 2007  2:58AM','Hsinchu' ,8055532) ;
```
or just click the **Load sample queries** button to load a list of queries already preloaded in the project.

![demo01](/images/gif_01.gif)

### Note

Inside the project, there is a **QueriesExample.txt**.
{'fraction_non_alphanumeric': 0.10015649452269171, 'fraction_numerical': 0.06885758998435054, 'mean_word_length': 5.1461538461538465, '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': '2782489', 'n_tokens_mistral': 1122, 'n_tokens_neox': 927, 'n_words': 431}