Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

dictionary templates should be SQL dumps #91

Closed
mjakubicek opened this issue Mar 28, 2019 · 0 comments
Closed

dictionary templates should be SQL dumps #91

mjakubicek opened this issue Mar 28, 2019 · 0 comments
Labels
backend good for beginners question? unsure what it is time-short

Comments

@mjakubicek
Copy link
Collaborator

not actual databases, so that one can reasonably track changes in them
iiegn added a commit that referenced this issue Apr 24, 2019
@iiegn
Automate DB creation
33e04b0 
This addresses #108 and (partly) #91
- Introduce `siteconfig` vars `dbSchemaFile` and `dbFile`
- Add a schema textfile for the DB `dbFile:lexonomy.sqlite`
- Use this file during `node adminscripts/init.js` and init the DB
iiegn added a commit that referenced this issue Apr 25, 2019
@iiegn
Automate DB creation
af023d2 
This addresses #108 and (partly) #91
- Introduce `siteconfig` vars `dbSchemaFile` and `dbFile`
- Add a schema textfile for the DB `dbFile:lexonomy.sqlite`
- Use this file during `node adminscripts/init.js` and init the DB
iiegn added a commit that referenced this issue Apr 25, 2019
@iiegn
Automate DB creation
5af8719 
This addresses #108 and (partly) #91
- Introduce `siteconfig` vars `dbSchemaFile` and `dbFile`
- Add a schema textfile for the DB `dbFile:lexonomy.sqlite`
- Use this file during `node adminscripts/init.js` and init the DB
rambousek pushed a commit that referenced this issue Apr 25, 2019
@iiegn @rambousek
Automate DB creation
16ab5ae 
This addresses #108 and (partly) #91
- Introduce `siteconfig` vars `dbSchemaFile` and `dbFile`
- Add a schema textfile for the DB `dbFile:lexonomy.sqlite`
- Use this file during `node adminscripts/init.js` and init the DB
iiegn added a commit that referenced this issue May 2, 2019
@iiegn
Txt sqlite db schema for dictionary
d53d7c6 
This is the .schema of the [blank.sqlite
template](47492f8), extracted via
```
$ sqlite3 blank.sqlite '.schema' > blank.sqlite.schema
```

Just for reference: `push.sqlite`, `sbd.sqlite`, and `smd.sqlite`
currently have identical schemata.

Addresses #91
@iztokkosem iztokkosem added the question? unsure what it is label Feb 17, 2022
rambousek added a commit that referenced this issue Mar 10, 2022
@rambousek
Templates as SQL dumps, fix #91
8da492f
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
backend good for beginners question? unsure what it is time-short
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@rambousek @mjakubicek @iztokkosem