Saturday 24 March 2012

Another version of a database written in C


A working databases can be downloaded at http://tarkastatistics.webs.com/



/****************************************************************************
 *                                                                          *
 * File    : main.c                                                         *
 *                                                                          *
 * Purpose : Console mode (command line) program.                           *
 *                                                                          *
 * History : Date      Reason                                               *
 *           00/00/00  Created                                              *
 *                                                                          *
 ****************************************************************************/

#include <stdio.h>

/****************************************************************************
 *                                                                          *
 * Function: main                                                           *
 *                                                                          *
 * Purpose : Main entry point.                                              *
 *                                                                          *
 * History : Date      Reason                                               *
 *           00/00/00  Created                                              *
 *                                                                          *
 ****************************************************************************/


#include<stdio.h>
#include<stdlib.h>
#include<string.h>
#define MAX 100

typedef struct {
char name[40];
char street[40];
char district[40];
char town[40];
char county[40];
char country[40];
char postcode[40];
char telno[40];
char email[40];
char response[1][10];
}addr_list;

addr_list address[MAX];
int counter;
void init_list(void), enter(void);
void delete(void), list(void);
void load(void), save(void), sort(void);
void loadbackup(void), outputthree(void);
void outputtwo(void), search(void);
void readLine(char buffer[]);
void swap(int u, int v);
int main(void)
{
int choice;
char s[80];
counter = 0;
init_list();
for(;;) {
printf("\n");
printf("1.  Create a record\n");
printf("2.  Delete a record\n");
printf("3.  List the file\n");
printf("4.  Save the file\n");
printf("5.  Load the file\n");
printf("6.  Sort the file\n");
printf("7.  Search\n");
printf("8.  Save to a back up file\n");
printf("9.  Load from a backup file\n");
printf("10. Output to a text file for printing or import into wp\n");
printf("11. Quit\n");
do {
printf("\nEnter your choice: ");
readLine(s);
/*gets(s);*/
choice=atoi(s);
/*scanf("%i", &choice);*/
}while(choice < 0 && choice > 11);
switch(choice) {
case 1: enter();
break;
case 2: delete();
break;
case 3: list();
break;
case 4: save();
break;
case 5: load();
break;
case 6: sort();
break;
case 7: search();
break;
case 8: outputtwo();
break;
case 9: loadbackup();
break;
case 10: outputthree();
break;
case 11: exit(0);
}
}
return 0;
}

void init_list(void)
{
register int t;

for(t=0; t<MAX; ++t) address[t].name[0] ='\0';
}

void enter(void)
{
char s[40];
int i;
for(i=1; i<MAX; i++)
if(!*address[i].name)
break;
if(i==MAX)
{
printf("Subscriber array full\n");
return;
}
printf("Enter information on new customer\n");

printf("Enter name: ");
readLine(address[i].name);

printf("Enter street: ");
readLine(address[i].street);

printf("Enter district / parish: ");
readLine(address[i].district);

printf("Enter town / city: ");
readLine(address[i].town);

printf("Enter county: ");
readLine(address[i].county);

printf("Enter country: ");
readLine(address[i].country);

printf("Enter postcode: ");
readLine(address[i].postcode);

printf("Enter telephone number: ");
readLine(address[i].telno);

printf("Enter email address: ");
readLine(address[i].email);
counter=counter+1;
}



void delete(void)
{
int t;
int u;
printf("enter a record number #: ");
scanf("%i", &t);
for(u=t; u<=counter; u++){
strncpy(address[u].name, address[u+1].name, 40);
strncpy(address[u].street, address[u+1].street, 40);
strncpy(address[u].district, address[u+1].district, 40);
strncpy(address[u].town, address[u+1].town, 40);
strncpy(address[u].county, address[u+1].county, 40);
strncpy(address[u].country, address[u+1].country, 40);
strncpy(address[u].postcode, address[u+1].postcode, 40);
strncpy(address[u].telno, address[u+1].telno, 40);
strncpy(address[u].email, address[u+1].email, 40);
}
address[counter].name[0] = '\0';
address[counter].street[0] = '\0';
address[counter].district[0] = '\0';
address[counter].town[0] = '\0';
address[counter].county[0] = '\0';
address[counter].country[0] = '\0';
address[counter].postcode[0] = '\0';
address[counter].telno[0] = '\0';
address[counter].email[0] = '\0';
counter = counter -1;
}

void list(void)
{
register int t;
int count;
count=0;
for(t=1; t<=counter; t++) {
count = count +1;
printf("Record number: %i\n",count);
printf("%s\n", address[t].name);
printf("%s\n", address[t].street);
printf("%s\n", address[t].district);
printf("%s\n", address[t].town);
printf("%s\n", address[t].county);
printf("%s\n", address[t].country);
printf("%s\n", address[t].postcode);
printf("%s\n", address[t].telno);
printf("%s\n", address[t].email);
printf("\n");
}
}

void sort(void)
{
register int u;
register int v;
for(u=1; u<counter; u++)
for (v=u+1; v<=counter; v++){
if( strcmp(address[u].name, address[v].name) >0){
swap(u, v);
}
}
}

void swap(int u, int v)
{
addr_list temp;
temp = address[u];
address[u] = address[v];
address[v] = temp;
}

void save(void)
{
FILE *fp;
register int i;

if((fp=fopen("maillist", "wb"))==NULL) {
printf("Cannot open file.\n");
return;
}

for(i=1; i<MAX; i++)
if(*address[i].name)
if(fwrite(&address[i],
sizeof(address[i]), 1, fp)!=1)
printf("File write error.\n");

fclose(fp);
}

void loadbackup(void)
{
FILE *fp;
register int i;
char filename[30];
printf("Enter a file name.\n");
scanf("%s",filename);
printf("\n");

if((fp=fopen(filename, "rb"))==NULL) {
printf("Cannot open file,\n");
return;
}

init_list();
for(i=1;  i<MAX; i++){
if(fread(&address[i],
sizeof(address[i]), 1, fp)!=1) {
if(feof(fp)) break;
printf("File read error.\n");
}
counter=counter+1;
}
fclose(fp);
}



void load(void)
{
FILE *fp;
register int i;

if((fp=fopen("maillist", "rb"))==NULL) {
printf("Cannot open file,\n");
return;
}

init_list();
for(i=1;  i<MAX; i++){
if(fread(&address[i],
sizeof(address[i]), 1, fp)!=1) {
if(feof(fp)) break;
printf("File read error.\n");
}
counter=counter +1;
}
fclose(fp);
}


void outputthree(void)
{
int t;
int count;
FILE *stream;
char filename[30];
count = 0;
printf("Enter a file name.\n");
scanf("%s",filename);
printf("\n");
stream = fopen(filename, "w+");
for(t=1; t<MAX; t++) {
if(address[t].name[0]) {
count = count +1;
fprintf(stream,"%i\n",count);
fprintf(stream,"%s\n", address[t].name);
fprintf(stream,"%s\n", address[t].street);
fprintf(stream,"%s\n", address[t].district);
fprintf(stream,"%s\n", address[t].town);
fprintf(stream,"%s\n", address[t].county);
fprintf(stream,"%s\n", address[t].country);
fprintf(stream,"%s\n", address[t].postcode);
fprintf(stream,"%s\n", address[t].telno);
fprintf(stream,"%s\n", address[t].email);
fprintf(stream,"\n");
}
}
fclose(stream);
return;
}



void outputtwo(void)
{
FILE *fp;
register int i;
char filename[30];
printf("Enter a file name.\n");
scanf("%s",filename);
printf("\n");
if((fp=fopen(filename, "wb"))==NULL) {
printf("Cannot open file.\n");
return;
}

for(i=1; i<MAX; i++)
if(*address[i].name)
if(fwrite(&address[i],
sizeof(address[i]), 1, fp)!=1)
printf("File write error.\n");

fclose(fp);
}

void search(void)
{
int i;
int count;
char s[40];
count=0;
printf("\nEnter a name.\n");
readLine(s);
for(i=1;i<MAX;i++)
{
if(address[i].name[0]) {
count = count +1;
}

if (strcmp(s, address[i].name)==0)
{
printf("\nRecord number: %i\n", count);
printf("\nName: %s\n",address[i].name);
printf("\nStreet: %s\n",address[i].street);
printf("\nDistrict: %s\n",address[i].district);
printf("\nTown: %s\n",address[i].town);
printf("\nCounty: %s\n",address[i].county);
printf("\nCountry: %s\n",address[i].country);
printf("\nPostcode:%s\n",address[i].postcode);
printf("\nTelephone number: %s\n",address[i].telno);
printf("\nEmail address: %s\n",address[i].email);
printf("\n");
}
}
}

void readLine(char buffer[])
{
char character;
int i=0;
do
{
character=getchar();
buffer[i]=character;
++i;
}
while(character !='\n');
buffer[i-1]='\0';
}