Simon;
Interesting approach that I'd forgotten about.
The tables aren't "variable". This is a "beginning of the project,
one-time execution" thing I was hoping to get at database initialization.
Meaning, 0-byte SQLite file size kind of initialization, with not a single
line of application code
On 5 Aug 2018, at 2:40am, Stephen Chrzanowski wrote:
> I'm making a small database for a game, and a bunch of the tables follow
> the same kind of naming convention due to normalization, like
>
> {Name_Of_Information}s
> {Name_Of_Information}ID as Integer
> {Name_Of_Information}Name as Char
>
On Sat, 4 Aug 2018 21:40:53 -0400, Stephen Chrzanowski
wrote:
> I'm making a small database for a game, and a bunch of the tables follow
> the same kind of naming convention due to normalization, like
>
> {Name_Of_Information}s
> {Name_Of_Information}ID as Integer
> {Name_Of_Information}Name
On Saturday, 4 August, 2018 20:01, Stephen Chrzanowski
wrote:
>I was right. I got the tables done before a response. But still
>would like to know if there's a SQLite method of doing so.
Of course there is.
>My method was to use a templating application that I wrote at work. I
>give it
I did this sort of thing in Xperdex (
https://sourceforge.net/projects/xperdex/ ) which is a C# thing, and
enabled easy creation of DataTables similarly auto creating ID and Name by
stripping pluralization from the name.
Was working on a similar thing for JS; but keep getting distracted making
it
I was right. I got the tables done before a response. But still would
like to know if there's a SQLite method of doing so.
My method was to use a templating application that I wrote at work. I give
it this variable declaration:
Name=Resource
I then give it this text:
CREATE TABLE [%(Name)s](
I'm making a small database for a game, and a bunch of the tables follow
the same kind of naming convention due to normalization, like
{Name_Of_Information}s
{Name_Of_Information}ID as Integer
{Name_Of_Information}Name as Char
So for example:
Resources
ResourceID as Integer
ResourceName
7 matches
Mail list logo