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...
-
Notifications
You must be signed in to change notification settings - Fork 0
cubman3134/CSVToSQLService
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
No description, website, or topics provided.
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published