Skip to content

cubman3134/CSVToSQLService

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 

Repository files navigation

CSVToSQLService

Built as a service that sits and waits for .csv files in the ToDoMySql folder. Once one shows up in the designated format shown here:
DEFINITION TYPE DESCRIPTION1 DESCRIPTION2 DESCRIPTION3 aPROCEDURE
AccountID BigInt NOT NULL AUTO_INCREMENT PRIMARY KEY out
FirstName Varchar(20) NOT NULL
LastName Varchar(20) NOT NULL
Gender TINYINT NOT NULL
Address1 Varchar(30) NOT NULL
Address2 Varchar(30) NOT NULL
City Varchar(30) NOT NULL
State Varchar(12) NOT NULL
DateOfBirth DATE
JoinDate DATE
Username Varchar(30) NOT NULL in
Password Varchar(30) NOT NULL in
Which is generated from a google sheets document, it will insert the table into the given database along with
TODO: the update/select/insert procedures
TODO: and select procedures attached to other tables.
In the future I will do a better job of documenting this...

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages